Lesson 1: Getting Started
TOPIC A: Getting Started with Microsoft Excel Online
- Logging into Office 365
- Launching Excel Online
- The Excel Online Interface
- Creating a New Workbook
- Closing Excel Online
TOPIC B: Getting to Know Excel
- What are Spreadsheets, Worksheets, and Workbooks?
- What are Columns, Rows, Cells, and Ranges?
- Navigating in Excel
- Keyboard Navigation Options
- Excel Formulas
TOPIC C: Managing Workbooks
- Opening a Workbook
- Editing Your Workbook in Excel Desktop
- Accessing Save Options
- Using the Accessibility Checker
- Printing a Workbook
- Sharing a Workbook
TOPIC D: Getting Help in Excel Online
- Using Tell Me
- Accessing Advanced Help Options
- Getting Accessibility Help
Lesson 2: Working with Data
TOPIC A: A Closer Look at Formulas
- The Formula Bar
- Elements of an Excel Formula
- Mathematical Operators
- The Order of Operations
- Types of References
TOPIC B: Using Formulas and Functions
- About Functions
- Creating a Function with AutoComplete
- Using the Insert Function Dialog Box
- Using AutoSum
- Viewing AutoSum Calculations in the Status Bar
- Automatic Workbook Calculations
TOPIC C: Working with Data
- Selecting Cells
- The Cut, Copy, and Paste Commands
- Using Paste Options
- Moving Data with Drag and Drop
- The Undo and Redo Commands
- Using AutoFill
- Using Flash Fill
TOPIC D: Working with Rows and Columns
- Inserting Rows and Columns
- Deleting Rows and Columns
- Clearing Data from Cells
- Changing Column Width and Row Height
- The Hide and Unhide Options
TOPIC E: Sorting and Filtering Data
- The Difference Between Sorting and Filtering
- Sorting Data
- Enabling Filtering
- Using the Filter Dialog Box
- Using Text Filters
- Clearing a Filter
Lesson 3: Formatting a Worksheet
TOPIC A: Formatting Text
- What is a Font?
- The Font Group
- The Format Painter
- Creating Links
TOPIC B: Formatting Cells
- Applying a Border
- Applying a Fill
- Changing the Number Format
- Formatted Numbers and Cell Width
- Customising Number Formats
TOPIC C: Aligning Cell Content
- Alignment Options
- The Indent Commands
- The Wrap Text Command
- Merge & Center Options
TOPIC D: Using Find & Select Tools
- The Find Command
- The Replace Command
- The Go To Command
TOPIC E: Applying Conditional Formatting
- What is Conditional Formatting?
- Applying Conditional Formatting Rules
- Setting Conditional Formatting Options
- Clearing Conditional Formatting
Lesson 4: Adding Pictures and Shapes
TOPIC A: Inserting Pictures
- Inserting Pictures
- Resizing Pictures
- Rotating Pictures
- Deleting Pictures
- Adding Alternative Text
TOPIC B: Inserting Shapes
- Inserting Shapes
- The Drawing Tools – Format Contextual Tab
- Resizing Shapes
- Deleting Shapes
TOPIC C: Formatting Shapes
- Changing the Shape Type
- Applying a Style
- Customising Shape Fill and Outline
- Adding Alternative Text
Lesson 5: Organising Worksheet Data with Tables and Charts
TOPIC A: Inserting Tables
- What is a Table?
- Creating a Table
- Customising Row Display
- Inserting and Deleting Table Rows and Columns
- Sorting and Filtering Table Data
TOPIC B: Inserting Charts
- Chart Types
- Chart Elements
- Inserting a Chart
- The Chart Tools – Chart Contextual Tab
- Moving Charts
- Resizing Charts
TOPIC C: Modifying Charts
- Switching Row and Column Display
- Using the Select Data Command
- Changing the Chart Type
- Adding a Chart Title
- Modifying Chart Labels
- Modifying Chart Axes
Lesson 6: Using PivotTables
TOPIC A: Inserting PivotTables
- What is a PivotTable?
- Creating a PivotTable
- The PivotTable Fields Task Pane
- Working with PivotTable Data
TOPIC B: Working with PivotTable Data
- Expanding and Collapsing Data
- Refreshing Data
- Renaming Fields
- Summarising Values
- Changing Value Display
TOPIC C: Sorting and Filtering PivotTable Data
- Sorting Data
- Using the Filters Pane
- Using Label and Value Filters
- Clearing Filters
Lesson 7: Finalising Workbooks
TOPIC A: Using Comments
- Inserting Comments
- Showing and Hiding the Comments Pane
- Editing Comments
- Deleting Comments
TOPIC B: Managing Worksheets (Part One)
- Viewing Worksheets
- Inserting Worksheets
- Deleting Worksheets
- Duplicating Worksheets
- Worksheet References in Formulas
TOPIC C: Managing Worksheets (Part Two)
- Hiding and Unhiding Worksheets
- Reordering Worksheets
- Renaming Worksheet Tabs
- Changing Tab Color
TOPIC D: Changing View Options
- Using the Workbook Views Group
- Showing and Hiding Workbook Elements
- The Freeze Panes Options