Comprehensive Excel 2016: Supports Excel 2010, 2013 and 2016

Description:

keywords:microsoft office training,microsoft office 2010 training,microsoft office button excel,microsoft office training videos,hosted microsoft office,


This step-by-step workbook will guide you through learning the Excel program. It can be used by a beginner to understand core concepts, and an advanced student to learn the in’s and out’s of Excel. The workbook includes over 400 Practice Exercises that demonstrate how to use Excel concepts, and can also be used as a reference guide to quickly look up a topic. This valuable workbook guide is broken into the 5 major categories below:

Introductory Concepts - The chapters in this group will cover three major Excel categories including Formulas, Formatting, and Printing. It also covers Sum, Average, Minimum, Maximum, Cell Manipulation, Sheet tabs, Backstage View, Font, Alignment, Number, Borders, and Fill Cell features, Print Area, Scale a sheet, Manipulating Columns and Rows.

Intermediate Formulas - The primary skills covered in this group of chapters are Formulas and Functions including Name Ranges, Statistical, Text, Date/Time, Financial, Informational, Math/Trig, Logical IF Statements, Lookup, as well as Database functions.

Major Components - The three major components of Excel (in this group) include Tables, Charts, and PivotTables. PivotTables will cover Filtering, Formatting, PivotCharts, Label Adjustments, and Calculation Capability.

Advanced Features – In this group of chapters, students will learn the advanced in’s and out’s of Excel including protection, share a workbook, track changes, data validation, dropdown lists, macros, error checking, what-if analysis, and consolidate worksheets.

Advanced Power Add-Ins – This includes PowerPivot, PowerQuery,PowerView and PowerMap.

keywords:microsoft office training,microsoft office 2010 training,microsoft office button excel,microsoft office training videos,hosted microsoft office,

./upload/Microsoft%20Office/Comprehensive_Excel_2016__Supp_9_25_2017_5_24_01_PM.jpg
eBook Details:
Category: Microsoft Office
Author: Jeff Hutchinson
Language: English
ISBN10: B075VNPSD3
ISBN13:
Pages:
PubDate: 2017-09-22 00:00:00
UploadDate: 9/25/2017 5:24:01 pm

The Latest Upload

The Most Related

Category