Advanced Excel Training in Chennai for CorporateExcelrocker
VAT not incl.
- 16 hours of class
Frequent Asked Questions
· What are the objectives of this course?
Join the workshop and enhance your competency and skill level with the powerful functions, hidden features, TAT saving tips and tricks. Which will ultimately enable to a value addition to your work and can make a difference at your workplace.
· Who is it intended for?
Any one who is the basic user of excel or any working professionals like MIS Executives, Bankers, Admin Executive, MBAs, CAs, Managers, Sales or Mktg , HR whose core job is to deal with data in excel.
Those who are the basic or intermediate user of excel and want to learn the hidden features, tips and tricks, tools and features of excel to the next level.
· What marks this course apart?
For our best training approach and unique delivery style makes us different among others and resulted in second to none.
· What happens after requesting information?
Need to contact the course provider for enrolment or registration. Registration form has to be dully filled with all necessary information and full payment has to be made to reserve a slot.
What could be improved the training delivery with connected to the real time corporate examples. time saving techniques, smart and quick approaches, presentation styles, hidden functions and features of excel. top of everything all my doubts are cleared with personal attention by the trainer.
Would you recommend this course? Yes.
What you'll learn on the course
Excel for Accounting1
Teachers and trainers (1)
A freelancer having 9 years of experience as MS-Office Trainer and 4 years of expertise as automation consultant. Specialised in providing Advanced excel training to corporate and working professionals as well. he has conducted many Public workshop and quite renowned as one of the best trainer in Chennai.
Have a look over the course contents what we offer:
• Advanced Ribbon Feature of Excel
• Capabilities of Pivot Table and Pivot Chart
• Charts and Graphs Including Smart Art Features
• Creation of Custom and Dynamic List
• Condition based formatting , Finding and removing duplicate values
• Prevention of data Errors and User defined Restrictions
• Worksheet Consolidation using Shell Command
• Multi-criteria V-Look up and H-lookup and other important Functions
• Functions( Financial, Text, logical, if and nested ifs, etc.)
• Create bar chart and organization chart using excel function and Text Box • Sorting , Filter and Advanced Filter (Creation a search engine in excel)
• Grouping , Outlining along with Subtotals.
• Creation of Hyperlink(Sheet , work book, email)
• Protection techniques
• To work with Multiple workbooks in a single Window.
• Extensive Keyboard Shortcuts
• Hidden Features and Functions in Excel
• Print techniques and management
• Importing and exporting data from and to various file formats.
• Workbook sharing and merging various to a single work book.
• Track changes
• Working with back stage view and Creation of Own Ribbon Tab
• How to create macro and usage of them. (In Brief)
Comprehensive Course Coverage by Expert trainers
Individual attention by trainer
Post Training Support for 90 days
Excellent Course material (Soft Copy)
Batch Size never exceeds 20!
Course Content regularly upgraded
Focus on real world application‘
Stare-at-the-projector’ & ‘Follow-the-instructor’ approach never used!
Trainers are end users of Excel and not IT guys!
Comprehensive take home material