Microsoft Excel

1024px-Microsoft_Office_Excel_(2018–present).svg

23

May

Teacher Step Certified
Categories
Students 3 (Registered)

Course Content

Total learning: 64 lessons Time: 10 weeks

Create and Manage Workbooks
- Lecture1.1
  
  Create a New Excel Workbook
- Lecture1.2
  
  Create a Workbook Based on a Template
- Lecture1.3
  
  Add a New Worksheet to a Workbook
- Lecture1.4
  
  Move or Copy Worksheets
- Lecture1.5
  
  Import Data from Delimited Text Files
- Lecture1.6
  
  Comments
Navigate in Workbooks and Worksheets
- Lecture2.1
  
  Search for Data
- Lecture2.2
  
  Find and Replace
- Lecture2.3
  
  Locate Workbook Elements
- Lecture2.4
  
  Hyperlinks
Format Worksheets and Workbooks
- Lecture3.1
  
  Manage Worksheet Attributes
- Lecture3.2
  
  Manage Rows and Columns
- Lecture3.3
  
  Apply a Theme to a Workbook
- Lecture3.4
  
  Modify Page Setup
- Lecture3.5
  
  Headers and Footers
Customize Options and Views
- Lecture4.1
  
  Hide or Unhide Cells
- Lecture4.2
  
  Modify View Settings
- Lecture4.3
  
  Modify the Display of Worksheets
- Lecture4.4
  
  Freeze Rows or Columns
- Lecture4.5
  
  Split View
- Lecture4.6
  
  View and Modify Document Properties
- Lecture4.7
  
  Configure Excel Options
Configure Workbooks for Distributing
- Lecture5.1
  
  Configure Printing Options
- Lecture5.2
  
  Saving and Exporting Workbooks
- Lecture5.3
  
  Inspect a Workbook for Hidden Properties and Information
- Lecture5.4
  
  Inspect a Workbook for Accessibility Issues
- Lecture5.5
  
  Inspect a Workbook for Compatibility Issues
Create Data in Worksheets
- Lecture6.1
  
  Use the AutoFill Feature
- Lecture6.2
  
  Cut, Copy, and Paste Data
- Lecture6.3
  
  Use the FlashFill Tool
Format Cells and Ranges
- Lecture7.1
  
  Merge and Unmerge Cells
- Lecture7.2
  
  Cell Alignment and Text Wrapping
- Lecture7.3
  
  Apply Cell Formats and Styles
- Lecture7.4
  
  Number Formats
- Lecture7.5
  
  Copy Existing Formatting
Summarize and Organize Data
- Lecture8.1
  
  Apply Conditional Formatting
- Lecture8.2
  
  Sparklines
- Lecture8.3
  
  Named Ranges
- Lecture8.4
  
  Outline Data
- Lecture8.5
  
  Insert Subtotals
Create and Manage Tables
- Lecture9.1
  
  Create a Table from a Data Range
- Lecture9.2
  
  Add or Remove Rows and Columns in a Table
- Lecture9.3
  
  Apply and Configure Table Styles
- Lecture9.4
  
  Filter Tables
- Lecture9.5
  
  Sort Data
- Lecture9.6
  
  Remove Duplicates from a Table
Use Functions to Summarize Data
- Lecture10.1
  
  Reference Cells and Ranges in Formulas
- Lecture10.2
  
  Order of Operations in Formulas
- Lecture10.3
  
  Filling Formulas
- Lecture10.4
  
  Use Functions to Calculate Data – Part 1
- Lecture10.5
  
  Use Functions to Calculate Data – Part 2
Use Functions to Perform Conditional Operations
- Lecture11.1
  
  Conditional Functions – Part 1
- Lecture11.2
  
  Conditional Functions – Part 2
Use Funtions to Modify and Format Text
- Lecture12.1
  
  Text Functions – Part 1
- Lecture12.2
  
  Text Functions – Part 2
Create and Format Charts
- Lecture13.1
  
  Create a Chart
- Lecture13.2
  
  Modify Charts
- Lecture13.3
  
  Format Charts
- Lecture13.4
  
  Use the Quick Analysis Tool
Insert and Format Objects
- Lecture14.1
  
  Insert Text Boxes and Shapes
- Lecture14.2
  
  Modify and Format Objects
- Lecture14.3
  
  Insert Images
- Lecture14.4
  
  Modify and Format Images
- Lecture14.5
  
  SmartArt

Instructor