We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Details

Looking for the Advanced Excel training? Then you are at the right stop. we are the freelancers provide training in advanced excel to corporate and individuals as well.We also conduct the workshops on weekends for working professionals.

Our Workshop will empower you with the Following:

Keyboard Shortcuts.
Hidden functions and Features along with tips and tricks.
Usage of Data summarising tool like Pivot, Subtotal, Table styles etc.
Data Analytical tool like Solver, Goal Seek, Data Table.
Dashboard designing.
Working with the other applications in Excel.
Usage of Conditional Formatting in Template.
Protection Techniques and Hiding techniques
Easy working with huge volume of data.
Consolidation of workbooks, worksheets, Notepads / textfiles in 10 seconds.

Course features

Pre and Post Training support (on Demand)
Comprehensive Course Coverage by Expert trainers
Individual attention by trainer
Flexible Schedule
Post Training Support for 90 days
Excellent Course material (Soft Copy)


We provide corporate it training on advanced excel, Professional powerpoint, MS Access, MS Project,excel vba and macros, finance modeling in New Delhi / NCR, Mumbai, Pune, Kolkata ,Chennai, Bangalore, Hyderabad, Vishakhapatnam & Cochin.

Outline

• 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
• Consolidation of 1000 text files using Shell Command, Worksheet and Workbook consolidation
• 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)

Speaker/s

Mr. Prabhas:

I am a corporate trainer and facilitator with a creative bent of mind along with strong communication skills and understanding of various facets of training in alignment with the organizational goals.Having15 Years of experience as MS-Office trainer and 4 years of count as an automation consultant imparted training to different verticals of the industries. I strive for quality in everything I do. With wide exposure to the corporate culture, my training suits the various levels of competency amongst the trainees. My coaching style and delivery method is quite unique and always welcomed by the professionals and results in choosing me second to none.

Speciality:
Personal attention and Non-mechanical approach
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

Special Offer

Commercials are always negotiable depending upon no of days/ batches of training program.
Reviews
Be the first to write a review about this course.
Write a Review
EXCELROCKER is the renowned Advanced Excel Training Partner for the corporate in Chennai and other major cities across India. We provide Microsoft Excel Training, completely Tailor-Made and customise contents according to the client need and meeting the business requirement of the industries. We not only teach excel but also empower the participants with tips and tricks, troubleshoot techniques, best industrial practices, Out of Box solutions and many more.

Our trainers are the end user of excel and we always do research on Microsoft excel features, functions and keep upgrading the hands in precisely, which really helps the participants in understanding the subject in to the core and can make use of those time saving techniques and smart and finest solutions to make the difference at their workplace, which will be a value addition to the job profile and work as well.

We do conduct Advanced Excel Workshops on weekends at business class hotels to equip professionals with more advanced features of PIVOT Table, Advanced Charts, Formula Based Conditional Formatting, Data Consolidation and many more.....

Apart from Advanced Excel , we do cater our training service on Professional PowerPoint, Excel VBA, MS Access with VBA, MS Project, Finance Modeling with Excel, Finance for Non-Finance etc. ...
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.