ONLINE COURSE
Our online course is exactly same as what we teach in interactive classes. We are offering 70% DISCOUNT at the moment.
Get the benefit or you may miss the chance.
Get the benefit or you may miss the chance.
SKYPE / Face 2 Face Training
Basic / advanced excel Training
Do you want to Learn EXCEL ?
We offer different courses for all levels and take beginners or intermediate folks to Expert level.
You can join our online training course and gain expertise in excel.
For more details, write us at [email protected]
Courses (INTERACTIVE LIVE SESSIONS OVER SKYPE)
Module 1 : Basic Excel Training (EXMK001)
Course Duration : 10/15 Days
Course Mode : Online (Globally) & F2F (in few areas of Gurgaon, India)
Course Coverage :
1. Usage of basic items available on ribbon (menu bar)
(covers all menu items)
2. Formatting, Conditional Formatting
(margins, orientation, alignment, background, colors, width, hight, themes, effects)
3. How to use Filters
4. Sorting (single level, multiple level)
5. Importing Data from txt and csv Files
6. Creating lists using Data Validation
7. Group and Ungroup data
8. Protection
(sheet level and workbook level)
9. Freeze & Unfreeze panes
10. Basic and complex Formulas
11. Inbuilt Functions that are used in Formulas
12. Array Formulas
13. VLookup and HLookup
14. Define Names and use in Formulas
15. Error Checking, Tracing Precedents and Dependents
16. Graphs
17. Pivots
18. Tables
19. Adding and deleting Watch under Watch Window
20. Basic definition of Macros, Record -Playback
21. Keyboard shortcuts
22. Tips and Tricks
To Join course, write us here.
Module 2 : Advanced Excel Training (EXMK002)
Course Duration : 15 /20/ 22 Days
Course Mode : Online (Globally) & F2F (in few areas of Gurgaon, India)
Course Coverage :
1. Basic and complex Formulas
2. Inbuilt Functions that are used in Formulas
3. Array Formulas
4. VLookup, HLookup, Match and Index
5. Define Names and use in Formulas
6. Error Checking, Tracing Precedents and Dependents
7. Graphs
8. Pivots
9. Loop statements, Logical Statements and other VBA functions
10. Introduction to macros
11. Record-Play Macros
12. Write/Edit a simple macro
13. How to write your own script in VBA
14. Extreme Programming examples
15. How to read/write data from/to txt file
16. How to read/write data from/to another excel file
17. Web queries to scrape data from web
18. How to connect excel with a Database
19. Triggering macros on events like change in cell value, button click, sheet open etc.
20. Keyboard shortcuts
21. Tips and Tricks
22. Assessments and problem statements
To Join course, write us here.
HOME | SERVICES | EXTREME EXAMPLES | ABOUT US | CONTACT US | CAREERS
Copyright © 2012. All Rights Reserved.