Everything Else
How To: Extract numbers from a text string with Excel's LEFT, SEARCH & TRIM functions
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 706th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use the LEFT, SEARCH and TRIM function to eaxtract numbers from a text string that can then be used in a calculating formula.
How To: Create a data validation drop-down list from a table with duplicates 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 608th installment in their series of digital spreadsheet magic tricks, you'll learn how to to create an expanding data validation drop-down list from table with duplicates using a number of different tricks.
How To: Extract all the letters from a text string 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 699th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract all the letters from a text string with a VLOOKUP function in Excel 2010.
How To: Return every other cell in a row 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 700th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will retrieve every other cell in a row as you copy the formula across the columns.
How To: Look up and return two values to one cell 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 702nd installment in their series of digital spreadsheet magic tricks, you'll learn how to look up two values at once and return then both to one cell using 2 VLOOKUP functions and concatenation (Ampersand &) or two cells using a single VLOOKUP and the COLUMNS function.
How To: Navigate and use the Microsoft PowerPoint 2010 user interface
Need some help figuring out how to use the PowerPoint 2010 UI? Whether you're new to Microsoft's popular presentation application or a seasoned MS Office professional just looking to better acquaint yourself with the PowerPoint 2010 workflow, you're sure to be well served by this video tutorial. For more information, watch this helpful video guide.
How To: Force your Microsoft Outlook 2010 inbox to automatically clean itself
In this clip, you'll learn how to enable and use the automatic tidying feature in MS Outlook 2010. Whether you're new to Microsoft's popular email and scheduling application or a seasoned MS Office professional just looking to better acquaint yourself with the Outlook 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started organizing your own inbox, watch this free video guide.
How To: Create and use multiple calendars in Microsoft Outlook 2010
In this clip, you'll learn how to create and work with multiple calendars when using Outlook 2010. Whether you're new to Microsoft's popular email and scheduling application or a seasoned MS Office professional just looking to better acquaint yourself with the Outlook 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started creating and juggling separate calendars yourself, watch this free video guide.
How To: Create and use automatic email signatures in Microsoft Outlook 2010
Learn how to create and apply custom email signatures to emails composed in Microsoft Outlook 2010. Whether you're new to Microsoft's popular email and scheduling application or a seasoned MS Office professional just looking to better acquaint yourself with the Outlook 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started appending a standard signature to your own emails, watch this free video guide.
How To: Add a folder to your Favorites list in Microsoft Outlook 2007
Want to add a new folder to your Favorites folder when using MS Outlook 2007? Whether you're new to Microsoft's popular email and scheduling application or a seasoned MS Office professional just looking to better acquaint yourself with the Outlook 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started organizing your own inbox, watch this free video guide.
How To: Arrange email messages by date or sender in Microsoft Outlook 2007
Sort your emails by either date or sender within MS Outlook 2007. This clip will teach you how. Whether you're new to Microsoft's popular email and scheduling application or a seasoned MS Office professional just looking to better acquaint yourself with the Outlook 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started organizing your own inbox, watch this free video guide.
How To: Use the Quick Steps feature in Microsoft Outlook 2010
This clip will teach you how to use Outlook 2010's built-in Quick Steps tool to manage your inbox. Whether you're new to Microsoft's popular email and scheduling application or a seasoned MS Office professional just looking to better acquaint yourself with the Outlook 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started organizing your own inbox, watch this free video guide.
How To: View and sort email messages by date or sender in Microsoft Outlook 2010
Need some help figuring out how to sort your emails by date or sender in Outlook 2010? This video will teach you everything you'll need to know. Whether you're new to Microsoft's popular email and scheduling application or a seasoned MS Office professional just looking to better acquaint yourself with the Outlook 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started organizing your own inbox, watch this free video guide.
How To: View email messages by conversation in Microsoft Outlook 2010
Looking for an easy way to consolidate and view your email messages conversations into easy-to-ready threads? This clip will teach you everything you'll need to know. Whether you're new to Microsoft's popular email and scheduling application or a seasoned MS Office professional just looking to better acquaint yourself with the Outlook 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started organizing your own inbox, watch this free video g...
How To: Create a bibliography with MS Word 2007
In order to create a bibliography with Microsoft Word 2007, you will need to access the reference tool bar, at the top of your screen. Click on references. Open your document. Put your cursor where you want to make the entry. Then, click on Manage sources. Fill in the pop-up that comes up. This will ask you for all of the information needed for the type of citation you are using. Click OK.
How To: Tell if you are logged in as an Admin or User in Windows 7
Admin accounts are given special privileges to change the system (like installing programs) that user accounts are not. This tutorial shows you a quick way to check using Windows 7's calendar, and also how to go through the Control Panel to find out if you're an Admin or general User on your computer.
How To: Use the Xtracharts control in Winforms to export a chart to PDF
Xtracharts, a control for Winforms, allows the user to easily export charts made using the program into a PDF, HTML or MHT, Excel spreadsheet or standard image. This tutorial shows the Winforms user how to properly code and then export the chart.
How To: Use PrimoPDF to convert any Microsoft file to a PDF file
PrimoPDF is a free program that will allow you to convert any document (Microsoft Word, Excel, PowerPoint and more) into a usable PDF file. This tutorial walks you through downloading, installing and using the PrimoPDF program to convert your files to PDFs. PrimoPDF even allows you to lock your files or add a password.
How To: Remove empty space when converting an Excel file to a PDF document
When converting an Excel file to an Adobe PDF document, you might sometimes accidentally export several pages of empty space. This tutorial briefly explains how to use the Acrobat program to convert your spreadsheet or worksheet to PDF format and avoid the blank gaps.
How To: Use your computer's Print Manager to convert files to PDF
It is possible to convert your Excel spreadsheets into a PDF file by using your PC's Print Manager and Save As functions. This video shows you a step by step to create a password-protected PDF version of your Excel file.
How To: Convert HTML data to either a PDF or Excel file using DeskPDF
The DeskPDF programs, published by DocuDesk, offer several methods for converting files in one format to an entirely different format - such as turning an HTML table on a web page into an Excel file or turning an RSS feed into an ebook file.
How To: Convert an Excel file with multiple worksheets to a single PDF
Converting an Excel spreadsheet to a single PDF file is quite easy, even if there are multiple worksheets in your document. This tutorial even demonstrates a common Excel error and how adjust your program's dpi settings to avoid double spooling.
How To: Create batch PDFs of Word, Excel or PowerPoint files
The new version of Microsoft Office has a feature which allows you to batch create PDFs. You can easily convert whole folders or specfic selections of Word, Excel or PowerPoint files into PDF files. You also have the option of converting the files into individual PDFs, or turn them into one large file.
How To: Upload a PDF or MS Office file to your WordPress blog and create a link
You can add PDFs, Microsoft Word, Excel or PowerPoint documents to your WordPress blog using version 2.7 of the WordPress software. This tutorial walks you through the steps of uploading your file, creating a link in your post and also pointing out the difference between the two WordPress "Media Libraries."
How To: Sync your online calendar with Outlook 2007
Friends tired of you forgetting plans? Missing important business appointments? Use your personal computer to improve your organization! Many software programs can help. This video shows you how to sync a compatible online calendar with Outlook 2007, and never miss another appointment again!
How To: Sync your Gmail contacts and e-mails to your Outlook account
This in-depth video allows everyone from a computer pro to your grandmother, to sync your Gmail contacts and e-mails with your Outlook! Full, detailed instructions will guide you every step of the way! Keep everything in one program, no more tab and window switching required!
How To: Convert a Microsoft Access 2003 database for use in Access 2010
Learn how to open up your old Access 2003 databases in MS 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 Backstage view in your own Access projects, watch this free video guide.
How To: Repair broken link problems in Microsoft Outlook or Outlook Express
Need help figuring out how to fix a broken hyperlink problem in MS Outlook or Outlook Express? This clip will teach you what you'll need to know. Happily, fixing this problem is easy. So easy, in fact, that this home-computing how-to from the folks at Britec can present a complete overview of the process in just over two minutes. For complete details, including step-by-step instructions, watch this video guide.
How To: Freeze titles and create split screens in Microsoft Excel 2010
In this clip, you'll learn how to quickl create frozen titles and split screens or splitscreens within MS Excel 2010. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, watch this free video guide.
How To: Make sure entries are unique in Microsoft Excel 2010
Looking for a way to ensure your entries are unique in Microsoft Excel 2010? This clip will teach you what you'll need to know. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, watch this free video guide.
How To: Create and use custom lists for rapid entry in Microsoft Excel 2010
Learn how to create lists for rapid entry when working in Microsoft Excel 2010. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, watch this free video guide.
How To: Enter data into nonadjacent cells in Microsoft Excel 2010
Looking for a guide on how to enter data into nonadjacent cells in MS Excel 2010? This clip will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned professional looking to become better acquainted with the features and functions of Excel 2010, you're sure to benefit from this free video software lesson. Take a look.
How To: Convert a formula to a value in Microsoft Excel 2010
Learn how to convert a formula to a value in a Microsoft Excel 2010 spreadsheet. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started converting formulas in your own MS Excel 2010 projects, watch this free video guide.
How To: Increment numbers in formulas 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 692nd installment in their series of digital spreadsheet magic tricks, you'll learn how to increment numbers in formulas to get 2,2,2,2,4,4,4,4 or 1,1,1,1,3,3,3,3 or 1,2,3,4,1,2,3,4 or 11,22,33,44 using the ROWS, INT, MOD and COLUMNS functions.
How To: Calculate how long it will take an investment to double 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 693rd installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate how long it will take to double your money using the NPER function and the rule of 72.
How To: Use the SUMIF function with an array 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 694th installment in their series of digital spreadsheet magic tricks, you'll learn how the SUMIF function (and COUNTIF, etc.) cannot accept arrays. If you need to sum by year from transactional data the SUMIF and YEAR functions cannot be used together. Instead we can use the SUMPRODUCT function.
How To: Allocate total costs across categories 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 697th installment in their series of digital spreadsheet magic tricks, you'll learn how to allocate $950 across 7 days including the extra penny with a single formula.
How To: Identify the first occurrence of a 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 697th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a column of 1s and 0s (ones and zeroes) where 1 indicates the first occurrence and 0 indicates any remaining duplicates.
How To: Extract month and year records from transactional data 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 697th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract month and year data from transactional records by filtering, array formula and non-array formula.
How To: Put a YouTube video into a PowerPoint presentation
This video tutorial is in the software category where you will learn how to put a YouTube video into a PowerPoint presentation. First you go to the YouTube video that you want to put in your presentation and copy the URL in the address box. Then you go to one of the file conversion websites like Media Converter, paste the URL in the box and click 'next'. Then select the type of file you want it to convert to, for example, mpg, and click 'next'. Once it is converted, download it. To embed it, ...