1 Day Corporate Training

Computer Training Courses

Microsoft Excel

Course Level: Intermediate

Click on the escalator to select another level.

Course Objectives:

To acquire more in-depth knowledge of formulae, charts and data analysis

Prerequisites:

Attendance at an Introduction to Excel Course. Or 3 - 4 months experience of using Excel regularly. Knowledge of basic formatting techniques and formulae

Duration:

1 Day

Course Content:

Session 1 - Introduction

Introduction to the course
Discussion of needs

Session 2 - The Basics

Creation of Spreadsheets
Shortcuts and proper practice
Formatting techniques
Printing requirements

Session 3 -Formulae

Operators and Functions
Autosum
Formula Palette and Paste Function
Fill right and down
Data Validation
Absolute Cell References
Fill by example
Range Names and Calculations
Maximum, Minimum and Count
If and Lookup functions

Session 4 - Formatting

Indent text, Rotate text
Conditional Formatting
Format Painter

Session 5 - Charts

Creating a chart with excel data
Enhancing your chart
Data Tables in Charts
*Microsoft Map
* Using charts within Word
* OLE and copying pictures

* Session 6 - Consolidation

3 dimensional spreadsheets
Using Workgroups

Session 6 - Automating Work

AutoCorrect
AutoComplete
AutoCalculate
Design and use of Templates
*Built-in Templates
*Templates with Data Tracking
* Macros and Personal.xls
* Customising toolbars

Session 7 - Database Functions

Using Excel as a database
Sorting and Querying Data
* Autofilter / Advanced Filter
* Subtotals

* Optional parts of the course depending on ability and requirements of participants

Next Level - Advanced Excel

Click here to reserve a place on this course

Home I Company Profile I Accreditations I Recruitment I FAQs I Links
Course Schedule I Delivery I Where We Are I Enquiry Form I Email Us