Excel Advanced Training (14 Courses, 23+ Projects)

Objectives

The course is focused on coverage of lifesaving excel tools and functionalities. Learners will gain insight about numerous in-built tools and features in excel and their application in real life so as to gain better results.

Course Highlights

Here is a highlight of the coverage of the project.

Learners will go through an intense training on MS Excel 2016 wherein they will learn about data functions, what-if-analysis, arrays, functions, text functions, pivot table, advanced charts etc.

We will continue with the above session and learn about the remaining advanced concepts of excel such as shortcuts, excel controls, cell comments, named ranges and advanced formulas.

We will then focus our energies on data and time functions in excel.

A beginners’ session will be conducted for providing clarity on pivot tables, its features and its formatting.

Then we will resume the session on pivot table and gain understanding on other advanced concepts relating to it such as data summarization in pivot table, pivot charts, its printing, macros, power pivot, DAX etc.

Session will be covered on power pivot in Excel 2016 where we will discuss about pivot charts, pivot tables, pie charts and slicers.

Moving on with power pivot, we will get to know as to how to download and install it and organize and format data.

Training will be conducted on power excel. Topics such as functions, pivot tables, evaluation, date and time format, statement and vlookup, future value function and so on.

Tutorial will be there so as to discuss upon shortcuts in excel, excel functions, vertical lookups, financial functions and average if function.

Next subject area in the training will be excel charts and smart-art graphics. We will discuss about pictures and clip arts, excel charts and data table, pie charts and line charts etc.

Knowledge will be imparted on financial functions such as future value, investment valuation with multiple cash flows, calculating rate of return, analysis of loans and payments and bond valuation.

In the next session, learners will understand working of statistical tools in excel such as central tendency, standard deviation, data analysis tools, correlation and regression etc.

Comprehensive training will be provided on VBA and macros in excel.

In the next session we will gain clarity on macros and VBAs features as well as concepts.

Tutorial will cover apt presentation method for pivot tables.

We will learn about problem handling and automation in excel through a project.

At last, we will undertake a case study on performance rating of employees using excel.

Project Highlights

Project will be covered on pivot tables so as to cover important features such as axis and formatting, sorting and filtering, grouping and analysis, show field values as, pivot charts and macros.

Learners will gain insight on excel data simulation through a project.

There will be also be a project that will deal with building dynamic heat map in excel 2016.

We will undertake a project on creation of basic CRM using excel VBA and SQL express.

There will be a specific project so as to cover automation using excel VBA.

You will also learn about creation of HR attendance register with the help of excel VBA.

Project will be there subjected on creation of sales productivity dashboard.

At next step, project on creation of advanced sales productivity dashboard will be covered.

Learners will undergo training on creation of sales dashboard through a project.

Another project will be there to discuss about HR dashboard and its analysis.

In continuance of above project, an advanced project on HR dashboard will be conducted.

We will also get to know about interactive dashboards in excel.

Thereafter, we will understand about creation of basic project management tool using treeview and listviews.

Next will a project on creation of interactive dashboard using VBA.

A project will there to cover application of VBA macros.

Specific project will be conducted to discuss restaurant billing system using excel VBA.

A focused project will be conducted on project schedule indexes.

Another project will be there relating to financial modelling with the use of VBA.

Microsoft excel dashboard training will be conducted through a project.

Case paper creation will be discussed using VBA macros.