MS Excel Advance Training: Solve Difficult Problems

MS Excel Advance Training: Solve Difficult Problems

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

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

Url: View Details

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.
• In this course, we are starting from very basic excel features and taking to very 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

Rating: 4.05

Level: Expert Level

Duration: 9.5 hours

Instructor: Manoj Kumar