KEMBAR78
MS Excel Syllabus | PDF | Microsoft Excel | Computing
Scribd
Upload
13 views3 pages

MS Excel Syllabus

The document outlines an advanced MS Excel syllabus, detailing various practical exercises focused on functions, formulas, data analysis, and visualization techniques. Topics include basic functions, logical functions, analysis functions, text and date functions, lookup functions, financial formulas, charts, pivot tables, data validation, and more. The syllabus aims to provide comprehensive training in advanced Excel skills for effective data management and analysis.

Uploaded by

ashmahi1999
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
13 views3 pages

MS Excel Syllabus

The document outlines an advanced MS Excel syllabus, detailing various practical exercises focused on functions, formulas, data analysis, and visualization techniques. Topics include basic functions, logical functions, analysis functions, text and date functions, lookup functions, financial formulas, charts, pivot tables, data validation, and more. The syllabus aims to provide comprehensive training in advanced Excel skills for effective data management and analysis.

Uploaded by

ashmahi1999
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

ADVANCED MS EXCEL SYLLABUS

PRACTICAL - 1 UNDERSTANDING AND USING BASIC FUNCTIONS


HOME TAB
• FONT
o FONT STYLE o BORDER
o INCREASE/ DECREASE o FILL COLOR
FONT SIZE o FONT COLOR
o UNDERLINE, BOLD, ITALIC
• ALIGNMENT
o INCREASE o ORIENTATION
INDENT/DECREASE o WRAP TEXT
INDENT o MERGE AND CENTER
• NUMBERING FORMATTING
o CURRENCY FORMAT
o NUMBER FORMAT
o CUSTOM AND SPECIAL FORMATS
PRACTICAL – 2 BASIC FORMULAS, STYLE, CELLS, EDITING
• BASIC FORMULAS
o SUM, AVERAGE
o MAX, MIN
• STYLE
o CONDITIONAL FORMATTING
o FORMAT TABLE
o CELL STYLES
• CELL
o INSERT CELL
o DELETE CELL
o FORMAT – ROW HEIGHT, COLUMN WIDTH, AUTO ROW HEIGHT, AUTO
COLUMN WIDTH
o Protect Sheet,Protect Workbook
• EDITING
o SORT AND FILTER o FILL SERIES
o FIND AND REPLACE o CLEAR
PRACTICAL – 3 LOGICAL FUNCTION I
• IF • IF AND
• AND, OR • IF OR
PRACTICAL – 4 LOGICAL FUNCTION II
• NESTED IF
PRACTICAL – 5 ANALYSIS FUNCTION I
• SUMIF • AVERAGEIF
• SUMIFS • AVERAGEIFS
PRACTICAL – 6 ANALYSIS FUNCTION II
• COUNT • COUNTBLANK • COUNTIFS
• COUNTA • COUNTIF
ADVANCED MS EXCEL SYLLABUS

PRACTICAL – 7 TEXT FUNCTION, DATE AND TIME FUNCTIONS


• UPPER, LOWER, PROPER • LEFT, MID, RIGHT • TRIM, LEN, EXACT
• CONCATENATE • FIND, SUBSTITUTE
• TODAY, NOW • DAY, MONTH, YEAR • DATE, • EOMONTH, WEEKDAY, DATEDIF
PRACTICAL – 8 LOOKUP FUNCTIONS
• VLOOKUP
• HLOOKUP
• INDEX AND MATCH
• SHEET TO SHEET VLOOKUP
• FILE TO FILE VLOOKUP
• NESTED VLOOKUP
• VLOOKUP WITH MATCH FUNCTION
• XLOOKUP
• FILTER

PRACTICAL – 9 FINANCIAL FORMULAS


• PMT
• PPMT
• IPMT
• FV
PRACTICAL – 10 ILLUSTRATIONS
• PICTURES • SMART ART
• SHAPES • SCREENSHOT
PRACTICAL – 11 HYPERLINKS
• HYPER LINKING DATA, WITHIN SHEET / WORKBOOK
• HYPERLINK WITHIN SHAPE/PICTURE
• HYPERLINK FORMULA

PRACTICAL – 12 CHARTS AND SLICER


• VARIOUS CHARTS I.E. BAR CHARTS / PIE CHARTS / LINE CHARTS
• USING SLICERS, FILTER DATA WITH SLICERS
• MANAGE PRIMARY AND SECONDARY AXIS
PRACTICAL – 13 PIVOT TABLES
• CREATING SIMPLE PIVOT TABLES
• BASIC AND ADVANCED VALUE FIELD SETTING
• CLASSIC PIVOT TABLE
• CHOOSING FIELD
• FILTERING PIVOTTABLES
• MODIFYING PIVOTTABLE DATA (REFRESH AND DATA SOURCE)
• CALCULATED FIELD & CALCULATED ITEMS
• SLICER AND TIMELINE
• ACTIONS (CLEAR, SELECT, MOVE PIVOT TABLE)
• PIVOT CHART
ADVANCED MS EXCEL SYLLABUS

PRACTICAL – 14 DATA VALIDATION


• NUMBER, DATE & TIME VALIDATION
• TEXT AND LIST VALIDATION
• CUSTOM VALIDATIONS BASED ON FORMULA FOR A CELL
• DYNAMIC DROPDOWN LIST CREATION USING DATA VALIDATION – DEPENDENCY
LIST
PRACTICAL – 15 WHAT IF ANALYSIS
• GOAL SEEK
• SCENARIO ANALYSIS
• DATA TABLES (PMT FUNCTION)

PRACTICAL – 16 CONSOLIDATIONS
• CONSOLIDATING DATA WITH IDENTICAL
• DIFFERENT LAYOUT

PRACTICAL – 17 DATA IMPORT USING POWER QUERIES


• IMPORT FROM WEB
• IMPORT FROM TEXT
• TEXT TO COLUMNS
• REMOVE DUPLICATES
• GROUPING AND UNGROUPING
PRACTICAL – 18 VIEW TAB
• FREEZE PANE
• SPLIT WINDOW
• MACROS
PRACTICAL – 19 PAGE SETUP
• SETTING UP PRINT AREA
• CUSTOMIZING HEADERS & FOOTERS
• DESIGNING THE STRUCTURE OF A TEMPLATE
• PRINT TITLES –REPEAT ROWS / COLUMNS
PRACTICAL – 20 INVOICE PREPARATION

You might also like