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:
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.
GreyCampus is a leading provider of certification training solutions for professionals globally. We offer a personalized, interactive and engaging learning experience for professionals across sectors to help them clear the certification exams of their choice quickly and easily.
Our online learning portal uses a highly advanced, analytics-driven technology platform to deliver courses that are highly personalized, adapt to your learning needs and constantly provide feedback to help you achieve your objectives. Each eLearning program is independently hosted on a Cloud platform that guarantees 99.99% availability anywhere in the world 24×7.