Everything Else
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: Create a brochure in Microsoft Publisher
A simple tutorial video that demonstrates the procedure for creating a brochure quickly and easily using the Microsoft Publisher program, which is shipped as a part of the Microsoft Office Suite.
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!
How To: Use the order of operations correctly when working with Microsoft Excel
You'll need to use lots of math if you're working with formulas and numbers in Microsoft Excel. This tutorila gives you a brief introduction to the different math operators avaiable to users of Excel, as well as reviewing the order of operations you'll need to be aware of.
How To: Format your numbers correctly when working on a spreadsheet in Microsoft Excel
Always make sure you've formatted your numbers correctly within the proper cells when you're developing a spreadsheet in Microsoft Excel. There are a variety of number formatting functions you can use to make your spreadsheet more readable, and this tutorial explains how to use number formatting correctly.
How To: Calculate weekly gross pay from time values 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 722nd installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate gross pay for the week from time values using the SUMPRODUCT function. Also see what to do if you get a #VALUE! error from blanks in cell using the IF function and an array logical test.
How To: Avoid errors with the COUNTIF function when using workbook reference 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 723rd installment in their series of digital spreadsheet magic tricks, you'll learn how to avoid errors with the COUNTIF function when using workbook references by using the SUMPRODUCT function.
How To: Check whether quantities are equal in two lists 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 724th installment in their series of digital spreadsheet magic tricks, you'll learn how to check if quantities are the same in two lists and show the differences if not, list the word "equal" if they are the same, and "not in list" if the lookup items is not in list using the MATCH, INSA, VLOOKUP and IF functions.
How To: Calculate quartiles with the Microsoft Excel 2010 QUARTILE function
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 725th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate quartiles with the MATCH and QUARTILE function.
How To: Avoid double-counting duplicates within a list 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 726th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SIGN, COUNTIF and SUMPRODUCT functions to count 1 for each item in a first list that's also contained in a second list.
How To: Locate your personal storage folder in Outlook 2003 or 2010
In this clip, you'll learn how to locate the Outlook personal storage folder when, for example, migrating between Outlook 2003 & 2010. Whether you're new to Microsoft's popular email application or are just looking to pick up a few new tips and tricks, you're sure to benefit from this free video software tutorial from Lynda. For more information, including detailed, step-by-step instructions, take a look.
How To: Generate a visual report in Microsoft Project 2010
In this clip, you'll learn how to visual data with charts and graphs in MS Project 2010. Whether you're new to Microsoft's popular project management application or are just looking to better acquaint yourself with the Project 2010 workflow, you're sure to benefit from this free video software tutorial from Lynda. For more information, including detailed, step-by-step instructions, take a look.
How To: Create a material resource in Microsoft Project 2010
In this clip, you'll learn how to create a new material resource when using MS Project 2010. Whether you're new to Microsoft's popular project management application or are just looking to better acquaint yourself with the Project 2010 workflow, you're sure to benefit from this free video software tutorial from Lynda. For more information, including detailed, step-by-step instructions, take a look.
How To: Link tasks within a Microsoft Project 2010 project
In this clip, you'll learn how to link two or more tasks in MS Project 2010. Whether you're new to Microsoft's popular project management application or are just looking to better acquaint yourself with the Project 2010 workflow, you're sure to benefit from this free video software tutorial from Lynda. For more information, including detailed, step-by-step instructions, take a look.
How To: Create a new milestone in Microsoft Project 2010
In this clip, you'll learn how add a new milestone when working in MS Project 2010. Whether you're new to Microsoft's popular project management application or are just looking to better acquaint yourself with the Project 2010 workflow, you're sure to benefit from this free video software tutorial from Lynda. For more information, including detailed, step-by-step instructions, take a look.
How To: Create a new task in Microsoft Project 2010
In this clip, you'll learn how to create a new task when using MS Project 2010. Whether you're new to Microsoft's popular project management application or are just looking to better acquaint yourself with the Project 2010 workflow, you're sure to benefit from this free video software tutorial from Lynda. For more information, including detailed, step-by-step instructions, take a look.
How To: Insert a screen clip in Microsoft Word 2010
In this quick clip, you'll learn how to insert screen clips when using MS Word 2010. Whether you're new to Microsoft's popular word processing application or a seasoned professional merely looking to pick up a few new tips and tricks, you're sure to benefit from this video tutorial. For complete instructions, take a look.
How To: Create a simple letter with the Mail Merge in Microsoft Word 2010
In this quick clip, you'll learn how to go about creating a basic letter for Mail Merge within MS Word 2010. Whether you're new to Microsoft's popular word processing application or a seasoned professional merely looking to pick up a few new tips and tricks, you're sure to benefit from this video tutorial. For complete instructions, take a look.
How To: Create envelopes with the Mail Merge tool in Microsoft Word 2010
In this quick clip, you'll learn how to create envelopes with the Mail Merge tool within MS Word 2010. Whether you're new to Microsoft's popular word processing application or a seasoned professional merely looking to pick up a few new tips and tricks, you're sure to benefit from this video tutorial. For complete instructions, take a look.
How To: Add address blocks & merge fields when using the Mail Merge tool in Word 2010
In this quick clip, you'll learn how to insert address blocks and merge fields when using Mail Merge within Microsoft Office Word 2010. Whether you're new to Microsoft's popular word processing application or a seasoned professional merely looking to pick up a few new tips and tricks, you're sure to benefit from this video tutorial. For complete instructions, take a look.
How To: Create a simple letter for Mail Merge in Microsoft Word 2007
In this quick clip, you'll learn how to go about creating a basic letter for Mail Merge within MS Word 2007. Whether you're new to Microsoft's popular word processing application or a seasoned professional merely looking to pick up a few new tips and tricks, you're sure to benefit from this video tutorial. For complete instructions, take a look.
How To: Create personalized email messages with the Mail Merge tool in MS Word 2007
Whether you're new to Microsoft's popular word processing application or a seasoned professional merely looking to pick up a few new tips and tricks, you're sure to benefit from this video tutorial. For complete instructions, and to get started creating your own personalized email messages in Word 2007, take a look.
How To: Create a new data source when using the Mail Merge tool in Microsoft Word 2007
In this clip, you'll learn how to add a new data source when using the Mail Merge tool within MS Word 2007. Whether you're new to Microsoft's popular word processing application or a seasoned professional merely looking to pick up a few new tips and tricks, you're sure to benefit from this video tutorial. For complete instructions, and to get started creating new data sources yourself, take a look.
How To: Use date and time functions in Microsoft Access 2007 queries
Looking for a quick guide on how to utilize date & time functions in your Access queries? You're in luck. Whether you're new to Microsoft's popular data management application or a seasoned MS Office professional just looking to better acquaint yourself with the Access 2007 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.