Microsoft Office Features
How To: Make a PowerPoint presentation
In this video series, learn how to make Microsoft PowerPoint presentations. Our expert will show you how to use this handy piece of software to organize your data in a slideshow format, making for an easy viewing experience at any meeting. Topics covered include how to use the design template, how to change backgrounds, how to add text and animate it to come in when you’re ready to make your next point, how to add photos, how to do slide transitions, and many other helpful tips.
How To: Format dates & calculations in Excel
This is an Excel magic trick video in which the instructor shows how is time represented in Excel and how it is formatted before displaying it to us. He talks about the decimal representation of the time. He says that if O hour is mapped to the number zero and 24th hour of a day is mapped to number one then we can represent any time of the day in the format of a decimal number between zero and one. He shows the type of formatting that excel uses to convert the decimal number into a human read...
How To: Base one data validation list on another 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 75th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use name, the INDIRECT function and data validation drop-down lists to create DV lists based on DV lists.
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: Return many items for a single lookup 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, the 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to write a formula that will return multiple items when there are two criteria for the data extraction. Also see an INDEX and MATCH functions formula that uses the SUMPRODUCT, COUNTIFS, IF, ROWS, INDEX, MATCH, SMALL, IF, and ROW fu...
How To: Extract records from a table to a column 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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from standard table and put a record in a column using the VLOOKUP, IF and ROWS functions.
How To: Use Microsoft Excel 2007 as a complete beginner
If you're a novice looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! This free video MS Excel lesson, the very installment in said tutorial series, covers the following topics:
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: Open a MS Word 07 file by double clicking in Ubuntu
In this video tutorial, viewers learn how to open a Microsoft Word 2007 file by double-clicking it on Ubuntu 9.10. Begin by right-clicking on the file and go to Properties. Click on the Open With tab and select Use a custom command. Now type in [playonlinux --run "Microsoft Office Word 2007" and click Add. Select the custom command from the list and close the window. This video will benefit those viewers who use a Linux computer, and would like to learn how to open Microsoft Word 2007 files b...
How To: Use the Mid and Find functions in Excel
Learn how to use text functions like mid and find to extract characters from a larger text string within a cell in Excel.
How To: Find a mean for data set while excluding 0s 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 13th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas that will calculate the AVERAGE excluding zeros (0) in the original data set.
How To: Add audio into PowerPoint
This video tutorial from hottyqingwa shows how to add audio files into PowerPoint projects.In this tutorial was used Power Point 2007 Professional edition.To start, create a folder with a random name. Then drag your audio file and power point project into this folder.Open PowerPoint project, click Insert from top menu, then select Sound-Sound from file. Double click audio file in your folder.Dialogue box will appear asking if you want the sound to start automatically or when clicked.After, cl...
How To: Use simple formulae in Microsoft Office Excel
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about simple addition, subtraction, multiplication and division in Excel. For more on using simple formulae, watch this video how-to.
How To: Use Microsoft Excel's built-in VLOOKUP function
Looking for a primer on how to create and work with lookup queries in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the very first installment in his series of Excel lookup formula series, you'll learn how to use the VLOOKUP function to deliver a value to cell.
How To: Use the Backstage view and File tab in MS Excel 2010
Learn how to use the Backstage view option 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, and to get started using the Backstage view and File tab in your own Excel projects, watch this free video guide.
How To: Use IF function formulas in MIcrosoft Excel
If you're looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! In this free video MS Excel lesson, the 22nd installment in said basics series, you'll learn how to write and use basic IF function formulas in Microsoft Excel.
How To: Record absolute and relative macros in MS 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've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how (and when) to record absolute and relative macros in MS Excel 2007.
How To: Convert integers to dates with Excel's DATE function
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 141st installment in their series of digital spreadsheet magic tricks, you'll learn how to take the number 1 (for day one of the month) and use the DATE function to convert it to a serial number formatted as a date.
How To: Evaluate a random value against criteria 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 28th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the INDEX, RANDBETWEEN, COUNTA, IF, AND, & VLOOKUP functions together to select a random employee from a list, determine if they have meet the given criteria and then conditionally format the relevant cells according to the result. Learn to love digi...
How To: Adjust font settings within Microsoft Office Word 2010
Before you can work in Word 2010, you'll need to learn how to work with it. See how to change and style fonts within the Microsoft Word 2010 user interface with this free video software tutorial. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2010 a little better, you're sure to find much of value in this video lesson. For more and better information, and to get started using custom font settings in Word 2010 yourself, take a look.
How To: Remove spaces from a Microsoft Excel formula
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 619th installment in their series of digital spreadsheet magic tricks, you'll see how spaces in cells cause trouble in formulas and learn how to use the REPLACE, COUNTIF, CLEAN & TRIM functions to solve space-related formula problems.
How To: Create site collections in Microsoft SharePoint 2010
Interested in creating a site collection within Microsoft SharePoint 2010? This guide will show you how it's done. 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, including detailed, step-by-step instructions, watch this free video guide.
How To: Disable or Remove Recent Document List in MS Word or Excel
This video will guide you how to disable or delete recent document list in MS Word 2007. The same procedure is also applicable for MS excel also. Follow the steps and employ the technique in your PC.
How To: Protect Word Doc with Password
If you want to protect your word doc from other, you can give it a password. When anybody wants to open, it will ask a password. This way your valuable document will be secured from unauthorized access.
How To: Do 2 pivot tables w/ different date groupings in Excel
Want to get more from the raw data you're entering into your Excel worksheets? Now you can create two distinct pivot tables in Excel comparing, for example, monthly and quarterly sales data. Not familiar with the pivot table? Pivot tables summarize spreadsheet input by counting, sorting and totaling data within a list and providing at-a-glance computations within the same sheet. Become an expert on the subject within 5 minutes and 24 seconds by following easy to understand instructions narrat...
How To: Create a pivot table in Excel 2007
This video demonstrates how to create a pivot table in Excel 2007. 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 a pivot table in Excel 2007, For Dummies.
How To: Extract records using MS Excel's advanced filter tool
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 525th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records using advanced filter and wild-card criteria. See, for example, how to extract records that start with the letters W or J.
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: Quickly navigate around in Microsoft Excel
Many seasoned users of Microsoft Excel, who have been using spreadsheets for years, still scroll through their spreadsheets, laboriously, with the horizontal and vertical scrollbars. In this software tutorial, you'll learn how to navigate around in Excel both quickly and efficiently. For more, take a look!
How To: Make calculations in Excel with formulas & references
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 2nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to make calculations in Excel using formulas and cell references. Learn about the different Excel Math operators and func...
How To: Setup email in Microsoft Office Outlook 2007
In this Software video tutorial you will learn how to setup email in Microsoft Office Outlook 2007. Suppose you have a Yahoo email id and you want it in Outlook, go to tools > account settings > email > new and fill out the details. Then check the box next to ‘manually configure server settings’ and click ‘next’. In the next box, choose the 1st option and click ‘next’. To get the information for filling up in the next box, go to the Yahoo page shown in the video and copy and paste...
How To: Work with date functions (TODAY, NOW, DAY) 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've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 12th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the TODAY, NOW, DATE, YEAR, MONTH, DAY and EDATE functions.
How To: Embed a YouTube video in PowerPoint w/ or w/o internet
In this Software video tutorial you will learn how to embed a YouTube video in PowerPoint with or without Internet. You will see two ways of doing this with and without internet access. When you have an internet connection, open up PowerPoint and click on the office circle button on the left hand corner. From there select ‘PowerPoint options’ and check the box that says ‘show developer tabs in the ribbon’ and click OK. Once the developer tab is in your ribbon, select that and go to the area t...
How To: Sort Excel data in custom order
This how to video shows you how to sort data in Excel in a custom order. First, open a spread sheet in Excel. Select a column of cells with words that you want sorted. Click the office button and select Excel options. Go to edit custom list. You will see different custom lists. Click import to import your selection as a custom list. Next, you can go back to a sheet with those words that you want sorted and click the sort command. Select custom list on the order tab and select your new custom ...
How To: Add data to an Excel cell range via keyboard shortcut
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 4th installment in their series of digital spreadsheet magic tricks, you'll learn how to add data or a formula to a range of cells by using the Excel's ever-useful ctrl+enter keyboard shortcut.
How To: Use Excel mixed cell references in formulas
Excel is a powerful tool, but sometimes you need a guide to navigate its possibilities. This clip shows the difference between absolute and relative cell references so that any given formula, when copied, gives the results you want. Sometimes you will want to refer to the same cell, even when you are copying a formula to a different place on the worksheet. Other times, you will want the items in the formula to change as you copy them across the columns. You will see how such actions work thro...
How To: Use the CHOOSE function in Microsoft 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 46th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use MS Excel's CHOOSE function.
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: Work with SharePoint calendars in Outlook 2007
When you link your calendar from a Microsoft Windows SharePoint Services 3.0 site to Microsoft Office Outlook 2007, you can view and work with the SharePoint calendar right alongside your Outlook calendar. When you make changes in one calendar, the two calendars are synchronized automatically. Take a look at this tutorial and learn how to overlay the calendars to make viewing your complete schedule even easier.
How To: Clear formatting from 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 7th installment in their series of digital spreadsheet magic tricks, you'll learn how to remove the formatting from a given Excel cell without erasing the cell content!