Category Archives: Excel tips

Excel tips: Auto fit cell/column to text/numbers

Microsoft Excel is full of surprises. Today while working in it I realized a simple yet tedious work ahead of me. It so happened that I had to copy a tab/sheet full of numbers and paste it into a new … Continue reading

Posted in Excel tips | Tagged , , , , | Leave a comment

Filling ‘blank/empty cells’ using data from the cell that is above the blank/empty cell

  Steps: 1. Select the row header (select the entire colum) 2. Press F5 3. Press Alt+S or click on “Special…” 4. Select “BLANK” 5. Click OK (Blank cells will be selected) 6. Enter ‘=’ and select the above cell … Continue reading

Posted in Excel tips | Tagged , , | Leave a comment

Excel tips: Creating a dashboard with pivot table, charts and slicers

Video | Posted on by | Tagged , , , | 1 Comment

Excel tips: Pivot table (Show report filter pages)

Video | Posted on by | Tagged , | Leave a comment