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 11th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate asset turnover, capital intensity, inventory turnover, days to sell inventory, receivable turnover, days to collect accounts receivab...
You'll need to use lots of math if you're working with formulas and numbers in Microsoft Excel. This tutorila gives you a brief introduction to the different math operators avaiable to users of Excel, as well as reviewing the order of operations you'll need to be aware of.
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 723rd installment in their series of digital spreadsheet magic tricks, you'll learn how to avoid errors with the COUNTIF function when using workbook references by using the SUMPRODUCT 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 715th installment in their series of digital spreadsheet magic tricks, you'll learn how to take a number with spaces, remove spaces and convert text to number using the SUBSTITUE function and plus zero.
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 calculate hours worked while subtracting time spent at lunch.
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 721st installment in their series of digital spreadsheet magic tricks, you'll learn how to to go from a time of 0655 to 06:55 AM with the TEXT 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 703rd installment in their series of digital spreadsheet magic tricks, you'll learn how to filter with 6 criteria then extract records to a new location.
Converting an Excel spreadsheet to a single PDF file is quite easy, even if there are multiple worksheets in your document. This tutorial even demonstrates a common Excel error and how adjust your program's dpi settings to avoid double spooling.
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...
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 646th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to add a column of categories using the VLOOKUP, RIGHT, LEN and SEARCH functions.
In this video tutorial, viewers learn how to disable the quick fill handle and drag and drop option in Microsoft Excel. This task is very easy, simple and fast to do. Begin by clicking on the Office button and click on Excel Options at the bottom. Then click on the Advanced tab and deselect "Enable fill handle and cell drag and drop" option under Editing Options. Finish by clicking on OK. This video will benefit those viewers who use Microsoft Excel for their work, and would like to learn how...
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 630th installment in their series of digital spreadsheet magic tricks, you'll learn how to copy formula through a huge range using keyboard shortcuts.
Not only is Microsoft Office Excel handy for drafting documents, it can also be used to make simple illustrations. Quite easily at that. The program's drawing tools are so easy to utilize, in fact, that this free video software tutorial can present a complete overview of the process in just under four minutes' time. For detailed instructions, as well as to get started doodling in your own Excel workbooks, take a look.
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 611th installment in their series of digital spreadsheet magic tricks, you'll learn how to create an array formula to summarize year over year sales using the SUMPRODUCT and YEAR functions. Also see how to calculate a formula for percentage change.
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 89.5th installment in their series of digital spreadsheet magic tricks, you'll learn how to use absolute and relative macros in concert with one another.
Looking for a primer on how to calculate child support payments in a Microsoft Excel spreadsheet? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, you'll learn how to do just that. For more information, including detailed instructions on how to find child support payment amounts yourself, watch this helpful how-to.
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 22nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use VBA code for conditional formatting as well as how to do it using the OFFSET, MOD and ROWS functions.
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 20th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to summarize survey data with a pivot table (grouping & report filter), COUNTIFS function (4 criteria), SUMPRODUCTS formula, SUMPRODUCTS & TEXT functions and DCOUNT database 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 and Mr. Excel, the 5th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create horizontal subtotals for a data set using the IF, SUM and SUMIF functions. Also see conditional formatting for non-contiguous cell ranges using a TRUE/FALSE logical formula with the NOT symbols.
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 270000000000000000000000000000000th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use custom number formatting for cells and the TEXT function. Specifically, this lesson covers the following:
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 26th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use spreadsheet construction guidelines to fix common problems:
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 3rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to name a range of cells; how to use names in formulas;
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 21st installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to add conditional formatting to data bars and icons to show relative size, icons to show relative size, to highlight values within 1 standard deviation, to highli...
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 22nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create a budget with formula inputs in an assumption area and formulas. Then do what-if analysis by saving and showing scenarios. Also see how to save variables...
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:
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 11th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use comparative operators; logical TRUE/FALSE formulas, IS functions (ISTEXT, ISNUMBER, ISBLANK, ISERROR, ISNONTEXT); IF functions (1 of 2 words in a cell, 1 of...
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 11th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to transform bad data into useful data using formulas and text functions such as TRIM, PROPER, SUBSTITUTE, REPLACE, FIND and LEFT. Also see how to use the ampersan...
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 7th installment in his "Excel Formula Efficiency" series, you'll learn about the SUMIFS function and how it blows SUMPRODUCT away when it comes to calculation speed.
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 7th installment in his "Excel Formula Efficiency" series, you'll learn how to use a helper cell to remove a time-consuming (expensive) section of your formula to speed up calculations.
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 7th installment in his "Excel Formula Efficiency" series, you'll see how a helper column with concatenated fields can dramatically reduce the time a formula takes to calculate.
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 7th installment in his "Excel Formula Efficiency" series, you'll learn how to count unique records with a formula with a helper column to speed up calculations.
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.
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 10th installment in his "Excel Formula Efficiency" series, you'll learn how to use Manual Calculation for huge spreadsheets so that recalculation only occurs when you want it to occur.
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 84th installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma is NOT known using the Descriptive Statistics data analysis add-in.
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 339th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT function to add the difference between two columns of numbers based on two criteria.
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 48th installment in his "Excel Business Math" series of free video lessons, you'll learn about the basics of markup on cost and markup on selling price. Markup on cost uses the base cost. Markup on selling price uses the base selling price.
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 32nd installment in his "Excel Business Math" series of free video lessons, you'll learn how to solve simple markup (mark-up) & markdown (mark-down) business math problems.
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 38th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the RANK and PERCENTRANK functions as well as the Data Analysis add-in's Rank & Percentile tools.
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 54th installment in his "Business Math" series of free video lessons, you'll learn how to solve a simple interest loan problem for part, base, or rate.
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.
