Latest Trending Tech & Gadgets Lifestyle Apple Android

Hot Microsoft Office Posts

iOS 18 Tips, Tricks, How-Tos, News

How To: Create a brochure in Publisher 2007

This video shows you how to make a brochure using Microsoft Publisher. To create a brochure first you will need to choose the brochure template in Publisher, in this case the presenter chooses the event brochure. You can then customize the template by changing the default text, which the video shows you how to do by highlighting and deleting. It also shows you how to move to page 2 and change the text there. You can also change the default pictures by choosing the picture to replace and brows...

How To: Avoid the #DIV/0! error in fornulas in Excel

Getting errors when trying to crunch your numbers in Windows Excel can be frustrating, but with this fun and easy to follow guide to remove the "#DIV/0!" error. When the computer thinks you're trying to divide by zero, it produces an annoying error, but by following this video guide you can be free of that irritation. He goes step by step on how to edit the formula calculator so that it no longer produces the error, and even explains in detail why this is solving the error problem. You don't ...

How To: Use SUMPRODUCT for weighted average cost in Excel

This video shows you how to calculate weighted average cost from a transactional data set using SUMPRODUCT function. It explains things very clearly. If you're working with a very large database transactions the SUMPRODUCT function makes it. It works as text if you do the formatting first and then type the number. We put the number in first and then format as text, then press F2 and ENTER.

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: 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: Create a histogram using data analysis in Excel

A histogram is a summary graph showing a count of data points that fall in various ranges. Histograms are used in statistics and other forms of mathematics. In this video, learn how to create your own histogram using data analysis on the computer. This tutorial will show you how to create a frequency distribution, a cumulative frequency distribution, a histogram chart and an ogive chart with the data analysis add-in.

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: Download a free beta version of Microsoft Office

This how to video describes how to download and install a free beta version of Microsoft Office. This video directs you to a Microsoft site that allows you to download the beta version of Office. The author warns you that this is the beta version of Office and that the software is still in the testing phase and is prone to many bugs and unknown problems and issues. This video is perfect for the penny pincher or those who want to be on the bleeding edge of technology.

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: 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: 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: 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.