Microsoft Excel 365 Bundle: Beginner to Advanced

Become an Excel Power User: Comprehensive Training Bundle

Unlock the full potential of Microsoft Excel 365 with this comprehensive 3-course training bundle from Simon Sez IT, designed for beginners to advanced users. Master number crunching, data organization, and chart creation – all with lifetime access to valuable resources.

What You'll Learn:

• Excel 365 Beginners: Build a solid foundation in Excel.
  • Navigate the Excel interface with ease.
  • Enter and manage data effectively.
  • Utilize fundamental formulas.
  • Create compelling charts and graphs.
  • Sort and filter data for quick insights.
  • Collaborate seamlessly with others using Excel Online and Microsoft Teams.
  • Understand order of operations (BODMAS rule).
  • Master absolute and relative cell referencing.
  • Apply number formatting to enhance readability.
  • Perform lookups using VLOOKUP and XLOOKUP.
  • Freeze and unfreeze panes for focused viewing.
  • Protect your work with cell, worksheet, and workbook protection.
• Excel 365 Intermediate: Elevate your spreadsheet skills.
  • Design professional spreadsheets with cell styles.
  • Implement data validation for accurate data entry.
  • Utilize logical functions (AND, OR, IF) for decision-making.
  • Refine lookup operations with VLOOKUP and INDEX/MATCH.
  • Efficiently sort and filter data.
  • Identify and handle duplicate data.
  • Round values and perform special rounding.
  • Apply statistical functions (mean, median, mode).
  • Analyze data with PivotTables and Pivot Charts.
  • Perform "what-if" analysis using PMT, Goal Seek, and Data Tables.
• Excel 365 Advanced: Become an Excel expert.
  • Extract and count unique entries using Dynamic Array Functions.
  • Differentiate between unique and distinct values.
  • Utilize SORT and SORTBY functions for advanced data organization.
  • Employ FILTER functions with logical operators for precise data filtering.
  • Generate random arrays and values with RANDARRAY and RANDBETWEEN.
  • Perform complex lookups with XLOOKUP and XMATCH.
  • Develop custom formulas with LET and LAMBDA functions.
  • Create and manage data models with Power Pivot and table relationships.
  • Clean and manipulate data using Power Query.
  • Automate tasks and customize Excel with macros and VBA.

Course Highlights:

• 25+ hours of engaging video tutorials
• 270+ individual video lectures
• Downloadable course and exercise files
• Certificate of Completion

This Excel bundle is perfect for anyone looking to improve their spreadsheet skills, automate tasks, and gain valuable data analysis capabilities. Whether you're a beginner or an experienced Excel user, this training will help you master Excel 365 and boost your productivity.