Hot Microsoft Office Posts
How To: Split or freeze a row or column in Microsoft Excel 2011
Need to know how to split and freeze columns in Excel 2011? Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started splitting and freezing rows and columns in your own MS Excel '11 projects, watch the video.
How To: Turn a Ctrl + Shift + Enter formula into an Enter array formula 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 and Mr. Excel, the 52nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use the INDEX function to turn a Ctrl + Shift + Enter array formula into just an Enter array formula. Avoid Ctrl + Shift + Enter by using the INDEX function and a blank as the row argument.
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: Compare cash flows for coupon & zero-coupon bonds 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 57th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to compare cash flows for both coupon and zero-coupon bonds.
How To: Make calculations for inflation and real & nominal rates 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 54th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to make inflation calculations.
How To: Value coupon bonds and zero coupon bonds 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 46th installment in his "Excel Finance Class" series of free video lessons, you'll learn formulas for bond valuation.
How To: Calculate yield to market & effective annual yield from bond price 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 yield to market and effective annual yield from a bond price.
How To: Make an Excel scatter chart to show the relationship between bond rate & price
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 50th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to demonstrate the inverse relationship between bond rate and price with a scater chart.
How To: Make an Excel formula to say if a bond is sold at discount, premium or par
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 51st installment in his "Excel Finance Class" series of free video lessons, you'll learn how to create an if formula to indicate whether a bond is sold at discount, premium or par.
How To: Calculate expected returns for a portfolio in Microsoft 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 and Mr. Excel, the 733rd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to calculate expected returns for a portfolio in Excel.
How To: Convert decimal or percentage grades into integer grades 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 and Mr. Excel, the 734th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to convert decimal grades to integer grades in Excel.
How To: Calculate future & present value for multiple 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, part of his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the future and present values for multiple cash flows in Excel.
How To: Value assets with discounted cash flow analysis 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, part of his "Excel Finance Class" series of free video lessons, you'll learn how to use the PV and PMT functions together to do asset valuation using discounted cash flow analysis.
How To: Calculate the future value of annuity with the FV function 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, part of his "Excel Finance Class" series of free video lessons, you'll learn how to use the FV function to calculate the future value of an annuity.
How To: Create a savings plan that will yield $1,000,000 at retirement 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, part of his "Excel Finance Class" series of free video lessons, you'll learn how to use the PMT function to contrive a savings plan that will yield $1,000,000 at the time of retirement.
How To: Calculate the present value of annuity 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, part of his "Excel Finance Class" series of free video lessons, you'll learn how to use the PV function to calculate the present value of an annuity.
How To: Calculate how much you'll need for retirement 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, part of his "Excel Finance Class" series of free video lessons, you'll learn how to use the PV and PMT functions together to decide how much you need at retirement and how much you should deposit each month during your working years.
How To: Calculate the present value of an annuity for asset valuation 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 34th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the present value of annuity in Excel.
How To: Use the APR function to make loan payment calculations 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: Extract dates from a cell with dates and words 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 51st installment in his "Excel Finance Class" series of free video lessons, you'll learn how to use the DATEVALUE, RIGHT, IFERROR, LEN, TEXT, SEARCH, TRIM and REPLACE to extract dates from a cell containing both dates and words.
How To: Calculate APR and EAR given cash flows from annuity 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 38th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate APR and EAR given cash flows from annuity in MS Excel.
How To: Calculate the number of periods it takes to pay off a credit card 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 39th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the number of periods it will require to pay off a credit card balance in full.
How To: Create a perpetuity preferred stock valuation formula 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 40th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to create a perpetuity preferred stock valuation formula in Excel.
How To: Create an interest-only loan schedule 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 create an interest-only loan schedule in Excel.
How To: Build an amortization table for a consumer loan with Excel's PMT function
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 4nd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to build an amortization table for a consumer loan in Excel with the PMT function.
How To: Build an amortization table for a business loan with the PMT function
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 43rd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to create an amortization table for a business loan with Excel's PMT function.
How To: Build an amortization table for a deep discount loan 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 44th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to build an amortization table for a deep discount loan in Excel.
How To: Calculate inventory turnover & days to sell ratios 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 18.5th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate common financial ratios.
How To: Create a document for the web in Microsoft Publisher 2010
In this video tutorial, we learn how to create documents for the web in Microsoft Office Publisher 2010. Whether you're new to Microsoft's popular desktop publishing application or are a seasoned pro merely looking to brush up on Publisher 2010, you're sure to be well served by this clip. For more information, and to get started employing the lessons imparted by this free video software tutorial in your own Publisher projects, take a look.
How To: Create and use templates in Microsoft Publisher 2010
In this video tutorial, we learn how to create and use publication templates when working in Microsoft Office Publisher 2010. Whether you're new to Microsoft's popular desktop publishing application or are a seasoned pro merely looking to brush up on Publisher 2010, you're sure to be well served by this clip. For more information, and to get started employing the lessons imparted by this free video software tutorial in your own Publisher projects, take a look.
How To: Insert clip art into a document in Microsoft Publisher 2010
In this video tutorial, we learn how to insert clip art into a publication when working in Microsoft Office Publisher 2010. Whether you're new to Microsoft's popular desktop publishing application or are a seasoned pro merely looking to brush up on Publisher 2010, you're sure to be well served by this clip. For more information, and to get started employing the lessons imparted by this free video software tutorial in your own Publisher projects, take a look.
How To: Select and manipulate objects in Microsoft Publisher 2010
In this video tutorial, we learn how to select and manipulate objects when working in Microsoft Office Publisher 2010. Whether you're new to Microsoft's popular desktop publishing application or are a seasoned pro merely looking to brush up on Publisher 2010, you're sure to be well served by this clip. For more information, and to get started employing the lessons imparted by this free video software tutorial in your own Publisher projects, take a look.
How To: Make a histogram chart in Excel
In this tutorial, we learn how to make a histogram chart in Excel. To create a vertical histogram, you will enter in data to the chart. Then, highlight all of the data and go to "insert", "chart", then choose a regular column chart. Grab a regular 2D column and then make sure your values are correct. Then, right click and go to "chart options", then take the legend off. Now, make these columns all touch each other by right clicking over the columns and formatting them. Go to "options" then ch...
How To: Create a brochure with Microsoft Publisher 2007
In this video, we learn how to create a brochure with Microsoft Publisher 2007. A brochure says a lot about your business, and you can make them yourself easily! Find the brochure templates first in the program. Choose a design and a color scheme along with the page size, font, and information you want to include. Once you do this, add in pictures and images to your template after clicking "create". Then, you can create a range of publications that adapt to different form functions. Click the...
How To: Double space a paragraph in MS Word in 2 clicks
In this video, we learn how to double space a paragraph in MS Word in 2 clicks. If you've needed to double space a paragraph, but didn't want to do it manually through each sentence, this will make it a lot easier. All you have to do is highlight the paragraph you are working with. After this, press the control button and the number 2. After this, the paragraph will automatically come up and show that it is double spaced. You can use this on your entire paper or just for a part of a paragraph...
How To: Calculate the future value of an investment 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 21st installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the future value of an investment in Microsoft Excel.
How To: Calculate the present value of an investment 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 22nd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the present value of an investment in Microsoft Excel.
How To: Solve for total number of periods when you know PV & FV 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 23rd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to solve for the total number of periods when the present and future values are known to you.
How To: Add holidays to your Microsoft Outlook calendar using Leo from Kryon Systems
Sometimes managing your calendar in Microsoft Outlook 2007 can be a tough job. Finding the information you need in Microsoft Office can be more than a chore, even when it comes to menial tasks, like adding a holiday to your calendar. But don't worry. There's an easier solution. Leo.
How To: Add a hyperlink into a PowerPoint document using Leo from Kryon Systems
Forget fumbling around in Microsoft Office for help. When you really need to solve a problem, you can never find any answers, even when it comes to performing menial tasks, such as adding hyperlinks. Seems easy, right? With Leo it is. This video demo will show you how to add hyperlinks in PowerPoint using the Leo help application from Kryon Systems. Learn. Evolve. Operate. That's what Leo stands for, and in PowerPoint, getting things done is no longer a chore. Leo can do it for you! It's a ne...