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 7 of 10« First...67810...Last »
Learn the difference between SumIf and SumIfs ... Dissect formulas in order to fix them ... Clean up inconsistent date formats.

You may have heard that Excel Pivot Tables are too difficult and should be attempted only by the most advanced users. Not true! Pivot Tables are easy to create and you can use them for everything from answering simple questions to performing complex analysis.

First, save each open file. Then, with all workbooks open and arranged how you want them (tiled, horizontal/vertical windows, arranged in various window sizes), click the Save Workspace button in the Windows group of the view tab ...

What-If Analysis tools are a well-kept secret in Excel, located on the Data tab, Data tools group.
Change the cell format to Number ... Put the cell value in Currency style ... Place the cell value in Percent style.

Periodically, Excel seems unwilling to let you change your mind when you accidentally get two different date formats in a column. Sometimes, it’s as easy as changing the format, other times you will need this two-step process.

Q. I need to perform a calculation if specific text is found inside a cell in an Excel work sheet. It won’t always be in the same place. How would I do that?

Q. When I link two sheets together and a cell in the source sheet is blank, I get a 0 in the target sheet. How do I get rid of the 0’s?

Q. In SharePoint, I keep getting an error when I import Excel workbooks. Why does it say it’s not a valid Excel File?

Try creating a Custom View in Excel if repeated filtering and hiding columns and rows become drudgery.
Page 7 of 10« First...67810...Last »