Excel Training for Beginners

Excel Training for Beginners

Certificate of Introduction to MS Excel 2007

Course Overview

The certificate of introduction to MS excel 2007 is an online professional development program that will equip you with the necessary skills and tools to able to use simple spreadsheets in any business setting or administrative officer capacity.

This excel training and tutorial is a great learning opportunity for students looking to acquire the basic fundamentals of Microsoft Excel in order to become a successful administrative support officer or any other role requiring excel experience.

Course Modules

The Excel Screen

  • Moving around a Sheet
  • Displaying other Areas
  • Mouse Movements
  • Viewing other Sheets

Selecting Cells

  • Inserting Text and Numbers
  • Typing the Text
  • Adjusting Column Widths and Row Heights
  • Typing Numbers

Alignment and Indenting

  • Indenting
  • Centre Aligning
  • Merging and Centring

Calculations

  • AutoSum
  • Filling the Formula
  • Basic Formulas
  • AutoCalculate
  • Cell Editing

Multiple Worksheets

  • Copying Sheet Contents
  • Data Entry Ranges
  • Calculating across Worksheets
  • Copying Formulas

Functions

  • Function Syntax
  • The AVERAGE Function
  • The MAX Function
  • The MIN Function

Formatting

  • Fonts and Font Sizes
  • Number Formatting
  • Formatting a Group of Sheets
  • Borders
  • The Format Painter
  • Cell Shading

Proofing

  • Checking Spelling
  • AutoCorrect
  • Find and Replace
  • Comments

Print Preview

  • Page Break Preview
  • Adjusting the Page Breaks
  • Previewing the Workbook
  • Zoom
  • Margins and Column Widths
  • Column Widths in Print

Page Setup

  • Orientation
  • Scaling
  • Margin Settings
  • Headers and Footers
  • Built-In Headers and Footers
  • Custom Headers and Footers
  • Sheet Options

Learning Outcomes

excel training beginnersAt the end of the course, students will be able to:

  • Create, develop and format basic spreadsheets
  • Apply formulas and calculations
  • Create lists and modify data
  • Work with multiple spreadsheets in a single workbook
  • Format and adjust cells for reporting

Course Format

All students will be provided with the workbooks, exams and spreadsheets as part of the course.

Didn’t Pass? Try Again

Not everyone passes the course on their first go, but we don’t believe it to be fair to charge you again. We offer unlimited attempts to all our students. If you don’t pass all modules, simply keep trying. That’s our promise to you.