MS Excel tutorial

100+ Excel Functions (explained with Examples and Videos)

Here you will find a detailed tutorial on 100+ Excel Functions & VBA Functions. Each Excel function is covered in detail with Examples and Videos.

.7This Tutorial Covers:

Excel Functions - Date and Times

EXCEL FUNCTION – DATE
EXCEL FUNCTION – DATEVALUE
EXCEL FUNCTION – DAY, MONTH, YEAR
EXCEL FUNCTION – WEEKDAY
EXCEL FUNCTION – NOW
EXCEL FUNCTION – TODAY
EXCEL FUNCTION – NETWORKDAYS
Excel Function – WORKDAY.INTL
Excel Function – WORKDAY

Excel Functions – Logical

EXCEL FUNCTION – AND, OR, NOT
  EXCEL FUNCTION – IF
EXCEL FUNCTION – ISERROR
EXCEL FUNCTION – ISBLANK
EXCEL FUNCTION – COUNTIF
EXCEL FUNCTION – IFS
EXCEL FUNCTION – COUNTIFS

Excel Functions – Lookup & Reference

EXCEL FUNCTION – COLUMN
EXCEL FUNCTION – COLUMNS
What is VLOOKUP in Excel?
EXCEL FUNCTION – INDEX
EXCEL FUNCTION – MATCH
EXCEL FUNCTION – INDIRECT
Create Dynamic Data Validation List – Offset Function Method
EXCEL FUNCTION – ROW
EXCEL FUNCTION – ROWS
Find Duplicate Files In Excel Using VBA

Excel Functions – Math

EXCEL FUNCTION – INT
EXCEL FUNCTION – MOD
EXCEL FUNCTION – RAND
How to Use RAND and RANDBETWEEN Functions in Excel
EXCEL FUNCTION – ROUND
Excel Function – Sum
EXCEL FUNCTION – SUMIF
EXCEL FUNCTION – SUMIFS
EXCEL FUNCTION – SUMPRODUCT

Excel Functions – Statistics

EXCEL FUNCTION – RANK
EXCEL FUNCTION – AVERAGE
EXCEL FUNCTION – AVERAGEIF
EXCEL FUNCTION – AVERAGEIFS
EXCEL FUNCTION – COUNT
EXCEL FUNCTION – COUNTIF
EXCEL FUNCTION – COUNTIFS
EXCEL FUNCTION – COUNTBLANK
EXCL FUNCTION – COUNTA
EXCEL LARGE FUNCTION
EXCEL FUNCTION – SMALL
EXCEL FUNCTION – MAX
EXCEL FUNCTION – MIN

Excel Functions – Text Functions

EXCEL FUNCTION – CONCATENATE
EXCEL FUNCTION – FIND
EXCEL FUNCTION- LEFT
EXCEL FUNCTION – LEN
EXCEL FUNCTION – MID
EXCEL FUNCTION – LOWER
EXCEL FUNCTION – PROPER
Excel Function Replace
EXCEL FUNCTION – REPT
EXCEL FUNCTION – RIGHT
EXCEL FUNCTION – SEARCH
EXCEL FUNCTION – SUBSTITUTE
EXCEL TEXT FUNCTION
EXCEL FUNCTION – TRIM
EXCEL FUNCTION – UPPER

Excel Functions – Info

EXCEL FUNCTION – ISBLANK
EXCEL FUNCTION – ISERROR

VBA Functions

Excel VBA Tool to Create Folders
VBA Code to Re-link MS Access Link Tables
VBA Code to List Files in Folder
VBA Code to Check if File Exist in Folder
VBA Code to Add New Sheet at Beginning or End of Excel File
VBA Code to Get User Name
VBA Code to Delete All Shapes On A Excel Sheet
VBA Code to Convert Excel Range into HTML Table
How to Add Outlook Reference in Excel VBA
VBA Code to Hide Menu Ribbon in MS Access
VBA Code to Export Access Recordset to Excel
VBA Code to Send Outlook Emails
VBA Code to Draft Outlook Emails
VBA Code to Read Outlook Emails
VBA Code to Browse a Folder
VBA to Browse Outlook Folder
VBA Code to Count Color Cells with Conditional Formatting
VBA to Open Workbook in Excel
ColorIndex in Excel VBA
VBA Code to Check if Folder Exist
VBA Code to Remove Duplicate Rows
VBA Code to Count Cells by Color
VBA Code to Sum Cells by Color
VBA Code to Delete File
VBA Code to Add Border to Excel Range
VBA Code to Protect Excel Sheet for Manual Input but Allow Programming Inputs
VBA Code to Add Items in ListBox Control in Userform
Find Duplicate Files In Excel Using VBA
VBA Code to Find Last Column or Row of a Sheet
VBA to Read Excel Data using Connection String
Excel VBA Tool to Rename Files
VBA Code to Change Sheet Color
VBA Code to Sort Data
VBA Code to Filter Data in Excel
VBA Tool to Merge Excel Files from a Folder
VBA Code to Change Cell Color
VBA Code to Convert MM.DD.YYYY to DD-MMM-YYYY In Excel
Few Simple Excel Tips – Excel Learner Should Know
Excel VBA Tool to Get File Properties
How to Hide Sheet in Excel with or without VBA?
Excel VBA Tips you Must Know – Part 1

Excel Tools

Merge Cells in Excel (Step by Step Guide)
Duplicate Data Identifier Tool
File Manager Tool
File Properties Tool
Duplicate Files Finder Tool
Dummy Data Generator Tool
Excel Files and Sheets Data Consolidation
Outlook Bulk Email Tool
Random Rows Selector Tool – Unprotected Version
Outlook Email Management Tool
Time and Motion Tracker
Time and Motion Professional Tracker
Introduction to Power Query
How to Create Pie Chart in Excel (Complete Tutorial)
How Histogram Works in Excel? (Definitive Guide)
Time Management Tools and Trackers
QR Code Generator Tool in Excel
ColorIndex in Excel VBA
HOW TO COMPARE TWO COLUMNS IN EXCEL
Dummy Data Generator Tool
Employee Database Tool
Simplest Way to Create Excel Add-in
Calculations with Date in Excel
Pivot Table For Beginners – Part 1
Few Simple Excel Tips – Excel Learner Should Know
Impress your Clients by Hiding these Simple Features
Protect Sheets, Share Workbook, Protect Workbook