Excelerate your progress!

Updated: Dec 11, 2023

Why you should join this event ?

Learn more in my online event where I share my experience and course material for your practice.

Modules Covered in this Excel Training

SYLLABUS:

ROUND() vs. ROUNDUP() & ROUNDDOWN()
COUNT() vs. COUNTA() & COUNTBLANK() vs. COUNTIF
DAY(), MONTH(), YEAR(), DATE()
TEXT()
WEEKDAY(), WORKDAY(), NETWORKDAYS()
WORKDAY.INTL() for deadline/due date calculations w. custom weekends/holidays
NETWORKDAYS.INTL() for no. of business days calculations w. custom weekends/holidays
TODAY() and NOW() w. Shortcut
Text Formulas – Using CONCATENATE
Text Formulas – LEFT(), RIGHT() & SEARCH() - 1
Text Formulas – MID() & LEN()03:41
Text Formulas – REPLACE() & SUBSTITUTE()
VLookup Rules
VLookup With Exact Match
VLookup Approximate Match
VLookup With Trim
H-Lookup
Hyperlink To Sheet, File, Webpage, External links
Print Page Setup, Header & Footer
Data Sorting
Advanced Filters
Filtering Data
Basic Table
Advanced Table
Conditional Formatting: Formula-based (Colored rows based on user input)
Pivot Table Examples 1, 2, 3
Data Validation
Dependent Dropdown List

NOTE: The classes will continue for ~1 hour. In case some topics remain uncovered in the class, you may join our next session.

Bonus Class on:

How to create online forms which allow you to gather data from individual team members
How to automate Excel tasks with time-saving macros
How to remove duplicates from data in Excel
VBA Macro - Making use of Excel for business purposes - Purchase Order Generator, Invoice/Billing,
Automatic Email Sending with attachments, MIS reports preparation

Enjoy !

A certificate of completion will be given at the end of the session.