This Excel short course is perfect for those wanting to learn Excel beyond simple workbooks to drive efficiency and perform more complex tasks. If you want to improve your Excel skills, create more professional spreadsheets and use shortcuts, functions and formulas to make your job easier, Microsoft Excel Intermediate is for you.Īnyone who uses Microsoft Excel at work and wants to advance their skills and knowledge. This Excel training course helps you to un-learn processes you may have picked up from learning Excel on the job, replacing them with the most efficient ways to achieve effective outcomes. Microsoft Excel is a powerful tool for a range of uses, but most users only scratch the surface of its capabilities.
#Online beginner excel training formulas how to
Gain new insights faster by learning how to manipulate data with VLOOKUP, IF and PMT functions and Excel data filtering. Reduce time spent on manual tasks with Autofilling and Sequential filling, and discover how to work with Custom Lists. You’ll be exposed to functions for financial and logical calculations, and learn useful methodologies to approach tasks in Excel with more confidence. In this one-day Excel course, you will learn intermediate Excel skills including how to use shortcuts, complex functions and relative and absolute formulas. This Microsoft Excel Intermediate short course will take your Excel skills to the next level, so you can start working smarter with spreadsheets and use them to improve your efficiency and organisation at work.