Imprint this in your mind. If you are in the finance industry, Microsoft Excel will be your best analytical tool till the end of your career. Conduct of financial analysis in Excel is a given thing. You will be dealing with a lot of finance Excel spreadsheets from the first day of your career.
The Excel is an invaluable source of financial data analysis. Every day, uncountable amount of financial data is analyzed by financial experts. These data helps investors to improve investment portfolios and dig deeper into the financial market.
You will be working on huge data sets, large financial models and that too, within strict deadlines. Therefore, it is important to know how to use Excel efficiently and effectively. Excel usage and management is essential.
By efficiency, it means that you should be able to use the right shortcuts. By effectively, it means that you should learn to conduct the right Excel operations. By management, it means you should be able to manage endless number of Excel files properly.
Why it is important to know shortcuts is because they are not only time savers but there is one more benefit to it which I am sure all of us will agree. When you are working for long hours and under pressure, imagine yourself using the computer or laptop mouse for around 10-12 hours continuously! If nothing else, this act itself will cause you a lot of stress. Believe me; it causes a lot of pain in every sense!
So, why not do away with mouse usage by learning these extremely handy and easy to use keyboard shortcuts?
We have split this module in three broad lessons:
(1) Data Manipulation & Navigation
(3) Formulas & Advanced Topics
By Manipulation, we mean how you can insert or delete rows or columns in Excel, how you can hide, unhide, group, ungroup your data and more.
By Navigation, we mean how you can move around your workbook and worksheets more efficiently.
By Formatting, we tell you ways to make your data more presentable. It tells you ways to change the background color, font size, color and other presentation factors.
Right now you will find it quite silly, but believe me; you require all these things when you work in investment banks, equity research and financial research. It is, thus, very important that you have good command over all the relevant shortcuts.
By Formulas, we imply the active role calculations play in Excel program. In the Excel software, there are many built-in functions available. Again, we are not going to see all those functions. We are going to study the ones that are used most frequently in investment banking and finance.
By Advanced Topics, we refer to some features like Lookup functions, Pivot Tables,Macros and all those functions that maximize our capability to perform financial functions with Excel.
These are some of the Excel features that are used frequently in investment banking, finance and consulting.
So, here’re these 3 lessons: