Microsoft Excel Training Courses
We offer two courses:
- Getting Started for beginners.
- Charts and Data for advanced users.
We also provide tailor–made courses. Please contact us for details.
Microsoft Excel: Getting Started
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
- Opening Excel
- Office button
- Using the ribbon
- Help
- Spell checker
- Saving a document
- Closing a document
- Creating a worksheet
- Templates
- The workbook
- The worksheet
- Cells, rows, columns
- Rows and Columns
- Inserting
- Deleting
- Row height
- Column width
- Formatting
- Toolbar
- Font
- Numbers
- Alignment
- Wrap text
- Merge cells
- Borders, colours and patterns
- Data
- Entering data
- Editing data
- Autofill handle
- Sorting
- Filter
- Editing
- Selecting text
- More paste options
- Find and replace
- Copy, cut and paste
- Worksheets
- Insert
- Rename
- Move and copy
- Insert a comment
- Formulas and Functions
- Countblank
- Percentages
- Print and Layout
- Page setup
- Header and footer
- Print area
- Page breaks
- Print preview
- Repeating a header row
Excel: Charts and Data
This one–day course is aimed at people who have a basic knowledge of Excel or those who have completed the Getting Started 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
- Adding sort levels
- Sorting months
- Autofilter
- Advanced filter
- Subtotals
- Conditional formatting
- Consolidating data
- Validation
- Validation lists
- Define names
- Charts
- Insert chart
- Chart types
- Design tab
- Format tab
- Adding data to existing chart
- Secondary axis
- Inconsistent data
- Copying charts
- Chart locations
- Functions
- Using the IF function
- Nested IF
- CountIF
- SumIF
- VLookup and HLookup
- Logical Functions
- AND
- IF
- OR
- FALSE
- NOT
- Macros
- What is a macro?
- Recording a macro
- Testing a recorded macro
- Editing a macro
- Assigning a macro
- VBA language
- Database
- Creating a database
- Defining a database
- Automating
- Creating a button
- Using the database
- Pivot Tables
- What is a pivot table?
- Pivot data
- Inserting a pivot table
- Pivot table field list
- Value field settings
- Pivot table layout
- Tools tab
- Design tab
- Glory of pivot tables
- Refreshing data
- Protection
- Protecting cells
- Protecting a workbook
- Lists
- About excel lists
- Creating a list
- Rows and columns
- Total row
- Sort and filter
- Convert to range
- Text Strings
- Right
- Left
- Mid
- Concatenate
- Goal Seek
- Whatif analysis
- Using goal seek
- Goal seek examples
- Useful Tips
- Remove duplicates
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.