Microsoft Excel: Beginner to Advanced

Course overview

Our Microsoft Excel bundle is designed to get you up to speed with everything there is to know about Excel, taking you from complete novice to Excel master. When signing up, you will get access to all three of our Microsoft Excel courses: Beginner, Intermediate and Advanced – inclusive of various useful tips and exercises. From basic formulas to solving complex business problems, these courses will equip you with practical, in-depth skills and knowledge to master Excel. If you are looking for an engaging, hands-on, and self-paced approach to learning all things Microsoft Excel, then this bundle is perfect for you.

Outcomes

• Getting started on Excel
• Working with formulas and functions
• Formatting data and modifying worksheets
• Inserting images, shapes and charts into worksheets
• Printing a worksheet
• Working with templates
• Single- and multi-level data sorting
• Apply built-in functions to perform calculations and return information about data lists.
• Apply data validation and create validation lists.
• Import and export data from and to text files.
• Apply PivotTables to Excel worksheets.
• Apply the Power Query tool to model and shape data.
• Apply various tools to work with large sets of data.
• Apply logical and mathematical functions.
• Use Lookup and reference functions.
• Apply text functions.
• Understand and apply Excel’s auditing tools.
• Understand and apply security and protection.
• Navigate and apply Excel’s What-if Analysis and Solver tools.
• Understand and use macros.