Microsoft Excel Training Courses
We offer courses for beginners and advanced users.
Microsoft Excel for Beginners
Our one–day course is specially designed for people with basic computer skills who have no knowledge of Microsoft Excel.
Although this course is aimed at people who are already familiar with computers, we can also include some basic computer skills tuition if necessary. Please let us know your requirements when you book the course.
The following topics are covered:
- Getting Started
- toolbars and menus
- opening and closing a workbook
- saving a workbook
- Data
- entering and editing data
- cells, rows and columns
- find and replace
- copy, cut and paste
- filling: autofill handle
- filling: series filling
- Rows and Columns
- inserting
- deleting
- changing row height
- changing column width
- Formatting Cells
- numbers
- alignment
- font
- borders, colours and patterns
- Worksheets
- inserting and renaming
- move and copy
- inserting a comment
- Formulas and Functions
- mathematical functions
- excel functions
- Print and Layout
- page setup
- header and footer
- print area
- repeating header rows
- page breaks
- print preview
- printing your document
Microsoft Excel for Advanced Users
This one–day course is aimed at people who have a basic knowledge of Microsoft Excel or those who have completed the Beginners’ course and who wish to get to grips with some of the program’s more specialised features.
The following topics are covered in detail:
- Data
- sorting
- subtotals
- autofilter
- conditional formatting
- consolidating worksheets
- validation
- validation lists
- Charts
- creating a new chart
- adding data to an existing chart
- formatting an existing chart
- adding a secondary axis
- selecting inconsistent rows of data
- Using the If Function
- the if function
- the countif function
- the sumif function
- Using the Lookup Functions
- VLookup
- HLookup
- Macros
- recording a macro
- testing a recorded macro
- assigning a macro
- vba language
- Database
- creating a simple database table
- defining the database name
- creating the form
- automating the database entry
- creating a button to automate entry
- using the database
- Lists
- about excel lists
- creating an excel list
- adding and deleting rows and columns
- total count and average
- sort and filter
- remove list options
- Pivot Tables
- creating pivot table
- pivot table field list
- value field settings
- pivot table layout
- the glory of pivot tables
- Protection
- protecting cells
- protecting a workbook
Further Information
Training Schedule
Daily courses at our premises start at 10am and finish at 4pm, with an hour for lunch, and a break in mid–morning and mid–afternoon.
Refreshments are included in the price of the courses, but students should provide their own lunch.
Equipment
All equipment required for training will be supplied, although you may of course use your own laptop if you prefer.
Documentation
Handouts and examples of exercises given during the training will be available for you to take away on a CDR for future use.
Tailor–Made Courses
We are also able to provide tailor–made courses. If there is a particular area you are keen to study, please contact us.
Open Office
Many individuals and firms are now using Open Office instead of Microsoft Office, for the simple reason that it’s free.
The two systems work in almost exactly the same way, so everything you learn on our Excel courses will also apply to the Open Office equivalent, Calc.
You can get a printer–friendly version of this or any page simply by clicking ‘File’ then ‘Print’ on your browser!