Microsoft Excel Fundamentals Training Course

Students should be familiar with using personal computers and have used a mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer.

• Lesson 1: Getting Started with Microsoft Excel
  
  • Navigate the Excel User Interface
  • Use Excel Commands
  • Creating and Save a Basic Workbook
  • Enter Cell Data
  • Use Excel Help
• Lesson 2: Performing Calculations
  • Creating Formulas in a Worksheet
  • Insert Functions in a Worksheet
  • Reuse Formula
• Lesson 3: Modifying a Worksheet
  • Manipulate Data
  • Insert, Manipulate, and Delete Cells, Columns, and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools
• Lesson 4: Formatting a Worksheet
  
  • Modify Fonts
  • Add Borders and Color to Cells
  • Apply Number Formats
  • Align Cell Contents
  • Apply Cell Styles and Themes
  • Apply Basic conditional formatting
  • Create and Use Templates
• Lesson 5: Printing Workbook Contents
  
  • Preview and Print a Workbook 
  • Define the Page Layout
• Lesson 6: Managing Large Workbooks
  
  • Manage Worksheets
  • Manage the View of Worksheets and Workbooks
  • Manage Workbook Properties