Comprehensive Excel 2016: Supports Excel 2010, 2013, 2016 and 2019 - KING OF EXCEL

Saturday, April 17, 2021

Comprehensive Excel 2016: Supports Excel 2010, 2013, 2016 and 2019


Comprehensive Excel 2016: Supports Excel 2010, 2013, 2016 and 2019

🎁Like Fanpage and Read online bellow⏬

by Jeff Hutchinson
  • Length: 220 pages
  • Edition: 2
  • Publisher:
  • 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.

    Table of Contents

    Chapter 1 – Overview / Interface
    Chapter 2 – Data Entry Techniques
    Chapter 3 – Formulas And Functions
    Chapter 4 – Formula Manipulation
    Chapter 5 – Worksheets
    Chapter 6 – Formatting
    Chapter 7 – Printing
    Chapter 8 – Application Options
    Chapter 9 – Standard Formula Features
    Chapter 10 – Formula Programming
    Chapter 11 – Logical And Lookup Functions
    Chapter 12 – Datasheets And Tables
    Chapter 13 – Charts
    Chapter 14 – PivotTable And PivotChart
    Chapter 15 – Protection
    Chapter 16 – Sharing And Tracking
    Chapter 17 – Conditional Formatting And Data Validation
    Chapter 18 – Macros
    Chapter 19 – Formula Auditing And Calculations
    Chapter 20 – Advanced Formulas
    Chapter 21 – What-If Analysis And Add-Ins
    Chapter 22 – Working With Files
    Chapter 23 – PowerPivot
    Chapter 24 – PowerView Reports
    Chapter 25 – PowerQuery
    Chapter 26 – PowerMap
    Appendix A – Power Add-Ins

#evba #kingexcel #etipfree #eama

Popular Posts