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.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Certified Microsoft Excel Essentials Bilal Consultancy Limited EnglandAED 571
AED 669Duration: 2 - 3 Weeks - Microsoft Excel 2016 Advanced Study 365AED 138Duration: Upto 5 Hours