Boost your productivity with

Smart Ebooks on
Excel & PowerPoint Presentations




Hi, Welcome to Goodly! My name is Chandeep

Chandeep

I do consulting and training on MS Excel, Business Intelligence Dashboards,
Business Plans / Financial Models and PowerPoint Presentations

I am putting together everything about Excel and PowerPoint Presentations
that I have learnt (and still learning) on this blog

Get started here by following these resources

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
© Goodly