Skip to main content

Excel 365 Basics E-Learning Course

This course provides training on Excel for Microsoft 365 for beginner and intermediate levels.

Excel is Microsoft’s spreadsheet program and allows both simple and complex calculations.

This course will introduce learners to the basics in Excel. It will show how to create workbooks and spreadsheets, fill them in, and perform simple calculations. Learners will be shown how to prepare data clearly using the editing and formatting functions, and how to export or print their results.

Course Features
Content Version
Application Group
Beginner / Intermediate
Learning Time
2 hours and 25 minutes
Number of Learning Videos
Languages Available
Course Design
  • Videos with Audio Narration and Closed-Captions
  • Practice Interactive Exercises
  • Tips and Printable PDF's
  • Chapter Tests
  • Personalized Learning Recommendations
  • Comprehensive Final Test with Certificate
  • Compatible with Desktop and Mobile Devices
  • SCORM and xAPI Support for LMS Deployement
Course Topics

Getting started with Excel

  • Finding your way around Excel
  • Getting to know the Excel web app
  • Creating a new workbook
  • Inserting and moving worksheets
  • Renaming a worksheet

Entering values

  • Filling a worksheet
  • Adjusting the column width or row height
  • Copying with the fill-in function
  • Creating data series
  • Using Flash Fill
  • Using wrap text
  • Setting manual text wrapping

Performing simple calculations

  • Getting to know how to structure and enter formulas
  • Subtracting Values
  • Multiplying Values
  • Dividing values
  • Calculating a sum total
  • Calculating an average

Editing rows and columns

  • Showing column and row labels
  • Selecting whole rows and columns
  • Inserting and deleting cells
  • Moving and copying cells
  • Merging cells

Formatting cells

  • Formatting a cell
  • Formatting numbers as text
  • Showing and hiding decimal places
  • Creating a custom number format
  • Applying a table style
  • Applying a cell format to multiple cells

Working with multiple worksheets

  • Working with multiple worksheets
  • Copying and moving a worksheet
  • Showing and hiding worksheets
  • Deleting worksheets
  • Switching between workbooks

Creating and using templates

  • Creating a Template
  • Using Templates

Protecting cells

  • Aligning text
  • Protecting sheet
  • Unprotecting a sheet
  • Protecting a workbook
  • Releasing locked cells in a protected worksheet

Preparing spreadsheets for printing or export

  • Setting a page break with the mouse
  • Setting a page break using the ribbon
  • Changing page orientation
  • Setting up headers and footers
  • Setting a repeat line for printing
  • Setting print area

Printing and exporting

  • Printing a table
  • Printing comments
  • Using Quick Print
  • Exporting data
This Course is Included in our Course Packages