MICROSOFT EXCEL
INTRODUCTION TO MICROSOFT EXCEL
ROWS COLUMNS, SHEETS
CLIPBOARD : CUT, COPY PASTE
FORMAT CELL : FONT BOLD,ITALLIC, UNDERLINE,FONT FACE, FONT SIZE, FONT COLOR, BORDER
FORMAT CELL: ALLIGNMENT CENTER LEFT RIGHT, ALLIGNMENT TOP MIDDLE BOTTOM, WRAP TEXT, MERGE &, CENTER
FORMAT CELL NUMBER: INCREASE DECIMAL, DECREASE DECIMAL, COMMA STYLE
STYLES:CONDITIONAL FROMATING,FORMAT AS TABLE, CELL STYLES
CELL: INSERT CELL, INSERT SHEET ROW & COLUMN, INSERT SHEET
DELETE CELL, DELETE SHEET ROW & COLUMN, DELETE COLUMN
ROW HEIGHT, COLUMN WIDTH,HIDE UNHIDE ROW & COLUMN,RENAME SHEET, MOVE OR COPY,TAB COLOR,DELETE TAB
AUTO SUM, SORT & FILTER
INSERT MENU, CHART
COLUMN CHART
BAR CHART
PIE CHART
PIVOT TABLE
PIVOT CHART
FORMULA
SUM, AVERAGE
COUNT, COUNTIF
MAX,MIN
SUMIF
PMT, PPMT, IPMT
CUMIPMT,PV, FV
DB, SLN
AND ,IF, OR
PROPER
CONCATENATE, TRIM, LEN
UPPER,LOWER
ROWS, COLUMNS
LOOKUP
VLOOKUP, HLOOKUP
DATA FILTER, ADVANCE FILTER
TEXT TO COLUMN
REMOVE DUPLICATES
CONSOLIDATE
GROUP, UNGROUP
SUBTOTAL
No reviews yet. Be the first to review this course!
Enroll in your desired course
Secure payment gateway
Click the button below to proceed with payment
Copyright © 2026 DITRP INDIA. All Rights Reserved