Hot Microsoft Office Posts
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: 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: 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.
How To: Make PowerPoint animations
Thanks to How To Make Anything, learn how to make and do just about anything! In this episode, learn how to make things move around through the power of animation in Microsoft Powerpoint! Take your Powerpoint presentation to the next level with help from this video!
How To: Sort numbers with a 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 and Mr. Excel, the 12th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas that will take an unsorted list and sort smallest to biggest or biggest to smallest using the MAX, LARGE, SMALL, ROW and ROWS functions.
How To: Count with more than 1 criteria 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 and Mr. Excel, the 27th installment in their joint series of digital spreadsheet magic tricks, you'll see ten different methods counting with more than 1 criteria.
How To: Decrease values 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 and Mr. Excel, the 2nd installment in their joint series of digital spreadsheet magic tricks, you'll see two methods for subtracting 35% from a column of values.
How To: Look up a picture 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 and Mr. Excel, the 42nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to look up a picture in Excel. See a VBA solution and a formula Solution using the INDIRECT function and named ranges.
How To: Use the NETWORKINGDAYS.INT function in MS 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 and Mr. Excel, the 23rd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use the NETWORKINGDAYS.INT, RANK.AVE, PERCENTILE.EXC, CONFIDENCE.T, T.DIST, T.DIST.RT and T.DIST.2T functions in MS Excel.
How To: Use VBA code for conditional formatting 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 and Mr. Excel, the 22nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use VBA code for conditional formatting as well as how to do it using the OFFSET, MOD and ROWS functions.
How To: Summarize survey data with a pivot table 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 and Mr. Excel, the 20th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to summarize survey data with a pivot table (grouping & report filter), COUNTIFS function (4 criteria), SUMPRODUCTS formula, SUMPRODUCTS & TEXT functions and DCOUNT database function.
How To: Do reverse lookups with VBA code 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 and Mr. Excel, the 7th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to complete a reverse lookup (find value inside table and then retrieve column and row header). Mr. Excel uses Excel VBA code (macro) and ExcelIsFun uses a formula with the INDEX, IF, SMALL, MATCH, TEXT, CHAR and...
How To: Create horizontal subtotals for a data set 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 and Mr. Excel, the 5th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create horizontal subtotals for a data set using the IF, SUM and SUMIF functions. Also see conditional formatting for non-contiguous cell ranges using a TRUE/FALSE logical formula with the NOT symbols.
How To: Find a weighted average cost ending inventory value
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 43rd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to calculate weighted average cost ending inventory value from transactional records on 2 different sheets using the COUNTIF, SUMIF and SUMPRODUCT functions.
How To: Create random dates within a set range 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 and Mr. Excel, the 26th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create random dates between upper and lower dates using the 4 different formulas that use functions such as RANDBETWEEN, RAND, INT and DATE.
How To: Extract items not having a given text value 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 25th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to extract records from databases that do NOT contain a given text value.
How To: Control percentages with a scroll bar 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 and Mr. Excel, the 46th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create scroll bars that will control a percentage in a cell.
How To: Count times exceeding 5 minutes 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 and Mr. Excel, the 17th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create 5 formulas to count times greater than five minutes using Excel's COUNTIF and TIME functions.
How To: Create a frequency distribution 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 and Mr. Excel, the 15th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use a pivot table with grouping and a count function to create a frequency distribution.