Discover the Functional Aspects of MS Excel 2013

Course details

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.