Microsoft Office Features
How To: Use SharePoint 2010's social computing functionalities
Learn how to take advantage of Microsoft SharePoint 2010's new social computing tools. Whether you're new to Microsoft's popular content management system (CMS) or a seasoned MS Office professional just looking to better acquaint yourself with the SharePoint 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started taking advantage of SharePoint's social computing features yourself, watch this free video guide.
How To: Use and work with tables in Microsoft Excel 2007
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 15th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with tables in Excel 2007. Specifically, you'll see the following:
How To: Creat charts in Excel
Charts can be used to visually present your data. In this tutorial we will take a look at how to create basic column and pie charts using MS Excel. Learn it to create a sales chart for your boss! Creat charts in Excel.
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: Share your Outlook distribution lists
Let's talk about how to share your Outlook Distribution Lists with others. This is so simple it's not even funny. If you have distribution lists and you want to send them to others, simply include them as attachments in your email to them. Once the recipient gets your email they'll drag and drop the attachment to their contact folder in Outlook.
How To: Copy an Excel formula through a range via the keyboard
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 630th installment in their series of digital spreadsheet magic tricks, you'll learn how to copy formula through a huge range using keyboard shortcuts.
How To: Extract the three largest values from a list in Excel
New to 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 Excel tutorial from ExcelIsFun, the 162nd installment in their series of digital spreadsheet magic tricks, you'll learn how to deal with duplicates with the MATCH function by using the COUNTIF function. This is accomplished with recourse to Excel's IF, OR, LARGE, ISERROR, MATCH, INDEX and COUNTIF functions.
How To: Add video in MS Word
This demonstrates how to add video in MS Word. This is a great tutorial for beginners.
How To: Use the FIND & REPLACE functions 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 519th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the FIND and REPLACE functions in Microsoft Excel.
How To: Isolate unique records with Excel's OR function
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 85th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to isolate unique records with the OR function.
How To: Add "if" function in Excel
The 'if' function in Microsoft Excel is perfect for projects such as doing grades for a pass/fail course. Find out how to add it to your spreadsheet.
How To: Speed up conditional formulae with VLOOKUP in MS Excel
hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 35th installment in his "Highline Excel Class" series of free video Excel lessons, you'll see an efficient IF function formula get beat by an even more efficient VLOOKUP function formula.
How To: Use Excel chart basics
In this Excel basics video, the instructor talks about the basics of charts. There is an enormous difference in how you make charts between Microsoft Excel 2003 and 2007. In both the versions, to make charts the first thing you do is highlight the data cells in your workspace. Now use the toolbar and click on the charts button there. Now Excel automatically generates the charts based on the data and the column and row names. But there are various changes between the charts produced in the dif...
How To: Work with dropdown lists in Microsoft Office Excel
This how to video shows you how to use drop down lists in Microsoft Excel. This will be useful for stores and avoiding people ordering items that are not available. First, type the items in a column. Select them and then click in the name box. Type the name of the list. Note that it must be one word. Now, go back to the order sheet. Select the cell where you want the list to be placed. Go to data and select validation. On the settings tab, choose list and type in = and list name. You can pres...
How To: Create simple math formulas in Microsoft Excel
As you might guess, one of the domains in which Microsoft Excel really excels is business 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 2nd installment in his "Excel Business Math" series of free video lessons, you'll learn how to create math formulas in MS Excel using addition, subtraction, multiplication, division, exponents, and parentheses. See how 2+2*2 is not equal ...
How To: Create and apply PowerPoint templates
This video demonstrates how to create and apply PowerPoint templates. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to create and apply PowerPoint templates, For Dummies.
How To: Hide information in Microsoft Excel
Sometimes you don't want people to see what you've entered into Excel. Use this tutorial video to learn how to hide that information in Excel to keep it safe.
How To: Make handouts to accompany a PowerPoint presentation
This video demonstrates how to make handouts to accompany a PowerPoint presentation. From the people who brought you the Dummies instructional book series, brings you the same non-intimidating guides in video form. Watch this video tutorial to learn how to make handouts to accompany a PowerPoint presentation, For Dummies.
How To: Create a pivot table in Excel
Pivot tables are great tools for comparing data, especially when dealing with long lists. See how to create pivot tables in Excel.
How To: Use templates in MS Word
Templates are an excellent way to save time and increase your productivity when you're working in Microsoft Word. There are a number of templates already in the program from headings to endings of letters. You can even create your own templates to customize the program for yourself. This video tutorial will show you how to use templates in MS Word.
How To: Use advanced features in Powerpoint
Some tips for intermediate to advanced Powerpoint users including adding sounds to presentations and creating custom animations.
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: Add your HTML military signature to Outlook Express
This is how you add your html signature to Outlook Express.
How To: Add a library to a Record Center with SharePoint 2007
Check out this tutorial and see how to add a library to an existing Record Center site, apply policies to the library, and configure the Records Center site so that submitted documents are routed to the right library.
How To: Create a defined name for a dynamic 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, the 676th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Defined Name formula for a dynamic range (columns can vary) using the INDEX and MATCH functions. This formula works when there are no column headers (field names).
How To: Add your HTML military signature to Microsoft Outlook
This is how you add your html military signature to Microsoft Outlook.
How To: Use Microsoft Excel macros securely
hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 52.5th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn about macro security. For more information on how to use macros safely, watch this free video guide.
How To: Fix poorly set up 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 507th installment in their series of digital spreadsheet magic tricks, you'll learn how to take badly setup data (not in database/table format) and summarize it by date and shipping name into table format report.
How To: Count data without an upper limit 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 198th installment in their series of digital spreadsheet magic tricks, you'll learn three different methods for counting quantitative data in categories that include a lower limit but not an upper limit.
How To: Return only even row data in an MS Excel spreadsheet
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 622nd installment in their series of digital spreadsheet magic tricks, you'll learn how to to write an array formula using the SUMPRODUCT, MOD, IF, ROWS, INDEX, SMALL, and ROW functions that will retreive only even row values.
How To: Add every other number in a range 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 377th installment in their series of digital spreadsheet magic tricks, you'll learn how to add every other number with the SUMPRODUCT, MOD and ROW functions in one formula.
How To: Count unique values greater than a hurdle in MS Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 56th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use an array formula and the COUNTIF function to count unique records that are greater than a given hurdle (in this case, $30). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
How To: Apply formatting to Excel cells that meet a condition
See how to apply condition formatting when working in Microsoft Excel 2007. Whether you're new to Microsoft's popular word processing application application or a seasoned MS Office professional just looking to better acquaint yourself with the Word 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the useful formatting feature in your own Excel documents, watch this free video guide.
How To: Remove table rows containing blanks in Microsoft Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 88th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to remove rows of a table where the row has a blank in column A using a macro.
How To: Create a Best man's speech in PowerPoint
Everyone thinks the bride and groom are having to do all the work day when it's their wedding. No one spares a thought for the poor sap who has to take on the role of Best man. Not only are there some fairly hefty ‘responsibilities' to adhere to, you have to get up in front of everyone and deliver the most gut-wrenching speech of all. Get it right, you're a hero. Get it wrong, and you've ruined the ‘special' day she's been dreaming about since she was an 8-year-old little princess. So check o...
How To: Create reusable template parts on InfoPath 2007
Check out this tutorial to see how to create a new template part in Microsoft Office InfoPath, test it, make corrections in it, and install it on your computer. After that, you can use it over and over and share it with other form designers in your company.
How To: Determine whether a given item in a list 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 119th installment in their series of digital spreadsheet magic tricks, you'll learn how to determine if a particular item is in a list of items using two formulas: a ISNUMBER & MATCH function formula & a COUNTIF function formula.
How To: Generate a series of dates in Excel with TODAY & ROW
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 141st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to generate a series of dates with the TODAY and ROW function that will always show today plus the next 10 days.
How To: Name cell ranges and use names in formulas in MS Excel
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 3rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to name a range of cells; how to use names in formulas;
How To: Sort a range in Excel
Using Excel, sorting large or small pools of data has never been easier. In this Excel tutorial, learn how to sort a range of data in Excel and what steps to do so, from start to finish. Sort totals, percentages, or decimals in a range in descending or acsending order with help from this video.