Hot Microsoft Office How-Tos
How To: Use Microsoft Excel for beginners
MotionTraining gives an overview for using Microsoft Excel for beginners in this video. This video gives a rundown and overview of the basics of this spreadsheet program: from typing in the columns and rows, adding dollar signs to data, and how to make basic calculations. MotionTraining will show how to make text stand out with bold and italics, adding colors to your data, and how to make a grid appear during the printing process. Creating various charts of the data in the spreadsheet is also...
How To: Do a reverse two way look up in Excel
In this Excel magic trick video the tutor shows how to perform reverse two way look up for date and time columns and row headers. In this tutorial he shows a spreadsheet that contains dates in columns and times of a day in rows which makes up a small table schedule. Now he shows how to use those values of the cells in that schedule table and summarize and print out the values based up on a name or some other text value. He also refers to a previous video of his which he says to watch to get g...
How To: Set-up an Excel page for print
In this Excel basic video the instructor show how to setup a page in Microsoft Excel. Now you before go to a page setup, first you have to make sure that all the cells are visible in a spreadsheet by extending or contracting the size of different columns. You can also select all columns and make their column width a constant. Now go to the orb and select a print preview to get a preview of how the print out is going to be. Now after checking it out you can make necessary changes in the origin...
How To: Preview pasted items in Microsoft PowerPoint 2010
This video is describing how to preview the pasted items such as from another PowerPoint or any other articles. These are all features available in the "Microsoft Office Power Point 2010". We will take the "conference1" presentation in that the first slide and we would like to add some text from another "Document" from another application like "Microsoft Word". So, we click and drop the mouse to select that and click the Copy button on the top of the word file or we can copy by the keyboard i...
How To: Use Microsoft Word 2010's Backstage view option
Microsoft Word 2010 prevails with new advancements. New options such as Backstage view allows the user to work efficiently and utilize new abilities when managing documents. It succeeds with new abilities that will allow the user to complete tasks quicker than before. Working with the newly enhanced ribbon allows the user to navigate with an easy, more personal customized environment. Now with more options and commands at your fingertips, it is evidently shown that Microsoft is gifting users ...
How To: Use the quick file function in Microsoft OneNote 2010
By watching this lyndapodcast tutorial you learn how to use the quick file function in Microsoft OneNote 2010. This feature eliminates to regroup information, so you can send notes obtained from multiple sources to a selected page of a note book. This method called quick filing lets you send the information from the program that your using directly to One Note seamlessly.
How To: Multiply & divide fractions using Excel key points
To multiply and divide the two fractions is a single step problems. Just multiply both the numerators and denominator for obtaining multiplication of two fractions, and for the division just multiply numerator of first fraction with denominator of second fraction and keep it in numerator place, and for the denominator place you just multiply the denominator of first fraction with numerator of second fraction.
How To: Turn off AutoCorrect symbols in Excel
In this Excel magic trick video the instructor shows how to stop automatic copyright symbol ©. While using Microsoft Excel when you type the letter c in between a pair of curved braces Excel automatically turns it into the copy symbol © even if we did not intend to use it. Now to get rid of this feature go to the file menu and then to the options menu. In the options window that pops up go to the proofing sub menu and there is a button for auto correct options. Go into it and it shows the lis...
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: Reverse two way lookup for date & time in Excel
In this Excel magic trick video the tutor shows how to perform reverse two way look up for date and time columns and row headers. In this tutorial he shows a spreadsheet that contains dates in columns and times of a day in rows which makes up a small table schedule. Now he shows how to use those values of the cells in that schedule table and summarize and print out the values based up on a name or some other text value. He also refers to a previous video of his which he says to watch to get g...
How To: Use INDIRECT, TEXT, and SUBSTITUTE in Excel
ExcelIsFun will show you how to use indirect text and substitute in Excel. Select any date and product and create an intersession. Use Vlookup to look up your columns. Use the match function to find the value range. To do the same thing with dates, highlight the dates and names. You then let the name look for indirect. Your space operator tells you two ranges to find the intercept. Take the text and substitute for the dashes. Use the text function on the value and format it.
How To: Calculate proportions and percentages in Excel
This Excel Statistics series of video shows how to calculate proportions and percentages in Microsoft Excel. This video shows how to do percentage calculations using formulas in Microsoft Excel. To make a formula for a percentage, you need to first make a formula to calculate the total sum of objects you are going to use. To do that, use the sum formula. Now, divide the current object's value with the previously generated sum formula, which gives you the frequency. When you multiply this by 1...
How To: Use PivotTable to group data in Excel
Excel Fun will show you how to get the most out of your Excel experience by learning about pivot tables. With Excel and the latest Excel 2010 you can learn how to create a pivot table. Learn where in the system to go to find the table. Learn how to add our numbers and create a calculation and watch it being solved. Your instructor will go through a detailed equation so that you can see how to do your own calculation.
How To: Use YEARFRAC, INT, and DATEDIF in Excel
In this Excel magic trick video the tutor shows how to use the years worked formula using Yearfrac, Int and Datedif functions. He says that using this trick you can find out how many years some one has worked if we know his starting date and ending date i.e. he shows how to extract the difference in years directly by using formula to calculate it. He shows how to use Yearfrac function which gives the number of years in decimal form. He also shows how to extract integer from the decimal using ...
How To: Use Microsoft Word to create a brochure
Rod Milstead brings us a video on how to create a brochure in Microsoft Word. He shows us how to navigate Microsoft Word in order to create the brochure. He gives us step by step instructions on how to get a general template to work with. Then he explains how to work with the template once you have pulled it up. He shows us that it is a two page document and that page one in the outside and page two is the inside. He says that while it might be a little hard to use at first, once you get used...
How To: Use OR, ISNUMBER and ISTEXT in Excel
ExcelIsFun shows you how to detect if a cell has a number or text. The first thing he explains is to find out what are the different types of things that can go into a cell. Next he talks about the use of "OR" and "IsNumber" to make it possible to determine if a cell has a number or text entered into it. The user then explains why certain rows where either "True" or "False". After watching this video, you should be able to determine if a cell is using text or a number.
How To: Add custom number formats to a cell in Excel
In this video the author shows how to perform custom number format for turnover ratio in a Microsoft excel document. He shows how to perform custom number formatting in which he shows how to display a decimal value in words. He opens the Format Cells option and there he shows how to set the Custom option. He shows how to configure different options so that we can format the decimal value and display it as text with some meaning attached to it. In this video the author shows how to use custom ...
How To: Create a Powerpoint presentation
Need to make a Powerpoint presentation and you're not sure where to begin? In this three-part video tutorial, learn how to make a Powerpoint presentation from start to finish. A Powerpoint presentation is a great way to enhance a school project and impress your teacher!
How To: Repeat a list of names 7 times in Excel
The ExcelIsFun shows how to repeat a list of names seven times. He starts out by telling you a fast way to do this. He starts out by selecting the names already typed in then he presses Control C (Ctrl + c) on the keyboard. The next thing he does is move the cursor to a different column and in the first row. He presses Control V (Ctrl + v) to paste the names into the other column. By watching this video, you will find out how to quickly repeat a list of names 7 times or more.
How To: Use Excel keyboard shortcuts
This video is all about the keyboard shortcuts that are used in Microsoft Excel of the latest version. If you really need speed and efficiency then watch this video for its shortcut keyboard buttons. After typing all the data, if you need to see the page setup with the help of the mouse than it will take a pretty long time. By opting for keyboard shortcuts you can save much of your time and can invest it in another work. If you press 'alt' button then it will show keyboard shortcuts on the sc...
How To: Use Excel to do math
This video describes how to use excel basics formulas to do math. Shows how to create new formulas so that you can complete math functions and how many formulas in excel work. Each step is displayed step by step with an explanation on what is going on so it may be understood. Keyboard short cuts among other tips and trick to help you navigate through microsoft's excel. After this video you would be able to use excel to do a variety of functions to complete math equations.
How To: Print double-sided and reverse printing order in Word
Learn how to print double-sided and reverse printing order in Microsoft Word. * Go to the Start menu and open Microsoft Word.
How To: Add citations & bibliographies in MS Word 2007
This video tutorial will show you how to add citations and bibliographies in MS Word 2007. 1. Select desired text.
How To: Create a database in Microsoft Access
In this six-part video tutorial, learn how to create an access database. The following six parts go over the following:
How To: Manage loans with an amortization table in Excel
In this three-part video tutorial, learn how to manage loans with an amortization table in Excel. The three parts of this video go over the following:
How To: Alphabetize in Excel
Need to sort a ton of data in Excel? Why waste time cutting and copying cells? In this tutorial, learn how make Microsoft Excel automatically sort columns or rows alphabetically.
How To: Alphabetize lists of words in Microsoft Word
Chronology in Microsoft Word is convenient when it comes to organizing your documents. Thankfully, you don't have to manually edit the document to put things in alphabetical order! This video shows you how to do it in a few clicks.
How To: Use Document Map to navigate writing in Microsoft Word
This tutorial is a great eye-opener into the world of Microsoft Word. If you thought you could just open Microsoft Word and type, you are not taking full advantage of what the system has to offer. Iain Broome shows you how to use the Document Map feature on Micosoft Word to your best advantage for any writing project. For more video tips on Microsoft Word, search for Microsoft Word on WonderHowTo.
How To: Choose a theme for your Word 2007 document
This video demonstrates how to choose a theme for your Word 2007 document. 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 choose a theme for your Word 2007 document, For Dummies.
How To: Work with PowerPoint themes
This video demonstrates how to work with PowerPoint themes. 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 work with PowerPoint themes, For Dummies.
How To: Format a paragraph in Word 2007
This video demonstrates how to format a paragraph in Word 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 format a paragraph in Word 2007, For Dummies.
How To: Record a macro in Excel 2007
This video demonstrates how to record a macro 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 record a macro in Excel 2007, For Dummies.
How To: Use PowerPoint presentation slide masters
This video demonstrates how to use PowerPoint presentation slide masters. 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 use PowerPoint presentation slide masters, For Dummies.
How To: Make multiple changes at once with Word 2007 themes
This video demonstrates how to make multiple changes at once with Word 2007 themes. 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 multiple changes at once with Word 2007 themes , For Dummies.
How To: Edit headers and footers in Word 2007
This video demonstrates how to edit headers and footers in Word 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 edit headers & footers in MS Word 2007, For Dummies.
How To: Run macros in Excel 2007
This video demonstrates how to run macros 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 run macros in Excel 2007, For Dummies.
How To: Add a data table to an Excel 2007 chart
This video demonstrates how to add a data table to an Excel 2007 chart. 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 add a data table to an Excel 2007 chart, For Dummies.
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: Create a pivot chart in Excel 2007
This video demonstrates how to create pivot chart 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 pivot chart in Excel 2007, For Dummies.
How To: Create a graph or chart in Excel 2007
This video demonstrates how to create a graph or chart 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 graph or chart in Excel 2007, For Dummies.