• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Excel Training

Our Microsoft Excel training helps you learn Microsoft Excel and the many Microsoft Excel tips available.

With our Microsoft Excel help, you’ll unlock the power of this resource, and learn excel from the bottom up. Benefit from the Excel tips provided by Business Management Daily’s team of experts.

Page 3 of 9« First...234...Last »
Say you’re filtering a list of your 55,000 employees, each with their own employee number. You need the records that have either of two criteria in one column and either of three criteria in another column. You want to filter for more than two “and” criteria. When Filter doesn’t give you exactly what you need, there are a few options to try.
Pop open the Format Cells dialog box with all the familiar tabs by using Ctrl+1 ... Change the font to Strikethrough with the Ctrl+5 shortcut ... Hide a column without selecting it by hitting Ctrl+0.
You’ve made that giant leap to using Pivot Tables in Excel. Congratulations! Now it’s time to gnash some numbers.
Q. How do I make a 0 show up as a blank on the screen, but still have the value 0 in the cell? I need the zero for other formulas.
If the column titles were on all the pages, would that help? It’s easy to do.
Q. I want to show 3 different types of filtering on the same worksheet, depending upon who’s using it. Can I do that?
The data item is a number that will be in a range, like a score of 87 on a test earning a B where the range was from 81-90. Use a VLookUp without a Range-Lookup value.
Numbers stored as text can be irritating, whether it’s just for aesthetics or these mixed numbers making your VLookUps misbehave. The following fix may seem strange to start out, but it will have all your numbers working like numbers in no time.
Q. I’d like to provide a “legend” so people know what the different Conditional Formatting colors mean in Excel. How can I do this?
But, you have to unhide them one at a time, unless you know Custom Views.
Page 3 of 9« First...234...Last »