In this video, we learn how to create a brochure with Microsoft Publisher 2007. A brochure says a lot about your business, and you can make them yourself easily! Find the brochure templates first in the program. Choose a design and a color scheme along with the page size, font, and information you want to include. Once you do this, add in pictures and images to your template after clicking "create". Then, you can create a range of publications that adapt to different form functions. Click the...
Learn. Evolve. Operate. That's the basis of Leo from Kryon Systems. It's a new application that runs on top of any program you have open (web and desktop applications), providing you with instant help. Leo can actually perform your duties for you! Like in Microsoft Word 2007. In this video demo, you'll learn how you can use Leo to help you insert a picture into Word 2007, making Office a whole lot easier. See it in action!
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 727th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the hours worked in a night or day shift with a break for lunch given time number inputs using the MOD function.
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 722nd installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate gross pay for the week from time values using the SUMPRODUCT function. Also see what to do if you get a #VALUE! error from blanks in cell using the IF function and an array logical test.
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 726th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SIGN, COUNTIF and SUMPRODUCT functions to count 1 for each item in a first list that's also contained in a second list.
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 718th installment in their series of digital spreadsheet magic tricks, you'll learn how to find the Absolute Value Max of a set of integers (positive, zero and negative) using the MAX and ABS functions.
In this tutorial, we learn how to use Microsoft SharePoint to view Acrobat 9 reviews. First, go to the comment bar and click "send for shared review". In this wizard, click internal and then click next. Then, click SharePoint workspace, then type in the URL to the server, then click "get workspaces" and you now may have to enter in your username and password. Now you will have to choose your workspace and document library. After this, click on next and click if you want to have it attached fo...
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...
In this tutorial, we learn how to make your first graph in Microsoft Excel. First, open a new graph and enter in your data. Click and drag down from the original date you enter to have the other dates automatically entered in. Enter the rest of your information, then highlight all the data. Go to the menu and click "insert", then "chart". Now, go through the chart wizard to select what kind of chart you want to make. When you are finished entering all your preferences, change your values so t...
In this Software video tutorial you will learn how to make a basic bar graph in Microsoft Excel. You will also learn how to give your chart a title and how to label the axes. First you put in all your data in to an Excel spreadsheet. Then you highlight the data you want to put in your graph, select the 'insert' tab, then' column' and choose the basic column chart. Next you select the title tab, go to option and choose new title. Now you add the title to the graph. To label the axes, go on top...
This video tutorial is in the Software category which will show you how to insert clip art with Microsoft Office Word 2007. Open a word document and click on 'insert' tab on the navigation bar and then click on 'clip art'. The task pane will show up on the right side of the page. Here you type in the subject of the clip art you are looking for in the 'search for' box. For example, type in 'tiger' and then click 'Go'. A list of images is displayed. Click on the one you like and it will be disp...
In order to insert Word Art, into your document, using Microsoft Word 2007, you will need to begin by opening your document. Next, find "Insert", at the top of your screen. Click on it. This will take you to the Insert Tool Bar. Find Word Art. Choose the style that you would like to use, from any of the styles in the style gallery. When the window opens, you can choose your font style at the top, if you want to change from the default setting. You can also change the font size. Write the word...
In this software video tutorial you will learn how to create a pdf document using Microsoft Word. First you select the document you want to convert to pdf, click on file and select print. When the print window opens up, on the left had bottom, you will see the pdf button. Click on it and a dropdown menu comes up. Select 'save as pdf' from the dropdown menu, give the file a name and click 'save'. Exit the word program and you will see the pdf document on the desktop. You can now open it to see...
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 and Mr. Excel, the 14th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas and Conditional Formatting that will display UP, DOWN, and SIDE arrows to indicate up or down for a list of numbers.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 45th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to perform debt analysis with the following input variables: % Down Payment, APR, Years, Points, Extra Fee. See how to calculate Amount to Borrow, Monthly Pay...
If you're a novice looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! This free video MS Excel lesson, the very installment in said tutorial series, covers the following topics:
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 16th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to sort data in MS Excel. Specifically, you'll see the following:
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 3rd installment in his "Excel Formula Efficiency" series, you'll see how the Excel 2003, 2002, 2001, 1997 Database D functions (DSUM, DAVERAGE, DCOUNT) are much faster than SUMPRODUCT and SUM array formulas.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 9th installment in his "Excel Formula Efficiency" series, you'll learn see two running total formulas, one that is faster than the other.
As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 8th installment in his "Excel Business Math" series of free video lessons, you'll learn how to work with whole and decimal numbers. See how to write words to represent numbers (for checks). See how formatting can hide decimals.
If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 23rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to work with skew in histograms for quantitative Data. Learn how to skew left (negative) and skew right (positive) with ...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 57th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to avoid a #NUM! error when changing the formula input numbers for the NPER function. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 55th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the Excel 2007 remove duplicates tool and the COUNTIF function to count unique records that are greater than $30. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
In this Software video tutorial you will learn how to setup email in Microsoft Office Outlook 2007. Suppose you have a Yahoo email id and you want it in Outlook, go to tools > account settings > email > new and fill out the details. Then check the box next to ‘manually configure server settings’ and click ‘next’. In the next box, choose the 1st option and click ‘next’. To get the information for filling up in the next box, go to the Yahoo page shown in the video and copy and paste...
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 515th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an amortization table that will update when you pay extra principal so that loan is paid off early. See also how to make changes to a template, get into trouble, then trouble shoot your way out of it so that you can fix ...
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 527th installment in their series of digital spreadsheet magic tricks, you'll learn how to enter VLOOKUPs 3rd Argument in four different ways: Number, COLUMN function, COLUMNS function, or MATCH function. col_index_num or Column Number for VLOOKUP
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 532nd installment in their series of digital spreadsheet magic tricks, you'll learn how to count blanks in a dynamic range using the COUNTIF, INDEX, MATCH, COUNTA and OFFSET functions. Learn about the difference between an empty cell and a blank. Also see how to create dynamic ranges with INDEX and OFFSET (Index:Index).
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 562nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first, middle and last names when the list contains names where some have a middle name and some do not using the LEFT, SEARCH, LEN, SUBSTITUTE, LEN, MID and IF functions.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 112th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to solve a common VLOOKUP problem — how to look up approximate values. If the lookup table for the VLOOKUP function is looking up approximate values, the first column of the table must be sorted in ascending order. Learn to love digital spreadsheets more p...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 28th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the INDEX, RANDBETWEEN, COUNTA, IF, AND, & VLOOKUP functions together to select a random employee from a list, determine if they have meet the given criteria and then conditionally format the relevant cells according to the result. Learn to love digi...
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 367th installment in their series of digital spreadsheet magic tricks, you'll see that the IF function sees -1, 1, 10 and -1.23 as TRUE and 0 as FALSE and learn how to use this fact to your advantage when writing formulas.
Microsoft has released its latest rendition of the Windows operating system, Windows 7. Windows 7 succeeds Windows Vista and comes with many improvements and useful updates. To install the update one a personal computer running Windows, a backup of the user's personal files and data onto a detachable hard drive is recommended to prevent data loss during the update process. The ISO image of the Windows 7 OS is burned onto a DVD. A partition is optionally created on the user's computer to allow...
In this how to video, you will learn how to set up an email account in Microsoft Outlook. First, open up your program. Go to tools and select account settings. From here, click new. A new window will open up and you should press next. Click on the check box at the bottom and click next. Make sure Internet Email is selected and click next. Now type in your name, email address, incoming mail server, outgoing mail server, and login information. Click on more settings and tick the first option in...
Video game systems are always evolving, and smart gamers like to make sure they have the most recent one.
In this Software video tutorial you will learn how to link tasks in Microsoft Project 2007. There are four ways to link a task. Finish to start is the default, then you have start to start, finish to finish and start to finish. Here you will see how to link up two tasks and what is the dependency between them. There are various methods of creating dependency between two tasks. One method is to select the two tasks and click on the ‚Äòlink tasks‚Äô button on the tool bar or you can go to the ‚...
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 306th installment in their series of digital spreadsheet magic tricks, you'll learn how to use MCONCAT & LOOKUP functions to lookup values from a table and add results. Also see a formula that uses exponents instead of the MCONCAT concatenation function to look up and sum table values.
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 204th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and EXACT functions in an array formula to add the sales for a sales representative where lower and upper letters matter (i.e., are case sensitive) in the criteria (conditions).
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 192nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the middle name in quotes from a cell that has last, middle and first name using Excel's in-built text-to-column tool.
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 173rd installment in their series of digital spreadsheet magic tricks, you'll learn how to show negative time with the "Use 1904 date system" as well as how to create a formula that will show the time over or under a given hurdle.
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 145.75th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGEIF (AVERAGE IF) function to create a formula that will calculate the average when you have more than 1 criterion.
