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
Learn Excel Short Cut keys, over 100 Excel Functions
Become more creative, efficient and accurate & Fast in Excel
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:
Basic Excel Calculation & Function
Excel Short Cuts
Conditional Functions
Text and Lookup Function: Right, Left, Mid, Find, Search, Len, Rept etc
Date & Time Workday, Networkdays, Datedif, Edate etc
What IF analysis Data Table, Scenario manager, Goal Seek
Array Functions SumProduct, Transpose
Additional Features in 2010 Customize Ribbon, Slicer
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.
4.2
74 Ratings
$ 34.99
per course
Also check at
FAQs About "MS Excel Advance Training: Solve Difficult Problems"
Is the online course "MS Excel Advance Training: Solve Difficult Problems" free?
The online course "MS Excel Advance Training: Solve Difficult Problems" costs $34.99 on the online classes platform Udemy
Is "MS Excel Advance Training: Solve Difficult Problems" an online course worth taking?
94 students from the online classes platform Udemy have given an average rating of 4.2 to the online "MS Excel Advance Training: Solve Difficult Problems" and at least 2140 have completed this online training.
About
Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers. DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.