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.
Excel
Transform data into insightful spreadsheets to help you analyze trends and visualize information.
Refine results
Product
Audience
Publish date
-
-
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.
-
Combining chart types, adding a second axis
It’s often helpful to create charts that compare different types of data.
-
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.
-
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.
-
Using multiple criteria in Excel LOOKUP formulas
If you want to look up a value in a table using one criteria, it’s simple. -
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.
-
Tip: Add a watermark to an Excel worksheet
If you’re collaborating or creating sensitive material in Excel, you probably need either a DRAFT or CONFIDENTIAL watermark.
-
Circular Reference? Excel’s most popular (!#?%) error message explained
Millions of people using Excel don’t get why they see the “circular reference” error message right after they’ve entered a formula.
-
Generate invoice numbers in Excel
If you need a way to create invoices in Excel, you can use one of the many invoice templates on Office.
-
Tracking small projects in Excel
It goes without saying that Microsoft Project is THE program to use if you need to manage large projects.
-
The Excel part of mail merge
Hey, the holidays are fast approaching, which means you’ve got to get your cards signed, sealed, and delivered! This post goes out to those of you who keep your address list in Excel and need to figure out how to use it to create mailing labels in Word.