Hot Microsoft Office Posts
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 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.
How To: Use mathematical operators in queries in Microsoft Access 2007
In this clip, you'll learn how to employ mathematical operators when running queries in MS Access 2007. 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.
How To: Follow naming conventions and best practices when using queries in Access 2007
In this clip, you'll learn how to observe naming conventions when using queries in MS Access 2007. 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.
How To: Use conditional formatting for a student attendance report in Microsoft Excel
You can use conditional formatting in Microsoft Excel to create an easy attendance report for you classroom. This can also be applied to other similar types of reports. The report in this video includes the names of the students, the total possible days of attendance, the actual amount of days attended by each student, the percentage of attendance, and their rank in the class. Just follow along with the video to see how it's done.
How To: Use Microsoft Project 2010 with Sharepoint 2010
This video is about combining Microsoft Project 2010 and SharePoint 2010. This combination helps project teams to collaborate and share project information. Information can be displayed on a dashboard. We will also discuss various levels of project management such as starting the project, planning, tracking and reporting on the projects progress.
How To: Find the absolute value max of a set of integers 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 718th installment in their series of digital spreadsheet magic tricks, you'll learn how to find the Absolute Value Max of a set of integers (positive, zero and negative) using the MAX and ABS functions.
How To: Calculate hours worked while subtracting lunch hours in 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 718th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate hours worked while subtracting time spent at lunch.
How To: Compare a list of numbers where one group is entered as text in 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 719th installment in their series of digital spreadsheet magic tricks, you'll learn how to compare two list of numbers and see what happens when one list is numbers is aligned right and the other list is numbers as text.
How To: Display records that fall between two dates 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 720th installment in their series of digital spreadsheet magic tricks, you'll learn how to use filtering, the AND, TODAY and EDATE functions, and conditional formatting to show values between two dates.
How To: Add or remove colons from a list of times 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 721st installment in their series of digital spreadsheet magic tricks, you'll learn how to to go from a time of 0655 to 06:55 AM with the TEXT function.
How To: Share calendars in Microsoft Outlook 2010
Interested in sharing a calendar? With Outlook 2010, it's easy. 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 guide.
How To: Navigate and use the user interface in Microsoft Outlook 2010
Need some help figuring out how to use the new Outlook interface? 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 using the Outlook 2010 UI yourself, watch this free video guide.
How To: Extract inconsistent name & e-mail data from a one-column list 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 712th installment in their series of digital spreadsheet magic tricks, you'll learn how to take bad data set up in one column and make a proper table of data for a mail merge as well as how to extract name and e-mail data from a list in one column where records are entered inconsistently.
How To: Count the max number of successive items in a data column 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 713th installment in their series of digital spreadsheet magic tricks, you'll learn how to count the max number of items in succession in a column of data using the FREQUENCY, IF, MAX and ROW functions.
How To: Rank values based on a single criteria 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 707th installment in their series of digital spreadsheet magic tricks, you'll learn how to rank values based on one criteria using the SUMPRODUCT function.
How To: Filter and extract records with multiple criteria 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 703rd installment in their series of digital spreadsheet magic tricks, you'll learn how to filter with 6 criteria then extract records to a new location.
How To: Find dependent and precedent formulas by keyboard shortcut 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 705th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Ctrl + ] to find dependent or
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: 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.