KEY LEARNING HUB
Hello All,
I have started this channel to share my experience via series of videos on
- Excel - Tips and tricks
- Audit, Finance and Taxation
- Private Equity
- Treasury
Mainly focused on short length videos....
Hope these will be much helpful and useful to gain your knowledge.
HAPPY LEARNING!!!!
Flash Fill Option in excel
Find - Format as well via Find and Replace
Move or make a Duplicate of Pivot table - Existing or New worksheet
Pivot table - Get or fixing number format for value field
Pivot table - Empty cell text filled feature
Advanced filter in excel
Text to columns do not import skip option in excel
Generate serial numbers in excel | Row formula
Insert shapes and linking cell contents in excel
Selection of destination cell for text to columns in excel
Pivot table filtering in excel
Open second Window for excel, work in at a time on same excel
Pin folders feature in excel | Pin to taskbar
Pin the excel work books to task bar
Set your default local location for saving excel file
Data entry in excel | Move data always towards right
Watch Window in excel
Hide cell contents by changing the cell format in Excel
Consolidation in excel
Sorting Data in excel | Row Wise
Selection of Row differences in excel
Selection of Column differences in excel
Grid lines show or hide in excel
Hold Ctrl Key feature in excel while using formula (no need of typing comma)
Evaluating the result of Particular formula With F9 Key in excel
Evaluate the formula in excel - step by step process
Group feature in Pivot table
Report Publishing in excel via Pivot Table
Conditional formatting | Highlight Duplicate Values
Blank Cell – selection and fill with required data from above cells