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 30th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the SUMIF function to add with one criteria, the RANK function to rank highest values to lowest values (one to five) and the IF function to assign a bo...
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 8th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to add across sheets using 3-D cell References and the SUM function.
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 count unique records with a formula with a helper column to speed up calculations.
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 24th installment in his "Excel Business Math" series of free video lessons, you'll learn how to build a table of decimal, fraction and percent equivalents. See how fractional formatting can be misleading.
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 5th installment in his "Excel Business Math" series of free video lessons, you'll learn how to use Excel's built-in SUM, AVERAGE, PRODUCT, LCM, QUOTIENT and MOD functions.
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 58th installment in his "Excel Business Math" series of free video lessons, you'll learn how to make simple value calculations for the present.
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 35th installment in his "Excel Business Math" series of free video lessons, you'll learn how to calculate the service charge for a checking account and see how to create a formula for the balance in a checkbook or checking register.
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 34th installment in his "Excel Business Math" series of free video lessons, you'll learn how to work with the various elements of bank checks 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 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 45th installment in his "Business Math" series of free video lessons, you'll learn when to solve a trade discount word problem with 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.
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 142nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a complex array formula that counts weekends between two dates with the SUM, IF WEEKDAY, ROW and INDIRECT 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, the 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic, two-way IF function lookup formula for pulling data from a different Workbook.
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.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 73rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add custom number formatting in the format cells dialog box for 00001, 09745 and 989-85-1253. 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 62nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP and INDIRECT functions to look up values from different tables. 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 50th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create a basic macro and then assign the macro to a form button. 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 43rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn use a data validation drop-down list to change conditional formatting in a table. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office 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, the 504th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the borders tab in the Format Cells dialog box to create a 3D effect.
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 501st installment in their series of digital spreadsheet magic tricks, you'll learn how to work with time in Excel, making calculations and formatting temporal 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 507th installment in their series of digital spreadsheet magic tricks, you'll learn how to take badly setup data (not in database/table format) and summarize it by date and shipping name into table format report.
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 517th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX and MATCH functions to show vendor name associated with lowest bid.
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 524th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records with partial text NOT criteria via filter, advanced filter & array 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 529th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT and COUNTIFS functions to count how many sales you made for a given product over the last 7 days.
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 531st installment in their series of digital spreadsheet magic tricks, you'll learn how to extract numbers from the middle of a text string (e.g., BB34G) becomes 34.
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 535th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the NETWORKDAYS, NETWORKDAYS.INTL, WEEKDAY, ROW, INDIRECT and SUMPRODUCT functions to count weekdays including half (1/2) workdays.
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 556th installment in their series of digital spreadsheet magic tricks, you'll learn how to change the source data for a pivot table (PivotTable).
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 555th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF and VLOOKUP functions to make one of two types of commission calculations based on what is put in the referral column.
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 551st installment in their series of digital spreadsheet magic tricks, you'll see a great non-array formula for counting Mondays between a start and end date.
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 566th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF functions and a bar chart to create a conditionally formatted chart for students scores that exceed 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 258th installment in their series of digital spreadsheet magic tricks, you'll learn how to make charts from noncontiguous data 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 360th installment in their series of digital spreadsheet magic tricks, you'll see an array formula that looks up one value and returns multiple items.
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 145th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will calculate the standard deviation when you have more than 1 criterion.
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 269th installment in their series of digital spreadsheet magic tricks, you'll learn how to get criteria from four (4) different cells and combine (join) them into one criterion for the COUNTIF 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 187th installment in their series of digital spreadsheet magic tricks, you'll learn two different array formula types for creating a unique list of items for a large list containing duplicates.
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 389th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a ctrl-period keyboard shortcut to quickly move the active cell in a selected range.
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 384th installment in their series of digital spreadsheet magic tricks, you'll learn how to use an easy go-to/enter keyboard shortcut trip that will allow you to highlight 1000 (100x100) cells.
Want to move quickly from indoor to outdoor shooting environments without having to futz with the manual controls on your video camera to adjust for the disparate light levels? If so, you should give your camera's automatic exposure feature a whirl. For more information on using your digital camera's auto exposure tool, watch this free cinematographer's guide.
