Course Title: Introduction To Microsoft Excel Training
The workshop is for users who are new to working with spreadsheets, or those wanting to improve their skills. This workshop begins with a basic overview of the application and quickly advances to cover useful formulas, functions, techniques for enhancing spreadsheets, charts, and much more.

Course Title: Introduction To Microsoft Excel Training
Duration: 4 hours of 1 hourly lessons, weekly, bi-weekly or monthly
Cost: £35 per lesson, per hour.
Where: We like to vist at home and training can take place on your own PC running Microsoft Word.

Pre-requisites: None - Basic keyboard and PC skills are part of the course.

Objectives: The goal of this Microsoft Excel Training course is to introduce attendees to the features of Microsoft Excel. After this Microsoft Excel Training course attendees will be able to:

• Understand spreadsheet fundamentals
• Create a new spreadsheet
• Manipulate data and cells in spreadsheets
• Create charts from Excel data

Course Profile: The 1 hour lessons are tutor-led by a Microsoft Office Specialist with over twenty years computer training experience in the print and publishing sector.
We are happy to vist at home and training can take place on your own PC running Microsoft Excel.

Table of contents

Getting Started

spreadsheet uses
toolbars and menus
moving around
getting help

Creating Workbooks
opening new workbooks
entering data
commenting and saving

Modifying Worksheets
opening worksheets
add and delete worksheets
insert and delete cells
worksheet data

Formatting Worksheets
width and height
numeric formats
alignment of data
naming cells and ranges
naming constants
creating lists
autofilter
designated lists

Printing Workbooks
print options
printing and hiding data
headers and footers

Working with Formulas
creating formulas
relative and absolute
external references
named constants

Working with Basic Functions
functions

Enhancing Worksheets
fonts and merging
rotate and indent
borders
shading and format painter
rename and color worksheet tabs
working with pictures

Using Templates, Styles and Autoformats
templates
styles
autoformat
smart documents

Charts
chart terminology
chart wizard
formatting charts
inserting images
printing charts

Finding and Replacing Data
file search
find and replace

Importing and Exporting Data
import from Word
delimited data
import from the web
exporting data

Using Multiple Worksheets
onsolidation
3D formulas

Manipulating the Screen Display
multiple panes
more screen options

Working with Advanced Functions
if
time
date and time
lookup

Formulas and Text
compare text
concatenation
special characters

Pivot Tables
pivot tables

Macros
recording a macro macro menus
global macros