Microsoft Excel Course - Intermediate Training

Real life exercises from banking and finance

4.15 (434 reviews)

Udemy

platform

English

language

Other

What you will learn

Beat almost everyone in Excel formulas

Create complex Vlookup, Index-Match, Nested IF functions, etc

Start learning macros and Excel programming to become even more efficient in their job

Why take this course?

Microsoft Excel Course Intermediate Training + 15 mins live online consultation with the tutor

Course Overview

Microsoft Excel Course - Intermediate Training contains all formulas that are required to be known in all finance jobs. It can be very useful for those who just finished the university studies and looking for a job in the finance sector. Only relevant and essential exercises that you will need to know in work. It will require a good understanding of basic Excel knowledge.

Material are recorded with Excel 2010 but works in 2013 and 2016 furthermore most functions also work in the 2007 version.

Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel.

This course will help you to learn all formulas that could be required in any jobs and with the help of this course your Excel knowledge will be outstanding.

As your instructor I will use my 5+ years of Excel training and Investment Banking experience to guide you step by step through the Intermediate Microsoft Excel formulas to advanced level and beyond. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into the more advanced level topics, array functions.

At completion of this course you will have mastered the most important Excel formulas and come out with an outstanding knowledge. You will be able to complete any Excel tasks with efficiency and proficiency.

Below are just a few of the topics that you will master.

Creating effective spreadsheets
Managing large sets of data
Mastering the use of some of Excel's most popular and highly sought after functions (VLOOKUP, IF, NESTED IF, AVERAGEIFS, SUMIFS, INDEX/MATCH, EOMONTH and many more...)
Create dynamic report with Excel formulas.
Learn how to become super fast with Excel Shortcuts
Get ready for the Advanced Excel Course and Excel VBA programming

So, what are you waiting for, enroll now and take the next step in mastering Excel and become outstanding in jobs and interviews!

Reviews

Ian

January 30, 2023

Definitely learned quite a bit I didn't know, but as a person that generally has to leave subtitles on, the captions were absolutely awful.

Aye

August 14, 2021

it would be better if example lessons are simple and make video to check the answers of the homework are correct or not.

Benjamin

July 10, 2020

It would be better if there were practice exercises and/or he explained the functions in the order that he has them written on the excel sheet.

Freddie

April 3, 2020

It showed some useful functions and how to build them into more complex formulas but could have had better homework examples as some were a bit basic. The accent of the presenter was a little difficult to follow at some times and i found myself re-winding several times to understand correctly what was being shown on the screen.

March 22, 2018

It will be very useful in my career and also I am connecting the dots where I could have used these functions in my past.

Monir

March 21, 2018

I thought the course had really good information and learned a lot. I do think some of the examples were overly basic and didn't really see how they would be used in the real world. I would have liked to have some exercises or projects to practice on to get some kind of hands on experience.

Suzette

March 19, 2018

I have learned so many things about excel that I wish I had known earlier so that my task would have been easier. the instructor made examples and explained how he got the result. Aside from the examples for discussion purposes he also made examples that are similar to the real world and helps me relate it to the actual Excel problems I face.

Omar

February 20, 2018

Barely any practice examples, and even the ones that are available are all scattered and don't correspond to the lecture properly. So you're just kind of sitting there listening to the instructor speak but not able to practice.

Ghada

November 10, 2017

For a course that was offered for free I learned a lot about some very important functions in Excel. This course assumes you have some knowledge about excel. Very good course.

Amer

September 30, 2017

Very poor explanation about the concepts. Moreover, the instructor always runs out of words to explain topics. He seems to rush. And Plus!!! there are no working files for students to follow along. I hope his later sections are better than the section 2 which I have finished.

Othmar

September 22, 2017

Excellent Course. Good explanations with logical steps. Practical homework files are also a good resource to keep as the answers are there to practice with the formulas. Learned a trick or two. Thanks!

Jingfenchoy

September 5, 2017

The videos are easy to understand. Will recommend this class for people who want to know more about Excel formulas.

Arnold

August 17, 2017

The instructor is clear and explains well the presented problems and examples. Having taken numerous Udemy Excel courses, I regard this as more of an advanced course, rather than an intermediate course. I'm getting a lot of benefit from this course; however, given the advanced nature of the problems and examples, I think it would be great if the supplemental materials showed the exact problems that the instructor is demonstrating ,,, so that I can practice and review and learn the material better.

Subash

August 13, 2017

These shortcuts keys are very helpful to my work. With these knowledge I can accelerate my work speed.

Nathan

June 23, 2017

This course thoroughly covered many commonly used functions in Excel. The "homework" was helpful to reinforce what the lectures covered. Although some of the "homework" tasks expected the student to know functions that were not covered which was a bit frustrating.

Charts

Price

Rating

Enrollment distribution

Microsoft Excel Course - Intermediate Training - Distribution chart