Tools and Commands:
Much more to explore in the videos.
Learn how you can define a short cut key to Open Excel
Learn why using sum function is better instead of adding every cell one by one.
Use of Relative lining vs Absolute referencing.
When you link in cell with single $ , it is called Mixed Linking. Write a universal formula.
Quick short cut key Alt + = , Ctrl C & Ctrl V to copy and paste fast.
Fill down with Ctrl + D and Fill right with Ctrl + R
Learn how to insert and Delete multiple rows and columns.
Hide and collapse Ribbon with Quick Short Cut Keys
Learn to access Ribbon without Mouse. and remove gridlines with Key tips.
Customize and access the tools on Ribbon more quickly.
If Function is used when the output is based on any criteria or condition.
Lets see how to join multiple functions (IF, And, Sum) within one Formula.
Lets see how to join multiple functions (IF, And, Or, Sum) within one Formula.
Learn how to use IF within IF function to provide different grades.
Paste special: The most used tool in Excel to exploit copied data. Learn how to paste values, format, comment or formulas only.
How to double or half the values in single step using Paste Special.
Transpose the data from Row to Column and from column to Row quickly.
Here is a great tool of paste special that is Paste Link.
Conditional Formatting based on the data in the cell. Color the cell if it is greater or less than 50.
Format top and bottom nos with Conditional Formatting.
Magical display of values.
Instead of using the defined rules of Conditional Formatting, you can make your own rule to format the cell.
Simple excel functions: Max, Min, Median, Average, Sum. You can skip them if already aware of them.
Learn how to count cells with numerical values, blank cells and cells with text.
Learn how to assign rank based on descending or ascending nos.
Find a certain largest or smallest no in range.
How to sum or average the nos based on a certain criteria or condition.
Count no of cells that meet a specified criteria or condition
How to use Sumifs and Averageifs for multiple conditions.
Count cells that meet multiple conditions.
I am Manoj Kumar. I am an MBA (Finance) from ICFAI and CFA level 3 candidate from CFA Institute, USA. I am running Investment Banking Institute, New Delhi. I teach Adv Excel, VBA, Dashboards, Financial Modeling, Valuations & M&A. I have been into consulting in Project Finance before moving to training.
Areas of Training: Excel, VBA,Dashboard Designing,Financial Modeling, Valuation & M&A Have trained in WNS, Global Energy, Intec Capital, Creative Web Mobi, ICOFP, GNIM etc Conducted more than 150 open workshops and trained more than 2500 participants Developed Video based Training courses on Various SubectsMy passion for training led me to start the IB Institute in New Delhi, India. I have two years of rich experience in the fields of Investment Banking, Corporate Valuation, Equity Research and Consulting for Project appraisal.
I have conducted more then 150 workshops for various colleges and corporate houses. I am Certified Excel Specialist and Trainer from Microsoft.