Category Archives: Excel tips

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

Excel tips: Sparklines for quick analysis of data

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