Excel Training Course

This Excel training course is designed for people who have little or no knowledge of working with Microsoft Excel worksheets.  You will learn how to use the fundamental features, starting with the initial design of a workbook; leading to creating basic formulas, formatting your data and printing.

Those attending this course should be already familiar with the basic operations of a PC, and Windows operating system.

Outline :

Getting Started with Excel

·            An Overview of Excel

·            Navigate in Excel

·            Enter Data

·            Select Data

·            Obtain Help

·            Excel templates

Modifying a Worksheet

·            Move and Copy Data

·            Fill Cells with Series of Data

·            Edit Cell Data

·            Insert and Delete Cells

·            Find, Replace, and Go To

·            Spell Check a Worksheet

Performing Calculations

·            Create Basic Formulas

·            Calculate with basic functions

·            Copy Formulas and Functions

·            BODMAS

·            Create an Absolute Reference

Formatting a Worksheet

·            Change Font Size and Type

·            Add Borders and Color

·            Change Column Width

·            Change Row Height

·            Merge Cells

·            Applying Number Formats

·            Align Cell Contents

·            Apply an conditional formats

Managing a Workbook

·            Adding & Deleting Sheets

·            Renaming & Moving Sheets

·            Copy and Paste Worksheets

·            Split a Worksheet

·            Freeze and hide row / sheet

·            Inserting graphics

Printing in Excel

·            Set print margins

·            Header and Footer Control

·            Change page layout

·            Print preview

·            Print a range

·            Print options