Log in
Business Courses

Excel 2026 Beginner: Build a Strong Foundation in Microsoft Excel (M365)

See licenses and prices Sign in
  1. Course content1 lesson
    1. Resources
  2. Getting Started with Excel2 lessons
    1. Welcome To Excel 2026
    2. Understanding Spreadsheets
  3. First Steps in Excel9 lessons
    1. Opening Excel And Creating Workbooks
    2. Exploring The Start Screen
    3. Navigating The Excel Workspace
    4. Quick Access Toolbar Essentials
    5. Working With The Ribbon
    6. Creating New Workbooks
    7. Saving And Managing Files
    8. Opening Recent And Existing Files
    9. Time-Saving Keyboard Shortcuts
  4. Entering and Editing Data8 lessons
    1. Typing And Editing Text
    2. Entering And Formatting Numbers
    3. Handling Dates And Times
    4. Find, Replace, And Select Tools
    5. Sorting And Organizing Data
    6. Using Cell References
    7. Relative Vs. Absolute References Explained
    8. Order Of Operations In Formulas
  5. Essential Excel Functions5 lessons
    1. How Functions Work
    2. Using Sum Effectively
    3. Finding Minimum And Maximum Values
    4. Calculating Averages
    5. Counting Data With Count And Counta
  6. Working with Worksheets7 lessons
    1. Moving And Copying Data
    2. Adding And Removing Rows And Columns
    3. Adjusting Column Widths And Row Heights
    4. Hiding And Unhiding Worksheet Elements
    5. Renaming Worksheets
    6. Deleting Worksheets
    7. Duplicating Worksheets
  7. Formatting Your Data5 lessons
    1. Adding Borders To Cells
    2. Formatting Numbers And Percentages
    3. Merging And Centering Content
    4. Exploring Cell Styles
    5. Intro To Conditional Formatting
  8. Visual Elements in Excel2 lessons
    1. Inserting Images And Shapes
    2. Creating With Smartart
  9. Printing and Page Layout3 lessons
    1. Print Preview Basics
    2. Adjusting Margins, Scaling, And Orientation
    3. Printing Workbooks
  10. Templates in Excel3 lessons
    1. Getting Started With Templates
    2. Using Built-In Templates
    3. Designing Custom Templates
  11. Wrapping Up1 lesson
    1. Course Summary & Next Steps
  12. Excel Beginner Resources2 lessons
    1. Resources
    2. Resources 2
  13. Marketing Videos2 lessons
    1. Advanced
    2. In Todays Modern World

Microsoft Excel (M365) is one of the most widely used tools for organizing, analysing, and presenting data. This beginner-level course is designed to help you build a solid foundation in Excel, even if you have little or no prior experience.

You’ll learn how to confidently create spreadsheets, enter and organise data, apply basic formulas and functions, format worksheets professionally, and prepare files for printing or sharing. Every lesson focuses on practical, real-world use cases—so you can immediately apply what you learn to everyday tasks like budgets, task lists, reports, and simple data tracking.

What you’ll learn

  • Understand how Excel works, including rows, columns, cells, and workbooks
  • Navigate the Excel (M365) interface, Ribbon, and Quick Access Toolbar efficiently
  • Create, save, open, and manage workbooks locally and in OneDrive
  • Enter, edit, and format text, numbers, dates, and times
  • Sort and organise data for clarity and structure
  • Work with formulas, including relative and absolute cell references
  • Use essential functions such as SUM, AVERAGE, MIN, MAX, COUNT, and COUNTA
  • Manage worksheets by adding, deleting, duplicating, hiding, and renaming sheets
  • Apply formatting, borders, styles, and basic conditional formatting
  • Add visual elements such as images, shapes, and SmartArt
  • Set up worksheets for printing with correct margins, scaling, and layout
  • Use and create templates to save time and standardise your work
  • Apply time-saving keyboard shortcuts for faster productivity

Who this course is for

  • Beginners who want to learn Microsoft Excel (M365) from scratch
  • Students and professionals who need Excel for school, work, or personal use
  • Entrepreneurs and freelancers managing simple data, budgets, or reports
  • Anyone who wants a clear, structured introduction before moving to intermediate Excel skills

Outcome

By the end of this course, you’ll be comfortable working in Excel, creating well-structured spreadsheets, using essential formulas, and presenting your data clearly. This course prepares you perfectly for more advanced Excel topics such as data analysis, PivotTables, and advanced functions.