Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
9 Hour(s) 35 Minute(s)
Language
English
Taught by
Manoj Kumar
Rating
Course Overview
Advance Excel 2007 and 2010 features: Do Advance Excel Training and use Excel like a Pro: Charts, Pivot Table & Array,
- 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.
- Basic Excel Calculation & Function
- Excel Short Cuts
- Conditional Functions
- Text and Lookup Function: Right, Left, Mid, Find, Search, Len, Rept etc
- Finance, Database Functions NPV. IRR, FvSchedule, PMT, IPMT, PPMT
- Maths & Stats Sumif, Averageif, Countif, Ceiling, Floor 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.
Course Content
- 10 section(s)
- 133 lecture(s)
- Section 1 Getting Stated with Excel:
- Section 2 Basic Excel Calculations
- Section 3 Quick Excel Short Cut Keys
- Section 4 Conditional Function: IF
- Section 5 Paste Special
- Section 6 Conditional Formatting
- Section 7 IS and Lookup Functions:
- Section 8 Basic Statistical Functions
- Section 9 Rounding Function
- Section 10 DataBase Functions:
What You’ll 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
Skills covered in this course
Reviews
-
JJaved Khan
Very good
-
RRakhi Shrivastava
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.
-
RRavi Kumar
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..
-
AArnold Schwartz
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.
