Candidate Services

Contents of Advance Excel Course


Excel Introduction

Cell Formatting

Format Cell

Custom List

Conditional Formatting with Formula

Fill Option

Justify Data

Protect Sheet/ Cell/ Workbook

Upper

Lower

LEN

TRIM

Concatenate Function

Text to Column

Hyperlink

LEFT/RIGHT/MID FUNCTION

Flash Fill

SUM Formulas

Average Formulas

Min/ Max Formula

SUM Product

Rank

YEARFRAC

Convert Function

COUPDAYS

count

Counta

Countblank

Countif

Countifs

istext

Today

Now

SLN

Days360

Networkdays

Weekday

EOMONTH

Workday

One Way Data Table

Two Way Data Table

IF Function

IF & "AND" Function

IF AND & OR Function

Payment due date

isblank with IF /function

Charts

Secondary Axis Chart etc…

Advance Find and Replace

Across Worksheets

Data Tools

Advance Filter

Data Validation

Consolidate tools

Goal Seek

Scenario Manager

Solver

PMT Function

Rate Function

FV Function

Received Function

Round

Roundup

Rounddown

Floor

Ceiling

SUMIF

SUMIFS

AVERAGE IF

DSUM Formula

Daverage

Dget

Match & Index

Lookup

Hlookup

Pivot Table

Query

Vlookup with 7 Examples

Google Sheet

Freeze Panes + More …

CREATE MIS Report

How to get a list of all Worksheet name in Excel Workbook

Print Option

Excel Convert to PDF

Merge Two Data in One Table

Your Own Tab Create

A to Z Shortcut Keys

how to compare two columns in excel to find differences

Mail Merge Excel Data go in word

Data Merge Jan to Dec in One Sheet

Who will buy Advance Excel Course



HR Professional


Businessman


MIS Executive


Startup/SME

Benefits

Access to Mobile App

Live Seminar

Plug and play

Can use as Ready Reckoner

Access to Mobile App

Live Seminar

Plug and Play

Can use as Ready Reckoner

Know More about Advance Excel

Quick Enquiry
whatsapp-icon

Get in touch with us

Connect On Facebook

Connect On Linkedin

YOUTUBE PROFILE

Watch our HR Videos and subscribe to our YouTube channel.