This Intermediate course assumes that you will have a good working knowledge of all of the principles covered in the introductory Excel course.
DurationThis Intermediate course assumes that you will have a good working knowledge of all of the principles covered in the introductory Excel course.
It is also expected that you will know how to open and save files to a folder in Windows, have a good working knowledge of the layout and use of a QWERTY keyboard including use of shift, tab and control keys and understand how to select blocks of content by clicking with a mouse.
The course assumes a working knowledge of basic Excel functions such as SUM, COUNT and AVERAGE as well as the ability use absolute cell references with confidence.
By the end of the session delegates will be able to:
Inserting and renaming a new Worksheet
Importing Data from External Files
Data Validation (Drop Down Lists)
Conditional Formatting
Advanced Formatting
Auto Filters
Removing an Auto Filter
Advanced Auto Filtering
Using Named Cells and Ranges
Calculating Across Worksheets
Protecting Worksheets
Creating a Shared Workbook
Advanced Functions (IF, AND, OR, VLOOKUP, HLOOKUP, CONCATENATE etc)
Mathematical Functions
Using LOOKUPS to Access Ranges
Introduction to Pivot tables
Pivot Table Charts
HWGTA offer a variety of training courses for individuals and businesses looking to upskill, improve or refresh their knowledge.
We work with Nationally recognised awarding bodies to deliver high quality, innovative training alongside our own in-house designed training programmes. It is also possible to provide bespoke training packages tailored to your business needs.
Recruit An Apprentice!
HWGTA are proud to assist employers from small local businesses up to large international companies in recruiting, developing and training their Apprentice workforce.
We have been delivering bespoke Apprenticeship programmes for over half a century, with consistently above average success rates and excellent feedback.
By learning the basics of Outlook, you will gain a professional skill set which will allow you to become more organised and be conscience of prioritising key factors of Outlook.
Microsoft PowerPoint is one of the best and most popular tools which allows creating captivating slide presentations that can be shared easily on the web. It is the default application for creating professional presentations that effectively communicate essential information.
This one-day course has been developed for those who are relatively new to Microsoft Excel and need an introduction to the basic functionality. The skills taught on this course are pre-requisites for the Financial Modelling and Data Analysis courses that we offer.
In Access VBA you will learn how to extend the functionality of Access using a programming language called Visual Basic for Applications (VBA). With VBA you can create code which will allow you to automate the functionality of your database.
About Coursetakers.com
Coursetakers.com is more than a decade old course aggregator and Online course platform that helps students find courses and compare course prices from Training providers in the UK, by just submitting their inquiry through the website. Coursetakers also helps Institutes, Universities and Online Instructors market their courses, gain leads and get more students to enroll into their courses.
© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy
Online
USA
UK
India
UAE
South Africa
Canada
New Zealand
Australia
Malaysia
Singapore
Saudi Arabia
Egypt
Jordan