Learn the most advanced formulas, functions and types of financial analysis to be an Excel power user.
Microsoft Excel :
Spreadsheets basics Creating Editing Saving and printing a spreadsheet Working with functions Formulae Graphically representing data : Charts & Graphs Analyzing data: Subtotal Formatting worksheets Securing & Protecting spreadsheets How to hide spreadsheets
Enter the pivot table data Create the pivot table Adding data to the pivot table Filtering the pivot table data
How to using macros Definition and use, Record macro Assign a macro Run a macro Shortcut a macro Store a macro How to use the developer option Introduction to VBA
Develop the worksheet :
Plan a worksheet How to Row and column create with coding How to Split worksheet with coding How to Copy and paste using with coding How to Merge and unmerge with coding How to alignment working with coding