All articles with 'videos' Tag

Excel Tables, a newly introduced feature in Excel 2007 is a very powerful way to manage & work with tabular data. I really like tables feature and use it quite often. If you are new to tables, read up Introduction to Excel Tables.

In this short video tutorial I explain how to combine VLOOKUP, INDEX, MATCH formulas with Excel Tables.

Learn how to create a birthday reminder worksheet in excel in this video post. You can also download a template to keep track of upcoming birthdays and anniversaries.

Do you ever think about questions like this?
1) What is the maximum profit we can make?
2) What is the best way to schedule employees in shifts?
3) What the best combination of tasks we can finish in a given time?

You might have heard about Excel Solver tool while trying to find solutions to questions above. If you have never used Solver or have little idea about it, then this post and video are for you.

Some of you know that I run an online excel training program called Excel School. If you want to join, click here. Only 8 days left.

I run excel school mainly to meet new students, understand their problems and learn new ways to solve them. But, Excel School also presents me with an interesting analytics challenges. In this post, I will share 2 pivot table based analytic techniques I used just yesterday to answer few questions I had about Excel School sign-ups.

Watch this 15 min. video to see how I analyzed the data

Hello reader, my friend & supporter,

I am happy to announce that Excel School is open and ready for registrations.

Visit Excel School page to learn more and sign-up.

In this post, you can find some information about the program and links to sign-up.

This post is about my Excel School online training program. Feel free to skip if you are looking for excel tips. Some of you know that I run an online Excel training program called Excel School. It helps excel newbies and beginners to learn about various powerful features and become proficient in them. We discuss […]

I don’t remember when was the last time both of us (Jo and I) were this excited. And the reason?

Nakshatra and Nishanth have started taking their first steps last week !!!

It is such a joy watching them take one step at a time. Aah, the beauty of parenting 🙂

So I asked myself, “What is a good way to celebrate this without looking like a super-excited dad?” and I got my answer in 72 milli-seconds.

I have created 10 short (<10 min) videos helping you to take baby steps in Excel world. Each video introduces you to one new functionality of Excel and shows you some nice examples. Before jumping straight in to the videos, I want to share a short clip (30 seconds) of our kids taking their baby steps.

As part of our Reader Awesomeness Week, Francis shares with us a travel site dashboard he made for his company. Francis took just two days to prepare this awesome dashboard which uses concepts like bullet charts, sortable KPI grid, Date based filtering, dynamic charts and more. I was really moved by Francis’ gesture in sharing his work with us, so much that, I did a video review of his work. You can see it in the embedded youtube video to the left.

Read the rest of the article to know how this dashboard is made and get a copy of the file.

In this and next 3 posts, we will learn how to make a Dynamic Dashboard using Microsoft Excel.

At the end of this tutorial, you will learn how easy it is to set up a dynamic dashboard using excel formulas and simple VBA macros.

Last week I asked you “would you be interested in an online excel training program?” and quite a few of you have responded with “YES”.

So I decided to start excel school. This is a 12 week online training program that will explain various MS Excel concepts to you in an easy to understand format. I am calling it “school” because the program will be fun, exciting and playful – just like school. We will learn from each other as much as we learn from the course itself. Read the rest of the post to see “Excel School Intro” video.

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 […]

Transposing rows and columns in a table is one of the most useful tricks when you are pasting data. Yet, it always surprises me that very few people actually know this. So here it is…

Yesterday while checking my website analytics reports on Google analytics site, I have noticed a new beta feature called “Intelligence”. Out of curiosity I clicked on it. It took me to a an intelligence alert dashboard. Ok, lets just back up for a minute and understand what “intelligence dashboard” is before moving on. In the […]

In our recent poll, I have asked you to tell me which buttons you have on the quick access toolbar?

Finnur, one of our readers has configured the Excel 2007 quick access toolbar to make it look like Excel 2003 toolbar.

I think this is a very cool way to max up your productivity, it takes 5 minutes to make your quick access bar look like Excel 2003 toolbar and you could save countless hours of “searching-for-that-command-in-ribbon” time.

A Bubble chart displays circles (or bubbles) at given X and Y co-ordinates. Bubble chart is a very good way to show 3 dimensional data (for eg. Region-wise product sales) without confusing users. In this tutorial, we will learn how to create a bubble chart using excel.