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 6 of 10« First...56710...Last »

If you’ve ever accidentally saved over a document you needed by using it to create a new one, or accidentally deleted long and complex formulas, you’ll appreciate these tips on choosing, creating and customizing templates.

In Excel, you can safeguard them by applying the lock cell format option and protecting the work sheet.

Q. What is the best way to paste an Excel chart into PowerPoint 2010?

While it's easier than it has ever been in Excel 2007 and 2010 to remove duplicates from a list based on selected criteria, you’ll need to watch out for a few things. Here’s how it works and how to avoid potential problems.

If you receive an Excel workbook with a Pivot Table in it and try to use the cells in a formula, you’ve probably seen the GetPivotData reference. GetPivotData has some very good uses, but it can be frustrating if you just want to refer to particular values in a range of cells in a Pivot Table ...

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.
Page 6 of 10« First...56710...Last »