Advance Excel 2016 Training Guide

What are the main uses of Excel and how can this help my business?

Excel enables any format of information to be organized in a spread sheet and its innate flexibility as program, you can define and structure the layout according to how you want to manage it. It allows for over 1 million rows by over 16,000 columns of data to be managed, which shows how Excel is advancing as a business tool. This allows Excel to be used for a large variety of business purposes.

New to Excel 2016 or upgrading from a previous version? Use this guide to learn the basics and advance features of Excel. This user guide will introduce you to some of Excel’s 2016 more complex functionality, such as:

Use Conditional Logic in a formula
IF statements
Use the SumIF and CountIF functions
Produce a chart
Sort and filter
Apply subtotals
Data Validation
What-if-Analysis Tools
Introduction to Pivot Tables
Introduction to Macros

Table of Content
Chapter 1: Overview of Excel 2016
Chapter 2: Cell References and Range
Chapter 3: Working with Formulas and Functions
Chapter 4: Data Validation
Chapter 5: Protection
Chapter 6: Sorting a Database
Chapter 7: Filtering a Database
Chapter 8: Subtotals
Chapter 9: Pivot Tables
Chapter 10: Conditional formatting
Chapter 11: What-if-Analysis Tools
Chapter 12: Working with Multiple Worksheets, Workbooks and Applications
Chapter 13: Working with Charts
Chapter 14: Macros