All articles with 'macros' Tag

Visualize Excel salaries around world with these 66 Dashboards

Visualize Excel salaries around world with these 66 Dashboards

Ladies & gentleman, put on your helmets. This is going to be mind-blowingly awesome.

See how many different ways are there to analyze Excel salary data. Look at these 66 fantastic, beautifully crafted dashboards and learn how to one up your dashboard awesomeness quotient.

Continue »

Highlight Row & Column of Selected Cell using VBA

Published on Jul 11, 2012 in Excel Howtos, VBA Macros
Highlight Row & Column of Selected Cell using VBA

When looking at a big table of analysis (or data), it would make our life simpler if the selected cell’s column and row are highlighted, so that we can instantly compare and get a sense of things. Like above.

Who doesn’t like a little highlighting. So lets learn how to do highlighting today.

Continue »

Visualizing Roger Federer’s 7th Wimbledon Win in Excel

Published on Jul 9, 2012 in Cool Infographics & Data Visualizations
Visualizing Roger Federer’s 7th Wimbledon Win in Excel

Did I tell you I love tennis? Some of my personal heroes & motivators are tennis players. And as you can guess, I admire Roger Federer. Watching him play inspires me to achieve more. So last night when he lifted Wimbledon trophy for 7th time, I wanted to celebrate the victory too, in my style. So I made an interactive timeline chart in Excel depicting his victory.

Continue »

Creating a Masterchef Style Clock in Excel [for fun]

Creating a Masterchef Style Clock in Excel [for fun]

Jo (wife) likes to watch Masterchef Australia, a cooking reality show every night. Even though I do not find contestant’s culinary combats comforting, occasionally I just sit and watch. You see, I like food.

The basic premise of the program is who cooks best in given time. To tell people how much time is left, they use a clock that indicates how much time is left (much like a stop clock, with a small twist).

One day, while watching such intense battle, my mind went

It be cool to make such a clock using hmm… Excel?

While I cannot share my snapper (or pretty much any other food item) with you, I can share my Masterchef style Excel clock with you. So behold,

Continue »

Extract Numbers from Text using Excel VBA [Video]

Published on Jun 26, 2012 in Excel Howtos, VBA Macros
Extract Numbers from Text using Excel VBA [Video]

Last week we discussed how to extract numbers from text in Excel using formulas. In comments, quite a few people suggested that using VBA (Macros) to extract numbers would be simpler.

So today, lets learn how to write a VBA Function to extract numbers from any text.

Continue »

VBA Move data from one sheet to multiple sheets

Published on May 14, 2012 in Automation, Excel Howtos, Learn Excel, VBA Macros
VBA Move data from one sheet to multiple sheets

Suresh sent an email with interesting problem.

There is one data entry sheet where all the data needs will be entered, however once done we want the data to be stored separately in multiple sheets designated by the Employee code.

In this article we will learn how to use VBA to help in resolving the problem Suresh was facing at work.

Continue »

Interactive Sales Chart using MS Excel [video]

Interactive Sales Chart using MS Excel [video]

Finally, I got some time to sit down and do what I love most – write a blog post to make you awesome in Excel. After a whirlwind trip to Sydney, I am back in India to spend few days with my kids & wife before rushing to Australia to run 2nd leg of my training programs (in Perth, Melbourne & Brisbane). I did 2 sessions in Sydney – one for KPMG and other for public and both went very well. We got lots of positive feedback and people really loved it. I am saving the details for another post, but today lets talk about Interactive Sales Chart using Excel.

Take a look at the Interactive Sales Chart

First, take a look at interactive sales chart. Today, you will learn how to build this using Excel.

Continue »

Excel Links – Live from Sydney Edition

Published on May 1, 2012 in excel links
Excel Links – Live from Sydney Edition

Hello folks,

My flight to Sydney has been lengthy but fun. I have reached here on Sunday morning (8AM) and spent most of the day with Danielle’s family. (Danielle is the founder of Plum Solutions. She is the one who invited me to Australia and planned this whole experience for me).
On Monday (30th April), I went exploring the city on foot. I had coffee in the beautiful Queen Victoria Building, attended 1PM church service at the magnificent St. Mary’s cathedral, walked thru Hyde park, went to Sydney central station, took at sneak peek at the new Apple store in down town, got back to my hotel, walked to Opera house to meet up with our readers.

Reader meetup at Sydney
We had 6 people turn up for the meetup. It was fun talking about Excel & our journey with these wonderful folks. Here is a pic (you can see the harbor bridge in background & 8 awesome Excel users in foreground, Click on it to enlarge).

Continue »

Adding Macros & Final Touches to Customer Service Dashboard [Part 4 of 4]

Published on Apr 26, 2012 in Charts and Graphs, VBA Macros
Adding Macros & Final Touches to Customer Service Dashboard [Part 4 of 4]

Welcome back. In final part of Making a Customer Service Dashboard using Excel let us learn how to add macros & VBA code that makes our dashboard interactive.

As you can see, there are 2 important macros in this dashboard.

Continue »

Send mails using Excel VBA and Outlook

Published on Apr 23, 2012 in Automation, Excel Howtos, Learn Excel, VBA Macros
Send mails using Excel VBA and Outlook

Ever wondered how we can use Excel to send emails thru Outlook? In this article we well learn how to use VBA and Microsoft Outlook to send emails with your reports as attachment.

Scenario: We have an excel based reporting template. We want to update this template using VBA code to create a static version and email it to a list of people. We will define the recipient list in a separate sheet.

Read on…

Continue »

Consolidate data from different excel files (VBA)

Published on Apr 9, 2012 in Automation, Excel Howtos, VBA Macros
Consolidate data from different excel files (VBA)

Last week, we learned how to use SQL and query data inside Excel. This week, lets talk about how we can use VBA to consolidate multiple data sheets from different workbooks into one single worksheet.

Continue »

Using Excel As Your Database

Published on Apr 2, 2012 in Automation, Excel Howtos, VBA Macros
Using Excel As Your Database

Often I have thought, if I could have write “Select EmployeeName From Sheet Where EmployeeID=123″ and use this on my excel sheet, my life would be simpler. So today we will learn how to do this.

People spend a lot of time thinking whether to use Excel as their database or not. Eventually they start using Access or SQL Server etc.

Today we will learn how to use Excel as a Database and how we to use SQL statements to get what we want. We will learn how to build a form like above.

Continue »

75 Excel Speeding up Tips Shared by YOU! [Speedy Spreadsheet Week]

Published on Mar 27, 2012 in Learn Excel, VBA Macros
75 Excel Speeding up Tips Shared by YOU! [Speedy Spreadsheet Week]

As part of our Speedy Spreadsheet Week, I have asked you to share your favorite tips & techniques for speeding up Excel. And what-a-mind-blowing response you gave. 75 of you responded with lots of valuable tips & ideas to speed-up Excel formulas, VBA & Everything else.

Thanks to all the contributors

Many thanks to everyone who shared their tips & ideas with us. If you like the tips, please say thanks to the contributor.

Read Excel Speeding-up tips by area

This page is broken in to 3 parts, click on any link to access those tips.

Read everything
Formula Speeding-up Tips
VBA / Macros Optimization Tips
Everything Else
Share your tips

Continue »

Excel Speedup & Optimization Tips by Experts [Speedy Spreadsheet Week]

Published on Mar 26, 2012 in Learn Excel, VBA Macros
Excel Speedup & Optimization Tips by Experts [Speedy Spreadsheet Week]

As part of Speedy Spreadsheet Week, I have emailed few renowned Excel experts and asked them to share their tips & ideas to speedup Excel. Today, I am glad to present a collection of the tips shared by them. Read the Excel optimization & speeding up tips shared by Hui, Luke, Narayan, George, Gregory & Jordon.

Continue »

Optimization Tips & Techniques for Excel VBA & Macros [Speedy Spreasheet Week]

Published on Mar 22, 2012 in VBA Macros
Optimization Tips & Techniques for Excel VBA & Macros [Speedy Spreasheet Week]

Is VBA slowing down your workbooks? Do you spend hours starting at Excel while the macros finish running? As part of our Speedy Spreadsheet Week, today lets talk about optimization techniques for Excel VBA & Macros.

Optimization Techniques for Excel VBA & Macros

Lets break this in to 2 sections. (1) Quick optimization techniques & tactics (2) Optimization ideas for the long run. Read on…,

Continue »