In this course, you will become familiar with some of the terms used when working with Excel, and how to use the basic features of the Excel interface. You will also learn how to create, view, navigate in, save, share, and print workbooks. The course also provides information on using Excel Online’s help features.
In this lesson you will learn how to:
- Get started with Excel Online
- Describe the basic components of Excel
- Manage workbooks
- Get help in Excel Online
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