Microsoft Excel Intermediate Training Course
Our Microsoft Excel Intermediate training course is only available as an in-house course. We can deliver the course as a face to face course and a live virtual online course in-house just for your business.
One Day Course | Delivered Just for Your Organisation | Delivered In-Person or Online
Microsoft Excel Intermediate Course – The Details
Flick through the tabs below to see all the details about our Microsoft Excel Intermediate training course.
Course Highlights
Here’s some quick information about our Microsoft Excel Intermediate course:
- Delivered anywhere in the UK as an in-house course
- Can also be delivered online just for your organisation
- We work with you to make the course match your needs more closely
Please Note
We are only able to deliver this course based on the Windows version of the software and not the Mac version.
Course Aim
Our one day Online Microsoft Excel Intermediate training course will provide slightly more advanced knowledge of the use and functions of Microsoft Excel.
Many of us need to use Microsoft Excel in our jobs to produce a range of spreadsheets to show a wide range of business data.
Our Microsoft Excel Intermediate Training Course is designed to provide those who attend with slightly more advanced knowledge of using this very much used software.
Course Objectives
Those who attend this Microsoft Excel Intermediate Training Course will be able to:
- Produce multiple sheet workbooks
- Use logical functions
- Sort, filter and subtotal data in the spreadsheet
- Create graphs and charts to show data
Course Content
Here’s what we cover in our Microsoft Excel Intermediate training course:
Naming Cell Ranges
- Naming individual and ranges of cells
- Amending and deleting ranges
- Using named ranges in formula’s as a navigation aid
Conditional Functions
Using a range of conditional functions such as:
- IF
- SUMIF
- SUMIFS
- AVERAGE
- AVERAGEIFS
- COUNTIF
- COUNTIFS
- IFFEROR
- ISERROR
Conditional Formatting
- Data bars
- Colour Scales
- Icon Sets
Linking Sheets and Files
- Linking different Excel sheets and sheets in the same file
- Viewing different files on one screen
- Windows split and freeze panes
- Watch window
List Management
- Sorting and filtering data using a range of values
- Multi-column sort and filter
- Advanced filter
- Adding sub-totals
- Freeze Panes
- Group and Outline
- Data Form
- Format As Table Feature
- Data Consolidation
Auditing Formula Review
- Tracing precedents and dependents
- Go to special
- Watch window
Advanced Charts and Graphs
- Creating Chart Using Shortcut Keys
- Saving custom chart as a template and as default
- Applying Trendlines
- Formatting and Editing Series, Plot Area, Data Points Chart Area, legends, etc…
- Using Sparklines
When you bring this course in-house, the content above can be tweaked and changed to meet the needs of your team.
Download the Course Brochure
Download a copy of our Microsoft Excel Intermediate training course brochure below.
Who Should Attend our Microsoft Excel Intermediate Training Course?
In-House Delivery
A 1 day training course with one of our highly experienced trainers at your location or online. You also get
- Course materials for each delegate to take away
- A course certificate
- Reporting on delegate evaluation
- Access to MyRevolution Learning to retain access to your materials and stay in touch with your trainer
Have Some Questions?
Here are some of the common questions we get asked about our Microsoft Excel Intermediate training course:
Our Microsoft Excel Intermediate courses are delivered by our friendly and highly experienced trainers. We live and breathe what we talk about in these sessions as we use most of the tools and techniques ourselves on a daily bases and bring this real-world experience into the session and the examples that we use.
Open Online Course
We currently only deliver this Microsoft Excel Intermediate course just for your organisation. We can do this in-person at your office or a location of your choice or as a live virtual training course. We can deliver this via Zoom, Teams, Webex or any other platform that you are currently using and comfortable with.
Here are the most recent reviews that have been left for our Microsoft Excel Intermediate Training Course. If you would like to see more detailed reviews then please get in touch and we can pull some data from our course evaluations together for you.
Get a Quote
Bring this Microsoft Excel Intermediate training course in-house and train your team together at the same time.
- Delivered online or in person at your business premises
- Course content can be tailored to your specific requirements
Complete the form below to get a personalised quote from a member of our team.
