Excel 2021/365 Starter Pack: Beginner to Intermediate Course

Unlock the Power of Spreadsheets: Excel 2021/365 Training for All Levels

Ready to master Excel 2021 and Excel 365? This comprehensive course bundle is the ultimate starting point, whether you're a complete beginner or looking to enhance your existing Excel skills. We've combined our popular Excel for Beginners and Excel Intermediate courses into one powerful learning experience.

What You'll Learn:

• Excel 2021 Essentials: Get acquainted with the latest features of Microsoft Excel 2021, including functionalities exclusive to Excel 365 subscriptions.
• Interface Navigation: Learn to effortlessly navigate the Excel 2021 interface for maximum efficiency.
• Keyboard Shortcuts: Boost your productivity with essential Excel keyboard shortcuts.
• Spreadsheet Creation: Create your very first Excel spreadsheet from scratch.
• Formulas & Functions: Master basic and intermediate Excel formulas and functions to perform calculations.
• Cell Formatting: Apply professional cell formatting and utilize conditional formatting to highlight key data.
• Excel Lists & Sorting/Filtering: Effectively use Excel lists, master sorting, and filtering techniques.
• Data Management: Work efficiently with cut, copy, and paste operations, and link to other worksheets and workbooks.
• Data Analysis & Visualization:
  • Charts: Analyze data with various Excel charts.
  • PivotTables: Analyze large datasets using powerful PivotTables.
  • PivotCharts: Visualize data with interactive PivotCharts.
  • Dashboards: Create interactive dashboards to present high-level metrics.
• Advanced Excel Techniques:
  • Lookup Formulas: Construct functional and flexible lookup formulas.
  • Excel Tables: Structure data using Excel tables for easy updates.
  • Data Extraction: Extract unique values from lists.
  • Text Functions: Extract data using text functions.
  • Date & Time Functions: Work effectively with date and time functions.
  • What-If Analysis: Use WhatIf analysis tools to predict outcomes.
• Data Import & Cleaning: Import data and clean it for accurate analysis.
• Formula Auditing & Troubleshooting: Audit formulas and resolve common Excel errors.
• Data Validation: Control user input with data validation.
• Protecting & Sharing: Protect and share your workbooks securely.
• File Management: Save your workbook in various file formats.
• User Input Control: How to control user input with data validation.
• Logical Functions: How to use logical functions for better business decisions.

Who is this course for?

• Excel Novices: Start your Excel journey with a solid foundation.
• Intermediate Users: Build upon your existing Excel skills and explore new features.
• Students: Explore the latest features of Excel 2021 if you have prior experience with older versions.
• Professionals: Improve your data analysis and spreadsheet skills for better decision-making.

Course Features:

• 20+ hours of video tutorials
• 180+ individual video lectures
• Downloadable course and exercise files to practice along
• Certificate of Completion upon finishing the course

Prerequisite: A working copy of Excel 2021 or Excel 265.

Start building your Excel skills today!