Advance Excel Languages :
1). Spreadsheet basics
2). Creating, editing, saving and printing spreadsheets
3). Working with functions & formulae
4). Graphically representing data : Charts & Graphs
5). Analyzing data : Data Menu, Subtotal, Filtering Data
6). Formatting worksheets , Securing & Protecting spreadsheets
1). Use the Function Wizard, Common functions (AVERAGE, MIN, MAX, COUNT,COUNTA, ROUND, INT)
2). Nested functions , Name cells /ranges /constants
3). Relative, Absolute, Mixed cell references : >,<,= operators
4). Logical functions using IF, AND, OR, NOT
5). The LOOKUP function , Date and time functions , Annotating formulas
1). Sub Total Reports, Auto Filter
2). Password Protecting Worksheets
3). Linking Multiple Sheets
4). Sheet Referencing
5). Linking Between Word/Excel/Ppt
6). PIVOT Tables, NESTED IF
7). Reporting
8). Age Calculations
9). Consolidation of Data
10). Data Validation
1). LOOKUP
2). VLOOKUP
3). HLOOKUP
4). COUNTIF
5). SUMIF
6). Character Functions
7). Date Functions
1). Definition and use , Record a macro
2). Assign a macro , Run a macro
3). Store a macro, Introduction to VBA Prog.
1). Plan a worksheet , Row and Column labels
2). Split worksheet /box /bar, Copy data and formulas
3). Display /move toolbars , Enhance worksheet Appearance
1). Use multiple windows : Copy/ paste between Worksheets
2). Link worksheets , Consolidate worksheets
3). Import and link from other Applications
4). Use AutoFormat : Create, use and modify styles and templates
5). Print features : Create /edit an outline
1). Create charts
2). Enhance charts
3). Drawing toolbar features