Thursday, September 24, 2015

Udemy – MS Excel Advance Training: Solve Difficult Problems




Udemy – MS Excel Advance Training: Solve Difficult Problems


MP4 | Video: 1280×720 | 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.


What are the requirements?




Students dont need any prior knowledge for doing this course. They just need desire to advance thier Excel skills




What am I going to get from this course?




Over 101 lectures and 6.5 hours of content!


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




What is the target audience?




Formulas & Function course is for everyone. If you are basic user or expert still you will find many important tools to advance your knowledge and skills for more efficiency and productivity. We are taking some basic concepts of Excel and taking it to Advanced Excel training with Practical Examples. By the end of this training, you will have mastered the advanced features and functions of this supreme software.