Microsoft Excel Advance Features
Menu Bars
o Formula
o Data
o Review
o View
Project & Assignments
o GST Invoice & Bills
o Payroll
o Income Tax
o Mark sheet
o Basic Data Entry
o Salary Statement
Advance Formulas & Functions
o Lookup, Vlookup, Hlookup
o Sumif, sumifs
o Counta, countif, countifs, countblank
o Concatenate
o Datedif, date, month, year, day, edate, eodate, time
o Lan, trim, repeat,
o Upper, lower, proper
o Mid, Left, Right
o Dmax, dmin, dsum, daverage, sumproduct
o If, ifs,
o And, or, true, false
o Pivot Table & Chart
o Whatif analysis, goalseek, data table
Working with option
o Group, ungroup
o Print area
o Print Title
o Freeze panel
o Data validation
o Text to column
o Remove duplicate
o Consolidate
Advance Shortcut
