Online Microsoft Excel Intermediate Training Course
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 that attend with slightly more advanced knowledge of how to use this very much used software.
Course Delivery Options
Our Online Microsoft Excel Intermediate Training Course is only delivered as a one-day virtual online training course.
Online Course Details
We run our Microsoft Excel Intermediate course as a virtual online training course. The course provides a practical toolkit and is delivered across one day. Despite being online, we try to keep these sessions as interactive as our classroom based courses.
Virtual Online Courses are delivered live by one of our trainers via our online conference system and form part of our online and virtual training service Skills Garage.
Here’s our current online Microsoft Excel Intermediate training course schedule. To book, select a date below and click Book Now. We’ll send the details of how to connect to your course a few days before the course date.
3 + Delegates
9.30am to 4.00pm
Price per delegate. Includes delegate course materials.
You can see the full schedule of open courses that we deliver by clicking here.
Click a Tab, Get More Details
- Basic PC knowledge is required and a basic understanding of your operating system (Windows or MacOS)
- The software installed on your PC
- Access to Zoom via the Zoom app or your browser
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 spread sheet
- Create graphs and charts to show data
Naming Cell Ranges
- Naming individual and ranges of cells
- Amending and deleting ranges
- Using named ranges in formula’s as a navigation aid
Using a range of conditional functions such as:
- 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
- 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
We can deliver this Microsoft Excel Intermediate training course as an in-house virtual course for your business.
What is a Virtual Training Course you may ask? Rather than have our trainer travel to you to deliver a course, our trainer will join you via our conference system to deliver the course.
It means you can get your team together where ever they are based. You can get the team together in the same room. Or, have individuals join from where they are based.
Our Virtual Training Courses are normally one day in length and we deliver them in all subjects that are available on our site.
Because there is no travel involved, they are very cost-effective and good for the environment too.
We’ve made sure that you don’t lose any of the benefits of having a trainer with you in the room. Our Virtual Training Courses are still interactive, come with training materials and also include exercises, case studies and discussions.
To find out more about having an in-house virtual Microsoft Excel Intermediate training course delivered for your business, fill in the form below and we’ll get back to you. Be sure to tell us what course you are looking for. Alternatively you can call us on 015549779.
The reviews below are submitted by past delegates. If you would like to see more then please get in touch. We can pull together some feedback from our evaluation forms to help you make a more informed decision about this course.