Course Objectives:
At the end of this course you will be proficient in entering data quickly into a spreadsheet. You will also be able to format a spreadsheet, plus using basic calculations such as Sum, Average, Count, Max and Min. You will also be able to create a basic chart on the data in the spreadsheet.
Benefits
At the end of this course you will have a good working knowledge of Excel basics. You will feel more confident using Excel and be able to create a spreadsheet from scratch. Understanding and using some of the built in calculation and formula functionality will allow you to be more productive in your work and home Excel environments. Spreadsheets that you create will be easier to use and look more presentable.
Typically our courses are delivered in one day, to groups of upto 8 delegates, at your location. This keeps your costs down, and allows your staff to learn in a familiar environment. If you don't have your own training facility, then we can deliver training at a location to suit you, which you can arrange yourself or we can do that for you.
Inspire IT has delivered training in Dublin, Waterford, Kilkenny, Sligo, Galway, Donegal, Tipperary, Athlone, Dundalk, Kerry and Wexford.
We will travel onsite anywhere in Ireland
Introduction
- Introduction
to Excel Environment
- Introduction to Ribbon User Interface
-
Navigation
of spreadsheet
-
Enter
Data
-
Highlight
Data
- Highlighting
Data in non-adjacent cells
Editing
a Worksheet
- Cut,
Copy & Paste Data
- Inserting
& Deleting Rows & Columns
Basic
Formulaes
- Sum, subtract
- Autosum
- Copy Formulaes
across rows & columns
- Editing Formulaes
- Viewing all
formulaes on spreadsheet
Formatting
Spreadsheet
- Changing
Font size, type, colour
- Adjusting
column & row width and height
- Using
number formats eg. currency
- Merge
cells
- Clearing
all formats
|
Creating
and Editing Charts
-
Selecting
Data to be used in chart
-
Creating
chart using shortcut key
-
Creating
chart on the same sheet as data
-
Applying
Chart Titles
-
Moving
& Enlarging Chart after creation
- Printing
Charts & Data on sheet
- Deleting
Chart
Editing
a Workbook
- Inserting
& Deleting worksheets
- Renaming
worksheet
- Moving
worksheets in workbook
Printing
a Workbook
- Printing
Worksheet
- Printing
Highlighted data
- Using Header
& Footers
- Creating
a Print Title
|
| Back to Main Excel Page>> |
Recommended Course Intermediate Excel |
|
