Microsoft Excel 2013: Intermediate
Buying 11 or more Microsoft Office courses?
10% off orders of 11+ courses
20% off orders of 50+ courses
This interactive online course will broaden your Microsoft Excel 2013 knowledge by explaining the various tools and features within the program.
Course Level: Intermediate
Certificate: Self printed
Description
In the course Microsoft Excel 2013: Intermediate, the presented interactive lessons focus mainly on performing various calculations.
You will broaden your basic knowledge by the application of logical and text functions and will get acquainted with the principles of referencing to the values in other cells.
You will learn to fill cells with series of data and will familiarise yourself with the advanced options of sorting and filtering data or searching for specific values in extensive tables.
You will also examine how to split longer text entries in tables into individual data placed into several columns.
What you'll learn
- Customisation of the Quick Access Toolbar
- Customising the Ribbon
- Manipulation with sheets of multiple workbooks
- Advanced paste options
- Copying multiple items
- Pasting external data into Excel
- Advanced number formats
- Custom number format
- Worksheet protection
- Advanced work with Excel tables
- Using references in formulas
- Comparing and connecting values using operators
- Cell and range references
- Conditional formatting rules
- Conditional formatting based on a formula
- Function library
- Text functions
- Advanced text functions
Suitable for
- Office computer user
- Those wanting to develop Microsoft Excel skills and knowledge
- Job Seekers
- Those working with computers
- Those using Microsoft Excel at work, home or in education
Certification
Self-Printed Certificate Option
Upon completion of the course, a digital certificate will be available to download instantly.
Recent Reviews
19th July 2025
Great
Easy to navigate
18th July 2025
Level 2 health & Safety within the catering world. With using virtual college
With using virtual college, it was quick and easy to pay and access my chosen course. I had a choice of using different methods on what type of device that I could use which was great for me. The course was very informative and I learnt a lot and the assessment at the end was good & you have a certificate that you can download straight away. Very highly recommend.
18th July 2025
Easy to access the Training
The process of purchasing the training (in this case combined offer of Allergy Awareness and Level 2 Food Safety and Hygiene) was easy as was the ability to access and complete the training. The online training system works well. The Food Allergy course was comprehensive and well structured my only criticism is that the Level 2 Food Safety and Hygiene is not as well structured with the same material repeated may times in different places so the course could be made much shorter.
18th July 2025
Very good everything completed…
Very good everything completed professionally
18th July 2025
Found the training easy to access and…
Found the training easy to access and navigate through different sections
17th July 2025
Very easy to follow well constructed…
Very easy to follow well constructed course
17th July 2025
The system was easy to use and things…
The system was easy to use and things were clear throughout
17th July 2025
easy to complete
easy to complete very informative
17th July 2025
Very informative
Very informative. Well navigated and explained in ways I could understand with out jargon that can often get in the way.
16th July 2025
Full of the correct info and to the point
Was very easy to operate and the course was full of really good information Could use a better functionality for the partially sighted individuals like myself
Excellent
4.7 out of 5
15857 Reviews on
