How to Access the Calculator Without Leaving Excel 2010

by May 20, 2010

How often do you find yourself opening the Windows calculator to quickly find the solution to a problem? How often do you create a formula in Excel to find the answer to a silly calculation? If any of these apply, then you might want to add the Calculator command to the Office Ribbon in Excel…Continue Reading

How to Create a Line Chart in Excel 2010

by May 11, 2010

If you are looking for a quick and easy way to display trend data for a period of time, like stock prices, the best chart to use is the line chart and its variants. Excel comes the option to chart data using various line charts that allow you to customize the look and feel of…Continue Reading

Use the NETWORKDAYS.INTL Function to Calculate Workdays Using Excel 2010

by May 10, 2010

In Excel 2010, Microsoft introduced a new formula to complement the NEWORKDAYS formula that exists in previous versions of Excel. NETWORKDAYS allows you to calculate the number of workdays in a given time period including holidays. In the new version of the equation for Excel 2010 you can specify when the the weekend falls in…Continue Reading

How to Add a Header and Footer to Excel 2010 Spreadsheets

by May 10, 2010

Want to make your Excel spreadsheets stand out? Use the header and footer. Like Word documents, Excel spreadsheets have the ability to use a header and a footer to display important information about the spreadsheet/chart you are working on. The header and footer are usually visible when the Page Layout view is enabled and when…Continue Reading

3 Ways to Enter Formulas in Excel 2010

by May 10, 2010

Excel’s power lies in the vast array of formulas that allow you to calculate the sum of a given list all the way to determining the interest rate on a loan. But in order to use these powerful formulas you must become familiar with the several ways that formulas can be entered and used. While…Continue Reading