Take the first step in growing your Excel skills

It's hard to find time to learn new skills. We're all busy, and as much as we might want to become more proficient at something, we seldom have the extra time required to learn. That's one of the reasons I'm excited about the new video series Excel Skills Builder.

In a nutshell, the skills builder is a video series that comprises short (typically under 5 minutes each) videos that give you an overview of a task or feature in Excel. The videos are grouped so that you can build on the basics and move from the simple to the more complex. It's a great way to learn about new features and tasks in Excel. And you can even track your progress through each lesson. If you come back later to finish the lesson, you know where you stopped. In the example below, I've watched all the videos, so a check mark appears for each video, and my Learning Progress bar is full. Very handy.

Lesson 1: Moving from lists to tables is currently available. It includes the following topics:

• Create a workbook
• Customize a worksheet
• Enter and edit data
• Format data
• Apply math and formulas
• Sort and filter data
• Create and use tables

At the end of each video, you'll get links to more information on the task, so you can dig deeper if you have the time or inclination.

We're working on creating the rest of the lessons in the series. These will cover visual analysis, collaboration and sharing, and automation, macros, and reporting.

So be sure to check out Lesson 1, and let us know what you think (post your comments here on the blog). We'd love your feedback and ideas for future video content.

--Amy Miller

• Amy

Sounds great, but something that is in the format of a video series, especially when they tend to be short, is unlikely to cover some of the details I would need. For example, very specific info about when I freeze panes at column D, Excel freezes it at column H everytime I have some columns further to the right i the spreadsheet 'grouped'. Where does someone get training or help to such a specific question?

• I think these are great and was ready to share until I saw how few there were. I'm anxiously awaiting the next series. Are you doing any for Word?

• @macd144 - great question. The idea behind the Excel Skills Builder is to provide more introductory-type content to features and tasks in Excel. Your questions are pretty specific. I would check out Microsoft Answers: answers.microsoft.com/.../office. You could also try posting these types of questions to the Excel Facebook page at www.facebook.com/.../set

@lstewart: So glad you liked the first lesson. The next 3 will be avaliable soon, and I'll be sure to announce them on the blog when they go live. There may be more of this type of training for other Office apps in the near future...especially if users find the Excel videos useful.

• dont know where to post a question regarding excel...... so here i go

lets say...

a table having 3 columns row1(id, age, secondary id)......row2(123, 24, 9999)

if i have to lookup for value 123 in column1 and return value from column3 then the formula will be....=vlookup(123,a2:c2,3,false)..... it will return 9999.

My question is.... what is the formula

If i have to lookup for value 9999 in column3 "secondary id" and return value 123 from column1 "id"

help will be really appreciated

Thanks

• Need help with Excel 2010 conditional formatting:

I need to have a conditional format for a cell where the color of the cell changes based upon 3 conditions.  If the value of the cell is between 0-69 (<70) the cell is green, between 70-121 the cell is yellow and if the value is >121 the cell is red.

Where in excel 2010 can I create 3 conditions for the same cell?