Useful Tools of Excel at Intermediate Level
3.9 (74 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,231 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Useful Tools of Excel at Intermediate Level to your Wishlist.

Add to Wishlist

Useful Tools of Excel at Intermediate Level

Get a useful knowledge for a job interview
3.9 (74 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,231 students enrolled
Last updated 8/2016
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 32 mins on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use some of the useful features of Excel
  • Represent this knowledge on a job interview
  • Use the followings: Shortcuts, VLookup, HLookup, Index, Index-match, SumIFs, Named Ranges and Advanced SumIfs, Custom lists
View Curriculum
Requirements
  • Microsoft Excel
Description

This course contains Intermediate Level exercises.  It can be very useful for those who just finished the university studies and looking for a job in the finance sector. It will require a good understanding of Excel. 

The following topics will be covered in this course: Shortcuts, VLookup, HLookup, Index, Index-match, SumIFs, Named Ranges and Advanced SumIFs, Custom lists. 

Even though students are good in Excel, almost 90% of them will not pass an Excel test in job interviews. This course will help you to learn some of the most common advanced formulas. 

Who is the target audience?
  • Anyone who has at least a basic Excel knowledge
  • This course is not ideal for beginners
Compare to Other Excel Courses
Curriculum For This Course
+
Introduction
1 Lecture 01:05
+
Shortcuts
1 Lecture 04:14
+
Intermediate formulas
4 Lectures 22:31

Index and Match formulas
06:06

SumIFs formula
02:14

Named Ranges and Advanced SumIFs
08:10
+
How to create Custom Lists?
1 Lecture 04:05
Custom Lists
04:05
About the Instructor
Excel Online Academy
4.3 Average rating
180 Reviews
5,272 Students
3 Courses
Online Education

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.