After every module you have to complete a MS Excel exercise that tests your understanding of the module topics. Assignments will simulate real-life business situations and expect you to analyze data, charting, lookups, macro etc. You will be provided with the data-sets for these exercises.
Lifetime Access & 24x7 Support
Once you enroll for a batch, you are welcome to participate in any future batches free. If you have any doubts, our support team will assist you in clearing your technical doubts.
In this advanced MS Excel training you will learn how to use MS Excel -
As a business analysis and tracking tool
To perform detailed analysis on data using advanced formulae with nested conditions
To obtain business intelligence from data using advanced filters, pivot and sorts
To make professional presentations using charts, conditional formatting and dynamic linking
To automate repetitive tasks using Macros
To build advanced macros using VBA - loops, arrays, variables, database access
To track business metrics using complex dashboards with scroll and charting functions
To secure your MS Excel worksheets with security features
Build hands-on lab exercises and projects simulating real-business case studies
What jobs will I get?
MS Excel is #1 business tool today. You will use MS Excel across various functions including Sales, Marketing, Project Management, HR, Operations, Supply Chain etc. Job Roles in these departments include
Your role will be to interface between client and internal domain teams. You will use MS Excel to capture and analyze details of the clients business. This will include capturing and analyzing sales figures, operations forecasts, cost-centre categorization, building dashboards, tracking tickets etc.
Your role here will be to coordinate large projects across client and in-house teams. You will extensively use MS Excel to make Gantt Charts, Assign tasks, Monitor deadlines and track dependencies and metrics.
You role here will be to crunch large volumes of data and provide business intelligence to your teams. Data Analysts typically look for patterns in data and make forecasts and simulations. You will use advanced excel functions including VBA to automate data analysis and formatting tasks. You will also extensively use graphs to professionally present your analysis.
Your role here will be to monitor day to day operations and ensure a smooth flow. You will use MS Excel to track team member KPI's, deadlines, red flag issues, present trends etc
What if I have any doubts?
For any doubt clearance, you can use:
Discussion Forum - Assistant faculty will respond within 24 hours
Phone call - Schedule a 30 minute phone call to clear your doubts
Skype - Schedule a face to face skype session to go over your doubts
Do you provide placements?
In the last module, DeZyre faculty will assist you with:
Resume writing tip to showcase skills you have learnt in the course.
Mock interview practice and frequently asked interview questions.
Career guidance regarding hiring companies and open positions.
"I researched 4 other online Excel trainers before choosing you guys. I am glad at my decision I must say. The online live delivery is unique and very powerful. Such an awesome way to learn Excel at my convenience"
6th August, 2014
"The real life assignments and projects are the best part of your course. They seem very similar to what I need at work. Appreciate the prompt and excellent support to my doubts in your forum. "
6th August, 2014
"Thanks DeZyre team for a fun filled learning experience. I assumed learning VB and dashboards would be very difficult. But your faculty and hands-on exercises did a terrific job of strengthening my concepts. I can already see my efficiency improve at work. "
MS Excel is #1 business tool today. You will use MS Excel across various functions including Sales, Marketing, Project Management, HR, Operations, Supply Chain etc. This advanced MS Excel course will prepare you technically for roles such as Business Analyst, Project Manager, Data Analyst, Operations Managers in these domains.
DeZyre's MS Excel Curriculum is the most in-depth, technical, thorough and latest curriculum you will find. Your leaning method is also very unique - through live instructor led sessions that are interactive. This curriculum has been reviewed in detail by a panel of 7 Business Managers with 10+ years of international experience in companies such as Credit Suisse, Yahoo and JP Morgan.
Nothing. This course starts from the basics and assumes you have no background in MS Excel. If you face difficulties our helpful teaching assistants are available round the clock to answer your questions.
From our previous MS Excel batches (both offline and online), our research and survey has indicated that online learning is far more effective than offline learning -
a) You can clarify your doubts immediately
b) You can learn from outstanding faculty
c) More flexibility since your don't have to travel to a class
d) Lifetime access to course materials