Excel 2013 Advanced Data Techniques
A 6-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 21 min
- Lessons 6
- Attachments 11
- Exercises 9
-
14 CQ
6 Lessons in This Course
-
2 minMicrosoft Office lesson 12 CQ
When working with complex formulas, small errors can easily go undetected. In this lesson, learn how to use the Evaluate Formula feature to debug your formulas.
When working with complex formulas, small errors can easily go undetected. In this lesson, learn how to use the Evaluate Formula feature to debug your formulas.
-
2 minMicrosoft Office lesson 22 CQ
Learn how to use the Watch Window dialog, which allows you to keep both cells and formulas visible for monitoring the effects of any worksheet changes.
Learn how to use the Watch Window dialog, which allows you to keep both cells and formulas visible for monitoring the effects of any worksheet changes.
-
4 minMicrosoft Office lesson 33 CQ
Looking for an easy way to visually represent data? In this lesson, see how to create and edit sparklines in Excel 2013 to illustrate data trends over time.
Looking for an easy way to visually represent data? In this lesson, see how to create and edit sparklines in Excel 2013 to illustrate data trends over time.
-
3 minMicrosoft Office lesson 42 CQ
In this lesson, Jillian shows you how to apply the data consolidation tool in Excel to combine several different data ranges into a single location.
In this lesson, Jillian shows you how to apply the data consolidation tool in Excel to combine several different data ranges into a single location.
-
2 minMicrosoft Office lesson 52 CQ
Merging Excel workbooks manually is both tedious and error prone. In this lesson, learn how to use Excel's automated process for flawless workbook merging.
Merging Excel workbooks manually is both tedious and error prone. In this lesson, learn how to use Excel's automated process for flawless workbook merging.
-
5 minMicrosoft Office lesson 63 CQ
Web queries allow you to add automatically updating web data in Excel. In this lesson, learn how to create a web query and how to set up its properties.
Web queries allow you to add automatically updating web data in Excel. In this lesson, learn how to create a web query and how to set up its properties.
-
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.
-
1790 min17-part Microsoft Office course53 CQ
Learn how to transform data into whatever form you need with a few clicks! This intermediate course on Excel introduces filtering, sorting, pivot tables, and more for all-star data management.
Learn how to transform data into whatever form you need with a few clicks! This intermediate course on Excel introduces filtering, sorting, pivot tables, and more for all-star data management.
-
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.