Chandeep Chhabra

Become Unbelievably "Excel"lent !

Hi, My name is Chandeep!

Since 2013, I have been training, consulting and blogging to help people become quicker and smarter with Excel

Let me get you started by sending you smart ebooks on Excel and Powerpoint!

Let's Get Started!




Quick Chart Formatting Tip

February 24, 2015| 1 Comment

Chart Formatting Tip1

Here is a fun and also really quick way to replicate formatting in your charts

Read More

Format Painter Tip in PowerPoint

February 18, 2015| No Comments

Format Painter Tip1

We all have used the Format Painter once in a while, It is really simple. Lets take a look a 2 simple tricks with the format painter

Read More

Calculated Fields in Pivot Tables – A Case

February 10, 2015| No Comments

Calculated Fields

One of the less known and extremely awesome feature of Pivot Tables is its ability to create calculated fields with in the Pivot Table

Read More

When TRIM function fails to detect the Ghost Spaces!

February 2, 2015| 4 Comments

TRIM Function Fails1

If you have been using the Trim function for a while to delete the extra spaces between your text, you may have encountered that sometimes the TRIM Just Doesn’t Work! Here is what you do in that case

Read More

Unhiding multiple sheets at once!

January 29, 2015| No Comments

Unhiding Multiple Sheets 3

No it is not magic, but a simple macro!

The problem with un-hiding multiple sheets

Unhiding Multiple Sheets 1

 

The unhide box (appears when you select unhide from the right click menu on the sheet tab) does not allow you to select multiple sheet names

Here is a VBA Macro to unhide multiple sheets at once!

Sub Unhideallsheets()
For Each Wrksheet In ActiveWorkbook.Worksheets
Wrksheet.Visible = True
Next Wrksheet
End Sub

All you need to do is to paste this code in the code window and run it whenever you want to unhide multiple sheets

Unhiding Multiple Sheets 2

  1. To access the code window, open Visual Basic Explorer. Use the shortcut ALT+F11
  2. From the Insert drop down in the Menu bar, click on Module
  3. In the empty space, paste the code and close the Visual Basic Explorer

 Now run the code whenever you need it

  1. Use the shortcut Alt  F8 to open the list of Macros
  2. Select the Macro and click on Run
  3. Alternatively you can also link it to shape. Create a shape –> Right Click –> Assign Macro –> Select the Macro –> Done

 

Read More

Download Smart Ebooks on
Excel and PowerPoint Presentations

© Goodly