All articles with 'Learn Excel' Tag

A common Forum Post question and one that Chandoo has written about a few times is, Does my data overlap with another range?

This week Formula Forensics examines Pradhishnair’s Overlapping Chaninage Problem where he wants to know if two values overlap with a range of other values

Hello my friend,

I have a few quick updates to start the week. Just read on to keep up.

Excel VBA section of Chandoo.org

During last few weeks, I have spent several hours organizing all the VBA material on Chandoo.org. I am happy to announce our brand to Excel VBA area of the site.

This section has Excel VBA overview, examples, videos, tips, books, references & more. Check it out.

Read on for the remaining 5 updates…

Not that I have friggatriskaidekaphobia or anything. But since today is Friday & 13th, lets put our Excel skills to test and find out when the next Friday the 13th is going to be.

Friends & Readers of Chandoo.org,

I am so happy to tell you that our VBA Classes are now open for your consideration. Click here to know more & join us.

What is this VBA Class?

VBA Class is a structured and comprehensive online training program for learning Microsoft Excel VBA (Macros). It is full of real world examples & useful theory.

The aim of VBA Classes is to make a beginner an expert in VBA.

Read on to understand the benefits of this program & how to sign-up.

Here is a quick Excel tip to kick start your week.

Sometimes, we want to enter same data in to several cells. You can use CTRL+Enter to do this in a snap.

(1) Select all the cells where you want to enter the same data.
(2) Type the data
(3) Press CTRL+Enter
(4) Done!

See the animation aside to understand how this works.

I have 2 quick announcements & 1 Excel tip for you.

Announcements

• Registrations for next batch of VBA Class start form January 11th (Wednesday). Please click here to download the course brochure.
• 20% Holiday discount on Excel School expires tonight (Midnight, Pacific Time). Please visit Excel School page and use the code LETSGOEXCEL to claim your discount.

Read on for a bonus Excel tip as well.

In the second installment on Excel Spreadsheet Risk Management, Myles takes a look at How companies can manage spreadsheet risk?.

He tells us, how we can set a formal governance framework to reduce or mitigate spreadsheet risk. Go ahead and read. And please tell us how your company manages spreadsheet risk in comments.

Here is something fun, personalized and delicious to start your new year. A Picture Calendar built in Excel!

Using this you can print a 12 month calendar with your own photos. Its fun to use, easy to set up and looks great. Read more to understand how this works & download the template.

This year has been the most hectic since we started Chandoo.org. We had 178 posts, more than 7,500 comments & 10,000 forum posts. We have trained more than 2,500 students thru Excel school, VBA Classes & Financial Modeling Classes this year alone.

More than 3.5 million people visited our site this year, spending an average of 2:30 minutes per visit, consuming a whopping total of 10.5 million page views. Just to give you a comparison, last year (2010), we had 1.5 million people visiting 5.5 million pages. We have also added 17,000 more RSS / Newsletter members this year. It is a hectic year for the site.

To wrap up the wonderful year, I want to share a list of posts that most of you loved.

2011 has been the most awesome year since we started Chandoo.org.

Without doubt, the credit goes to our community – that is you.

I feel very fortunate to have you in our community. You inspire me to learn & share. I know I said this several times, but everytime, I feel like I have not done enough. Thank you so very much.

Apart from our little community, I feel thankful to many others, who have helped me through out 2011 to make you awesome in Excel. In this post, I am highlighting them & expressing my gratitude.

Here is a new year gift to all our readers – free 2012 Excel Calendar Template.

This calender has,

» One page full calendar with notes, in 4 different color schemes
» 1 Mini calendar
» Monthly calendar (prints to 12 pages)
» Works for any year, just change year in Full tab.

Go ahead and download the FREE 2012 Calendar and Enjoy.

One of the most asked questions within the posts and Forums at Chandoo.org is, How Does Sumproduct work ?

Today in Formula Forensics we take at look at just that with a few worked examples.

Some of you know that I run an online Excel training program – Excel School. This program has 24 hours of detailed, step-by-step, fun & very useful Excel training, all available online so that you can view & learn at your own pace.

Creating this program has been the best thing that happened in my life. This program has been received very well by Excel users all over the world. Since we launched in Jan 2010, More than 2,500 people have joined Excel School and have become awesome in Excel. Personally, I have learned so much more about Excel, teaching & running business by conducting this program in last 2 years.

You too can become awesome in Excel by joining us. Please click here.

Have you created models which run into 20 – 30 years? You might have noticed that navigating to the last year (the last column) is probably the most boring part (and also the most time consuming part). Excel does provide you a shortcut (Ctrl + end), but that hardly works! It’s been a while since […]

Last week I asked, What is one area of Excel you want to learn more?

More than 250 of you responded to this question. Many of you shared your areas of interest thru comments, quite a few of you also emailed me personally.

So what next?

You told us what you want to learn, the next step is logical. We share some of the best tutorials & examples with you so that you can learn. In this post, we have presented more than 75 links, to help you learn your area of focus.

I have divided this in to 16 areas. In each area, we have identified (upto) 5 best links for you to learn more. I have also recommended 1 or 2 training programs that make you awesome in that area. Plus, if we found any excellent external resources, we have highlighted them as well.

So go ahead and learn Excel.