Courses

ADVANCED EXCEL

Category
ALL
Instructor
admin
0 Reviews

Course Description

Microsoft Excel is one of the most simplest and powerful software applications available out there. It lets users do quantitative analysis, statistical analysis with an intuitive interface for data manipulation, so much so that its usage spans across different domains and professional requirements.

Rather than focusing on what excel is and how to do simple subtraction, addition, we shall look into some of the advanced formulas which are frequently asked in interviews when it comes to analyzing a candidate’s Excel skills. Advanced Excel is quite different from Basic Excel,  the focus for the user is more on DSUM, DCOUNT, Pivot Table, Pivot Chart, Formulas, Functions, and Macros.

Some of the other important concepts to explore while working on Advanced Excel are:

If Statements

Sum Products

VLOOKUP

Concatenate

Sum Ifs

Data Validations

Specifying a valid range of values for a cell

Specifying a list of valid values for a cell

Specifying custom validations based on formula for a cell

Sorting and Filtering Data

Sorting tables

Using multiple-level sorting

Using custom sorting

Filtering data for selected view (AutoFilter)

Using advanced filter options

WhatIf Analysis

Goal Seek

Data Tables

Scenario Manager

Charts

Using Charts

Formatting Charts

Using 3D Graphs

Using Bar and Line Chart together

Using Secondary Axis in Graphs

Sharing Charts with PowerPoint / MS Word, Dynamically

(Data Modified in Excel, Chart would automatically get updated)

New Features Of Excel

Sparklines, Inline Charts, data Charts

Overview of all the new features

Final Assignment

The Final Assignment would test contains questions to be solved at the end of the Course

 

About Instructor

  • admin

    Teaching is a very noble profession that shapes the character, caliber, and future of an individual. If people remember me as a good teacher, that will be the biggest honour for me.

Reviews

0
0 Ratings
stars 5
0%
0
stars 4
0%
0
stars 3
0%
0
stars 2
0%
0
stars 1
0%
0

There are no reviews yet.

Leave a Review

Be the first to review “ADVANCED EXCEL”