Become an Excel Expert in 30 days

About Advanced MS Excel Training Course

feature

Remote Lab and Projects

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.

feature

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.

feature

Weekly 1-on-1 meetings

feature

Money Back Guarantee

DeZyre has a 'No Questions asked' 100% money back guarantee. You can attend the first 2 webinars and if you are not satisfied, please let us know before the 3rd webinar and we will refund your fees.

Benefits of

How will I Benefit?

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

  • Business Analyst

    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.

  • Project Manager

    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.

  • Data Analyst

    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.

  • Operations Manager

    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.

Advanced MS Excel Training Course Curriculum

Module 1

Filling Data

  • Understanding Filling
  • Filling A Series
  • Creating A Custom Fill List
  • Modifying A Custom Fill List
  • Deleting A Custom Fill List
Module 2

Formula Referencing

  • Absolute and Relative Referencing
  • Relative Formulas
  • Problems With Relative Formulas
  • Creating Absolute References
  • Creating Mixed References
  • Other basic formulas
Module 3

Creating Name range

  • Creating Names for the range
  • Using Names In New Formulas
  • Creating Names Using The Name Box
  • Using Names To Select Ranges
  • Pasting Names Into Formulas
  • Creating Names From A Selection
  • Using The Name Manager
Module 4

Logical Functions

  • Understanding Logical Functions
  • Using IF To Display Text
  • Using IF To Calculate Values
  • Nesting IF Functions
  • Using IFERROR
  • Using AND
  • Using OR
  • Vlookup function
  • Multiple Vlookup
Module 5

Conditional Formatting

  • Formatting Cells Containing Values
  • Clearing Conditional Formatting
  • More Cell Formatting Options
  • Top & Bottom Ten Items
  • Working With Data Bars
  • Working With Colour Scales
  • Working With Icon Sets
  • Creating Sparklines
  • Editing Sparklines
Module 6

Advance Validation

  • Creating drop down in cells
  • Restriction values from list only
  • Creating error message
  • Creating dependent list
Module 7

Formulas

  • Count, CountA, CountIF & CountBlank
  • Sum, SumIF & SumIFs
  • Networkdays
  • Networkdays International (For ver 2010)
  • Today & Now function
  • Trim (Removing unwanted spaces)
  • Concatenate (Combining columns)
Module 8

Dynamic table

  • Converting data into table
  • Automation calculation in table
  • Converting table to normal range
  • Using table in Charts & Vlookup
Module 9

Sorting Data

  • Understanding Lists
  • Performing An Alphabetical Sort
  • Performing A Numerical Sort
  • Sorting On More Than One Column
  • Sorting By Rows
  • Working with subtotal
  • Paste special
  • Hyperlink
Module 10

Filtering Data

  • Understanding Filtering
  • Applying And Using A Filter
  • Clearing A Filter
  • Creating Compound Filters
  • Multiple Value Filters
  • Creating Custom Filters
  • Using Wildcards
Module 11

Creating Charts

  • Choosing The Chart Type
  • Creating A New Chart
  • Working With An Embedded Chart
  • Resizing A Chart
  • Dragging A Chart
  • Changing The Chart Type
Module 12

Charting Techniques

  • Adding A Chart Title
  • Adding Axes Titles
  • Positioning The Legend
  • Showing Data Labels
  • Showing A Data Table
  • Modifying The Axes
  • Showing Gridlines
  • Adding A Trendline
  • Adding A Text Box To A Chart
  • Creating combination chart
  • Creating 2 Axis chart
Module 13

Pivot Tables

  • Understanding Pivot Tables
  • Creating A PivotTable Shell
  • Dropping Fields Into A PivotTable
  • Filtering A PivotTable Report
  • Clearing A Report Filter
  • Calculation in pivot
  • Formatting A PivotTable Report
  • Dynamic range for pivot
  • Understanding Slicers
  • Creating Slicers
Module 14

File / Data Security

  • Open & Modify file password
  • Sheet protection
  • Protecting your sheet from deletion
  • Protecting few cell, rows or cols
  • Protecting your data from copying
Module 15

VBA: Macros

  • Recording & Running Macros
  • Creating button to run the macro
  • Assigning shortcut to macro
  • Deleting Macros
  • Relative reference in Macros
Module 16

VBA: Basics

  • Overview of Excel VBA Editor
  • Adding & Deleting Modules
  • Sub & End Sub
Module 17

VBA: Worksheet and Ranges

  • Protecting your Macro Codes)
  • Working with Workbooks & Worksheets
  • Understanding Ranges coding
  • Declaring Variables
  • Arrays
  • Pivot Tables from VBA
  • User Forms
  • Databases
Module 18

VBA: IF condition

  • Using IF in macro
  • Using Multiple IF in macro
Module 19

VBA: Loops

  • Understanding Looping
  • Practically using looping in macro
Module 20

VBA: Debugging

  • Taking Backup of Modules
  • Debugging Code & Break Points
  • Commenting Codes
Module 21

VBA: Messaging

  • Creating Message Box for interaction
  • Using different types of Message boxes
  • Using IF Condition in Message Box
Module 22

VBA: Practical Projects

  • Formatting regular reports
  • Auto Filtering & Separating Data
  • Consolidating Multiple Sheet into one
  • Consolidating Multiple files into one
Module 23

Dashboards: Visualization Best Practices

  • Overview of Excel Dashboards and what can be done
  • Designing Dashboards - the considerations
  • Tips for Building Excel Dashboards
Module 24

Dashboards: Excel Charting Principles

  • Overview of different chart types
  • Editing and formatting your charts
  • Creating and customizing Charts
  • Using specialist charts for your Excel Dashboards
  • How to select the Right Charts for your Data
Module 25

Dashboards: Excel Pivot Tables

  • Creating Pivot tables
  • Changing the Pivot table layout
  • Producing reports
  • Grouping and ungrouping data
Module 26

Dashboards: Creating Excel Dashboards

  • Dashboard Do's and Don'ts
  • Data Layout Creating Dynamic Dashboards
  • Creating a Thermometer Chart
  • Using Alerts to draw attention to dashboards
Module 27

Creating Interactive Components

  • Adding a scroll bar to a data window
  • Adding option buttons to a chart
  • Using a combo box drop-down
  • Using a list box control
  • Using the Check Box Control
Module 28

Analysing Data

  • Understanding Data Quality issues
  • Linking Data
  • Merging and Consolidating Data
  • Using the dashboards with Excel Pivot Tables

Advanced MS Excel Training Course Reviews

See all 3 Reviews

FAQs for Advanced MS Excel Training Online Course

  • Why do I need the DeZyre Course in Advanced MS Excel with Macro, VB and Dashboards?
    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.
  • Why should I learn Advanced MS Excel with Macro, VB and Dashboards from DeZyre instead of other providers?
    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.
  • What are the pre-requisites to start the course?
    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.
  • Who will be my faculty?
    Since we organize multiple batches, we work with a panel of 5 faculty for our MS Excel courses. All of them have atleast 9 years of industry experience and are all Microsoft Certified Professionals.
  • Is Online Learning effective to become an expert on MS Excel?
    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
  • How do I get my final Certificate?
    The final certificate will be emailed to you once you complete the final project and all related exercises.

Advanced MS Excel Training Jobs

View all Jobs

Data Scientist

Company Name: ForeScout
Location: San Jose, CA
Date Posted: 29th Dec, 2016
Description:

Responsibilities

  • Work with a group of security researchers to analyze unique context-rich endpoint and network security data collected through our cloud platform;
  • Use advanced modeling techniques to search for patterns in historical data;
  • Identify additional data sets that can be useful in refining and enhancing ForeScout’s IoT security policy engine;
  • Suggest CounterACT software enhancements and define detailed requirements with software development team. Ensure accurate implementation;

Big Data Solution Engineer

Company Name: Zaloni
Location: Durham, North Carolina
Date Posted: 15th Dec, 2016
Description:

Architect and develop Big Data applications for fortune 100 companies around the globe.

·         Design and build data processing pipelines for structured and unstructured data using tools and frameworks in the Hadoop ecosystem.

·         Implement and configure Zaloni tools for Hadoop based data lake implementations and Proof of concepts.

·     ...

Company Name:
Location:
Date Posted: 30th Nov, -0001
Description: