Hot Microsoft Office How-Tos
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...
How To: Insert a picture into a Microsoft Word document using Leo from Kryon Systems
Learn. Evolve. Operate. That's the basis of Leo from Kryon Systems. It's a new application that runs on top of any program you have open (web and desktop applications), providing you with instant help. Leo can actually perform your duties for you! Like in Microsoft Word 2007. In this video demo, you'll learn how you can use Leo to help you insert a picture into Word 2007, making Office a whole lot easier. See it in action!
How To: Add a column of numbers while ignoring #N/A errors 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 add a column of numbers ignoring #N/A errors.
How To: Perform basic financial ratio analysis in Microsoft Office 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 17th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to perform simple financial ratio analysis.
How To: Make basic balance sheet 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 9th installment in his "Excel Finance Class" series of free video lessons, you'll learn a number of handy formulas for making common balance sheet calculations.
How To: Calculate growth ratios and market value 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 11th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the Earnings per Share EPS, Price to Earnings (PE), Dividends per Share, Internal Growth and Sustainable Growth ratios in Excel.
How To: Calculate return on equity, assets and profitability 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 19th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate return on equity, assets, and profitablility — return on investment (RoI).
How To: Find asset turnover, capital intensity and inventory turnover ratios 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 11th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate asset turnover, capital intensity, inventory turnover, days to sell inventory, receivable turnover, days to collect accounts receivab...
How To: Calculate leverage and solvency 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 17th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the debt ratio, debt to equity ratio, equity multiplier ratio and times interest earned ratio.
How To: Calculate liquidity ratios 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, the 16th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate liquidity ratios including current ratio, times interest earned and cash Ratio. Also see how current ratio changes when certain trans...
How To: Create common-sized financial statements 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 15th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to generate a common-sized financial statement within Microsoft Excel.
How To: Calculate cash flow from assets 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 11th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate cash flow from assets, cash flow to creditors and cash flow to shareholders using accounting financial statements.
How To: Calculate average and marginal tax 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, 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: Retrieve the cell address of the minimum value in a column 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, the 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve the cell address of the minimum value in column. To accomplish this, you'll use the ADDRESS, MATCH, INDEX, MIN, ROW and LOOKUP functions.
How To: Use the SUMIF function with approximate criteria 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, the 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF function with approximate criteria to add when criteria has other content in the cell.
How To: Use the SERIES chart function in Microsoft Excel 2010
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 732nd installment in their series of digital spreadsheet magic tricks, you'll learn how to make use of the Excel SERIES chart function.
How To: Look up an item when multiple lookup items are in a single cell 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 729th installment in their series of digital spreadsheet magic tricks, you'll learn how to lookup an item when multiple lookup items are in a single cell with the LOOKUP and SEARCH functions.
How To: Calculate hours worked in a shift with a lunchbreak in Microsoft Excel 2010
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 727th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the hours worked in a night or day shift with a break for lunch given time number inputs using the MOD function.
How To: Use the Ribbon and Backstage view in MS OneNote 2010
In this video, we learn how to use the Ribbon and Backstage view in MS OneNote 2010. First, open up MS OneNote 2010 on your desktop. You will now see a new user interface where the ribbon appears underneath the tabs. Click the home tab to see the ribbon and then you will see the options to change font, colors, headings, and more. These help you find the features you want to change much faster and is completely customizable. The options can be located on the backstage view, which is underneath...
How To: Subscribe to blogs and RSS feeds in Microsoft Outlook
Have your favorite blog posts delivered straight to your email inbox! Many websites and blogs offer RSS feeds which allow you to subscribe and have new content emailed directly to you. This tutorial shows how you get RSS feeds sent to your Microsoft Outlook inbox.
How To: Use the ASAP Utilities to boost the functionality of MS Excel
If you have multiple spreadsheets you want to merge into a single master file, you can easily accomplish this task by using the ASAP utilities. This tutorial demonstrates how to get the most out of this tool for your own spreadsheets and MS Excel projects.
How To: Encrypt emails with the Voltage Security Network Microsoft Outlook plug-in
In this clip, you'll learn how to use the VSN plug-in to encrypt email in Microsoft Outlook. It's easy! So easy, in fact, that this helpful how-to can present a complete overview of the app in just over five minutes. For more information, including detailed, step-by-step instructions, take a look.
How To: Use formulas, functions, formula inputs and cell references in Microsoft Excel
This tutorial aimed at someone new to Microsoft Excel shows you how to navigate the basic functions of a spreadsheet. It goes over formulas, functions, formula inputs and cell references, all of which you'll need to master in order to use Excel effectively.
How To: Write and give a great PowerPoint Presentation
Here are seven tips you can use to make your PowerPoint presentation eye-catching and attention-grabbing. Never have your audience nod off. Keep your slides simple and organized, make good use of transitions, don't read directly from the slide and know your way around the keyboard and Presenter Mode.
How To: Write and publish a blog post in Microsoft Word 2007
Start blogging directly from Micrsoft Word! Use spellcheck, and never worry about your browser eating your post. You can write your own perfectly formatted blog posts using Word 2007. And when you're done, you can even publish the post directly from the program to your Word-compatible blog on the web.
How To: Create a calendar appointment using drag and drop in Outlook
You can drag and drop an email onto your Calendar icon in Microsoft Outlook, which then immediately gives you the option of setting up a new calendar entry. You can even color code your various events for easy reference later!