Course Objective:..

To equip participants with the fundamentals of MS Excel as a strong foundation for the Applied-Excel® Core courses

A FIRST LOOK AT EXCEL

·          Starting the Excel program

·          What is the Active Cell?

·          The Excel cell referencing system

·          Entering numbers and text

·          Default text and number alignment

·          Adding a column of numbers

·          Worksheets and Workbooks

·          Saving a workbook

·          Closing a workbook

·          Creating a new workbook

·          Opening a workbook

·          Switching between workbooks

·          Saving a workbook using another name

·          Saving a workbook using a different file type

HELP

·          Getting help

·          Searching for Help

·          The Help 'Table of Contents'

·          Printing a Help topic

·          Alt key help

USING EXCEL

SELECTION TECHNIQUES

·          Why are selection techniques important?

·          Selecting a cell

·          Selecting a range of connecting cells

·          Selecting a range of non-connecting cells

·          Selecting the entire worksheet

·          Selecting a row

·          Selecting a range of connecting rows

·          Selecting a range of non-connected rows

·          Selecting a column

·          Selecting a range of connecting columns

·          Selecting a range of non-connecting columns

MANIPULATING ROWS AND COLUMNS

·          Inserting rows into a worksheet

·          Inserting columns into a worksheet

·          Deleting rows within a worksheet

·          Deleting columns within a worksheet

·          Modifying column widths

·          Modifying column widths using 'drag and drop'

·          Automatically resizing the column width to fit contents

·          Modifying row heights

COPYING, MOVING AND DELETING

·          Copying the cell or range contents

·          Deleting cell contents

·          Moving the contents of a cell or range

·          Editing cell content

·          Undo and Redo

·          AutoFill

·          Sorting a cell range

·          Searching and replacing data

WORKSHEETS

MANIPULATING WORKSHEETS

·          Switching between worksheets

·          Renaming a worksheet

·          Inserting a new worksheet

·          Deleting a worksheet

·          Copying a worksheet within a workbook

·          Moving a worksheet within a workbook

·          Copying or moving worksheets between workbooks

FORMATTING

FONT FORMATTING

·          Font type

·          Font size

·          Bold, italic, underline formatting

·          Cell border formatting

·          Formatting the background colour

·          Formatting the font colour

ALIGNMENT FORMATTING

·          Aligning contents in a cell range

·          Centring a title over a cell range

·          Cell orientation

·          Text wrapping

·          Format painter

NUMBER FORMATTING

·          Number formatting

·          Decimal point display

·          Comma formatting

·          Currency symbol

·          Date styles

·          Percentages

FREEZING ROW AND COLUMN TITLES

Freezing row and column titles

FORMULAS AND FUNCTIONS

FORMULAS

·          Creating formulas

·          Easy way to create formulas

·          Copying formulas

·          Operators

·          Formula error messages

CELL REFERENCING

·          Relative cell referencing within in formulas

·          Absolute cell referencing within formulas

FUNCTIONS

·          What is a function?

·          Common functions

·          Sum function

·          Average function

·          Max function

·          Min function

·          Count function

·          What are 'IF functions'?

·          Using the IF function

CHARTS

USING CHARTS

·          Inserting a column chart

·          Inserting a line chart

·          Inserting a bar chart

·          Inserting a pie chart

·          Resizing a chart

·          Deleting a chart

·          Chart title or labels

·          Chart background colour

·          Changing a column, bar, line or pie slice colours

·          Changing the chart type

·          Modifying Charts using the Layout tab

·          Copying and moving charts within a worksheet

·          Copying and moving charts between worksheets

·          Copying and moving charts between workbooks