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

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

Quick Tip : Turning off GETPIVOTDATA function

January 27, 2015| 1 Comment

Quick Excel Tip

Recently I was getting a model vetted from my girl friend! She saw a set of pivot tables and asked: How do you turn off the irritating GETPIVOTDATA function?

I traded off the quick tip with some awesome stuff ! 😆 And for you my friend.. it is on the house 😎

Read More

Getting the Tray look in PowerPoint

January 19, 2015| No Comments

Tray in PowerPoint

 

 

I recently worked on a consulting project where I had to deliver a corporate presentation. The client had to impress its peers in Singapore. I thought what better way than creating some interesting animations and one of them was to display the logos in a tray like look 😎

Read More

A Check Button Chart !

January 11, 2015| 1 Comment

Check Button Chart

I guess I don’t have to say much to get your interest!! Interested..? Ok lets begin!  🙂

Read More

4 Quick custom number formats for dates!

January 4, 2015| No Comments

Quick custom date formats

 

A while ago I wrote a post on how to use custom formatting in excel. Let’s take a look at some interesting custom formatting codes for dates

Read More
© Goodly