How To: Find a p-value with Excel
This how-to-video helps to find the P-Value using MS excel function tdist. For demonstration this tutorial takes the following examples.
How To: Extract records that meet certain criteria in Excel
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. (All of this is accomplished through us...
How To: Update inventory records by formula 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 348th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to build a formula that will take invoice information for inventory quantity sold and update inventory records to show correct amount on hand (in stock).
How To: Create a simple database in Excel with a list or table
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 168th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a simple dynamic database in Excel using lists in Excel 2003 and tables in 2007.
How To: Create an in-cell dropdown menu in Excel 2003
1. Select the cell for which the dropdown menu is to be applied. 2. once the cell is selected goto DATA menu select VALIDATION.Data validation dialog box will be displayed.
How To: Create a pass-fail grade formula 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 529th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a pass-fail grading formula using the IF and AND and VLOOKUP functions.
How To: Compare two lists and extract the new values in Excel
Excel dilettantes and seasoned Microsoft Office Pros alike are sure to delight in this tip, which comes to us by way of the 540th installment of ExcelIsFun's series of Excel magic tricks.
How To: Completely hide the Ribbon menu in Excel
The instructor of this video shows you how to completely hide the ribbon, or the menu, in Excel. If you only want to partially hide the ribbon, you can use the shortcut control + F1. To completely hide the ribbon, though, go to the Visual Basic screen, hit Alt + F11. Then, go to insert, then module, and type in the macro "sub (Your name for macro)" then hit enter, then type in the code "application.executeExcel4macro''show.toolbar(""Ribbon"", false)''". To set up the code to show the ribbon a...
How To: Create a Basic Attendance Sheet in Excel
If you're a teacher in any type of school, whether it's high school, college, or middle school, it's imperative that you keep an attendance sheet. The paper and pen route can get pretty messy, and very disorganized, and that's where Microsoft Excel comes in. With this software, you can create a simple yet functional attendance sheet to keep track of your students.
How To: Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
You know that moment when you finally figure out something, but you figured it out years after you really needed it? Don't you freaking hate that?!
How To: Enter formulas in Excel with a macro
In order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, delete the contents of the cell. Press Alt + F11.
How To: Create a dynamic weekly chart in Microsoft Excel
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck.
How To: Create an Excel inventory template with running totals
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 79th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to an entire table based on the content of a cell outside the table area. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
How To: Calculate proportions and percentages in Excel
This Excel Statistics series of video shows how to calculate proportions and percentages in Microsoft Excel. This video shows how to do percentage calculations using formulas in Microsoft Excel. To make a formula for a percentage, you need to first make a formula to calculate the total sum of objects you are going to use. To do that, use the sum formula. Now, divide the current object's value with the previously generated sum formula, which gives you the frequency. When you multiply this by 1...
How To: Compare two lists in Excel with match, join and filter
Need to compare two datasets and extract the new values? In this the 539th installment of ExcelIsFun's series of Excel magic tricks, you'll see how to use the MATCH function, the Join Symbol (& Ampersand), and the Filter feature to check two 2 lists of transactoinal records and extract only the new records (records that are in new list but not in old list).
How To: Create a relative frequency distribution 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 14th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create relative & percent & frequency distributions with formulas for categorical data. See, too, how to create a per...
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: Remove empty space when converting an Excel file to a PDF document
When converting an Excel file to an Adobe PDF document, you might sometimes accidentally export several pages of empty space. This tutorial briefly explains how to use the Acrobat program to convert your spreadsheet or worksheet to PDF format and avoid the blank gaps.
How To: Create a scatter diagram for 2 variables 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 30th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a scatter diagram for 2 quantitative variables.
How To: Find the sample size for confidence intervals 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 87th installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate sample size (n) for confidence intervals.
How To: Use the IF function with letter grades in Excel
This six-minute tutorial shows you how to use the logical IF function with letter grades in Excel. The video features a sample table with a sample assigned grading scheme ranging from A to F, which is a common application of the logical IF statement in Excel. After the data is added to your Excel table, use the IF function in the respective cell or column by inputting the logical test, the value if the test is true, and the value if the test is false. In addition to showing you how to use the...
How To: Clear data & cell contents in Excel using a macro
In order to clear the cell content in Excel, using a macro, you will first need to have a table. If you don't already have a spreadsheet, you will need to create one with random numbers. Next, highlight some numbers, by clicking one box and dragging in order to select a number of boxes. Click Alt + F11.
How To: Do bank reconciliation 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 37th installment in his "Excel Business Math" series of free video lessons, you'll learn how to do bank reconciliation when accounting in Microsoft Excel.
How To: Graph the probability density function in an Excel file
One of Microsoft Excel's capabilities is to allow you to graph Normal Distribution, or the probability density function, for your busines. This is a quick and easy tracking feature you can learn in just a few minutes.
How To: Conditionally format at every change in value in Excel
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this tutorial from ExcelIsFun, the 474th installment in their series of digital spreadsheet magic tricks, you'll learn how to conditionally highlight every last value in a data set or each value which differs from the value preceding it.
How To: Create a multiuser login system in Microsoft Access
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating a multi-user login form to password protect different areas of your database.
How To: Find critical values with T functions 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 91st installment in his "Excel Statistics" series of free video lessons, you'll learn how to use TINV and TDIST functions to find critical values given an unknown sigma value.
How To: Link two (multiple) workbooks & cells in Excel
In this tutorial, we learn how to link two workbooks and cells in Excel. First, save both of the files that you want to link together. Make sure you only have one Excel window open, then double click the other Excel file, don't open separately. Next, type in the equals sign into the "A" column, then to go the window menu and you will be able to see all the Excel files currently open. Now, click "link" and you will be taken back to the original worksheet. Now, you will be linked to the other n...
How To: Print double-sided and reverse printing order in Word
Learn how to print double-sided and reverse printing order in Microsoft Word. * Go to the Start menu and open Microsoft Word.
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: Calculate income tax payroll deductions 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 42nd installment in his "Excel Business Math" series of free video lessons, you'll learn about the wage bracket and percentage methods for calculating federal income tax payroll deductions.
How To: Allow only Monday dates in a cell 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 593rd installment in their series of digital spreadsheet magic tricks, you'll learn how to add data validation to allow only Monday dates in a cell using the custom option and the WEEKDAY function.
How To: Create an Excel pivot table with 4-variable tabulation
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 216th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a pivot table (PivotTable) with 4-variable cross tabulation. Learn to use multiple fields in a pivot table with this free video tutorial.
How To: Make credit card calculations with 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 36th installment in his "Excel Business Math" series of free video lessons, you'll see how to make credit card calculations using the ROUND function.
How To: Calculate total savings in Excel
This video will show you how to calculate the total savings on a transaction where there are two percentage series discounts and two dollar discounts. This video shows frugal bargain hunters how to simplify with an Excel sheet and find the total saving percentage. It teaches functions that can be used in the Excel sheet, plus useful tweaks and formulas.
How To: Use the auto-complete feature in MS Office Excel 2007
Microsoft Office Excel 2007 Tip - Using Formula Auto-Complete - Microsoft® Office Excel® 2007 is truly at its best when it's working hard behind the scenes to execute complex calculations, working with any of a number of standard formulas. When we're creating spreadsheets, formulas should be easy to replicate again and again, but human error can sometimes get in the way.
How To: Create a line chart in Microsoft Excel 2011
Want to generate a line chart 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 creating and using line charts to visualize data in your own MS Excel '11 projects, watch the video.
How To: Preview & review your presentation in Powerpoint 2007
Now that you've created your presentation, you want to make sure it's ready for your audience. This Microsoft Office PowerPoint 2007 tutorial shows you how to preview a presentation on your own computer to make sure it looks as you expect; check the spelling; and make comments on the slides if you want colleagues to review the show first. It steps you through preparing speaker notes and printing handouts.
How To: Create navigation forms in Microsoft Access 2010
David Rivers shows us how to create navigation forms in Microsoft Office 2010 without writing codes or using logic. A navigation form is kind of like a homepage that will give you a list of reports. There are pre-designed layouts you can choose from to make your navigation form. You will just need to customize your form by adding reports to the navigation pane. What this means for business owners is that you can see customer orders and store reports just by looking at one page. Simple to make...
How To: Create a dynamic equation system 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 Excel tutorial from ExcelIsFun, the 263rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a completely dynamic math equation system (function of x) with formulas, data points, charts and chart labels.
Next Page
Prev Page