Microsoft Excel 365 Bundle: Beginner to Advanced

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

Created by: Simon Sez IT
990,000+ Students, 290+ Courses, Learners in 180+ Countries

What Will I 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.

Target audience

• 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.