• 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 6 of 7« First...34567

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.

If you know what a secondary axis chart is, then you know what a challenge it can be to show disparate values on the same chart. This used to be somewhat cumbersome in older versions of Excel, but with Office 2007 and Office 2010 it’s a piece of cake! For those unfamiliar with the term, a secondary axis is useful when you have to display whole numbers and related percentages, like cost, price and profit percentage.

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.

Named ranges, which substitute a user-specified name for data in a range of cells, make data entry easier, formulas simpler to name, and cells a cinch to locate.

If you experience problems with date formats not “sticking,” here’s a sanity-saving technique to make your dates appear in the same format.

Q. What is the best way to create identical worksheets? I do a lot of copying and pasting, but I’m sure there is a better way.

Say you're trying to use an Excel spreadsheet to track weekly wages for office employees. It's simple enough to create a formula (hours x hourly rate) that calculates wages for someone who works 40 hours or less. But what if someone works 45 hours one week?

Q. This SUMIFs formula keeps getting an error that says, “The formula you typed contains an error." Here’s what I wrote: -SUMIF(C2:C278,>1000). What is causing the error?

Beyond simple pie charts, bar and column charts, you can create an additional layer of information in your Excel charts. Two such techniques are a secondary axis and trendlines.
Q. I used to use a button called Select Visible Cells in Excel 2003. I can’t find it anywhere in Excel 2007. Help!

What the heck is a pivot table?!? I like to call pivot tables custom table writers. Let's say you have some very detailed data: employee data, student data, or maybe customer transaction data, and you just want to see a segment of it in a report. Let's see how we do this with a pivot table...

You have probably been doing “if” logic ever since you were a toddler: If this is true, then this; otherwise, this. In Excel, IF statements are great for solving undesirable, but predicable, problems with error conditions.

Just start typing to get the function you want in Excel 2007 and 2010. A new type-ahead feature is now included for Excel functions.
Page 6 of 7« First...34567