Course Outline of Microsoft Excel

  1. Home /
  2. Course Outline of Microsoft Excel

Course Outline of Microsoft Excel

Course Outline

Lesson 1: Creating a Microsoft Excel

  • Starting Microsoft Excel
  • Creating & Saving Workbook
  • Adding and Deleting Worksheets
  • Copying and Moving Worksheets
  • Changing the Order of Worksheets
  • Splitting the Worksheet Window
  • Closing a Workbook

 

Lesson 2: The Backstage View

  • Introduction to the Backstage View
  • Opening a Workbook
  • Open a Workbook
  • New Workbooks and Excel Templates
  • Select, Open and Save a Template Agenda
  • Printing Worksheets
  • Print a Worksheet

 

Lesson 3: The Ribbon & Quick Access Toolbar

  • Tabs, Groups, Commands
  • Adding Additional Commands
  • Adding Ribbon Commands, Placement
  • Customize the Quick Access Toolbar

 

Lesson 4: Entering Data in Worksheets

  • Entering Text
  • Adding and Deleting Cells
  • Adding a Hyperlink
  • Add WordArt to a Worksheet
  • Entering Text and Using AutoComplete
  • Entering Numbers and Dates
  • Using the Fill Handle
  • Entering Numbers and Dates

 

Lesson 5: Formatting Worksheets

  • Selecting Ranges of Cells
  • Hiding Worksheets
  • Adding Color to Worksheet Tabs
  • Adding Themes to Workbooks
  • Adding a Watermark
  • The Font Group
  • The Alignment Group
  • Working with Alignment, the Number Group

 

Lesson 6: Using Formulas

  • Math Operators and the Order of Operations
  • Entering Formulas
  • AutoSum (and Other Common Auto-Formulas)
  • Copying Formulas and Functions
  • Relative, Absolute, and Mixed Cell References
  • Working with Formulas

 

Lesson 7: Working with Rows and Columns

  • Inserting Rows and Columns
  • Deleting Rows and Columns
  • Transposing Rows and Columns
  • Setting Row Height and Column Width
  • Hiding and Unhiding Rows and Columns
  • Freezing Panes
  • Working with Rows and Columns

 

Lesson 8: Editing & Finalizing Worksheets

  • Find and Replace
  • Using Find and Replace
  • Using the Clipboard
  • Using Format Painter
  • Managing Comments
  • Setting Margins
  • Setting Page Orientation
  • Setting the Print Area
  • Print Scaling (Fit Sheet on One Page)
  • Printing Headers and Footers
  • Headers and Footers
  • Preparing to Print

 

Assignments:

Assignment 01 – 10 Formula (Sheet 1) – Day 01

Assignment 02 – Quotation (Sheet 2)  – Day 01

Assignment 03 – Graph & Chart (Sheet 3) – Day 02

Assignment 04 – Invoice (Sheet 4) – Day 02