MS Excel Advance Training: Solve Difficult Problems

MP4 | Video: 1280x720 | 66 kbps | 44 KHz | Duration: 7 Hours | 1.33 GB

Genre: eLearning | Language: English

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

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

The course itself is designed in very fine way having step by step & logical approach to explain the concepts & logic that will make things easy to remember in future. This course will help to improve your work in excel as you covering the topics with real life examples.

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.

readmore

IB Institute training makes sure that you learn the Advanced Excel software effectively and efficiently.

In this way you will have the capabilities and required knowledge to really unleash the great power of Advanced Excel once you have made use of the Advanced Excel training courses which we provide.

Categories of all Functions Covered:

Basic Excel Calculation & Function

Excel Short Cuts

Conditional Functions

Text and Lookup Function:

Finance, Database Functions

Maths & Stats

Date & Time

What IF analysis

Array Functions

Additional Features in 2010

Tools and Commands:

Conditional Formatting

Paste Special

Go To Special, Sorting, Filter, Adv Filter

Error Tracking, Evaluate Formula, Name Manager

Import Date from web

Text to Column, Data Validation, Consolidate

What IF Analysis, Scenario Manager, Goal Seek

Grouping, SubTotal, Solver

Workbook & workSheet Protections

Pivot Table

Spinner, Scroll Bar, List Box, Combo Box

Analysis Tool Pack

Much more to explore in the videos.