Complete Excel 365 - Beginner to Advanced: 3 Course Bundle

Unlock the full potential of Microsoft Excel 365 with this comprehensive learning path, covering beginner, intermediate, and advanced skills. Whether you're starting from scratch, enhancing your current abilities, or mastering advanced techniques, these courses provide a robust foundation and deep insights into Excel's capabilities.

Begin your journey by understanding the basics of navigating Excel, entering and managing data, and using essential formulas. Progress to designing structured spreadsheets, improving data readability, and leveraging logical functions for better decision-making. Finally, dive into advanced features like dynamic array formulas, custom functions, and automation tools to handle complex data analysis with ease.

Gain confidence in data visualization, manipulation, and collaboration. Learn to use Excel in professional settings with tools like PivotTables, Power Query, and macros, and explore emerging AI tools like Microsoft Copilot for a seamless workflow.

Upon completing this course, you should be able to confidently tackle Excel spreadsheets, leaving a lasting impression on colleagues and future employers.

In the Excel 365 Beginners course, you will learn how to:

• Access Microsoft 365, launch Excel, enhance efficiency with shortcuts, and navigate the interface.
• Master the order of operations, the 'Big 6' basic Excel functions, VLOOKUP, XLOOKUP, and logical functions.
• Differentiate absolute and relative referencing, create named ranges, and apply them in formulas.
• Format numbers, cells, rows, and columns, and utilize conditional formatting.
• Create Excel tables, sort, filter data, and visualize it with charts and sparklines.
• Customize page layout, freeze/unfreeze panes, and add headers, footers, and page breaks.
• Collaborate in Excel Online, co-author in real-time, and share workbooks seamlessly.
• Seamlessly integrate Excel workbooks into Teams and share them within Teams meetings.

In the Excel 365 Intermediate course, you will learn how to:

• Design spreadsheets effectively using cell styles.
• Control data input with validation techniques.
• Utilize logical functions for decision-making tasks.
• Perform advanced lookup operations using various formulas.
• Master sorting and filtering techniques for data organization.
• Apply statistical functions for data analysis.
• Utilize pivot tables and charts for data visualization and analysis.

In the Excel 365 Advanced course, you will learn how to:

• Extract and tally unique entries using Dynamic Array Functions.
• Apply SORT and SORTBY functions for data sorting.
• Use FILTER functions with logical operators for precise data filtering.
• Efficiently execute complex lookups with XLOOKUP and XMATCH.
• Craft custom formulas using LET and LAMBDA functions.
• Build and manage data models with Power Pivot.
• Effectively clean and manipulate data with Power Query.
• Automate tasks and customize Excel using macros and VBA.

The files accompanying this course are below. Please use the Supplemental Content download links.