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 300th installment in their series of digital spreadsheet magic tricks, you'll learn how to use date and time functions together. Specifically, you'll see how to use the INT function to calculate total days worked and the TEXT function to calculate total hours worked.
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 279th installment in their series of digital spreadsheet magic tricks, you'll learn how use the ADDRESS, LEFT, ROW, ROWS, and COLUMN functions to create the series AA, AB, ZZ with a 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 220th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula with the SUMPRODUCT and EOMONTH functions that count the dates in each month for a given range of dates.
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 576th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a point and a dynamic label to a break-even chart that marks the breakeven point using INDEX and MATCH functions. This point is dynamic and will change if data is changed.
Mike Callahan aka Dr. Filefinder of Butterscotch explains how to adjust the margins in Microsoft Word 2007. While working on a document navigate your mouse to the 'Page Layout' tab at the top, center of the page. On the far left of the resulting page you will find 'Margins', click on that. A drop down window will display some default options that may suit your needs. If not, then click on the bottom option 'custom margins' to change the margin width to any size that you choose. You will now b...
Microsoft Excel is used to store and work on data by storing them in rows and columns in tables. You can use a macros to check if a cell is empty. To do this you have to know two short cuts. The first is the VBA Window short cut which is Alt + F11 and the other one is View Macros short cut which is Alt + F8. So open an Excel spread sheet and insert some data into a small table. Now create a macro for this tutorial. You can use and IsEmpty() functions to check if a cell is empty. Use this func...
Mike Callahan with Butterscotch demonstrates how to work with tables in MS Word 2007. Tables are useful for creating information charts and address lists. First, open up Microsoft Word. To create a table, click on the insert tab on the top tool bar. Highlight the elements that you would like to appear in the table by selecting the desired number of columns and rows. Pressing enter inside of a table, it will increase the side of the cell all the way across the table. It will not just increase ...
Microsoft excel is a powerful tool used to work with numbers and data by filling them down in rows and columns of a table. Excels also supports macros, which are small scripts to automate certain functions. In Microsoft Excel you can select entire rows and columns using the range property. You can also use macros to select individual rows and columns as well as multiple variations of rows, columns, and individual cells all at once. In Excel a horizontal line of data is called as row and a ver...
In this video the instructor shows how to change views in Microsoft word 2007 and navigate around the documents. In Microsoft word 2007 in the ribbon there is a view tab to the extreme right. Open the tab. Now in that bar the default layout selected is the Print Layout which is 'What you see is what you get' layout. Next to it the full screen reading option and clicking on it, the documents opens up as a two page book with all the other tool bars hidden. The next is web layout which is ideal ...
In this video, Lance Sisiolo draws a beautiful house using Microsoft Paint. He uses line tool to draw most part of the house. He uses different types of lines. He also uses curve tool to draw sky and the entrance of the house. The unwanted part of the picture is erased using erase tool. Then he uses fill with color tool and airbrush tool to paint the picture. He uses different colors to increase the beauty of sky and the house. Then some trees are added. Using airbrush tool he increases the b...
In this video we learn how to use Smart Art graphics including creation of Hierarchal charts, flow charts, modify, adding gradients, style, and colors, in Word 2007. The first step is to click on the Smart Art icon in Microsoft Word 2007. Next, you can scroll through the Smart Art object choices. In this example we first want to click on the Text Cycle icon. Once we do that click on OK and the rough drawing will be placed on your document. After that click on design and you can format the gra...
This video demonstrates how to show and hide the ruler in Microsoft Word 2007, along with working with page margins. The presenter indicates that if you click the small button above the vertical scroll bar, Microsoft Word will then display Rulers. To work with margins you'll need to click on the Page Layout tab to display the Page Layout ribbon. The video shows the different options located on the Margins menu. There are several built in settings for wide, narrow, normal, moderate, and mirror...
This video tells you how to save files in Microsoft Word using different file types. If you are trying to save a file as the old Microsoft Word 97-03, the process is easy. This video takes you through a visual tutorial on how to save files under different documents. If you click the circle in the upper left corner and scroll down to save as, it will give you several different options to save under. Then, you can choose which document you want to save it under, and save the file under a new na...
In this video the instructor shows how to create charts and graphs in Microsoft Word. First, open the Word document and select an area to insert the charts. Now go to the Insert tab in the ribbon and select the Chart icon. The Insert Chart window opens up with various chart templates. There are various categories of charts like Line, Pie, Bar in the left hand side. In the right hand side you can see the sample charts available and you can select any of them that you want. Now it transfers you...
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.
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.
Windows 7 is the hot, new operating system replacing the past XP and Vista systems. Windows 7 is the most simplified, user-friendly version that Microsoft has developed - ever. Get acquainted with your new version of Windows straight from Microsoft.
Windows 7 is the hot, new operating system replacing the past XP and Vista systems. Windows 7 is the most simplified, user-friendly version that Microsoft has developed - ever. Get acquainted with your new version of Windows straight from Microsoft.
Check out this video tutorial to learn more about the Phishing Filter on Internet Explorer 7. Web browsers such as Microsoft's Internet Explorer 7 have become an important part of the computing experience for business and home users around the world. With the popularity of web browsers for accessing information, running programs, and even accessing corporate resources, the browser has become a target for viruses, malware, and phishing schemes that present real dangers to Internet users. Inter...
Interested in sharing a calendar? With Outlook 2010, it's easy. This clip will teach you everything you'll need to know. Whether you're new to Microsoft's popular email and scheduling application or a seasoned MS Office professional just looking to better acquaint yourself with the Outlook 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started organizing your own inbox, watch this free video guide.
This video will show you how you can simply type a symbol of a bomb in Microsoft Word. Using three easy steps, the symbol can be simply inserted into a word document. After opening up the Microsoft Word program, the user should then change the font type to a font which is called "Wingdings". This font will create symbols in the place of the regularly typed letters. In order to obtain the bomb symbol, simply type "M" (capital m) and the symbol will appear. The symbol should appear as a simple ...
OK, title says it all. This video will show you how to use a bluetooth headset with an Xbox 360 controller and on xbox live, without paying the ridiculous fee for the Microsoft wireless headset that usually breaks within 2 months. Watch and see how to connect Bluetooth to Xbox live!
The achievement system and hard drives of modern video game consoles present an as-yet-underutilized potential for crossover content between games. Microsoft has finally taken advantage, and recent Xbox 360 releases World of Keflings, Ilomilo, and Raskulls contain some really awesome crossover content. Watch this video for a guide to accessing and using all of this awesome and visionary content.
Call of Duty Black Ops manages to be frantically fast-paced and highly tactical at the same time, and strategizing for each map properly will get you many kills. Watch this video for some strategy tips for the Launch multiplayer map on team deathmatch.
Start blogging directly from Micrsoft Word! Use spellcheck, and never worry about your browser eating your post. You can write your own perfectly formatted blog posts using Word 2007. And when you're done, you can even publish the post directly from the program to your Word-compatible blog on the web.
Urgot is a unique champion who can deal out high amounts of damage early in his game, and eventually evolves into a tank/assassin hybrid who can be sent after important enemy targets. Here's a guide for building and leveling Urgot to take advantage of his capabilities to help your whole team.
Galio's strength on the Fields of Justice comes from his ability to tank, though he can provide a bit of team support as well. This guide goes over his strengths, and gives good advice when it comes to making an optimum build for the Sentinel's Sorrow for your next League of Legends game.
Interested in adding a spell check function to any Windows application? This clip will show you how it's done. It's easy! So easy, in fact, that this handy home-computing how-to from the folks at Tekzilla can present a complete overview of the process in about two minutes' time. For more information, including detailed, step-by-step instructions, take a look.
Want to create Mac-style stacks in your Windows 7 taskbar? This clip will show you how it's done. With Piles, it's easy! So easy, in fact, that this handy home-computing how-to from the folks at Tekzilla can present a complete overview of the process in about two minutes' time. For more information, including detailed, step-by-step instructions, take a look.
Want to mod your HTC HD2 Microsoft Windows smartphone to use wireless charging—without breaking your warantee in the process? It can be done! And quite easily at that. For complete details, and to get started modding your own HD2 phone to work with wireless chargers, watch this handy hacker's how-to.
Gambit is one of the coolest X-Men, and his kinetic energy powers are awesomely powerful. If you want to depict them using special effects in a film, this video will show you how to do it using three free pieces of digital editing software:
If you have a hacked XBox 360, you've only accomplished part of the process required to allow you to played burned copies of games on your console. You also have to burn the games correctly, and part of doing that is stealth patching you ISO files to make sure that they are up-to-date and won't get you noticed by Microsoft. This video will show you how to use AGBX360 to stealth patch you files and make them ready to play.
Show your love for England's football team as they compete at the FIFA World Cup by wearing the team's pretty red and white colors on your face! Don't you dare tone these vivid colors down; this is for a sports celebration, after all, not for single's night at Hyde!
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 618th installment in their series of digital spreadsheet magic tricks, you'll learn about a handy key command that will allow you to enter both today's time and date into a single Excel cell.
Check out this video and learn how to get the most out of your characters in Final Fantasy XIII. Each character has a different focus when it comes to fighting. In this clip, you will get a quick overview of what each character is good at so you know how to best level them up as you go through the game. Follow along and keep track of your team's strengths and weaknesses so you can dominate FFXII.
Learn how to force the Windows 7 taskbar to display a preview for each and every one of your Mozilla Firefox tabs upon mouse-over. This home-computing how-to from the people at Tekzilla will show you a quick and easy about:config Firefox hack that will permit you to do just that. For more information, and to get started using this hack yourself, give this clip a look.
If you're having a hard time getting the "Beat the Team II: the Revenge" achievement in the racing game Split/Second for the Xbox 360, no need to fear, Achievement Hunter is here! In this video, they'll show you how to get this difficult achievement using some helpful tips and tricks. This requires you to complete the Power Plant level in Detonator in under 1:18. So good luck and enjoy!
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 6th installment in their series of digital spreadsheet magic tricks, you'll learn how to add conditional formatting to a whole row of data in an Excel sheet.
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 288th installment in their series of digital spreadsheet magic tricks, you'll learn how to count the number of characters or numbers in a text string with a formula that is case sensitive.
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 292nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first and last names from an Excel spreadsheet and rearrange them using a formula.
