Course Outline

Microsoft Excel - Level 1
Create simple spreadsheets, then format numbers and text, rows and columns. Utilize borders and shading, fonts and alignment for greater impact and clarity. Learn how to copy, move, insert, delete and sort data. Insert functions and use basic formulas. Create simple charts! 6 hours
Getting Started
  • Understanding pointer shapes
  • Undo and Redo
  • Excel's menus and toolbars
  • Activating another cell
  • Making selections within a worksheet
  • Using navigation keys
  • Working with sheet tabs
Creating a New Workbook

Entering Values

  • Entering labels (text)
  • Entering numbers
  • Entering dates
  • Changing column widths
  • Automatic date formatting
  • Number formatting
  • Using AutoComplete

Entering Formulas and Functions

  • Calculation operators in formulas
  • Order of operation precedence
  • Using the AutoSum function
  • Copying data within a row or column
  • Using AutoCalculate
Formatting a Worksheet
  • Formatting toolbar
  • Format Cells command
Editing Worksheets

Moving and Copying Cells

AutoFilling a Series

Creating a Custom Series

Relative vs. Absolute references

  • Relative references
  • Absolute and Mixed references
  • Switching between Absolute, Relative, and Mixed references
Preparing to Print
  • Formatting the sheet onscreen
  • Adding headers and footers
  • Repeating titles on every page
  • Changing the layout
  • Previewing and adjusting margins
  • Checking page breaks
Charting Basics
  • Anatomy of a chart
  • Choosing the best chart type
  • Selecting data
  • Creating an embedded vs. a separate chart
Prerequisites:  Macintosh Introduction, Microsoft Windows, or equivalent experience.
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600