Advance Excel

Advance Excel Course Fee:  Rs. 6,000 (for a week)

Advance Excel Course:

Basic Excel: Person should have familiarity with excel, Can Create Pivot tablets, data handling done in past.

MODULE I: KNOW YOUR WORKBOOK

Workbook and worksheet- protecting excel workbook and worksheet, importing and exporting data, Data and Formatting-Adding Data, Cut Copy Paste, Data fill, Data Movement, Cell Formatting, Conditional Formatting, Cell Operation, Reusable Lists, Data Validation, Sorting and Filtering, Tables.

MODULES II: FORMULAS AND FUNCTION

Understanding formulas; operators in formula; named ranges; calculations; function in formulas; relative and absolute addressing; referencing cells outside the worksheet and workbook; Function- logical summarizing text, lookup, reference, data and time, math/ Finance function, Creating formulae in pivot tables, error handling, formula auditing.

MODULES III: CHARTS

Charts type and uses, Charts depiction-column, line pie, bar, bubble, histogram Analysis- Pivot Tables, Pivot Charts, What If Analysis

MODULE IV: Google Spreadsheets (ONLINE)