Catalog Search Results
Author
Pub. Date
2019.
Language
English
Description
Learn the basics of charts and graphs in Excel. Find how to create engaging data visualizations with these simple Excel chart tips.
Learn the basics of Excel charts and graphs in this concise course. Excel expert Dennis Taylor begins by explaining Excel chart concepts, including identifying the different elements of a chart and choosing the right chart type. Next, Dennis walks through creating a basic chart, using the Recommended Charts feature and...
Author
Pub. Date
2023.
Language
English
Description
Learn powerful tips, tricks, and shortcuts from Excel trainer and popular instructor Dennis Taylor.
Want to take your Excel game to the next level? In this course, veteran Excel trainer and instructor Dennis Taylor shares powerful tips, tricks, and shortcuts that can help you leverage more of what Excel has to offer. Learn time-saving tricks for creating formulas rapidly, accelerating data entry, and navigating within worksheets efficiently. Plus,...
Author
Pub. Date
2016.
Language
English
Description
Learn how to create efficient formulas and use some of the 450+ functions in Excel to tabulate and analyze numerical, date, and text data.
Excel expert Dennis Taylor demystifies some of the most useful of the 450+ formulas and functions in Excel and shows how to put them to their best use. Dennis starts with a review of the more basic functions (SUM, AVERAGE, and MAX), and a few critical keyboard shortcuts that will let you locate and display formula...
Author
Pub. Date
2016.
Language
English
Description
Learn easy-to-use commands, features, and functions for managing and analyzing large amounts of data in Excel 2016.
Large amounts of data can become unmanageable fast. But with the data management and analysis features in Excel 2016, you can keep the largest spreadsheets under control. In this course, Dennis Taylor shares easy-to-use commands, features, and functions for maintaining large lists of data in Excel. He covers sorting, adding subtotals,...
Author
Pub. Date
2020.
Language
English
Description
Learn how to use conditional formatting to spot trends and emphasize key results in Microsoft Excel.
Conditional formatting sounds more complicated than it is. This powerful tool in Microsoft Excel allows you to highlight data based on cell contents, making it easy to spot trends and patterns and emphasize key results. Though this process can be quick and easy, many Excel users don't know how to use conditional formatting to its fullest potential....
Author
Pub. Date
2016.
Language
English
Description
Save time by automating repetitive tasks with Excel macros. Learn how to record, edit, and run simple macros, and program more complex macros with VBA.
Macros can help you save enormous amounts of time, but they are uncharted territory for many Excel users. Learn how to create your own simple macros to automate repetitive tasks in Excel 2016, in this course with Excel expert Dennis Taylor. Find out how to record a macro in stages, share macros between...
Author
Pub. Date
2017.
Language
English
Description
Learn how to grapple with a common Excel problem: managing large amounts of data contained in multiple worksheets and workbooks.
In this short, task-focused course, learn how to grapple with a common Excel problem: managing large amounts of data contained in multiple worksheets and workbooks. Follow Dennis Taylor as he takes you through how to move, copy, and link data across multiple worksheets. Dennis shares tips for adding, moving, and navigating...
Author
Pub. Date
2015.
Language
English
Description
Learn how to enter and organize data, create formulas and functions, build charts and PivotTables, and use other powerful Excel 2016 features.
Start mastering Excel, the world's most popular and powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables....
Author
Pub. Date
2016.
Language
English
Description
Learn how to use the data validation tools in Excel 2016 to control how users input data into workbooks and ensure data is entered consistently and accurately.
With Excel's data validation tools, you can control how users enter data into workbooks, ensuring that data is consistent and accurate. You can control dates, times, even the length of the text they enter, or simply provide a list of acceptable choices to eliminate any possible mistakes. Here,...
Author
Pub. Date
2020.
Language
English
Description
Prevent common errors from occurring in your Excel data with this short course.
If you work in Excel, you know that even a small error can have big consequences, throwing off important calculations or transmitting incorrect information to your team. In this concise course, Excel expert Dennis Taylor provides quick and easy tips to help you avoid common mistakes. Dennis begins with the basics—how to display data so that errors can be easily spotted,...
Author
Pub. Date
2016.
Language
English
Description
Get simple, powerful tips for making spreadsheet information readable and understandable in Excel 2016. Learn advanced Excel formatting techniques.
Get simple, powerful tips for making spreadsheet information readable and understandable in Microsoft Excel 2016. Dennis Taylor shows how to emphasize specific cells with fonts, borders, and color; adjust the positioning of cell contents; format numeric data; and add style and readability to worksheets....
Author
Pub. Date
2022.
Language
English
Description
Get up to speed with Microsoft Excel. Learn how to enter and organize data, build charts and PivotTables, sort data, and use other Excel features.
Get up to speed with Microsoft Excel, the world's most popular spreadsheet program. Follow along with Excel expert Dennis Taylor as he demonstrates how to efficiently manage and analyze data with this powerful program. Learn how to enter and organize data, perform calculations with simple functions, and...
Author
Pub. Date
2017.
Language
English
Description
Learn tricks and techniques for optimizing the use of dates and times in Excel 2016.
Getting dates and times to show up the way you want in an Excel spreadsheet can be tricky. In this concise course, Excel expert Dennis Taylor shares easy solutions for formatting and calculating dates and times in Excel 2016. Dennis explains what's going on behind the scenes when Excel stores dates and times, and offers tips for entering and formatting data. Next,...
Author
Pub. Date
2018.
Language
English
Description
Learn how to enter and organize data, create formulas and functions, build charts and PivotTables, and use other powerful Excel 2019 features.
Start mastering Excel, the world-renowned powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to enter data, organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of data and cells, build charts, and create PivotTables. Find out...
Author
Pub. Date
2015.
Language
English
Description
Get a new productivity-boosting tip every Tuesday from Excel expert Dennis Taylor.
This tips-based course will show Excel users productivity-boosting tricks, cool hidden features, need-to-know functions, and advanced content on subjects such as using PivotTables for data analysis. Tune in every Tuesday for a new tip from expert Dennis Taylor. Each tutorial is a short, self-contained lesson guaranteed to give you new insights into Excel. Note: Because...
Author
Pub. Date
2013.
Language
English
Description
In this series of Excel tutorials, discover some of the most challenging of the 300+ formulas and functions in Excel, and learn about how to put them to their best use.
Conquer some of the most daunting features in Microsoft Excel once and for all. In this 2013 update to his popular series, author Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use. The course...
Author
Pub. Date
2018.
Language
English
Description
Learn easy-to-use data management commands and techniques to manage and analyze large lists of data.
Large amounts of data can become unmanageable fast. But with the data management and analysis features in Excel 2016, you can keep the largest spreadsheets under control. In this course, Dennis Taylor shares easy-to-use commands, features, and functions for maintaining large lists of data in Excel. He covers sorting, adding subtotals, filtering, eliminating...
Author
Pub. Date
2019.
Language
English
Description
Explore how to add visual appeal to your spreadsheets and workbooks with this in-depth course on the powerful charting features of Microsoft Excel.
Excel charts allow you to communicate information with much more impact than raw numbers and are surprisingly easy to generate. Instructor Dennis Taylor shows you how to create different kinds of Excel charts, from column, bar, line and pie to more recently introduced types like Treemap, Funnel, and Pareto....
Author
Pub. Date
2021.
Language
English
Description
Learn how to create a simple yet powerful database using Microsoft Excel. This course covers all the steps, from preparing data to using slicers to filter data.
Did you know you can use Excel to create a simple database and get even more insights into your data? Join instructor Dennis Taylor and learn how to create a simple database. Dennis explains how to prepare lists that are suitable for data analysis. He goes into how to use the Form tool to...
Author
Pub. Date
2020.
Language
English
Description
Explore ways to save time by automating tasks with macros in Microsoft Excel.
Learn about how to use macros to automate tasks in Excel and see how to create simple macros of your own. Veteran Excel trainer Dennis Taylor shows how to record a macro in stages, share macros between workbooks, set up keyboard shortcuts to run macros quickly, and use Visual Basic for Applications (VBA) to code macros that can't be recorded. The course wraps up with a...
Didn't find it?
Can't find what you are looking for? Try our Materials Request Service. Submit Request