Microsoft Excel 365 Part 1

Course Topics:

Lesson 1. Getting Started

TOPIC A: Getting Started with Excel Online

• Logging into Office 365
• Launching Excel Online
• The Excel Online Interface
• Creating a New Workbook
• Closing Excel Online
• Activity 1-1: Getting Started with 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
• Activity 1-2: Getting to Know Excel

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
• Activity 1-3: Managing Workbooks

TOPIC D: Getting Help in Excel Online

• Using Tell Me
• Accessing Advanced Help Options
• Getting Accessibility Help
• Activity 1-4: Getting Help in Excel Online
• Course Summary
• Review Questions
• Review Questions Answers
• Lesson Lab 1-1
• Course Completion

Lesson 2. Adding Pictures and Shapes

TOPIC A: Inserting Pictures

• Inserting Pictures
• Resizing Pictures
• Rotating Pictures
• Deleting Pictures
• Adding Alternative Text
• Activity 4-1: Inserting Pictures

TOPIC B: Inserting Shapes

• Inserting Shapes
• The Drawing Tools – Format Contextual Tab
• Resizing Shapes
• Deleting Shapes
• Activity 4-2: Inserting Shapes

TOPIC C: Formatting Shapes

• Changing the Shape Type
• Applying a Style
• Customizing Shape Fill and Outline
• Adding Alternative Text
• Activity 4-3: Formatting Shapes
• Course Summary
• Review Questions
• Review Questions Answers
• Lesson Lab 4-1
• Lesson Lab 4-2
• Course Completion

Lesson 3. Finalizing Workbooks

TOPIC A: Using Comments

• Inserting Comments
• Showing and Hiding the Comments Pane
• Editing Comments
• Deleting Comments
• Activity 7-1: Working with Comments

TOPIC B: Managing Worksheets (Part One)

• Viewing Worksheets
• Inserting Worksheets
• Deleting Worksheets
• Duplicating Worksheets
• Worksheet References in Formulas
• Activity 7-2: Managing Worksheets (Part One)

TOPIC C: Managing Worksheets (Part Two)

• Hiding and Unhiding The Hide and Unhide Worksheets
• Reordering Worksheets
• Renaming Worksheet Tabs
• Changing Tab Color
• Activity 7-3: Managing Worksheets (Part Two)

TOPIC D: Changing View Options

• Using the Workbook Views Group
• Showing and Hiding Workbook Elements
• The Freeze Panes Options
• Activity 7-4: Changing View Options
• Course Summary
• Review Questions
• Review Questions Answers
• Lesson Lab 7-1
• Lesson Lab 7-2
• Course Completion

Lesson 4. Formatting a Worksheet

TOPIC A: Formatting Text

• What is a Font?
• The Font Group
• The Format Painter
• Creating Links
• Activity 3-1: Formatting Text

TOPIC B: Formatting Cells

• Applying a Border
• Applying a Fill
• Changing the Number Format
• Formatted Numbers and Cell Width
• Customizing Number Formats
• Activity 3-2: Formatting Cells

TOPIC C: Aligning Cell Content

• Alignment Options
• The Indent Commands
• The Wrap Text Command
• Merge ​&​ Center Options
• Activity 3-3: Aligning Cell Content

TOPIC D: Using Find ​&​ Select Tools

• The Find Command
• The Replace Command
• The Go To Command
• Activity 3-4: Using Find ​&​ Select Tools

TOPIC E: Applying Conditional Formatting

• What is Conditional Formatting?
• Applying Conditional Formatting Rules
• Setting Conditional Formatting Options
• Clearing Conditional Formatting
• Activity 3-5: Applying Conditional Formatting
• Course Summary
• Review Questions

Lesson 5. Organizing Worksheet Data with Tables and Charts

TOPIC A: Inserting Tables

• What is a Table?
• Creating a Table
• Customizing Row Display
• Inserting and Deleting Table Rows and Columns
• Sorting and Filtering Table Data
• Activity 5-1: Inserting a Table

TOPIC B: Inserting Charts

• Chart Types
• Chart Elements
• Inserting a Chart
• The Chart Tools – Chart Contextual Tab
• Moving Charts
• Resizing Charts
• Activity 5-2: Inserting 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
• Modifying Charts
• Course Summary

Lesson 6. Using Pivot-Tables

TOPIC A: Inserting PivotTables

• What is a PivotTable?
• Creating a PivotTable
• The PivotTable Fields Task Pane
• Working with PivotTable Data
• Activity 6-1: Inserting PivotTables

TOPIC B: Working with PivotTable Data

• Expanding and Collapsing Data
• Refreshing Data
• Renaming Fields
• Summarizing Values
• Changing Value Display
• Activity 6-2: Working with PivotTable Data

TOPIC C: Sorting and Filtering PivotTable Data

• Sorting Data
• Using the Filters Pane
• Using Label and Value Filters
• Clearing Filters
• Activity 6-3: Sorting and Filtering PivotTable Data
• Course Summary
• Review Questions
• Review Questions Answers
• Lesson Lab 6-1
• Course Completion

Lesson 7. 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
• Activity 2-1: A Closer Look at Formulas

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
• Activity 2-2: Using Formulas and Functions

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
• Activity 2-3: Working with Data

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
• Activity 2-4: Working with Rows and Columns

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
• Activity 2-5: Sorting and Filtering Data
• Course Summary