Using crosstab queries in reports
A well designed database stores data in a normalized format with dates defined in a field so that new data is simply added as additional records.
Refine results
Product
Audience
Publish date
-
-
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 a Combo Box to search as you type
Here’s a neat trick that you can use to filter a Continuous or Split form while your users are typing in a Combo Box.
-
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.
-
5 tips on using Bcc in Outlook email
It’s kind of funny that a software application would use abbreviations that refer to pre-software days. -
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.
-
Change the default line spacing in Word
When the default line spacing in documents changed from single spacing in Word 2003 to a slightly roomier 1.
-
Conditional Formatting Rules Simplified
Conditional formatting is a popular feature and is a great way to easily identify cells with a range that meet some criteria.
-
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.
-
Tip: How to cut and paste without messing up formatting
Why does formatting sometimes get messed up when you cut and paste text? And what is that thing that appears at the end of the last sentence every time you paste-like a fly returning to honey.