dots bg

Excel certification

Course Instructor: Admin

FREE

To enroll in this course, please contact the Admin
Contact Admin
dots bg

Course Overview

Schedule of Classes

Course Curriculum

7 Subjects

Revision of excel

Revision with Some tools

tips and tricks - Text to Column Data

SUMPRODUCT

mport Data from Text File

Remove Duplicates

Types of Errors in Excel

Random Numbers

Text to Column Fixed Width

Custom Views

Graphs and Charts

Pivot table

Understanding and Creating Pivot table and Pivot Chart

Handling Missing Values in Pivot Tables

Sorting, Filtering and Various other Functions of Pivot tables

Creating Dashboard (Two Projects) Using Pivot Table

Adding Slicers to Dash Board

Adding Time Line and Symbols

Logical functions

Logical or Comparison operators

IF Function

Nested IF Function

AND-OR-NOT

IF-AND

IF-OR

IF-NOT

XOR

COUNT

COUNTA

COUNTBLANK

COUNTIF

SUM IF

AVERAGEIF

IFS

COUNTIFS

SUMIFS

AVERAGEIFS

MAXIFS

MINIFS

IF ERROR

Basic financial functions

uture Value (FV), FVSCHEDULE

Present Value (PV)

Net Present Value (NPV)

XNPV, PMT, PPMT-IPMT, NPER, RATE

Lookup functions

Vlookup - Hlookup

Data Validation-DropDown

Developer Tools- Spin Button

Check Box

Group Box

Option Button

An Introduction to INDEX and MATCH Functions

Elementary Statistics

Learning Elementary Statistics

Enabling Data Analysis Tool Pack

Mean, Median, Mode & MULTIPLE MODE

Standard Deviation, Calculating Frequency and Using Frequency Function, Histogram

Conditional Formatting

Conditional Formatting-Quick Analysis

Conditional Formatting-Colour Scales

Data-Data Bars-Icon Sets

Top-Bottom Rules

Highlight Duplicate/Unique data, Gradient/Relative/Solid Fill, Negative Databars

Course Instructor

tutor image

Admin

71 Courses   •   1541 Students