Applying conditional formatting across rows | Excel tips | lynda.com

About this tutorial: Video duration: 6:54 Learn how to apply conditional formatting across rows in Excel. Watch more Excel tutorials at This tutorial is from the Excel Tips Weekly series presented by lynda.com author Dennis Taylor. The complete course is a weekly series that offers a new Excel tip every Tuesday on topics such as […]

Excel 2013 tutorial: Applying border styles and adjusting gridlines | lynda.com

About this tutorial: Video duration: 4:30 One way to spotlight cells with important data in your Excel spreadsheets is to style their borders. In this tutorial, find out how to work with border styles and modify the appearance of gridlines. Watch more at This tutorial is a single movie from the Excel 2013: Advanced Formatting […]

Using date and time as metrics in a PivotTable | Excel Tips | lynda.com

About this tutorial: Video duration: 7:4 Learn how to use one of the greatest strengths of PivotTables: their ability to analyze both date and time. Watch more Excel tutorials at This tutorial is from the Excel Tips Weekly series presented by lynda.com author Dennis Taylor. The complete course is a weekly series that offers a […]

TREND and GROWTH functions | Excel Tips | lynda.com

About this tutorial: Video duration: 6:5 Learn how to add trendlines to charts, explore the trendline options, and use the TREND and GROWTH functions to predict future results in Microsoft Excel. Watch more Excel tutorials at This tutorial is from the Excel Tips Weekly series presented by lynda.com author Dennis Taylor. The complete course is […]

Using slicers with table data for richer filtering tools | Excel tips | lynda.com

About this tutorial: Video duration: 5:34 Learn how to make sense of your spreadsheet data. This tutorial shows how to use slicers in order to examine specific portions of your dataset. Watch the follow-up movies within this series at This specific tutorial is from the Excel Tips Weekly series presented by lynda.com author Dennis Taylor. […]

Custom grouping in PivotTables | Excel tips | lynda.com

About this tutorial: Video duration: 4:42 Excel PivotTables help you group and summarize your data quickly and easily. Learn about how to work with PivotTables in this tutorial. Watch the follow-up movies within this series at This specific tutorial is from the Excel Tips Weekly series presented by lynda.com author Dennis Taylor. The complete course […]

Using scroll bars and spin buttons in forms | Excel Tips | lynda.com

About this tutorial: Video duration: 10:12 Learn how to incorporate two popular form controls—scroll bars and spin buttons—into your Excel forms and charts. Watch more Excel tutorials at This tutorial is from the Excel Tips Weekly series presented by lynda.com author Dennis Taylor. The complete course is a weekly series that offers a new Excel […]

Looking up information with VLOOKUP and HLOOKUP | Excel | lynda.com

About this tutorial: Video duration: 4:18 Learn how to look up information with VLOOKUP and HLOOKUP in Excel. Watch more Excel tutorials at This tutorial is from the Excel 2013 Tutorials: Advanced Formulas and Functions course presented by lynda.com author Dennis Taylor. In the complete course, Dennis demystifies some of the most challenging of the […]

Excel 2013 tutorial: Choosing a chart layout with the Quick Layout option | lynda.com

About this tutorial: Video duration: 3:35 Sometimes you may not know which kind of chart will best display your data. In this tutorial, find out how to preview different kinds of charts on the fly using the Quick Layout option in Excel 2013. Watch more at This tutorial is a single movie from the Excel […]

Excel 2013 tutorial: Using column and bar charts | lynda.com

About this tutorial: Video duration: 8:57 In this tutorial, find out how to control your column and bar charts in Excel 2013. Watch more at This tutorial is a single movie from the Excel 2013: Charts in Depth course presented by lynda.com author Dennis Taylor. The complete course is 3 hours and 46 minutes, and […]

Quick formatting tips | Excel tips | lynda.com

About this tutorial: Video duration: 8:20 Increase your efficiency in Excel! Dennis Taylor shows you various shortcuts for formatting in this tutorial. Watch the follow-up movies within this series at http://www.lynda.com/Excel-tutorials/Excel-Tips/363001-2.html?utm_campaign=sTeDIu8mF74&utm_medium=social&utm_source=youtube-earned This specific tutorial is from the Excel Tips Weekly series presented by lynda.com author Dennis Taylor. The complete course is presented as a weekly […]

Excel formula tutorial: Working with ROUND, ROUNDUP, and ROUNDDOWN | lynda.com

About this tutorial: Video duration: 6:39 With ROUND, ROUNDUP, AND ROUNDDOWN you can increase the accuracy of your data. Find out how to use these functions in this tutorial. Watch more at http://www.lynda.com/Excel-tutorials/Excel-2013-Advanced-Formulas-Functions/126129-2.html?utm_campaign=CzEIydjuifg&utm_medium=viral&utm_source=youtube. This tutorial is a single movie from the Excel 2013: Advanced Formulas and Functions course presented by lynda.com author Dennis Taylor. The […]

Excel formula tutorial: Working with ROUND, ROUNDUP, and ROUNDDOWN | lynda.com

About this tutorial: Video duration: 6:39 With ROUND, ROUNDUP, AND ROUNDDOWN you can increase the accuracy of your data. Find out how to use these functions in this tutorial. Watch more at http://www.lynda.com/Excel-tutorials/Excel-2013-Advanced-Formulas-Functions/126129-2.html?utm_campaign=CzEIydjuifg&utm_medium=viral&utm_source=youtube. This tutorial is a single movie from the Excel 2013: Advanced Formulas and Functions course presented by lynda.com author Dennis Taylor. The […]

Excel formula tutorial: How to use COUNTIF, SUMIF, or AVERAGEIF functions lynda.com

About this tutorial: Video duration: 5:43 If you’re trying to tabulate data from large lists, you’ll want to use either the COUNTIF, SUMIF, or AVERAGEIF functions in Excel. Find out how to use these functions in this tutorial. Watch more at http://www.lynda.com/Excel-tutorials/Excel-2013-Advanced-Formulas-Functions/126129-2.html?utm_campaign=YqF62MDY7ts&utm_medium=viral&utm_source=youtube. This tutorial is a single movie from the Excel 2013: Advanced Formulas and […]

Excel formula tutorial: Working with ROUND, ROUNDUP, and ROUNDDOWN | lynda.com

About this tutorial: Video duration: 6:39 With ROUND, ROUNDUP, AND ROUNDDOWN you can increase the accuracy of your data. Find out how to use these functions in this tutorial. Watch more at http://www.lynda.com/Excel-tutorials/Excel-2013-Advanced-Formulas-Functions/126129-2.html?utm_campaign=CzEIydjuifg&utm_medium=viral&utm_source=youtube. This tutorial is a single movie from the Excel 2013: Advanced Formulas and Functions course presented by lynda.com author Dennis Taylor. The […]

Calculating with hours, minutes, and time of day | Excel Tips | lynda.com

About this tutorial: Video duration: 11:13 Learn how to use Microsoft Excel to calculate differences not just between dates, but times: hours, minutes, and seconds. Watch more Excel tutorials at http://www.lynda.com/Excel-tutorials/Excel-Tips/363001-2.html?utm_campaign=5uqkrzkEXCU&utm_medium=social&utm_source=youtube-earned This tutorial is from the Excel Tips Weekly series presented by lynda.com author Dennis Taylor. The complete course is a weekly series that offers […]

Using check boxes and conditional formatting together for dynamic displays | Excel Tips | lynda.com

Learn how to highlight data in your Excel spreadsheets with checkboxes and some conditional formatting. Watch more Excel tutorials at http://www.lynda.com/Excel-tutorials/Excel-Tips/363001-2.html?utm_campaign=uYxotKfjarw&utm_medium=social&utm_source=youtube-earned This tutorial is from the Excel Tips Weekly series presented by lynda.com author Dennis Taylor. The complete course is a weekly series that offers a new Excel tip every Tuesday on topics such as […]

Top 5 unknown but useful keyboard shortcuts | Excel tips | lynda.com

In this tutorial, learn 5 helpful keyboard shortcuts in Excel, for tasks such as toggling the Ribbon on and off, getting a quick print preview, and viewing only visible cells. Watch the follow-up movies within this series at http://www.lynda.com/Excel-tutorials/Excel-Tips/363001-2.html?utm_campaign=ffNFBqXFx9o&utm_medium=social&utm_source=youtube-earned This specific tutorial is from the Excel Tips Weekly series presented by lynda.com author Dennis Taylor. […]