A lot of people who’ve interacted with Excel believe that Intermediate Excel course is a piece of cake. However, imagine paying for a class and realizing you can’t follow because you failed to take the class right before. This is what happens when you don’t take the Advanced Excel Course before the Intermediate one.

Recently, we got feedback from a trainee who undertook our Online Intermediate Excel Course, which you can view here. She said that she thought she knew Intermediate Excel until she took our course. This is a testament to the general perception of Intermediate Excel.

Building Blocks

We have Excel Courses from Beginner level to Advanced Excel and each course builds on the other. A lot of times, we find trainees choosing Advanced Excel before undertaking Intermediate Excel but once they start, it’s a struggle for them due to the step-by-step nature of the courses.

There is a lot of information and skills in the intermediate course that you might not be aware of. Apart from calculating and solving problems, this Excel course gives the opportunity to learn how to sort and navigate data, analyze the data, apply conditional formatting and more. It helps you go beyond the basics.

A few things that are modelled specifically for this course are; using anchors to facilitate formulas, learn shortcuts that allow you to be faster at Excel, create rules with logical formulas among others.

In addition, manually looking for errors on a spreadsheet is quite tedious especially if you are working with large volumes of data. A major issue that is solved by this course is how to deal with circular references amongst other errors.

In intermediate Excel you will also advance your skills by learning how to work with Excel formulas, list, illustrations, charts and advanced formatting.

Excel Formulas

Imagine that you get a long awaited and dreamed of interview and part of it is to simplify complex data using an Excel formula. How will you maneuver the interview?

Formulas are the most basic and important aspect of any problem solving. They make work easier and increase the ability to understand complex sets of data. By getting a deeper understanding of formula fundamentals in Excel, you will be able to independently build Excel models that solve specific tasks including financial modelling for business plans, discounted cash flows or operational metrics.  If you want to do more, taking the Advanced Excel course will help you scale higher by programming for large scale operations.

What you will learn from taking our Online Excel Course

1. The use of ($) for Cell referencing (locking formulas).

2. Useful data cleansing processes (comparing lists, identify & remove duplicates).

3. Testing specified conditions using logical functions (IF, Nested-IF and Ageing analysis).

4. Handling genuine errors result by use of IFERROR

5. Using Text functions (LEFT, RIGHT, TRIM, CONCATENATE) to return the number of specified characters from a given text or join two/more text strings; Using the Flash-Fill feature.

6. Retrieving and reconciling data made easier by use of VLOOKUP, HLOOKUP.

7. Excel features to make powerful charts.

8. Manipulating dates (MONTH, TODAY, WORKDAY, YEAR, DATE).

9. Control user input in a worksheet using Data Validation (drop-down lists, dates validation).

10. Consolidating data from multiple worksheets (by Position, by Category, using a Formula).

11. Summarizing data using PIVOT-TABLES.

12. Apply cell formatting using inbuilt Conditional Formatting.

Excel is among the most important programs in businesses as it holds many secrets that people with no knowledge are not privy to. It is important to improve your skills as it not only makes your job easier but also gives you an upper hand against competition when you are applying for that dream job.