In this Advanced MS Excel course, we will prepare you to become a power user of Excel - this is your last step before specializing at a professional level. The topics we have prepared will challenge you as you learn how to use advanced formula techniques and sophisticated lookups.
You will clean and prepare data for analysis, and learn how to work with dates and financial functions. An in-depth look at spreadsheet design and documentation will prepare you for our big finale, where you will learn how to build professional dashboards in Excel. Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces around the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. Advanced Excel is a comprehensive course that gives you a clear understanding of the most recent and advanced features in Microsoft Excel. This course is for anyone who works with complex data in MS-Excel to build charts, tables, and technical reports. It will be useful to all readers who regularly use MS-Excel to analyze data.