Microsoft Excel 365 Courseware – Foundation

Part of the Microsoft Office 365 Courseware Library

Microsoft Excel Training Materials

Excel 365 Foundation Training Materials

Getting Started With Excel 365

  • Starting Excel 365
  • Selecting the Blank Worksheet Template
  • The Excel 365 Cell Referencing System
  • Entering Numbers and Text
  • Default Text and Number Alignment
  • Summing a Column of Numbers
  • Entering a Date
  • Worksheets and Workbooks
  • Saving a Workbook to Your Hard Disk
  • Closing a Workbook
  • Creating a New Workbook
  • Opening a Workbook
  • Opening a Recently Used Workbook
  • Pinning Files and Folders
  • Switching between Workbooks
  • Saving a Workbook Using another Name
  • Saving a Workbook Using a Different File Type
  • Getting Help within Excel 365
  • Searching For Help
  • The Help ‘Table of Contents’
  • Printing a Help Topic
  • Alt Key Help
  • Using Other Excel Templates

 

Excel 365 Selection Techniques

  • Why Are Selection Techniques Important?
  • Selecting a Cell
  • Selecting a Range of Connecting Cells
  • Selecting a Range of Non-Connecting Cells
  • Selecting the Entire Worksheet
  • Selecting a Row
  • Selecting a Range of Connecting Rows
  • Selecting a Range of Non-Connected Rows
  • Selecting a Column
  • Selecting a Range of Connecting Columns
  • Selecting a Range of Non-Connecting Columns
  • Recommended Techniques When Creating or Editing Lists

 

Manipulating Rows and Columns within Excel 365

  • Inserting Rows into a Worksheet
  • Inserting Columns into a Worksheet
  • Deleting Rows within a Worksheet
  • Deleting Columns within a Worksheet
  • Modifying Column Widths
  • Modifying Column Widths Using ‘Drag and Drop’
  • Automatically Resizing the Column Width to Fit Contents
  • Modifying Row Heights

 

Manipulating Cells and Cell Content within Excel 365

  • Copying a Cell or Range Contents within a Workbook
  • Deleting Cell Contents
  • Moving the Contents of a Cell or Range within a Workbook
  • Editing Cell Content
  • Undo and Redo
  • Copying Data between Worksheets (Within the Same Workbook)
  • Moving Data between Worksheets (Within the Same Workbook)
  • Moving Data Worksheets (Between Different Workbooks)
  • Copying Data between Worksheets (In Different Workbooks)
  • AutoFill
  • Copying a Data Range Using AutoFill
  • Sorting a Cell Range
  • Searching and Replacing Data

 

Excel 365 Worksheets

  • Switching between Worksheets
  • Renaming a Worksheet
  • Recommended Techniques with Naming Worksheets
  • Inserting a New Worksheet
  • Deleting a Worksheet
  • Copying a Worksheet within a Workbook
  • Moving a Worksheet within a Workbook
  • Copying or Moving Worksheets between Workbooks

 

Font Formatting within Excel 365

  • Font Formatting Options
  • Font Type
  • Font Size
  • Bold, Italic, Underline Formatting
  • Cell Border Formatting
  • Formatting the Background Color
  • Formatting the Font Color

 

Alignment Formatting within Excel 365

  • Horizontally Aligning Contents in a Cell Range
  • Centring a Title over a Cell Range
  • Cell Orientation
  • Text Wrapping within a Cell
  • Aligning Cell Contents Vertically
  • Format Painter

 

Number Formatting within Excel 365

  • Number Formatting
  • Decimal Point Display
  • Applying and Removing Comma Style Formatting (To Indicate Thousands)
  • Currency Symbol
  • Date Styles
  • Percentages

 

Freezing Row and Column Titles

  • Freezing Row and Column Titles

 

Excel 365 Formulas

  • Creating Formulas
  • The Easy Way to Create Formulas
  • Copying Formulas
  • Operators
  • Using Operators in Formulas
  • Formula Error Messages
  • Relative Cell Referencing within Formulas
  • Absolute Cell Referencing within Formulas

 

Excel 365 Functions

  • What Are Functions?
  • Common Functions
  • Sum Function
  • Average Function
  • Max Function
  • Min Function
  • Count Function
  • The Counta Function
  • The Countblank Function
  • What Are ‘If Functions’?
  • Using the If Function

 

Excel 365 Charts

  • Inserting a Column Chart
  • Inserting a Line Chart
  • Inserting a Bar Chart
  • Inserting a Pie Chart
  • Resizing a Chart
  • Deleting a Chart
  • Chart Title or Labels
  • Changing the Column, Bar, Line or Pie Slice Colors in a Chart
  • Modifying the Legend Fill Color
  • Changing the Chart Type
  • Modifying Charts Using the Layout Tab
  • Copying and Moving Charts within a Worksheet
  • Copying and Moving Charts between Worksheets
  • Copying and Moving Charts between Workbooks

 

Customising Excel 365

  • Modifying Basic Excel Options