In this clip, you'll learn how to use the Ribbon and Backstage View 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.
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.
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 683rd installment in their series of digital spreadsheet magic tricks, you'll learn how to count with Boolean criteria in Excel 2010.
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 685th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the MOD and ROW functions for applying formating to every other row in your chart.
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 681st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the MIN and IF functions to find smallest number that is greater than zero in an 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 682nd installment in their series of digital spreadsheet magic tricks, you'll learn how to to average times values that were exported from a database as text values instead of number 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 663rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to add or average while ignoring #N/A errors in hidden rows.
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 672nd installment in their series of digital spreadsheet magic tricks, you'll learn how you can use the non-Ctrl+Shift+Enter function AGGREGATE in place of SMALL in an 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 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.
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 660th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract a unique list from a data set using Advanced Filter.
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 648th installment in their series of digital spreadsheet magic tricks, you'll learn see the functions ROWS, COLUMNS, and CHAR in a formula that will create a data set.
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 649th installment in their series of digital spreadsheet magic tricks, you'll learn see how to increment a number pattern using the INT, ROW and ROWS functions and the act of dividing by 3.
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 651st installment in their series of digital spreadsheet magic tricks, you'll learn see how use all the different comparative operators for logical formulas (TRUE/FALSE).
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 654th installment in their series of digital spreadsheet magic tricks, you'll learn see when to use line charts and when to use an X-Y scatter diagrams.
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 656th installment in their series of digital spreadsheet magic tricks, you'll learn see how to use the Speak Cells on Enter 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 645th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CUMIPMT function to calculate the total interest paid for two different loans.
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 641st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a PivotChart based on a PivotTable in one click.
See how to use VBA to write a value to a cell within a Microsoft Excel workbook. Whether you're new to Microsoft's popular digital spreadsheet application, new to Visual Basic for Applications (VBA) or merely new to using the two in tandem, you're sure to benefit from this free video software tutorial from the folks at Lynda. For more information, including detailed, step-by-step instructions, 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 638th installment in their series of digital spreadsheet magic tricks, you'll learn how to add two horizontal axes to a chart.
Learn how to keep track of cash on hand via special table in your MS Excel 2010 workbooks. 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, and to get started tracking cash for your own budgets, take a look.
Learn how to freeze panes when working within Microsoft 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, and to get started freezing panes in your own Excel 2010 projects, watch this free video guide.
Learn how to add numbers using the SUM and AutoSUM functions within Microsoft 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, and to get started using the SUM and AutoSUM functions in your own Excel projects, watch this free video guide.
Learn how to use the Backstage view option when working in Microsoft 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, and to get started using the Backstage view and File tab in your own Excel projects, watch this free video guide.
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 619th installment in their series of digital spreadsheet magic tricks, you'll see how spaces in cells cause trouble in formulas and learn how to use the REPLACE, COUNTIF, CLEAN & TRIM functions to solve space-related formula problems.
Learn how to take full advantage of MS Excel 2010's collaboration features. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2010, you're sure to be well served by this video tutorial. For more information, and to get started using SharePoint to share your own Excel 2010 worksheets, watch this free video guide.
Learn how to customize the Ribbon Bar MS Excel 2010. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2010, you're sure to be well served by this video tutorial. For more information, and to get started using your own custom Ribbon Bar layout within MS Excel 2010, watch this free video guide.
Learn how to work with digital images within MS Excel 2010. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2010, you're sure to be well served by this video tutorial. For more information, and to get started editing pictures in your own 2010 worksheets, watch this free video guide.
Learn how to store, use and manipulate equations in MS Excel 2010. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2010, you're sure to be well served by this video tutorial. For more information, and to get started using mathematical equations and formulas in your own 2010 worksheets, watch this free video guide.
Learn how to copy and move sheets in MS Excel 2007. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to be well served by this video tutorial. For more information, and to get started manipulating your own Excel 2007 worksheets, watch this free video guide.
Learn how to get get around worksheets in MS Excel 2007. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to be well served by this video tutorial. For more information, and to get started navigating Excel 2007 worksheets yourself, watch this free video guide.
Learn how to create linkage formulas in MS Excel 2007. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to be well served by this video tutorial. For more information, and to get started using linkage formulas in your own 2007 workbooks, watch this free video guide.
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 604th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a budgeted income statement that utilized mixed cell references.
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 607th installment in their series of digital spreadsheet magic tricks, you'll learn how to match three lists using 2 VLOOKUP functions and the AND 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 599th installment in their series of digital spreadsheet magic tricks, you'll learn how to ROUND only the total column using a SUM & ROUND function 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 600th installment in their series of digital spreadsheet magic tricks, you'll learn how to convert between days and hours using Excel's MOD & INT 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 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.
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.
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 596th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SERACH, ISNUMBER and SUMPRODUCT functions to count with 4 criteria including an all criteria option.
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 17th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create 5 formulas to count times greater than five minutes using Excel's COUNTIF and TIME 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 6th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to retrieve the last value in a row.