Our training courses are straightforward, wide-ranging and easy to remember. With training materials designed to be a companion for your future use they are ideal for both home and business users.
Expert Tuition
Our Excel specialist has more than twenty years’ experience using every version of Microsoft Excel professionally and providing training for many users at different skill levels. He is also highly proficient with MS Word, Visual Basic, Power Query, SQL Server and the rest of the Microsoft Suite.
Our course documents will explain how to create professional and easy-to-manage spreadsheets, automate tasks and contain many ideas and techniques for you to copy and paste into your own documents.
Syllabus
To choose the most suitable course please look over the Foundations in Excel syllabus – if you feel confident with most of the items on the list look at the Intermediate Excel syllabus – if you are happy with those topics then perhaps Advanced Excel training is the one for you?
Foundations in Excel
Interface
The ribbon | How cells work | The formula bar | Worksheets
Data
Entering data and text | Basic functions | Find and replace
Presentation
Know your audience | Fonts and styles | Number formatting | Alignment | Charts
Intermediate Excel training
Good Practice
Before you start a new doc | Quality assurance | Simplify calculation
Data
Structure your document | Search your data | Intro to pivot tables | Intermediate functions
Presentation
Styling documents | Quick Analysis | Conditional formatting | Printing
Advanced Excel training
Good Practice
Security | Publication | Quality assurance
Analysis
Advanced functions | Searching your data | Named ranges, tables and cells | Advanced pivot tables | Power Query | Macros and Code
Presentation
Conditional formatting | Advanced charts | Form controls and Hyperlinks
We tailor our courses to your needs, so if you have a particular area of interest or difficulty please let us know in advance.
Prices
- One-day course: £100 per person
- One-day on-site course for a group of up to eight: £450
(Discounts available for charities and not-for-profit organisations.)
Locations
Clear View Courses run training sessions for individuals, groups and organisations at training facilities in Bristol, on-site anywhere in the South of England and Wales or via video conferencing.
Contact
If you have any questions or want to book a session please contact Adam Hillmann on adam@clearviewcourses.com or 07817 946 487 or fill in the form on our Contact page.
Other courses
We also run Google Sheets, MS Word and MS PowerPoint courses.
Clear View Courses 