• 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 4 of 9« First...345...Last »
But, you have to unhide them one at a time, unless you know Custom Views.
Use Shift+Enter to commit the value to a cell and move up a row in the same ­column ... Select Shift+Tab to do the same but move to the left ... Hit Shift+F10 to show the right-click menu.
Try Conditional For­­mat­­­ting using Top & Bottom Rules in Excel.
Excel really shines in its ability to perform calculations. However, it can seem somewhat intimidating if you don’t know the rules.
First, to make it easier to identify the right list, name your worksheet ...
Q. When should I use VLookUp and when is it better to use Index and Match?
The first argument, “Range,” isn’t very clear. It means the range of cells you want to examine, not necessarily with what range you want to create a sum. The criteria argument has its own quirks ...

Q. My formula suddenly started giving me #REF! errors. What went wrong?

We certainly do not suffer from a lack of data these days. But all the tools in the world will not get that data talking until it is in a format you can use. Excel is the most common place to fix data because it has tools to help scrub up your data files.

Q. How can I return characters to the left of a dash in an Excel cell using the LEFT function? I don’t always know what position it will be in.

Page 4 of 9« First...345...Last »