One Minute Geek Video Podcast - Microsoft Office | Tutorials, Tips, and Tricks
Summary: Microsoft Office tutorials, tips, tricks, and how to's served up hot and fresh in one minute or less. We endeavor to provide quick video tutorials that will assist the Microsoft Office user with applications such as Word, Excel, PowerPoint, and Outlook. These videos are designed to quickly provide the information you are looking for without any of the fluff that you find in similar Microsoft Office tutorials. These video tips were created for anyone looking to become more efficient and productive in the Microsoft Office suite of products.
- Visit Website
- RSS
- Artist: Jason Burke: Microsoft Office Support and Software Tutorial Blogger
- Copyright: Copyright One Minute Geek - Microsoft Office Tutorials in One Minute or Less 2013
Podcasts:
This video tutorial shows you how to sum specific cells using the SumIf formula in Microsoft Excel with an example that is easy to follow. http://youtu.be/iXvwToRY7Qo The SumIf function in Excel is something that I use quite often when I want to add cell values based upon specific criteria. The syntax for the SumIf function is: Where "Range" is the cells that the SumIf function searches, "Criteria" is the statement that the SumIf function evaluates in the range to determine if a specific cell should be summed, and "Sum Range" is the cells that the SumIf function adds when the specified criteria evaluates as true in a specific cell. *If the "Sum Range" is omitted from the formula, then the cells in the "Range" are added if the specified criteria evaluates as true in a specific cell. Example: A B C 1 Sales Dept Criteria 2 100 Software software 3 120 Hardware hardware 4 90 Hardware accessories 5 15 Accessories 6 45 Accessories 7 200 Software 8 60 Accessories In this example we could do the formula =SUMIF(B2:B8, C2, A2:A8) The formula would search in the range B2:B8 and evaluate if any of the cells match the criteria in C2. If a cell in B2:B8 has the same value as in cell C2, then the formula adds the corresponding cell value in the A column to the total. In this example the sum of the formula would be 300 because "software" only appears in cells B2 and B7, which when adding A2 and A7 together, it equals 300.
This video tutorial explains how to make efficient use of the columns layout in Microsoft Word. This layout is excellent for newsletters, magazines, and newspaper style printed materials. I have personally used this layout for creating a bi-fold pamphlet. http://youtu.be/8nMsyIl54JE There are a few notes that I need to mention with regard to the columns layout in Microsoft Word. Many people choose this layout with the expectation that they will be able to type some text into the left column and then tab over to the right column and type more text. That is not the case with the columns layout in MS Word. If you want to have that functionality, you should use a table with two columns and one row minimum. A table will allow you to tab back and forth from one side to the other in a Word document. Another thing I want to mention is that the text I pasted into the document in the video was taken from lipsum.com. That is a handy website for generating filler text for any document. If you have Microsoft Word 2007 or later, Microsoft has added a built-in Lorem Ipsum text generator. Simply type the following syntax into any blank Word document: Microsoft Word allows you to specify the number of paragraphs and lines that it will generate. For example, if you type =lorem(10,5), Microsoft Word will generate 10 paragraphs with 5 lines of text in each paragraph. Pretty handy feature when you want to test the formatting of a Word document.
This video tutorial explains how to combine two separate cells of text into one cell in Microsoft Excel. http://youtu.be/ZN6fY-f4IHg The One Minute Geek video shows you one way to combine text strings in Microsoft Excel. Read on through this post for a more detailed explanation of concatenate and an alternative to using the concatenate function. The formula that was used in the OMG video tutorial is as follows: To quickly explain what is happening here, the concatenate function in Microsoft Excel simply combines the contents of multiple cells together into one cell. The contents of those cells can be more than just text strings. Here is the definition from Microsoft. Like many things in the world of computers, there is usually more than one way to do the same task. The concatenate function is no exception. Here is another formula that will produce the same results as the formula described in the video: I know that this is an easier way to do what I explain in the video tutorial. I prefer to use functions in Microsoft Excel simply because it keeps things readable and orderly. Using concatenate as opposed to the ampersand symbol is a best practice that everyone should use in Microsoft Excel.
