Latest Trending Tech & Gadgets Lifestyle Apple Android

Hot Microsoft Office How-Tos

iOS 18 Tips, Tricks, How-Tos, News

How To: Use the SUMIF function with an array 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 694th installment in their series of digital spreadsheet magic tricks, you'll learn how the SUMIF function (and COUNTIF, etc.) cannot accept arrays. If you need to sum by year from transactional data the SUMIF and YEAR functions cannot be used together. Instead we can use the SUMPRODUCT function.

How To: Identify the first occurrence of a value in a column 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 697th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a column of 1s and 0s (ones and zeroes) where 1 indicates the first occurrence and 0 indicates any remaining duplicates.

How To: Put a YouTube video into a PowerPoint presentation

This video tutorial is in the software category where you will learn how to put a YouTube video into a PowerPoint presentation. First you go to the YouTube video that you want to put in your presentation and copy the URL in the address box. Then you go to one of the file conversion websites like Media Converter, paste the URL in the box and click 'next'. Then select the type of file you want it to convert to, for example, mpg, and click 'next'. Once it is converted, download it. To embed it, ...

How To: Change the colour scheme in Word 2007

In this video, we learn how to change the color scheme in Word 2007. First, click on the Word orb in the upper left hand corner. After this, go to the options menu to change your settings. On the new window that pops up, you will see an option to change the color from blue to silver or black. Choose which color you want to have as your background on this software, then click on "ok". Now your color scheme will be changed to not reflect the blue that you usually see when you star this program ...

How To: Use a text box in Excel 2007

In this video, we learn how to use a text box in Excel 2007. To do this, you will go to the insert tab and then go to the text box and select text box. Now, draw yourself a text box then highlight and copy the text you want, then paste it in. now you will have a paragraph of text written on top of your cells. You don't have to copy and paste, you can type it in as well. If you want to format the text, right click in the box and then change the preferences you want to change to format the text...

How To: Create a Powerpoint presentation step by step

In this video, we learn how to create a PowerPoint presentation. Start off by adding in the title and subtitle of the project. After you do this, you can start to change the fonts and colors, as well as add pictures to the background and add transitions to the next page. When you're done with this, go onto your next page and start to add in all the information you need to on the following pages. When you are finished, you will be able to save your project and then use it for a presentation. T...

How To: Use the bibliography feature in MS Word 2007

In order to use the bibliography feature in Microsoft Word 2007, you will need to begin by opening your document in Word. Find the place where you would like to add a reference. Place your cursor in that spot. Then, go to the tool bar. Click on "Insert Citation". Click on "Add New Source". When the pop-up opens, enter the information about the periodical or book that you are citing. Fill it in completely. Make sure you choose the type of material you are referencing in the top drop down menu....

How To: Create and edit tasks in MS Project 2007

In this tutorial, we learn how to create and edit tasks in MS Project 2007. Before you begin, you need to set the start date by going into project information and changing the start date and end date. After this, type in your first task name, then enter in the information that goes with it. After you have entered this, press the check mark to set it up. After this, enter in the other task names that you need to specify in your project. When you are finished, you will need to save this onto yo...

How To: Insert tasks in MS Project 2007

In this tutorial, we learn how to insert tasks in MS Project 2007. First, go onto your project and use the insert menu to enter in the insertion point before the selected task. After his, enter in the task name and then enter in the duration and the start and finish time. If you need to enter multiple tasks, you can simply highlight the number of tasks you want to fill in to do it more quickly. If you want to delete a task, simply right click on it and click the delete button, then it will be...

How To: Quickly copy & paste data in Microsoft Excel

In this video, we learn how to quickly copy and paste data in Microsoft Excel. First, if you have two columns that you want to add up, you will highlight the columns and then copy and paste them into the other cells. Another way is to select the cell and go to the bottom right hand corner, then drag it down. This will fill your formula in to every cell below it! This will save you a lot of time instead of having to type in formulas for the columns that you are trying to do equations with! Thi...

How To: Create summary tasks in MS Project 2007

In this video, we learn how to create summary tasks in MS Project 2007. Start by selecting the firs task that is on your project. You can create a summary task by selecting a task underneath and indenting the task. This makes the item above this the summary task that is defined by the sub task underneath this. You can do this for multiple tasks at once, or just one task. Now, you will be able to see the duration of the entire project and then change the tasks from sub tasks to summary tasks a...

How To: Learn keyboard shortcuts in MS Excel 2007

In this video, we learn how to learn keyboard shortcuts in MS Excel 2007. First, hit the "alt" key and then you will see numbers and letters at the top of the screen. Now you will see all of the pages of the keyboard shortcuts. Go to the page layout tab and hit "p". Now, you will get the keyboard shortcuts for everything on the page layout tab. Continue to do this on all the different tabs for this and you will be able to memorize the ones you use most, so you can more easily navigate MS Exce...

How To: Format charts in MS Word 2007

In order to format graphs and charts using Microsoft Word 2007, click on Chart Tools. The tabs at the top of the screen provides you with your options. You can change the type of chart or graph by clicking on Change Chart Type. If there is a particular type of chart that you would like to use again and again, then you can save it as a template via the Save As a Template icon. You can edit the data in your chart of graph by clicking on Edit Data. You can modify the chart layout by clicking on ...

How To: Insert movie files into a MS Word document

In order to insert movies into Microsoft Word 2007, Click on Insert. For AVI, go to Object, Create From File, and select the location of the file. Then, click on Insert. It will now appear on your document. The video should play. The video can be repositioned or adjusted. It can be saved with your document, although this is not true for other movie formats.

How To: Prepare a Powerpoint file or presentation

In this tutorial, we learn how to prepare a PowerPoint file or presentation. First, open up the software and start a new project. After this, you will start a page that has nothing on it. Insert the title of your page as well as any images or audio you would like displayed. After this, you will be able to add in a transition that will easily make this page go to the next one smoothly. Continue on to the next page inserting your information for your presentation. If you are adding bullets for ...

How To: Create summary tasks in MS Project 2007

In this tutorial, we learn how to create summary tasks in MS Project 2007. First, put a task into your project and use the fill option to create more tasks. Fill in the duration and start time of your tasks as well. Now, write the subject at the top and then highlight the tasks that have to do with them, and click an arrow to indent all of these tasks. You can have up to nine levels of indenting and tasks, but this can make your project look far too complicated. When finished, save your proje...

How To: Merge & center a cell in Microsoft Excel

This video tutorial belongs to the software category which is going to show you how to merge & center a cell in Microsoft Excel. Highlight the area that you want to merge. Press the "Merge and Center" button located in the tool bar at the top. The cell will be merged. Then, type in what you want to type and click on the cell that you merged. Right click on it. Next, select "Format Cells" and click on "Alignment" tab. Click on the drop box, select "Center" and click OK. Your text inside the me...

How To: Avoid common mistakes when doing financial analysis in Microsoft Excel

Learn how to prevent fallying prey to cmmon careless errors when doing fiscal analysis in MS Excel. 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, including step-by-step instructions, take a look.

How To: Save an Excel 2010 document for use in Excel 2003

Learn how to make your Excel 2010 spreadsheets compatible with Excel 2003. 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, including step-by-step instructions, take a look.

How To: Use the Ribbon and Backstage View in Microsoft Excel 2010

In this clip, you'll learn how to use the Ribbon and Backstage View in MS 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, including step-by-step instructions, take a look.

How To: Use the TODAY and NOW functions in Microsoft Excel 2010

Learn how to make time-based calculations with the TODAY and NOW functions in MS 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, including step-by-step instructions, take a look.

How To: Round when making time calculations in Microsoft Excel 2007

Learn how to round to a given interval when making time-based calculations in MS Excel 2007. 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 2007 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.

How To: Use the TODAY and NOW functions in Microsoft Excel 2007

Need an introduction to Excel's useful TODAY & NOW time functions? You're in luck as this clip provides just that. 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 2007 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.

How To: Do look-up addition with VLOOKUP & HLOOKUP 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 684th installment in their series of digital spreadsheet magic tricks, you'll learn how to do single-condition lookup adding for both the VLOOKUP and HLOOKUP functions. You'll also learn how to use an array constant in the row/column num argument for the HLOOKUP and VLOOKUP functions.

How To: Calculate Commission Based on Varying Rates 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 673rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT formula to calculate commission amounts based on varying commission rates based on cumulative sales totals for each month.

How To: Count with OR criteria in Microsoft 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, the 674th installment in their series of digital spreadsheet magic tricks, you'll learn four different methods for counting OR criteria in Microsoft Excel 2010:

How To: Validate data with dynamic VLOOKUP functions 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 675th installment in their series of digital spreadsheet magic tricks, you'll learn how to do data validation using a custom logical formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and...

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: Average the last three values for an entity 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 677th installment in their series of digital spreadsheet magic tricks, you'll learn how to average the last three scores eneterd for any Player using the functions: AVERAGE, IF, ROW, COUNTIF, MIN, LARGE.

How To: Sum values after a deadline in Microsoft 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, the 678th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM only the values after a deadline using a dynamic range formula using INDEX Function. Also see a SUMPRODUCT function method.

How To: Add yearly totals from monthly data 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, the 679th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize yearly totals from monthly totals when there Year Criteria is entered as a serial date. See the SUMPRODUCT and SUMIFS functions. Learn about criteria and how to enter it into the SUMIFS functions.

How To: Find the smallest number greater than zero 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 681st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the MIN and IF functions to find smallest number that is greater than zero in an array formula.

How To: Average times entered as text 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 682nd installment in their series of digital spreadsheet magic tricks, you'll learn how to to average times values that were exported from a database as text values instead of number values.