Skip to content
Write a review
UdemyExcelPaid courseExpert levelCertificate

MS Excel Advance Training: Solve Difficult Problems (Udemy.com)

Advance Excel 2007 and 2010 features: Do Advance Excel Training and use Excel like a Pro: Charts, Pivot Table & Array,

4.3
105 reviews

Created by: Manoj Kumar

Last updated September 2016

icon
What you will learn

  • If you want to learn Excel 2007 from basic and reach to very advanced level of Excel usage, then you are at the right place.
  • Adv. tools like Vlookup, Hlookup, text, Financial Functions, Array Function, Pivot Table and scenario & Sensitivity analysis.
  • Over 6 Hours of Video content with more then 100 videos
  • Learn Excel Short Cut keys, over 100 Excel Functions
  • Become more creative, efficient and accurate & Fast in Excel

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.3 out of 5higher than 13% of them
  • Reviews105#337 of 356 by number of reviews
  • Length9.6 hourslonger than 69% of them
  • Last updatedSeptember 2016earlier than 93% of them

icon
Course Description

  • Updated on 18 August, 2015
  • "Advanced Excel 2007 for Professionals" is a comprehensive online training program. It is covered in 6 hours of videos and covers exhaustive list of topics. There are so many features available in excel that can save a lot of time & can make your work presentable.
  • We are specialists in offering expert level training courses and other great features of Excel. As part of our Advanced Excel training you will gain the necessary knowledge required for the efficient use of the tools and other exciting features which this outstanding software has to offer.
Categories of all Functions Covered:
  1. Basic Excel Calculation & Function
  2. Excel Short Cuts
  3. Conditional Functions
  4. Text and Lookup Function: Right, Left, Mid, Find, Search, Len, Rept etc
  5. Finance, Database Functions NPV. IRR, FvSchedule, PMT, IPMT, PPMT
  6. Maths & Stats Sumif, Averageif, Countif, Ceiling, Floor etc
  7. Date & Time Workday, Networkdays, Datedif, Edate etc
  8. What IF analysis Data Table, Scenario manager, Goal Seek
  9. Array Functions SumProduct, Transpose
  10. Additional Features in 2010 Customize Ribbon, Slicer

Tools and Commands:

  1. Conditional Formatting
  2. Paste Special
  3. Go To Special, Sorting, Filter, Adv Filter
  4. Error Tracking, Evaluate Formula, Name Manager
  5. Import Date from web
  6. Text to Column, Data Validation, Consolidate
  7. What IF Analysis, Scenario Manager, Goal Seek
  8. Grouping, SubTotal, Solver
  9. Workbook & workSheet Protections
  10. Pivot Table
  11. Spinner, Scroll Bar, List Box, Combo Box
  12. Analysis Tool Pack

Much more to explore in the videos.

Read More Expert Expert Level product length iconTime: 9.6h

icon
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.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Manoj Kumar

I am Manoj Kumar. I am an MBA (Finance) from ICFAI and CFA level 3 candidate from CFA Institute, USA. I am running Investment Banking Institute, New Delhi. I teach Adv Excel, VBA, Dashboards, Financial Modeling, Valuations & M&A. I have been into consulting in Project Finance before moving to training.

Areas of Training: Excel, VBA,Dashboard Designing,Financial Modeling, Valuation & M&A Have trained in WNS, Global Energy, Intec Capital, Creative Web Mobi, ICOFP, GNIM etc Conducted more than 150 open workshops and trained more than 2500 participants Developed Video based Training courses on Various SubectsMy passion for training led me to start the IB Institute in New Delhi, India. I have two years of rich experience in the fields of Investment Banking, Corporate Valuation, Equity Research and Consulting for Project appraisal.

I have conducted more then 150 workshops for various colleges and corporate houses. I am Certified Excel Specialist and Trainer from Microsoft.

Read More

icon
More courses by Manoj Kumar

$39.99

All courses by Manoj Kumar

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

All Excel courses

icon
Reviews

4.3

105 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Rakhi Shrivastava on 5/18/2020

Hi, I am HR by profession and i keep my all number record online and I know basic Excel and I like excel most. So, I want to enhance my skill on excel so I can use more this.

By Ayushi Parikh on 9/5/2019

could have been on the higher level. too basic

By Ravi Kumar on 7/1/2019

This is one of the Best Decision which I have ever made to take this course anyone who's looking for an edge and really wanted to Deep Dive in function and how to use them in combination that's the right choice..

By Arnold Schwartz on 8/22/2017

This advanced course is comprehensive & takes a learn-by-problem/example approach. The illustrations are well-explained and truly support learning. What this instructor does different than most others is that he explains the problem, works out the problem while explaining every step, and then he re-explains (which is great). Certainly, it's not an entertaining course, but rather a no-nonsense approach to teaching what one needs to know.

By Douglas Mayfield on 2/22/2017

This is one of the most practical Excel courses out there. I really appreciate topics being being repeated (especially the more difficult one's) to reinforce our learning.

By Frank Freese on 1/28/2017

Poor examples. Dialect makes it difficult to understand. Most features are not advanced.

By Brian Thompson on 8/19/2016

This course delivers a large amount of very useful information, in a very concise and well-organized manner.

By Fred Hickman on 4/25/2016

Thesoundqualityisverypoorbutthecontentisgood.

By Piyush Thakurr on 2/20/2016

course is very nice ...easy is to understand and i would recoomend this course to those who want to learn Excel and is a begineer

By Mohammed Ishaq on 11/23/2015

The content of the course is very advanced. The way instructor delivers is clear and simple. Got to learn so many things, my go to course for Excel. Thank You!

Showing all 10 reviews on CourseDuck

Read all 105 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 86 / 100

MS Excel Advance Training: Solve Difficult Problems
Visit course on Udemy Write a review
  • Video Duration: icon 9.6h
  • Price: $19.99
  • Provider: icon Udemy
  • Updated: icon September 2016
  • Level: Expert Expert
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com