Microsoft Excel 365 - Advanced

If you already have some experience with Excel and want to further boost your skills, this online course will quickly amplify your knowledge of intermediate and advanced Excel functions.

In just a few hours, you'll learn how to:

• Find a value with VLOOKUP, HLOOKUP, INDEX, MATCH.
• Discover the latest features, like XLOOKUP, Dynamic Arrays, and LET functions.
• Present and report your data exactly how you want to see it.
• Create and format Pivot Tables.
• Record a basic Macro to automate repetitive tasks.
• Use data validation to restrict data entry.
• Customize your page setup options for printing.
• And much, much more!

These bite-sized lessons will power you through your journey to mastering Excel with clarity and ease, and can even help you earn an Excel certification!

For those new to Excel, try our Basic course, or the beginner and advanced lessons in our combined Basic and Advanced Course. If you'd like to learn more advanced techniques, check out our Macros and VBA course.