Advanced Excel and MIS Course

Online Certification in Advanced Excel & MIS Reports (International Batch)

International Price : $130

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

We conduct 2 Month (Only Friday/Only Saturday) 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.

Duration: 2 Months (only Friday/Only Saturday)

Auidance : Course is designed for international students specifically from United Arab Emirates,Middle East Countries,Singapore,Indonesia,Asian countries.

Delivery Method : Live online classes

We will be Providing:

1)  Live Online lectures for 2 hours every Friday,

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.

Course Instructor

Ranjit Kate Ranjit Kate Author
 

Live Online Certification in Advanced Excel & MIS Reports (International Batch)

₹9,500.00
Enroll
 

Live Online Certification in Advanced Excel & MIS Reports (International Batch)

₹9,500.00
Enroll

Course Introduction and Free Lectures

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 a range
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

Data Validation

Types of Data Validations
Dependant Validations

Sorting and Filtering

Simple and Custom Sort
Using Advanced filters to copy data 

Conditional Formatting

Conditional Formatting Part 1
Conditional Formatting Part 2

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