Why book this course?
Many of us are familiar with the basic functions of Microsoft Excel, but few realise how flexible the software is, and the range of situations it can be used for. Even if you have a solid grasp on how to use Excel, it’s likely that you’re missing out on tricks and tips that could elevate your productivity.
Our action-packed Intermediate Training course builds on our Microsoft Excel Beginners course, extending your skills and further improving your confidence with the software. Learners will delve into the facilities of data tables and databases, learn even more powerful formulae, and manage and finish their spreadsheets in a way that stands out from the crowd.
Who is the course for?
Our Microsoft Excel - Intermediate Training course assumes a good level of prior knowledge of the basics of Excel, equivalent to our Microsoft Excel Beginners Introduction course.
This will include anyone who has taken that course with us, or who uses Excel on a day-to-day basis for basic calculations and organisation.
What content will the course cover?
Recap on some basic formulae
-
Absolute and Relative Cell Referencing
-
Average/Max/ Min Functions
-
Custom Lists and Creating Own
-
BODMAS – order of calculation
-
Shortcuts
-
Quick Fill
Working with Sheets and Workbooks
-
Worksheet administration
-
Work on multiple workbooks – 3d Formulae
-
Freeze panes/Split Screen
-
Use Styles, Creating and Merging
-
Use borders and shading effectively
Conditional Formatting
-
Icon Sets and Managing Rules
Data Lists
-
Creating data lists
-
Simple and custom sorts
-
Maintain lists with data forms
-
Use Subtotals
-
AutoFilter lists
-
Advanced Filtering
Range Names
-
Why you would use them?
-
Using Range Names in Formulae
Charts
-
Creating and editing charts
-
Changing chart location and adding data
-
Change/customise the chart type
-
Auto format and customised auto Sparklines
Creating Hyperlinks
What will I get out of the training?
Learners on our Microsoft Excel - Intermediate Training course will gain an understanding of how to use Microsoft Excel for database purposes, including how to store and analyse data within spreadsheets. You’ll also learn to use and understand a greater variety of formulas and functions, and how to manage and finish your spreadsheets quickly, easily and professionally.
At Kent Trainers, we’re proud to offer courses that take the needs of businesses into account. All of the learners on our Microsoft Excel courses will benefit from in-depth practical exercises, as well as being able to ask questions and gain feedback from our trainers - tailoring your learning experience to the skills you need.
What is the duration of this course?
This is a 1-day course.
The timings and format for our courses are as follows:
- In-house & bespoke courses, held virtually or at a venue of your choice
For all in-house training courses, we will adapt the timings and format for each day around the needs of your organisation and team. Please get in touch with us to discuss your requirements.
- Scheduled training courses held at one of our venues
Courses commence at 9:30am and finish at approximately 4:30pm. A hot and cold buffet lunch is included on all our scheduled courses, and refreshments are provided throughout the day.
- Scheduled training courses held virtually
Unless specified, courses commence at 9:30am and finish at approximately 4:00pm. The day is broken up into modules, both online and offline to ensure engagement and interaction. We also ensure that there are plenty of comfort breaks throughout the day.
