Search this site
Skip to main content
Skip to navigation
Excel Course
Home
A. Ms Excel Essential Index
Excel overview lecture-1(Demo)
Excel Interface Overview Lecture-2 (Demo)
How to fill up data in excel
usage of conditional formatting
Home Tab Font Section Formatting Options
Home Tab Alignment Section Formatting Options
Home Tab Number Section Formatting Options
Home Tab Edit Section Filter Option Lecture-1
Home Tab Editing Section Number and Date FIlter
Home Tab Editing Section Text Filter
Home Tab Editing Section Number and Date FIlter
Home Tab Editing Section Question Mark and Star Filter Usage
Home Tab Editing Section Sort and Filter
Home Tab Clipboard Section Format Painter
Home Tab Editing Section Sort and Filter
Add Values To Database in Single Click
Usage Of View Tab Window Section Freeze Panes
Usage Of Insert Tab Illustrations Section PIcture and Shapes
Page Layout Tab Page Setup Section Margins and Orientation
B. Charts in Excel Index
Insert Tab Chart Section Column Chart
Column Chart Features in Depth
Different Types Of Column Chart
Usage Of Pie Chart in Excel
C. Tables And Pivot Tables Index
Create Pivot Table Process Lecture-1
How To Convert Created Table To Normal Format
Creating Pivot Table Process Lecture-2
Creating Pivot Table Process Lecture-3
Pivot Table Analyze Tab Actions Sections Detailed Features
Pivot Table Analyze Tab Data Section Refresh Feature
Creating Multiplication Table in Excel
Usage Of Conditional Formatting With Pivot Table
Usage Of Filter and Sort Data Options in Pivot Table
D. Formula And Function Index
usage of IF formula
sum,avrg,mini,maxi formula
Usage Of Nested IF Formula
Count Counta and countIF Formula in Excel
Usage Of Sum And Sum IF Formula in Excel
Usage of Large and Small Formula in Excel
Usage Of CountIFS Formula in Excel
Usage Of Rank Formula in Excel
Usage Of Upper Lower and Proper Formula in Excel
Usage Of Trim Formula in Excel
Usage Of Weekday Formula in Excel
Usage Of Day Month and Year Formula in Excel
Usage Of Vlookup Formula For Exact Match
Usage Of Vlookup Formual Approximate Match
Usage of Hlookup Formula in Excel
Dollar Sign Usage in Formula Vertially and Horizontally
Usage Of PMT Formula in Excel
Usage Of Match Formula in Excel
Usage of Transpose Formula in Excel
Usage Of Left and Right Formula in Excel
Usage Of Replace Formula in Excel
Usage Of Cell and Info Formula in Excel
Usage Of ISTEXT ISNUMBER And ISFORMULA
Usage of Formlas Tab Auditiong Section Trace Precedents Trace Dependents an
Excel Course
Tables And Pivot Tables
Google Sites
Report abuse
Page details
Page updated
Google Sites
Report abuse