Excel Fundamentals – Virtual Live

Excel Fundamentals – Virtual Live

Course Description: This course will demonstrate to the Excel beginner how to navigate through the program by outlining core fundamentals. Featured topics included selecting cell ranges, distinguishing between different data types, and applying general formatting. Additionally, this course will delve into how to define worksheet layouts, namely freezing columns, hiding and unhiding columns, and basic printing options. Furthermore, working with multiple worksheets will be explored.

Objective: Upon completion of this course, the Excel user will be able to work with existing workbook files as well as creating and modifying basic worksheets.

Lesson 1: Getting Started with Excel

  • Exploring the Excel Interface
  • Navigate and Select Cells in Worksheets
  • Create a Basic Worksheet
  • Entering Data into Cells

Lesson 2: Modifying the Appearance of a Worksheet

  • Apply Font Properties
  • Align Content in a Cell
  • Apply Number Formatting
  • Add Borders and Colors to Cells
  • Basic Conditional Formatting

Lesson 3: Worksheet Layout and Printing

  • Splitting and Freezing Worksheets
  • Hiding and Unhiding Columns and Rows
  • Printing a Worksheet
    1. Working in Page Break Preview
    2. Inserting Page Breaks
    3. Printing Titles
    4. Page Setup Options
  • Printing a Worksheet by Selection
  • Defining a Print Area

Lesson 4: Working With Multiple Worksheets

  • Inserting and Deleting Worksheets
  • Renaming Worksheets
  • Moving or Copying Worksheets
  • Changing the Worksheet Tab Color
Course Information
  • Course Level:Introductory
  • Prerequisite:None
  • Credit:3 CPE hours
  • Fee:$135
  • Length:3.5 hours
  • Hours:1:00 p.m. - 4:30 p.m. (flexible)
  • Delivery:Virtual Live

Related Courses

Virtual Live Classes Available for Nearly All Courses