Microsoft Excel 365 Bundle: Beginner to Advanced

Master and elevate your Microsoft Excel 365 skills with this great value 3-course bundle.


What you'll learn
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.
Collaborate in Excel Online, co-author in real-time, and share workbooks seamlessly.
Implement data validation for accurate input control.
Utilize logical functions like AND, OR, and IF for decision-making.
Identify and handle duplicates in data using conditional formatting and formulas.
Apply statistical functions such as mean, median, and mode.
Analyze data using PivotTables and Pivot Charts for insights.
Perform what-if analysis using functions like PMT, Goal Seek, and Data Tables.
Extract and count unique entries using Dynamic Array Functions.
Utilize SORT and SORTBY functions for data organization and analysis.
Employ FILTER functions with logical operators for precise data filtration.
Generate random arrays and values with RANDARRAY and RANDBETWEEN functions.
Perform complex lookups efficiently using XLOOKUP and XMATCH functions.
Develop custom formulas with LET and LAMBDA functions for tailored analysis.
Create and manage data models with Power Pivot, including table relationships.
Clean and manipulate data effectively using Power Query functionalities.
Automate repetitive tasks and customize Excel with macros and VBA.



Requirements
Microsoft Excel 365 for Windows installed and ready to use on your computer.
No prior experience needed. This course is designed for absolute beginners.

Description
**This bundle includes practice exercises, downloadable files, and LIFETIME access**
Learn all the tools needed to become a Microsoft Excel 365 power user with this great-value 3-course training bundle from Simon Sez IT for beginners to advanced users. This Excel bundle is perfect for anyone interested in number-crunching, data organizing, and chart-making.
Start by learning the basics, such as navigating Excel's interface, entering data, and using basic formulas. Then, move on to creating impressive charts, sorting and filtering data, and collaborating with others.
As you advance, master complex calculations, design professional spreadsheets, and analyze data with PivotTables and charts. Finally, explore powerful tools like Power Pivot, Power Query, and macros to automate tasks and handle large datasets effortlessly.
If you already have a good understanding of Excel, you can skip to the intermediate and advanced sections, where our expert instructor will help you take your spreadsheet skills to the next level.
What's included?
Excel 365 Beginners
Access the Microsoft 365 online portal.
Understand the order of operations and the BODMAS rule.
Know the difference between absolute and relative referencing.
Apply number formatting, format cells, rows, and columns.
Perform lookups with VLOOKUP and XLOOKUP.
Freeze and unfreeze panes.
Protect cells, worksheets, and workbooks from editing.
Work with files in Excel Online.
Add an Excel workbook to a Teams channel and share in a Teams meeting.
Excel 365 Intermediate
Design spreadsheets for improved readability using cell styles.
Implement data validation for accurate input control.
Utilize logical functions like AND, OR, and IF for decision-making.
Perform lookup operations using VLOOKUP and INDEX/MATCH.
Sort and filter data efficiently using built-in Excel functions.
Identify and handle duplicates in data using conditional formatting and formulas.
Round values and perform special rounding using Excel's math functions.
Apply statistical functions such as mean, median, and mode.
Analyze data using PivotTables and Pivot Charts for insights.
Perform what-if analysis using functions like PMT, Goal Seek, and Data Tables.
Excel 365 Advanced
Extract and count unique entries using Dynamic Array Functions.
Differentiate between unique and distinct values in Excel spreadsheets.
Utilize SORT and SORTBY functions for data organization and analysis.
Employ FILTER functions with logical operators for precise data filtration.
Generate random arrays and values with RANDARRAY and RANDBETWEEN functions.
Perform complex lookups efficiently using XLOOKUP and XMATCH functions.
Develop custom formulas with LET and LAMBDA functions for tailored analysis.
Create and manage data models with Power Pivot, including table relationships.
Clean and manipulate data effectively using Power Query functionalities.
Automate repetitive tasks and customize Excel with macros and VBA.
This course bundle includes:
25+ hours
of video tutorials
270+ individual video
lectures
Course and exercise files
to follow along
Certificate of completion
Who this course is for:
Suitable for learners of all levels.
Users who are brand new to Excel or those who have a foundation of Excel and seeking to advance their Excel 365 knowledge.
Excel users upgrading from an older desktop version and want to keep up to date with Excel 365 developments.

More Info