VLOOKUP Tutorial: Updating prices in a master price list
In honor of VLOOKUP Week, MVP Bill Jelen has created a VLOOKUP tutorial for those of you who have a basic working knowledge of Excel but want to improve your skills.
Excel
Transform data into insightful spreadsheets to help you analyze trends and visualize information.
Refine results
Product
Audience
Publish date
-
-
Using multiple criteria in Excel LOOKUP formulas
If you want to look up a value in a table using one criteria, it’s simple. -
Grouping emails by conversations
Have you ever had to find an email that was part of a long thread–an email with lots of replies about the same topic? For example, your boss might have asked for the results of last month’s important meeting, and you know Sherry sent an email outlining them, but then you remember that Todd followed hers with more information.
-
Quick Trick: Resizing column widths in pivot tables
Who could be better than a Business Intelligence analyst at teaching us a thing or two about Excel? We asked our own number-crunching wizard Stacey Armstrong to share some Excel tricks she’s learned along the way.
-
Combining chart types, adding a second axis
It’s often helpful to create charts that compare different types of data.
-
Score! Merge data from multiple worksheets
The Excel Consolidate feature provides an easy way for a coach to merge data from different expense worksheets into one main budget.
-
Want a way to send email to a group?
It’s your turn to organize a BBQ or highway litter patrol (or whatever) with your group of friends and you don’t want to type each individual name (or email address) on the To: line.
-
Email stuck in your outbox? Try this.
“What do you mean you didn’t receive it? I sent it last night!” At least you thought you did.
-
The good kind of circular reference
There have been ample articles about troubleshooting unintentional circular references in Excel workbooks.
-
Introducing Excel 2013
This blog post is brought to you by Jane Liles Group Program Manager for the Excel team.
-
The new Office Web Apps
I’m excited to talk about updates to the Office Web Apps, which are now available live on SkyDrive and the Office 365 Preview.
-
Recommended Reading
We’re wrapping up another outstanding week of the Office Preview release.