Courses that have matched your search criteria
Finance & IT:
Excel Intermediate (Online)
Get more for your money with our Learning Passport. Find out more here
Timings
This online course runs in 2 sessions over the day. Morning session from 9:30am - 12:00noon; afternoon session from 2:00pm to 4:30pm with breaks included. You will need to be available to attend both.
* Please note that this course is for PC users only, we do not currently offer Excel training for Macs.
Course overview
Our Excel intermediate course is ideal for the reasonably experienced user of Excel who wants to improve their skills when using Microsoft Excel. This Excel training course will develop your knowledge and teach you how to use more complicated functions.
You will train on the version of Excel that you use in your office or at home. Our courses are highly practical and interactive. We limit the class size to 8 to ensure the tutor has time to deal with any specific queries you may have. All Open courses take place in our Exeter training suite, we supply laptops for use during the session and your materials will be provided to you on a USB drive.
This course will build on your existing Excel skills and develop your knowledge to undertake more complicated tasks.
Who is it for?
A proficiency in basic Excel use is assumed. This course is designed for those who want to build on their existing Excel skills and learn the more complicated commands in Excel. This course is ideal for people who have been using Excel, but wish to gain a better understanding of the capabilities of this powerful application.
Anyone who has successfully completed our Excel Introduction Plus and feels ready to progress their skills will enjoy this course.
What will you learn?
You will develop more complex spreadsheets, use more advanced formulae and develop skills in data analysis techniques. You will learn how to work with multiple spreadsheets and how to link other spreadsheet and other workbooks. You will also learn how to link Excel with other Microsoft applications such as Microsoft Word.
Course Content
- Customizing Quick Access Toolbar
- Autofill – Fill By Example & Custom Lists
- Working With Sheets, Links & Group Mode
- Using IF, SUMIF, COUNTIF and other logical functions
- Statistical functions, Rounding
- Logical functions - Nesting, SUMIF & COUNTIF
- Range Names
- Linking to Word & External Workbooks
- Short Cuts
- Pivot Tables
- Database Functions, Multiple Sorts & Filters
- Date Arithmetic
- Conditional Formats
- Charting
- Lookup Tables
- Manipulating Data
- Formatting and Display techniques
- Sorting and Querying Data
- Protection and Security
A note about attending a 'Virtual' training session
This course will be run on the Zoom video conferencing platform.
If you've never used Zoom - or any other video conferencing platform - before don't worry, it's quite straightforward!
Before the session, we'll send you instructions to help you get started. The key thing is to ensure that your video and audio settings are working, which you can test before the session.
All you'll need is a laptop/PC with audio and video capability, a good internet connection and somewhere quiet to sit and share a 'virtual learning space' with us.
Who is the trainer?
Sue Biggs – Senior Crisp Associate
You may also be interested in?
- Excel Introduction Plus (Online)
- Excel Introduction Plus (Face-to-Face)
- Finance for non-Finance Managers (Face-to-Face)
Benefits of the course
By the end of the session you will feel……
…..that you have expanded your knowledge of Excel and that you are able to undertake more complicated tasks with ease, saving you precious time.
Other people like you who attended this course commented:
- “Great course, Excellent Trainer”
- “A really useful course with lots of Excellent hints and tips”
- “Very informative and useful – really enjoyable too”
Didn't find the right course you were looking for?
Why not try a new search