Hot Microsoft Office Posts

How To: Build a early zero coupon bond amortization table in Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 54th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to build an early zero-coupon bond amortization table in Excel.

How To: Calculate YTM and effective annual yield from bond cash flows in Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 49th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate YTM & effective annual yield from bond cash flows.

How To: Record bond discount & premium journal entries in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 53rd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to record bond discount and premium journal entries in Excel.

How To: Calculate APR, EAR & period rates in Microsoft Excel 2010

As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, part of his "Excel Finance Class" series of free video lessons, you'll learn how to calculate APR (Annual Percentage Rate), EAR (Effective Annual Rate) and Period Rate.

How To: Calculate monthly retirement income in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 12th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate average and marginal tax rates with Excel.

How To: Link two (multiple) workbooks & cells in Excel

In this tutorial, we learn how to link two workbooks and cells in Excel. First, save both of the files that you want to link together. Make sure you only have one Excel window open, then double click the other Excel file, don't open separately. Next, type in the equals sign into the "A" column, then to go the window menu and you will be able to see all the Excel files currently open. Now, click "link" and you will be taken back to the original worksheet. Now, you will be linked to the other n...

How To: Enter formulas in Excel with a macro

In order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, delete the contents of the cell. Press Alt + F11.

How To: Format reports with the Layout view in MS Access 2010

Learn how to use the Layout view option when working in Microsoft Access 2010. Whether you're new to Microsoft's popular database management application or a seasoned MS Office professional just looking to better acquaint yourself with the Access 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the Layout view in your own Access projects, watch this free video guide.

How To: Calculate child support payments in Microsoft Excel

Looking for a primer on how to calculate child support payments in a Microsoft Excel spreadsheet? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, you'll learn how to do just that. For more information, including detailed instructions on how to find child support payment amounts yourself, watch this helpful how-to.

How To: Use MS Excel 2010's NORM.DIST & NORM.S.DIST functions

New to Microsoft Excel 2010? Looking for a few good tips and tricks? Look no further. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 6th installment in his series of Excel 2010 video tutorials, you'll learn how to use the new NORM.DIST and NORM.S.DIST normal distribution functions. They have new screen tips to help you select the correct argument.

How To: Find a weighted average cost ending inventory value

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun and Mr. Excel, the 43rd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to calculate weighted average cost ending inventory value from transactional records on 2 different sheets using the COUNTIF, SUMIF and SUMPRODUCT functions.

How To: Retrieve multiple values from a horizontal Excel table

hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 21st installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the HLOOKUP and ROWS function to retrieve multiple values from a horizontal table.

How To: Create projections for sales numbers in MS Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 10th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create projections for sales numbers from a database using the SUMIF, VLOOKUP and COLUMNS functions and a percentage increase formula.

How To: Work with Microsoft Excel's LOOKUP function

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 42nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn ten tricks involving the LOOKUP function:

How To: Work with Chebyshev's Theorem & bell curves in Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 48th installment in his "Excel Statistics" series of free video lessons, you'll see comparison of Chebyshev's Theorem and the Empirical Rule (bell curve) and learn when to apply which.

How To: Do bank reconciliation in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 37th installment in his "Excel Business Math" series of free video lessons, you'll learn how to do bank reconciliation when accounting in Microsoft Excel.

How To: Create a contribution margin income statement in Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the very first installment in his "Beauty of Excel" series of free video lessons, you'll learn how to create a contribution margin income statement across various units sold.

How To: Find critical values with T functions in MS Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 91st installment in his "Excel Statistics" series of free video lessons, you'll learn how to use TINV and TDIST functions to find critical values given an unknown sigma value.

How To: Create a percentage frequency table in Microsoft Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 4th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a frequency table and percentage frequency table using a Pivot Table (PivotTable).

How To: Update inventory records by formula in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 348th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to build a formula that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock).

How To: Create an Excel inventory template with running totals

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 79th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to an entire table based on the content of a cell outside the table area. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Cross-check two lists for discrepancies in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 528th installment in their series of digital spreadsheet magic tricks, you'll learn how to check two data sets (lists & tables) to see if there are discrepancies using the MATCH and VLOOKUP functions.

How To: Calculate commissions with Excel's IF & VLOOKUP

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 555th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF and VLOOKUP functions to make one of two types of commission calculations based on what is put in the referral column.

How To: Calculate probability in an Excel pivot table

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 55th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate probabilities with a pivot table (PivotTable). Specifically, you'll learn how to find joint, marginal and conditional probabilities.

How To: Create date labels with YEAR, DATE & TEXT in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 300th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the YEAR, DATE and TEXT functions and the ampersand (concatenation) to create a date label that adds leading zeros appropriately.

How To: Create a nested unique list via a pivot table in Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 250th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a unique list of customers within a unique list of sales representatives using a pivot table (PivotTable).

How To: Make a gradebook based on percentage scores in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 194th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, VLOOKUP and ROUND functions to create a gradebook based on percentage scores that will calculate grade for you automatically. See also how the VLOOKUP and the percentage format can deliver the wrong grade when you dont use the ...

How To: Create an array for a stem-and-leaf chart in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. With this video tutorial from ExcelIsFun, the 376th installment in their series of digital spreadsheet video tutorials, you'll learn how to an array formula for a stem and leaf chart for numbers that have more than two digits. This is accomplished through use of the IF, COLUMNS, SUMPRODUCT, LEFT, RIGHT, FIXED, INDEX, SMALL and ROW functions.