Hot Microsoft Office How-Tos
How To: Use predefined workflows in Microsoft Office: Mac 2008
If you use Office 2008 for Mac and all its applications (Word, PowerPoint, Entourage, Excel), than you need to know about the predefined workflows available using the Script menu that uses Automator to help perform mind-numbing tasks. The Microsoft Office for Mac team shows you just how to save time by using predefined workflows in this how-to video.
How To: Create notebook layouts in Microsoft Word: Mac 2008
Are you a vigorous notetaker? But are your notes disorganized and cluttered? Drop the paper and pen and pick up Word 2008 for Mac. Word contains a new feature that allows you to take notes, not to mention add audio notes and video notes. The Microsoft Office for Mac team shows you just how to create a text and audio notebook in this how-to video.
How To: Wrap text around pictures in Microsoft Word: Mac 2008
Add pictures always seems to mess up your document— but not anymore. In Word 2008 for Mac, adding photos doesn't have to be stressful. Words and pictures can coexist beautifully now. The Microsoft Office for Mac team shows you just how to make text wrap around pictures in this how-to video. They will look and fit better, and your words can be friends now with your added images.
How To: Create headers & footers in Microsoft Word: Mac 2008
Did you know that headers and footers are a great way to make your documents easier to read? Not to mention more professional— and if you have Word 2008 for Mac, creating those headers and footers is a cinch. The Microsoft Office for Mac team shows you just how to create headers and footers for documents in this how-to video.
Start using Microsoft Word: Mac 2008
Whether you've used Word before, on Windows or a Mac, the Word 2008 for Mac program has tons of new and yet undiscovered features (undiscovered by you!) that you still need to learn. So, if you're a beginner Word user or a seasoned pro, you still could learn a thing or two with this overview. The Microsoft Office for Mac team shows you how to get started in this how-to video.
How To: Use new features in Microsoft Word: Mac 2008
Word 2008 for Mac is jam-packed with tons of cool and useful features and tools that you can use to make a great looking document. Starting with the pre-made templates is the best way to go, and from there, customize it the best you can, anyway you can. The Microsoft Office for Mac team shows you all the great features in this how-to video.
How To: Use business card examples in Microsoft Word: Mac 2008
Need to make a homemade business card for you new company. Maybe you're about to take freelancing to the next level, a more professional level. Well, Word 2008 for Mac allows you to make your very own, personal business cards, and they give you tons of pre-formatted templates to choose from. You just have to supply the ink and paper. The Microsoft Office for Mac team shows you just how to find and use business card templates in this how-to video.
How To: Add document elements in Microsoft Word: Mac 2008
There's a lot you can do in Word 2008 for Mac, and with all of the possibilities, it can be hard to figure out what you can and can't do. Well, you can add cover pages. You can add headers. And you can add bibliographies easy. The Microsoft Office for Mac team shows you just how to add cover pages, headers, and other document elements in this how-to video.
How To: Use tables in documents on Microsoft Word: Mac 2008
Creating tables inside Microsoft Word has always been a chore— but not anymore! With Word 2008 for Mac, you can easily create tables of all your information. And if you're not sure of the best way to select, resize, and move those tables, you'll know soon enough. The Microsoft Office for Mac team shows you just how to work with tables with these Word table tips in this how-to video.
How To: Design top-notch brochures in Microsoft Word: Mac 2008
Sure, not everyone will want to create brochures, but for some of us, it's the best way to get around paying a design firm— making them yourself in Word 2008 for Mac. The tools and templates inside Word 2008 make it easy to create visually stunning brochures for any occasion. The Microsoft Office for Mac team shows you just how to design a professional brochure in this how-to video.
How To: Use Visual Basic macros in Microsoft Excel: Mac 2008
Oh, no! Visual Basic macros are no longer supported in Excel 2008 for Mac, which might make things a little difficult for you if you're used them a lot in the past, or if somebody else gives you spreadsheets using them. The Microsoft Office for Mac team shows you just how to deal with Visual Basic macros in this how-to video.
How To: Explore bigger grids in Microsoft Excel: Mac 2008
Have you always thought of Excel's grid system as kind of limited? Too small for what you need? Well, now in Excel 2008 for Mac, its grid might be too big for its own good! It's huge with plenty of room for all your data. The Microsoft Office for Mac team shows you just how to explore the bigger grid in this how-to video.
How To: Budget w/ ledger sheets in Microsoft Excel: Mac 2008
Don't want to shell out the big bucks for some fancy, expensive budgeting software? Well, if you have Excel 2008 for Mac installed, you can manage your budget right there. Personal financing doesn't get easier than this— even business finances are easy to keep track of. The Microsoft Office for Mac team shows you just how to manage your finances with pre-formatted Ledger Sheets in this how-to video.
Start using Microsoft Excel: Mac 2008
Great news! — Excel isn't just for Windows anymore. Okay, so it's been available on the Mac for awhile now, but if you haven't used it yet, why not start now? Getting started with Excel 2008 for Mac is easy, and this video overview will show beginners or even the most seasoned professional spreadsheet worker a thing or two. The Microsoft Office for Mac team shows you just how to get started in this how-to video.
How To: Use the new features in Microsoft Excel: Mac 2008
Excel is great, and if you're a Mac user, Excel 2008 for Mac has a lot of new and useful great features you can use to maximize efficiency in your spreadsheets. Excel doesn't have to be the boss anymore, you can! The Microsoft Office for Mac team shows you all the great features in this how-to video.
How To: Use worksheets in Microsoft Excel: Mac 2008
Data can be troubling, especially if there's a ton of it plaguing your Excel worksheet. But Excel 2008 for Mac makes life a little easier and less confusing thanks to a few worksheet tips and features you can utilize to work with your data in worksheet cells. The Microsoft Office for Mac team shows you just how to work with worksheets in this how-to video.
How To: Use the Formula Builder in Microsoft Excel: Mac 2008
Excel 2008 for Mac makes it easy to create formulas for cells. You could always do it before, but now with the new Formula Builder feature, building formulas just got one step closer to simple. The Microsoft Office for Mac team shows you just how to build formulas by using the new Formula Builder in this how-to video.
How To: Add spreadsheet snippets in Microsoft Excel: Mac 2008
Not every client or coworker likes to mine through a spreadsheet to find all the important data. So, with Excel 2008 for Mac, you can easily share that data without sending the entire Excel spreadsheet. To do this, all you need to do is to use the "copy as picture" option. The Microsoft Office for Mac team shows you just how to insert a spreadsheet snippet in this how-to video.
How To: Use Table Styles in Microsoft PowerPoint: Mac 2008
Sure, you can make boring tables inside PowerPoint 2008 for Mac, but who wants to add that dull element to their slideshow presentations? Nobody! Tables can be more than just numbers, they can be eye-catching and visually striking. The Microsoft Office for Mac team shows you just how to create great-looking tables by using Tables Styles in this how-to video.
How To: Share slides in iPhoto albums in PowerPoint: Mac 2008
Not everybody in this digital age has PowerPoint, whether on Windows or a Mac. But at least Mac users can find other ways to share their PowerPoint presentations with other Mac users via iPhoto. PowerPoint 2008 for Mac makes it easy to share your slideshows. The Microsoft Office for Mac team shows you just how to share PowerPoint slides as an iPhoto album in this how-to video.
How To: Start using Microsoft PowerPoint: Mac 2008
You could be a PowerPoint power user or you could be a PowerPoint newbie— you've never created a slideshow in your life! Either way, this will show all of you brand new to PowerPoint 2008 for Mac (and all of your slideshow gurus) the basics of PowerPoint. The Microsoft Office for Mac team shows you just how to get started and get up to speed fast in this how-to video.
How To: Use the new features in Microsoft PowerPoint: Mac 2008
If you've used PowerPoint in the past, you're probably used to version available on Windows, but you can do even more in PowerPoint 2008 for Mac. There are tons of new features that slideshow builders will love, but sometimes you can never know about them unless someone tells you about them. The Microsoft Office for Mac team shows you all the great features in this how-to video.
How To: Create striking bulleted lists in PowerPoint: Mac 2008
PowerPoint 2008 for Mac can help you turn boring old bulleted lists into something nobody would forget. With SmartArt graphics in PowerPoint you can now make your bullet lists pop using pre-formatted charts, graphs, and more. The Microsoft Office for Mac team shows you just how to make a bulleted list more visual in this how-to video.
How To: Convert text to SmartArt in PowerPoint: Mac 2008
Dull and drab bulleted lists are no longer necessary with the help of PowerPoint 2008 for Mac. When you make a bullet list in PowerPoint, you can now transform those boring text charts with actual visual charts and graphs and more. The Microsoft Office for Mac team shows you just how to convert text to a SmartArt graphic in this how-to video.
How To: Use My Day in Microsoft Entourage: Mac 2008
There's a lot of great features in Entourage 2008 for Mac, and one of the new features in "My Day". It's a small integrated app that helps you stay organized and helps you manage all of your upcoming events and tasks. The Microsoft Office for Mac team shows you just how to manage tasks and events by using My Day in this how-to video.
How To: Manage schedules using calendar in Entourage: Mac 2008
Managing your busy schedule just got easier in Entourage 2008 for Mac. Using the powerful Entourage Calendar feature lets you organize your time wisely. The Microsoft Office for Mac team shows you just how to organize your schedule with the calendar in this how-to video.
How To: Calculate hours worked in days 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 598th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to calculate hours worked given an in time, an out time and an in and out time for the lunch break. Learn about how time in Excel is the proportion of one 24 hour day.
How To: Calculate sales using a compact 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, the 602nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a compact array formula that can total sales with 1 criteria when the database does not have a price or total sales column. See how SUMIF can be used to lookup values and simulate a missing column from a database.
How To: Round only the total column with SUM & ROUND 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 599th installment in their series of digital spreadsheet magic tricks, you'll learn how to ROUND only the total column using a SUM & ROUND function array formula.
How To: Convert hours to days & days to hours with Excel's MOD
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 600th installment in their series of digital spreadsheet magic tricks, you'll learn how to convert between days and hours using Excel's MOD & INT functions.
How To: Calculate bonuses based on years worked 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 601st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP & IF functions to make bonus calculations based on the number of years worked.
How To: Use statistical functions in Excel (STDEV/MODE/MEDIAN)
If you use Microsoft Office Excel on anything resembling a regular basis, odds are you work with numbers. Put those numbers to work with this free MS Excel video tutorial, which will teach you how to use a number of Excel's basic statistical functions (e.g., STDEV, AVERAGE, MEDIAN, MODE, RANK, ROUND, LARGE & SMALL).
How To: Embed YouTube videos in PowerPoint 2003
This video uses screenshots to show you step-by-step how to add a YouTube video to your Microsoft Office 2003 Powerpoint presentation. It's a great way to help support an argument that you may be trying to make and keeps people's attention. It's easy to do and will help you in whatever you may be doing. Enjoy!
How To: Easily embed a video in PowerPoint
Using videos in presentations, can easily help boost your argument, if they come from a reputable source and relate to the topic. So using them can be a pretty good idea, but how can you do it? Well, this video uses screenshots to show you step-by-step how to easily embed a Youtube video into a Microsoft Office Powerpoint presentation.
How To: Do mathematical operations with paste special 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 591st installment in their series of digital spreadsheet magic tricks, you'll learn how to add $600 to a lot of numbers all at once by using paste special operations add.
How To: Allow only Monday dates in a 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 593rd installment in their series of digital spreadsheet magic tricks, you'll learn how to add data validation to allow only Monday dates in a cell using the custom option and the WEEKDAY function.
How To: Count with four 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 596th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SERACH, ISNUMBER and SUMPRODUCT functions to count with 4 criteria including an all criteria option.
How To: Extract the word that occurs most frequently 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 592nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract word that occurs most frequently from a column of survey results that contain customer preferences for a product using the INDEX, MATCH, MAX and COUNTIF functions. This is a way to get the MODE for data that is made up ...
How To: Calculate age in years with DATEDIF & TODAY 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 594th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate age in years using the TODAY and DATEDIF functions.
How To: Fix a DGET #NUM! error 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 595th installment in their series of digital spreadsheet magic tricks, you'll learn how to resolve a problem that the DGET function and advanced filter have with criteria and duplicates. See how to switch to either the VLOOKUP function or not criteria for advanced filter.