Working with Functions & Formulas
Basic Functions
Lookup Functions
Logical If Functions
Financial Functions
Statistical Functions
Math’s & Trig. Functions
Text Functions & Many More
Modifying worksheets with color
Conditional Formatting and IF Conditions & Charts.
Pivot Table, Sort & Filter, Data Tools, Subtotal and What if Analysis
Cell References Formulas, Audit Formula, Define Name, Protect Workbook & Worksheet.
Record Macro Freeze Panes.
Text Function, Statistical Function, Math & Trig Functions
Date & Time and Logical Functions, Financial Functions
Advance Date & Time Functions with Logical Functions
Advance of Pivot Table, Pivot Charts,
Lookup Functions (With Hlookup & Vlookup)
Lookup Functions with IF Error.
Advance Filter with Wild Card Character, Macros, Page Setup and Printing.
Advance Conditional Formatting, Paste Special & Advance Number
Advance Tools – Solver, Advance Subtotal etc.
Advance Marcos.
Advance Logical Functions and Lookup Functions & etc.
Auto Formats
Charts & Graphs
Pivot Table & Pivot Chart
Data Forms
Analysing Data
Data
Subtotal
Sorting Data
Filtering Data
Data Validation
Goal Seek
Formatting worksheets
Conditional formatting
Macros
Securing & Protecting Spreadsheets
Proofing and Printing
10TH PASS
Course Code : C-01
Course Code : C-02
Course Code : C- 03
Course Code : S-C - 04
Course Code : S-C-05
Course Code : S-C-06
