Web Development
Data Science
Python
SQL
JavaScript
Artificial Intelligence
IT & Software
IT Certifications
Hacking
AWS
Arduino
DevOps
3D Modeling
Graphic Design
Photoshop
Drawing
Digital Painting
UX Design
Business
Data Analysis
Communication Skills
Project Management
Leadership & Management
Human Resources
Digital Marketing
Social Media Marketing
Marketing
SEO
Google Analytics
Branding
Excel
Office Productivity
SAP
PowerPoint
Microsoft Access
SharePoint
Finance & Accounting
Trading & Investing
Accounting
Bitcoin
Personal Finance
Video Editing & Animation
Photography
Adobe Premier Pro
Adobe Lightroom
Personal Development
Productivity
Career Development
Life Coaching
Health & Fitness
Meditation & Mindfulness
Yoga
Music
Music Production
Guitar
Piano
Singing
Language Learning
Teaching & Academics
Engineering
Math
LifestyleMicrosoft Excel Course - Intermediate Training (Udemy.com)
Real life exercises from banking and finance
Created by: Excel Online Academy
Last updated February 2017
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
How it compares
Against the other 355 rated Udemy courses in Excel on CourseDuck:
- Rating4.3 out of 5higher than 13% of them
- Reviews462#232 of 356 by number of reviews
- Length2.8 hoursshorter than 77% of them
- Last updatedFebruary 2017earlier than 89% of them
Quality Score
Overall Score : 86 / 100
Course Description
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
Who this course is for:
- Finance people
- Everyone who use Excel
- Students who would like to become outstanding in jobs and interviews
Udemy Discount
The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.
Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.
Instructor Details
- 4.3 Rating
462 Reviews
Excel Online Academy
Online Excel Academy provides educational services to everyone including students , professionals and companies. The main profile of Excel Online Academy is mostly Microsoft Excel and MS Excel Visual Basic (VBA) education by online courses and private tuition.
Additional services are available such as Private Courses, CV Advisory and Writing, Full Interview Preparation and Career Advisory in finance.
The tutor is an investment banking professional who specialized in Excel and Excel programming. Has experience in firm valuation, risk management, trading and statistics and working experience in the largest investment banks. Has been teaching private students more than 4 years in finance and in Microsoft Excel. Furthermore, held several professional training in Excel for companies.
These days it is not enough to be good, you need to be exceptional. Our services are aimed to help all people who are looking for a job or willing to improve their career.
Related courses
Microsoft Excel Data Analysis - Learn How The Experts Use It (2026)
5.0 (5,696 Reviews)
Provider: Udemy
Time: 3h
$11.99
Original price
Reviews
By Benjamin Kerr on 8/16/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.
By Sudharsan Srivatsan on 6/19/2020
Course is designed well and easily understandable
By Nkiru Udechukwu on 6/13/2020
The course is perfect for my need.
By Freddie Rose on 4/24/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.
By Tony Ukey on 2/14/2020
So far it is uninspiring.
By Chastity Irwin on 11/14/2019
Not as hands on as I would have liked it to be.
By Sihle Radebe on 11/12/2019
Its teaching me simpler ways to do spreadsheets that will save me time.
By Carol Sibeko on 9/13/2019
was very helpful
By Paula Yankova on 9/13/2019
The content of the course covers a variety of the most popular Excel functions and presents them in a more complex yet simple to understand way. If there was one thing I could add in this course would be workbook with all the exercises the tutor is doing.
The course is exceeding my expectations.
By Wynand Riekert on 9/11/2019
Yes
By Maggie Bapela on 7/13/2019
i have learned quite a lot from this training, now i can work on excel easily.
By Nicolette Bowers on 7/13/2019
I would need to practise formula's more but it was i do have a better understanding now.
- Video Duration:
2.8h - Price: $11.99
- Provider: Udemy
- Updated:
February 2017 - Level:
Intermediate - Language:
English - Certificate:
Yes
30-day money-back guarantee on most paid courses
Udemy Coupon Price Tracker
