Certification in Advanced Excel & MIS Reports

 

Certification in Advanced Excel & MIS Reports which is very meticulously developed and helps you to develop advanced skills in excel  and grow in your career.You can step by step go through every tutorial and do the practicals on your own to get perfection in excel skills.

Delivery Method : Prerecorded Tutorials

We will be Providing:

1)  Online Access for course.

2)  Certificate

3) Excel files of the course content.

Faculty:

Ranjit Kate
MBA Finance
Faculty has 5 years experience in Advanced excel training and MIS reporting.

Call us on +91 9881196664 or mail to preetib@techcraftonline.com

Course Information

Course Instructor

nilamg nilamg Author
 

Certification Course in Advanced Excel & MIS Reports

₹9,500.00
Enroll

Course Introduction

Course Introduction
Course File Downloads

Making Basics of Excel Perfect and Moving to Advance Functions (Using Sales Report)

Mathematical,Logical and Text Operators
Writing basic formula and understanding precedence
Understanding basic logical formulas
Sum,Average,Max and Min Functions
Count and Rounding Functions
Countif,AND,OR Logical functions
IF AND IFS Functions
Date Functions
Text Functions
DSUM,DAVERAGE AND DCOUNT

Relative and Absolute Referencing (Using Expense Report)

Relative and Absolute referencing Part I
Relative and Absolute referencing Part II

Creating Charts (Using Budget Reports) 

Data selection,creating Pie chart and Bar Chart
Creating Bar Chart and Line Chart

Data Cleaning Techniques

Case Change and Trim
Identifying Errors and Blanks
Identifying and Removing Duplicates
Dividing Data from Single to Multiple Columns
Substitute and Replace
Left,Right,Mid,Find and Replace

Complex Logical Formulas (Sales and Outstanding Report) 

Using IF,AND Functions
Nested IF
IFError and IFS used together
Sum IF and Count IF

Getting expert with Look Up Functions (Using Inventory Reports)

Naming Ranges
VLook Up
VLook Up and Match
HLook Up
HLook Up and Match
Index and Match
Indirect,VLook Up and Match
Using Approximate Match

Data Protection

Protecting Data and allow editing ranges
Protecting workbook structure and encrypting with password

Sorting and filtering

Simple and Custom Sort
Simple filters and Advanced filters
Using Advanced filters to copy data 

Conditional Formatting

Conditional Formatting Part 1
Conditional Formatting Part 2

Data Validations

Types of Data Validations
Dependant Validations

Pivot Tables and Dashboard Creation

Understanding and Creating Pivot Table
More Pivot Tables and Value Field Settings
Pivot Tables with Different Fields
Pivot Charts
Creating Dashboard
Dashboard_Get Pivot Data
Inserting Slicer

Recording,Running and Editing Macros

Basic Preparation before recording macro
Recording macro to add formatting
Recording macro to apply formulas
Running the macros
Visual Basic Editor,Understanding VBA code of formatting
VBA code for calculate macro
VBA code for total macro

One thought on “Certification in Advanced Excel & MIS Reports”

  1. Rahul Chaturvedi says:
    October 26, 2020 at 7:17 pm

    Interested in the course, let me know the fees and schedule.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *