ADVANCE EXCEL 2016 TRAINING GUIDE

ADVANCE EXCEL 2016 TRAINING GUIDE

Author: RITU ARORA
Rs. 150 Rs. 135 Save 10%

The first version of MS Excel was released in 1985 and was widely adopted across the globe and became the most prolific and important programs for over 750 million users. Many people assume that Excel is only used by accountants, analysts, scientists and other similar professions that points to the fact that there is a real problem with the understanding of what is in this book. Through this book we will explain why Excel is such an amazing program and why it can do so much more than you think.

Book Title ADVANCE EXCEL 2016 TRAINING GUIDE
Date Published Dec 31, 2017

The first version of MS Excel was released in 1985 and was widely adopted across the globe and became the most prolific and important programs for over 750 million users. Many people assume that Excel is only used by accountants, analysts, scientists and other similar professions that points to the fact that there is a real problem with the understanding of what is in this book. Through this book we will explain why Excel is such an amazing program and why it can do so much more than you think.

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 Macro

Content

  • Overview of Excel 2016 
  • Cell References and Range
  • Working with Formulas and Functions 
  • Data Validation 
  • Protection 
  • Sorting a Database
  • Filtering a Database 
  • Subtotals
  • Pivot Tables 
  • Conditional formatting 
  • What-if-Analysis Tools  
  • Working with Multiple Worksheets, Workbooks and Applications
  • Working with Charts 
  • Macros