Microsoft Excel 365 Bundle: Beginner to Advanced (Udemy.com)

**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:

1. 25+ hours of video tutorials

2. 270+ individual video lectures

3. Course and exercise files to follow along

4. Certificate of completion