fbpx
Search
Close this search box.

All articles with 'excel add-ins' Tag

Show difference between cells in status bar – VBA Example

Published on Sep 10, 2019 in Excel Howtos, VBA Macros
Show difference between cells in status bar – VBA Example

We can select a few cells in Excel and quickly see their count, sum etc. in the status bar. Ever wanted to customize the status bar to show something else, say difference? You can use VBA add-ins with application level events to achieve this. In this VBA Example, we will look at how to set up a class module, application event in our personal macro add-in to customize status bar.

Continue »

Secret Agent KV’s Chops…what’s in HIS Personal Macro Workbook?

Published on Nov 19, 2013 in Posts by KV, VBA Macros

Yesterday, I talked about how you don’t have to know how to code in order to highly leverage VBA. All you need to know is how to Google, Cut, and Paste. As discussed then, I ‘volunteered’ KV under pain of exposure to empty the contents of his secret satchel onto the virtual table, so that […]

Continue »

What would James Bond have in his Personal Macro Workbook?

Published on Nov 18, 2013 in Posts by Jeff, VBA Macros
What would James Bond have in his Personal Macro Workbook?

You know, I‘m constantly amazed at the depth of knowledge and wisdom that comes up in the comments of this site. For instance, the other day, undercover Excel secret agent KV came up a great list of interview questions in response to Chandoo’s great article What are best Excel interview questions?

I particularly liked this one:
Do you have a Personal Macro Workbook setup ? If yes, what are the most common macros you use in your daily work?

Secret Agent KV obviously has some purpose-built gadgets that he employs to kill inefficiencies. And he obviously also knows the two top-secret reasons to keep code in a Personal Macro Workbook:

  1. To keep it safe from international spy rings.
  2. So you can whip it out whenever you are cornered by any evil-looking spreadsheet.

While that first point is important, that second is the clincher: code stored in a personal workbook can be unleashed with a simple judo-chop to the throat.

Today, lets understand how to setup your personal macro workbook and open a secret passage-way to Excel awesomeness.

Continue »

80% Discount on PUP & PowerPivot Contest – Hurry up!

Published on May 3, 2011 in excel links
80% Discount on PUP & PowerPivot Contest – Hurry up!

Since I am busy with background work on VBA Classes launching next week, today I want to give you two quick updates.

1. John Walkenbach is offering 80% discount on his Power Utility Pack Excel add-in, only today (3rd May) between 11AM-1PM EST.
2. You can win an XBOX 360 + Kinect by participating in PowerPivot Nerdtastic Quiz on their facebook page.

Read more to get the details about these two.

Continue »

How to Add your Macros to QAT or Excel toolbars?

Published on Jun 8, 2010 in Excel Howtos, VBA Macros
How to Add your Macros to QAT or Excel toolbars?

Ok, so you have written a shiny new macro to solve all the problems. The macro, solveWorldProblemsAndMakeSomeCoffee() sits nicely in your personalmacros.xlam file somewhere in C drive. You have also installed the macro as an add-in so that it is always available. But wait!!! How do you run your sWPAMSC everyday in the morning? (ok, […]

Continue »

Excel Links – What are your plans for 2010 Edition

Published on Jan 11, 2010 in excel links
Excel Links – What are your plans for 2010 Edition

So we are in 2010, dawn of a new decade. In fact everyday is a start of new decade, as my friend Jon reflects on twitter. So what are your plans for this year and decade? As for me, I haven’t really jotted down any new year resolutions. So I am using this post as […]

Continue »

What is PowerPivot? (and does it really wear underwear on top of pants !?!)

Published on Jan 8, 2010 in Charts and Graphs
What is PowerPivot? (and does it really wear underwear on top of pants !?!)

Along with Excel 2010, Microsoft released a free add-in called PowerPivot. According to MS, PowerPivot gives users the power to create compelling self-service BI solutions, facilitates sharing and collaboration on user-generated BI solutions in a Microsoft SharePoint Server 2010 environment, and enables IT organizations to increase operational efficiencies through Microsoft SQL Server 2008 R2-based management […]

Continue »

Venn Diagrams in Excel

Published on Jun 3, 2009 in Charts and Graphs, excel apps
Venn Diagrams in Excel

This post is a testament that readers of this blog are way cooler and enterprising than I am. Justin, who I must say, has some really amazing excel skills, contacted me in April with a VBA Script he made that can draw two circle venn diagrams in excel.

Continue »

Now Edit Google Spreadsheets using MS Excel

Published on May 21, 2009 in Excel Howtos, Google Spreadsheets - Tip & Tricks
Now Edit Google Spreadsheets using MS Excel

Do you like the cool features of Google docs spreadsheets but too comfortable with MS Excel’s UI? Well, the supercool OffiSync add-in is for you. It is developed for Oudi Antebi an former marketing manager at Microsoft.

Once you finish the installation of the addin you will see a new ribbon in the corresponding applications (word, excel and powerpoint).

Continue »

Bonavista Chart Tamer Kicks ass.

Published on May 4, 2009 in Charts and Graphs, excel apps
Bonavista Chart Tamer Kicks ass.

Over the last few days I have been using Bonavista Chart Tamer tool and I found it pretty neat. Read my review of this wonderful tool.

Continue »

Review of PTS Clustered Stack Chart

Published on Feb 9, 2009 in Charts and Graphs, Learn Excel
Review of PTS Clustered Stack Chart

My Friend and long time Microsoft Excel MVP, Jon Peltier has released a wonderful little excel charting utility called Cluster Stack Chart Utility. Out of curiosity I have mailed Jon and asked him if he could send me a copy of it so that I can review the product and recommend it to PHD reader community. He is kind enough to mail the add-in to me and here goes my review of the tool.

Continue »

Clean up Incorrectly Formatted Phone Numbers using Excel

Published on Sep 30, 2008 in ideas, Learn Excel
Clean up Incorrectly Formatted Phone Numbers using Excel

In our Utopian imaginations all the data would have been standardized and shareable across systems and people. But alas, the reality is totally different. We seldom get data in the format / way we desire it to be. In other words, the ingredients are all there, but for us to prepare the dinner, you must […]

Continue »