Master in treasure of function with the most powerful features of MS Excel

This course familiarizes you with some of the most powerful features of MS Excel, its treasure of functions. Besides explaining the preliminary concepts of cell references, it also covers some of the lesser known utilities.

At the end of the course, participants would learn/use/acquire the following techniques/knowledge:

Understand the concepts of cell references
Appreciate some of the amazing features of Excel’s Backstage view
Utilize the data protection capabilities of worksheets
Explore some of the amazing and lesser known functions aimed at providing meaningful information
Perhaps the closest thing to magic Excel users will ever see in a workbook is Flash Fill. This feature anticipates formatting and data requirements by recognizing patterns so it can finish what you start.  Recommended Charts, but generates a quick PivotTable. It's a great new feature for most users. Quick Analysis offers a second new way to generate appropriate charting for your data. A timeline lets you filter records in a PivotTable—it works similar to a slicer, but you'll filter by dates.