tricksOntips

What are  macros in Excel A  macro  is simply a series of instructions. After you've created a  macro ,  Excel  will execute those instructions, step-by-step, on any data that you give it. How to Enable or Record Macros in Excel Step 1 - Click on the developer tab in Ribbon in excel         How to enable developer tab in your Work Sheet                     Step 1 - Click on FILE                     Step 2 - Select Options                    Step 3 - Click on Customize Ribbon                     Step 4 - Enable Developer Tab  Step 2 - On Left Side of the Screen you can see options like Macros , Record Macros and Use Related References Step 3 - Click on Record Macro to record the step by step instructions ...

Excel provides you different types of charts that suit your purpose . Based on the type of data, you can create a chart. Follow the steps given to insert Charts Step 1 – Arrange the data in columns or rows on the worksheet. Step 2 – Select the Data. Step 3 – On the INSERT tab, in the charts group, click the column chart icon on the Ribbon Step 4 – Click on the Column Chart and place the cursor on each chart and you can see the preview of the same. Step 5 – Place the matched chart exact with your data. List of Charts in Excel  Column Chart Line Pie Bar Area XY (Scatter) Map Stock Surface Radar Treemap Sunburst Histogram Box & Whisker Waterfall Funnel Combo Charts are creating with the same method mentioned above.

Shortcut Description Tab Move to the next  cell , to the right of the currently selected cell. 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+L Opens the  Create Table  dialog box. Ctrl+N Create...