Microsoft Office Features
How To: Find statistical critical & p values in MS Excel
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 89th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the NORMSINV function for critical values and the NORSDIST function for p-values.
How To: Round off date and time calculations in Microsoft Excel 2010
Learn how to round dates and times to a given interval 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: Automate tasks with macros in Microsoft Access 2010
Learn how to use create macros when working in Microsoft Access 2010. Whether you're new to Microsoft's popular database management application or a seasoned MS Office professional just looking to better acquaint yourself with the Access 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using macros in your own Access projects, watch this free video guide.
How To: Avoid Ctrl+Shift+Enter for array formulas 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 666th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to avoid Ctrl + Shift + Enter for normal array formulas.
How To: Calculate excess over a hurdle 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 99th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF, MAX and the MIN functions to solve a basic problem in three different ways! See how to calculate the excess amount over a hurdle with three different methods!
How To: Apply accounting & percentage formatting in Excel
This is the fifth video in the Statistics in Excel. He gives the website address where content can be downloaded. He speaks about the different types of formatting like stylistic and number formatting. He talks about the different formats like accounting and percentage, and how to use both of them. Accounting format is nice because it lines up the decimals nicely. He shows how to apply the accounting format. The percentage format displays the value in as a percentage. He shows you how to appl...
How To: Create random basic math problems in Microsoft Excel
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 71st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create random math problems for your kids with the CHOOSE, RANDBETWEEN, DOLLAR and TEXT functions. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
How To: Create a background and watermark in Visio 2007
Take a look at this instructional video and learn how to include your company logo in the background and add a watermark in just a few quick steps with Microsoft Visio 2007. And you can reuse this background on every page in your Visio drawing.
How To: Calculate hours worked in days 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 598th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to calculate hours worked given an in time, an out time and an in and out time for the lunch break. Learn about how time in Excel is the proportion of one 24 hour day.
How To: Create a brochure in Microsoft Publisher
A simple tutorial video that demonstrates the procedure for creating a brochure quickly and easily using the Microsoft Publisher program, which is shipped as a part of the Microsoft Office Suite.
How To: Extract a unique list from a huge data set 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 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter tool with criteria to extract a unique list of employees for each department from a huge data set with transactional records.
How To: Find the largest increase in a data set in MS Excel
Looking for a primer on how to create and work with arrays in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12th installment in his series of Excel array formula series, you'll learn how to create array formulas for finding the largest improvement in sales from one year to the next.
How To: Create an AutoSum formula in Microsoft Excel 2010
Want to create an AutoSum formula in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started using AutoSum formulas in your own MS Excel '11 projects, watch the video.
How To: Use simple formulas to do math in Excel 2007
Take a look at this instructional video and learn how to use simple formulas in Microsoft Office Excel 2007 to add, subtract, multiply, and divide. For example, you can use a prewritten formula called the SUM function to find totals, such as your total monthly expenses. Excel updates the results if the numbers change later.
How To: Create a simple IF function formula with text 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 217th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a simple If function formula that uses a logical test that involves text (instead of a number).
How To: Calculate markup on cost in Microsoft Excel
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 49th installment in his "Excel Business Math" series of free video lessons, you'll learn how to make calculations for markup on cost in MS Excel.
How To: Match text substrings with an array formula 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 321st installment in their series of digital spreadsheet magic tricks, you'll learn how to match text substrings with an array formula that uses the AND, ISNUMBER and SEARCH functions.
How To: Create an Excel table in Excel 2007
First, open the Excel worksheet you have previously created that you would like to create a table for. Click on any of the cell that contains data for your table. On the menu found on the upper portion of the application, go to the Insert Tab. Find and click Table. Your entire worksheet will now be selected. When a prompt window appears, click OK. Your table should now be created automatically.
How To: Find credit for a partial invoice payment in MS Excel
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 47th installment in his "Business Math" series of free video lessons, you'll learn how to determine credit given for partial payment of an invoice.
How To: Link tasks in Microsoft Project 2007
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 ‚...
How To: Collaborate files between SharePoint and Office 2007
File collaboration is one of the best integration features between Office 2003/Office 2007 and SharePoint. These task panes allow you to access and modify content in a SharePoint site from within Office without having to navigate to the site using your browser. The feature is available in the following Office 2003 and Office 2007 applications: Word, Excel, Microsoft Project, OneNote, PowerPoint, and Visio.
How To: Use VLOOKUP queries inside of an MS Excel IF 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 588th installment in their series of digital spreadsheet magic tricks, you'll learn how to determine whether an employee is exempt from a tax using a VLOOKUP in an IF function, and if not use a second VLOOKUP lookup query to look in tax tables to look up and calculate the tax
How To: Value a stock with irregular dividend payments in Microsoft Excel
As you might guess, one of the domains in which Microsoft Excel really excels is finance 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 67th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the value of a stock with irregular dividend payments,
How To: Calculate horsepower with Excel's VLOOKUP 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 469th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a VLOOKUP query to lookup values for horsepower calculation.
How To: Use SUMPRODUCT for deposit calculations in Excel
Excel Magic Trick 475 talks about Sumproduct for bank deposit calculation. Here, the total money can be calculated by just a click. Total is taken as Sumproduct and can be obtained by clicking on the number of bills that get added to give the final checked amount. If these steps are followed, the viewers will find themselves in a new world of deposit and bill calculation
How To: Name cell ranges with relative references in MS Excel
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 8th installment in his series of Excel name tricks, you'll learn how to name cell ranges with relative cell references instead of the default absolute cell references.
How To: Create and use styles in Microsoft Office Word 2007
Want to know how to make custom styles within Word 2007? This clip will teach you everything you need to know. Whether you're new to Microsoft's popular word processor or just wish to get to know Word 2007 a little better, you're sure to find much of value in this video lesson. For more and better information, take a look.
How To: Open a MS Word 07 file by double clicking in Ubuntu
In this video tutorial, viewers learn how to open a Microsoft Word 2007 file by double-clicking it on Ubuntu 9.10. Begin by right-clicking on the file and go to Properties. Click on the Open With tab and select Use a custom command. Now type in [playonlinux --run "Microsoft Office Word 2007" and click Add. Select the custom command from the list and close the window. This video will benefit those viewers who use a Linux computer, and would like to learn how to open Microsoft Word 2007 files b...
How To: Use the archive feature in MS Outlook
Is your Outlook inbox starting to seem overwhelming? No problem! In just a few minutes you can corral that growing pile of e-mail by using the 'archive' feature. Have a look at this video and learn how to use this handy option and clean up the mess in your inbox.
How To: Find a P-Value with Excel
So you need to find the p-value for your hypothesis test. To do so, employ the spreadsheet program Microsoft Excel. Using a simple formula, you can easily determine the p-value for your tests and thereby conclude strong or weak support of the null hypothesis.
How To: Create an Excel spreadsheet to calculate your GPA
Open Microsoft Office Excel. Across the top notice letters (columns), along the sides are numbers (rows). The columns and rows can be extended by highlighting sections and right clicking and choosing the high of the row. You can also select to add a border, and change the orientation of your cells.
How To: Build a conditional average calculation table in Exel
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 583rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGEIF & IFERROR functions with absolute and mixed cell references to create a large table of conditional average calculations (averaging with criteria).
How To: Use conditional formatting for a student grading report in Microsoft Excel
If you're looking for a way to create a student report, Microsoft Excel makes it easy to create a wonderful spreadsheet with tons of information. This video shows an example of a student report being created, which has three simple items in the columns of the sheet, which are the names of the students, the marks obtained and the grades.
How To: Cross-check two lists for discrepancies 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 528th installment in their series of digital spreadsheet magic tricks, you'll learn how to check two data sets (lists & tables) to see if there are discrepancies using the MATCH and VLOOKUP functions.
How To: Create a line chart mapping blood pressure 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 361st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic two data series line chart for blood pressures.
How To: Automatically insert symbols 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 391st installment in their series of digital spreadsheet magic tricks, you'll learn how to use custom number formatting to insert symbols automatically.
How To: Sort columns in MS Excel
In this how to video, you will learn how to sort columns in Excel with the Excel Experts. This is great if you want to learn the basics of sorting in the program. First, you must have Excel installed and running. Open up a spreadsheet that needs columns to be sorted. Select the column. Go to data and sort. Click options and select left to right. Choose the row you want to use and select the order. To undo this, go to sort and change the sort order. This video offers straight forward advice fo...
How To: Create confidence intervals for proportions in Excel
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 86th installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals for proportions using NORMSINV function and other formulas.
How To: Make a coordinate plane or Venn Diagram with Excel
How to use Microsoft Excel to produce a Cartesian coordinate plane and a Venn Diagram.
How To: Calculate bonuses based on years worked 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 601st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP & IF functions to make bonus calculations based on the number of years worked.