Cart List

Final Price : 0

Certification in Advanced Excel,MIS Reports and Data Analysis


Course with develop your advanced skills in Excel and MIS Reporting.

Available class for :

  • Live

Date Day Timing Course Type Location
29 Jan(6 Weeks)SAT & SUNTimings7:00:00 PM to 9:30:00 PM LiveOnline

10500 /-

Course Price

   

Course content

Mathematical, Logical and Text Operators (Check Download Files)

No Preview

Writing basic formula and understanding precedence (Check Download Files)

No Preview

Understanding basic logical formulas

No Preview

Sum,Average,Max and Min Functions

No Preview

Count and Rounding Functions

No Preview

Countif,AND,OR Logical functions

No Preview

IF AND IFS Functions

No Preview

Date Functions

No Preview

Text Functions

No Preview

DSUM,DAVERAGE AND DCOUNT

No Preview

Relative and Absolute referencing Part I

No Preview

Relative and Absolute referencing Part II

No Preview

Data selection,creating Pie chart and Bar Chart

No Preview

Creating Column Chart and Line Chart

No Preview

Using IF,AND Functions

No Preview

Nested IF

No Preview

IFError and IFS used together

No Preview

Sum IF and Count IF

No Preview

Naming Ranges

No Preview

VLook Up

No Preview

VLook Up and Match

No Preview

HLook Up

No Preview

HLook Up and Match

No Preview

Index and Match

No Preview

Indirect,VLook Up and Match

No Preview

Using Approximate Match

No Preview

Protecting Data and allow editing ranges

No Preview

Protecting workbook structure and encrypting with password

No Preview

Simple and Custom Sort

No Preview

Simple filters and Advanced filters

No Preview

Using Advanced filters to copy data

No Preview

Types of Data Validations

No Preview

Dependant Validations

No Preview

Understanding and Creating Pivot Table

No Preview

More Pivot Tables and Value Field Settings

No Preview

Pivot Tables with Different Fields

No Preview

Pivot Charts

No Preview

Creating Dashboard

No Preview

Dashboard_Get Pivot Data

No Preview

Inserting Slicer

No Preview

Basic Preparation before recording macro

No Preview

Recording macro to add formatting

No Preview

Recording macro to apply formulas

No Preview

Running the macros

No Preview

Visual Basic Editor,Understanding VBA code of formatting

No Preview

VBA code for calculate macro

No Preview

VBA code for total macro

No Preview

Copyright © 2019 Kate Education and Consultancy Services Pvt Ltd

Register for Demo

Please fill the below form.Our representative will call you for more details.