Stay FIT & Blessed
Posts
WHY MICROSOFT EXCEL IS IMPORTANT FOR ANALYTICAL CAREER???
in our current work atmosphere, we usually come across various data. We read it, access it and work on it. Have you ever analyzed it? You didn’t need it or haven’t got the opportunity to work on. Isn’t it? Well, that’s true in most of our cases. The requirement of every analytical tool is to analyze data & extract relevant information which can lead to increase in business growth. If we talk about today, there are many ways to perform business analytics & reporting like SAS, R, Big Data, Salesforce, SAP, SSAS, SSRS, Tableau, Qlik Sense, Machine Learning , etc. Every tool has its own uniqueness and is well used & adopted by Industry. The important point to understand is Microsoft Excel is the basis for any Analytical tool. Any big giant like McKinsey, Mu Sigma, American Express, etc. using advanced analytics ultimately works on Excel sheets for the data loading & internal communication. That’s why there is a steady increase in Excel Jobs & Excel...
Few More Shortcut keys in MS Excel..
Shortcut Description F2 Edit the selected cell F3 After a name has been created, F3 will paste names. F4 Repeat last action. For example, if you changed the color of text in another cell, pressing F4 will change the text in cell to the same color. F5 Go to a specific cell. For example, C6. F7 Spell check selected text or document. F11 Create chart from selected data. Ctrl+Shift+; Enter the current time. Ctrl+; Enter the current date. Alt+Shift+F1 Insert New Worksheet. Alt+Enter While typing text in a cell, pressing Alt+Enter will move to the next line, allowing for multiple lines of text in one cell. Shift+F3 Open the Excel formula window. Shift+F5 Bring up search bo...
Microsoft Excel Useful Shortcut keys…
Shortcut Description Ctrl+A Select all contents of a worksheet. Ctrl+B Bold all cells in the highlighted section. Ctrl+C Copy all cells in the highlighted section. Ctrl+D Fill down. Fills the cell beneath with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Down to select multiple cells. Then press Ctrl+D to fill them with the contents of the original cell. Ctrl+F Search current sheet. Ctrl+G Go to a certain area. Ctrl+H Find and replace. Ctrl+I Puts italics on all cells in the highlighted section. Ctrl+K Inserts a hyperlink . Ctrl+N Creates a new workbook. Ctrl+O Opens a workbook. Ctrl+P Print the current sheet. Ctrl+R Fill rig...