Skip to main content

Excel 365: Basics

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

This E-Learning 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
Office Version
Application Group
Level
Beginner / Intermediate
Learning Time
2 Hours and 25 Minutes
Number of Learning Videos
50
Languages Available
English
German
French
Spanish
Portuguese
Japanese
Chinese
Russian
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 Content Bundles

New Generation Workplace | E-Learning Content Bundle

Our full course library for Microsoft 365 and Microsoft Office.

Includes E-Learning training courses for the following applications: Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, SharePoint, Planner, Power BI, Power Automate, Power Apps, Delve, Forms, Lists, To-Do, Whiteboard, Windows, Edge, Viva Engage, Visio and more...

Our New Generation Workplace content package is our full E-Learning course library for Microsoft 365.

This course package addresses core end-user training for Office and Windows at the Beginner, Intermediate and Advanced levels and also provides training on how to use Microsoft 365 collaboration tools to easily communicate and work in project teams.

During your subscription to this course package, you will receive our content updates to the package, including new courses we release into the package.

Desktop | E-learning Content Bundle

Learn and improve basic skills on using the classic Office desktop apps and more.

Includes E-Learning training courses for the following applications: Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Windows, Edge, To-Do and more...

Our Desktop E-Learning content package for Microsoft 365 addresses core end-user training for Office and Windows at the Beginner, Intermediate and Advanced levels.

During your subscription to this course package, you will receive our content updates to the package, including new courses we release into the package.

Contact info

We are the leaders in the building industries and factories. We're word wide. We never give up on the challenges.