Description
Course Outline
- Paste as Hyperlink, Transpose, Skip Blanks, Add, Subtract, Divide, Multiply with paste special advance
- Formatting Dates, Custom & Special Formats,
- Custom Formatting Rules with formula
- Chart Type, Insert Chart, Update Chart, Formatting Charts, Charts Styles, Chart Layout, Chart Title, Legends, Data Labels
- Creating Pivot Table, Choosing Fields, Pivot Table Layout, Filtering Pivot Tables, Pivot Chart
- Print Titles, Print Area, Headers & Footers with Design, Sheets Options
- Static Function (Countif,Countifs, Sumif, Sumifs, Averageif, Averageifs)
- Text Function (Customize, nesting and dragging , Left, Right, Mid, Len & Find )
- Date & Time Function (Find days with date formulas Edate )
- Logical Function (and, or ,not, if, nested if /multiple if)
- Financial Function (PV, RATE, NPER, PMT)
- Lookups Formulas (VLOOKUP, HLOOKUP, MATCH, INDEXm LOOKUP, Rows, COlumns)
- Database Formulas (DSUM, DMAX, DMIN, DAVEGRAGE, DCOUNT)
- Data Validation, Number Validation, Text Validation, Dropdown Lists, Removing Duplicates, Goal Seek, Scenario Manager, what if analysis, Converting Text to Columns, Get external Data
- Absolute References, Multiple Sheet References, Consolidating, Trace Precedents and Dependents, Using the watch window, Show Formula, Evaluate Formula
- Name Manager, Cell Names, Named Ranges, Formulas with Cell Names, Use in formula, calculate now, calculate sheet
- Subtotal, Group and Ungroup, One Level Sort, Two Level Sort, Advance Filter
- Worksheet Protection, Protecting workbook
- Inserting Hyper links within a document, sharing a workbook, Track changes, Accept / Reject
- Recording Macro, Running Macro, Editing Macro
- Workbook Views, Show / Hide, Zoom Features, Freeze Panes, Split Window, Viewing Multiple Windows, Worksheet Backgrounds
