Excel 2013 Tables, Filters & Functions
A 17-part course with SONIC Performance Support
Start Free Preview Start CourseCourse Overview
Teacher
SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training,... View ProfileDetails
- Total Time 1 hr, 30 min
- Lessons 17
- Attachments 15
- Exercises 34
-
53 CQ
17 Lessons in This Course
-
6 minFREEMicrosoft Office lesson 1Free4 CQ
Learn how to create concise and descriptive range names for improving the readability and maintainability of formulas and functions in Excel 2013.
Learn how to create concise and descriptive range names for improving the readability and maintainability of formulas and functions in Excel 2013.
-
3 minMicrosoft Office lesson 22 CQ
Range names are key to keeping your data organized and readable in Excel. In this lesson, learn how to use the Name Manager to edit cell range names.
Range names are key to keeping your data organized and readable in Excel. In this lesson, learn how to use the Name Manager to edit cell range names.
-
6 minMicrosoft Office lesson 34 CQ
In this lesson, learn how to improve your Excel workbook readability by performing calculations with range names instead of using cryptic cell addresses.
In this lesson, learn how to improve your Excel workbook readability by performing calculations with range names instead of using cryptic cell addresses.
-
4 minMicrosoft Office lesson 43 CQ
Adding notes to worksheets can help prevent confusion when working as a team. In this lesson, learn how to create, modify, and delete comments in Excel.
Adding notes to worksheets can help prevent confusion when working as a team. In this lesson, learn how to create, modify, and delete comments in Excel.
-
6 minMicrosoft Office lesson 54 CQ
Counting can be surprisingly tricky in Excel if you don't know which function to use. In this lesson, learn about the COUNT, COUNTA, and COUNTIF functions.
Counting can be surprisingly tricky in Excel if you don't know which function to use. In this lesson, learn about the COUNT, COUNTA, and COUNTIF functions.
-
4 minMicrosoft Office lesson 63 CQ
To improve the readability of text in Excel, you'll have to combine multiple cells into one with concatenate. Learn how to use this function in this lesson.
To improve the readability of text in Excel, you'll have to combine multiple cells into one with concatenate. Learn how to use this function in this lesson.
-
4 minMicrosoft Office lesson 73 CQ
Learn about Excel's VLOOKUP and HLOOKUP functions, and see how to use the powerful VLOOKUP function to find data based on very specific criteria.
Learn about Excel's VLOOKUP and HLOOKUP functions, and see how to use the powerful VLOOKUP function to find data based on very specific criteria.
-
4 minMicrosoft Office lesson 83 CQ
This lesson demonstrates the steps of turning raw data into a table in Microsoft Excel, and how to modify and customize the table with different styles.
This lesson demonstrates the steps of turning raw data into a table in Microsoft Excel, and how to modify and customize the table with different styles.
-
3 minMicrosoft Office lesson 92 CQ
Want to view your data from lowest to highest, or vice versa? In this lesson, learn how to use Excel's sort feature to arrange data according to your needs.
Want to view your data from lowest to highest, or vice versa? In this lesson, learn how to use Excel's sort feature to arrange data according to your needs.
-
2 minMicrosoft Office lesson 102 CQ
By filtering data, you can remove from view any data that does not meet certain criteria. In this lesson, learn how to use Excel's powerful AutoFilter tool.
By filtering data, you can remove from view any data that does not meet certain criteria. In this lesson, learn how to use Excel's powerful AutoFilter tool.
-
5 minMicrosoft Office lesson 113 CQ
Learn how to use the Advanced Filter dialog in Excel, which allows you to create complex data filters with a variety of user-defined conditions.
Learn how to use the Advanced Filter dialog in Excel, which allows you to create complex data filters with a variety of user-defined conditions.
-
5 minMicrosoft Office lesson 123 CQ
With the Total Row tool, you can indicate what type of summary calculation you’re looking for in your table. Learn how to add Total Rows in this lesson!
With the Total Row tool, you can indicate what type of summary calculation you’re looking for in your table. Learn how to add Total Rows in this lesson!
-
3 minMicrosoft Office lesson 132 CQ
You don't have to remove duplicate data by hand! In this lesson, learn how to use Excel's duplicate identification and deletion function to clean your data.
You don't have to remove duplicate data by hand! In this lesson, learn how to use Excel's duplicate identification and deletion function to clean your data.
-
7 minMicrosoft Office lesson 144 CQ
A pivot table is a dynamic table that enables you to reposition columns and rows of raw data. Learn pivot table basics in Excel 2013 to get started!
A pivot table is a dynamic table that enables you to reposition columns and rows of raw data. Learn pivot table basics in Excel 2013 to get started!
-
7 minMicrosoft Office lesson 154 CQ
In this lesson, learn how to adjust your field settings and apply sorting options to your Excel Pivot Table to help understand your data even better.
In this lesson, learn how to adjust your field settings and apply sorting options to your Excel Pivot Table to help understand your data even better.
-
5 minMicrosoft Office lesson 163 CQ
Slicers allow you to filter data in Pivot Tables and Pivot Charts based on user selections. In this lesson, learn how to use this data management tool.
Slicers allow you to filter data in Pivot Tables and Pivot Charts based on user selections. In this lesson, learn how to use this data management tool.
-
7 minMicrosoft Office lesson 174 CQ
Learn how to make sense of your data with Pivot Charts, which are interactive and allow you to filter data by selecting filters either directly or via slicers.
Learn how to make sense of your data with Pivot Charts, which are interactive and allow you to filter data by selecting filters either directly or via slicers.
-
1172 min11-part Microsoft Office course41 CQ
If you aren't familiar with Excel, you may not know how to take advantage of its great features! This course presents the essentials of managing and customizing worksheets in the Excel environment.
If you aren't familiar with Excel, you may not know how to take advantage of its great features! This course presents the essentials of managing and customizing worksheets in the Excel environment.
-
621 min6-part Microsoft Office course14 CQ
Want to dive into the best of Excel? In this course, SONIC Performance Support introduces intermediate to advanced data management techniques, from debugging complex formulas to creating web queries.
Want to dive into the best of Excel? In this course, SONIC Performance Support introduces intermediate to advanced data management techniques, from debugging complex formulas to creating web queries.
-
16218 min16-part Management course118 CQ
Does your device come with Microsoft Office 365? In this comprehensive course, get familiar with all the helpful apps this productivity program offers, from Mail to Skype for Business.
Does your device come with Microsoft Office 365? In this comprehensive course, get familiar with all the helpful apps this productivity program offers, from Mail to Skype for Business.
-
8106 min8-part Basic Computing course57 CQ
Need detailed guidance on how to make the best of the Windows 10 operating system? This course familiarizes beginner students with the Windows 10 user interface and its basic capabilities.
Need detailed guidance on how to make the best of the Windows 10 operating system? This course familiarizes beginner students with the Windows 10 user interface and its basic capabilities.
-
27 minMicrosoft Office lesson14 CQ
Learn how to create Excel PivotTables, which provide powerful ways to interact with data through easy-to-read formats, and can summarize large amounts of data.
Learn how to create Excel PivotTables, which provide powerful ways to interact with data through easy-to-read formats, and can summarize large amounts of data.
-
762 min7-part Microsoft Office course33 CQ
New to Microsoft Office? Then you're probably eager to get started with Microsoft Word, the go-to program for creating text documents. Over the course of 13 lessons, instructor Richard Rost will walk you through an overview of Microsoft Word basics. Learn to navigate the program using the Word interface and ribbon. Once you're comfortable, learn to create a document—a business letter—and enter edit, and format text. You'll learn a few keyboard shortcuts and how to print, email, and save files.
with AmicronNew to Microsoft Office? Then you're probably eager to get started with Microsoft Word, the go-to program for creating text documents. Over the course of 13 lessons, instructor Richard Rost will walk you through an overview of Microsoft Word basics. Learn to navigate the program using the Word interface and ribbon. Once you're comfortable, learn to create a document—a business letter—and enter edit, and format text. You'll learn a few keyboard shortcuts and how to print, email, and save files.
-
11137 min11-part Microsoft Office course73 CQ
Learn how to crunch through your PowerPoint slides, create decks you’re proud of, and finish your PowerPoint presentation quickly and professionally with hotkeys and the Quick Access Toolbar!
Learn how to crunch through your PowerPoint slides, create decks you’re proud of, and finish your PowerPoint presentation quickly and professionally with hotkeys and the Quick Access Toolbar!
-
26150 min26-part Microsoft Office course89 CQ
Discover some of Microsoft Excel's most handy formulas, shortcuts, and add-ins in this course. From sorting through data, to using a solver to optimize values, increase your Excel productivity today.
Discover some of Microsoft Excel's most handy formulas, shortcuts, and add-ins in this course. From sorting through data, to using a solver to optimize values, increase your Excel productivity today.
-
12175 min12-part Microsoft Office course94 CQ
Whether you’re a beginner or have Excel experience, this course will help you master one of the most powerful Microsoft Office programs available. Motion Training covers the fundamental skills you need to become a power user, including: proper spreadsheet set up, workbooks, calculations, formulas, functions (such as AutoFill and AutoSum), cell formatting, and charting. All lessons include .xlsx files so you can follow along for practice. Note that videos show Excel 2010.
with Motion TrainingWhether you’re a beginner or have Excel experience, this course will help you master one of the most powerful Microsoft Office programs available. Motion Training covers the fundamental skills you need to become a power user, including: proper spreadsheet set up, workbooks, calculations, formulas, functions (such as AutoFill and AutoSum), cell formatting, and charting. All lessons include .xlsx files so you can follow along for practice. Note that videos show Excel 2010.
-
661 min6-part Microsoft Office course34 CQ
Learn everything you need to know to get up and running with Powerpoint in just 1 hour! This course covers design, style, transitions, animations and a few advanced topics too.
Learn everything you need to know to get up and running with Powerpoint in just 1 hour! This course covers design, style, transitions, animations and a few advanced topics too.