About this Course

Length : 2 Days

Audience(s) : Users new to Microsoft Excel or spreadsheet skills & Users who wants to improve their basic Excel skills

Delivery Method : Instructor-led (classroom)

Course Overview

This introductory course gets participants started with Microsoft Excel basic spreadsheet skills.

Audience Profile

• Users new to Microsoft Excel or spreadsheet skills

• Users who want/need to improve their basic Excel skills

At Course Completion

After completing this course:

• Students will have the knowledge and application skills in using a spreadsheet application

• Students will understand fundamental spreadsheet concepts

• Students will be able to design a spreadsheet

• Students will be able to use basic functions within a spreadsheet

Pre-Requisites

No pre-requisites is needed in this course

Course Outline

SECTION 1: STARTING OUT

• What is Microsoft office excel 2010?

• Starting excel

• The excel screen layout

Exercise: starting excel and simple editing

• The ribbon

• Understanding tabs and groups

• The file (backstage) menu

• The quick access toolbar

• Adding commands

• Removing commands

• Customizing the toolbar

Exercise: customizing the quick access toolbar

• Using excel help

• Excel preferences (excel options)

• Closing excel

SECTION 2: OPEN AND CLOSE WORKBOOKS

• Opening a workbook

• Using scroll bars

• Closing a workbook

SECTION 3: CREATING AND SAVING WORKBOOKS

• Creating a new workbook

• Enter text, numbers and dates

• Editing cells

Exercise: edit cells

• Saving a workbook

• About excel file types

• Saving a workbook as a template

SECTION 4: WORKING WITH BASIC FORMULAS

• What are formulas?

• Writing a formula

Exercise: writing a basic formula

• Mathematical operators

• Editing formulas

• Autosum

Exercise: apply autosum

• Fixing formulas errors

• Modifying error checking options

• Displaying formulas

• Circular references

Exercise: resolve circular reference errors

• Checking spelling

SECTION 5: WORKBOOKS

• Working with multiple worksheets

• Insert a new worksheet

• Rename a worksheet

• Copy and move between worksheets and workbooks

• Deleting a worksheet

Exercise: working with worksheets

• Switching between open workbooks

• Arranging workbooks

SECTION 6: EDITING

• Entering and deleting data

• Use undo and redo

• Select ranges of data

• Using autofill

• Sorting data

• Best practices in organizing your data

Exercise: sorting data

• Copy, cut and paste

• Paste special

• Using find and replace

SECTION 7: PRINTING

• Printing your worksheet

• Print preview

• Using basic print options

• Change page setup

• Add headers and footers

• Use print titles

• Display and print formulas

SECTION 8: FORMATTING

• Format numbers, dates and percentages

Exercise: apply cell formats

• Change cell alignment and rotation

• Add borders and colours

• Change row height and column width

• Insert and delete rows and columns

• Freezing panes

• Use zoom

• Use the format painter

SECTION 9: FUNCTIONS AND ADDRESSING

• Functions

• Insert function wizard

• Average function

• Count function

• Max and min functions

• Other common functions

• Using the if function

• Understanding relative and absolute cell references

Exercise: adding tax as an absolute reference

SECTION 10: CHARTS

• Creating a chart

• Chart types

• Resizing charts

• Moving charts

• Styling charts with the design tab

• Formatting chart elements

• Modifying charts with the layout tab

• Additional styling with the format tab

• Changing the source data

• Working with the chart axes and data series

• Saving a chart as a template

• Print charts

Exercise: create and format a chart

Rate this course:

Log in to submit

Comments