TOSA Excel: TOSA Excel 2019 Beginner
Certification Exam:
Expertise:
- 6 Courses | 5h 4m 5s
- 6 Books | 53h 4m
- 6 Courses | 4h 44m 14s
- 6 Books | 51h 48m
- Includes Lab
- Includes Test Prep
- 10 Courses | 6h 23m 20s
- 6 Books | 50h 19m
- 9 Courses | 6h 57m 20s
- 6 Books | 49h 54m
- Includes Lab
- Includes Test Prep
- 2 Courses | 2h 3m 58s
- 4 Books | 24h 54m
- Includes Lab
- Includes Test Prep
Acquire the skills needed to utilize Microsoft Excel in a work environment as you prepare for the TOSA Excel 2016 and TOSA Excel 365 certification exams.
GETTING STARTED
Getting Started
-
1.Finding & opening the application2m 53sNOW PLAYING
-
2.Exploring the Interface4m 13sUP NEXT
GETTING STARTED
Inserting PivotTables
-
1.Creating a PivotTable4m 33sNOW PLAYING
-
2.Editing your PivotTable3m 31sUP NEXT
GETTING STARTED
Custom & Conditional Formatting
-
1.Customizing your number formats5m 34sNOW PLAYING
-
2.Customizing your text formats3m 17sUP NEXT
GETTING STARTED
Using the Power View Add-in
-
1.Activating Power View4m 2sNOW PLAYING
-
2.Creating a new report4m 31sUP NEXT
COURSES INCLUDED
Getting Started
Excel 2016 is the spreadsheet application in the Microsoft Office 2016 suite. Explore the interface and some of its features, including the ribbon, status bar, zoom, and various view modes.
5 videos |
19m
Assessment
Badge
Creating, Saving & Sharing Workbooks
Excel 2016 is highly customizable and easy to share with others. Learn how to create, manage, and save documents; insert headers and footers; edit document properties; and protect and share your workbooks.
19 videos |
1h 13m
Assessment
Badge
Inserting & Manipulating Data
Excel 2016 contains a number of features to aid in data insertion and manipulation. Explore numerous ways to insert, edit, and manipulate your data, including undo and redo, Flash Fill, spell check, and transposing a data range.
16 videos |
1h 3m
Assessment
Badge
Formatting Data
Formatting data makes it easier to see and work with. Discover how you can align data, use colors and themes, resize rows and columns, and insert tables and borders in Excel 2016 to change data presentation.
14 videos |
51m
Assessment
Badge
Illustrating Documents
An Excel 2016 worksheet can contain more than just numbers and text. Discover how to insert and edit images, screenshots, and shapes; insert hyperlinks; and use the new Smart Lookup feature.
6 videos |
28m
Assessment
Badge
Basic Formulas
The power of Excel 2016 is the support provided for using formulas on your data. Learn how to work with formulas, including built-in formulas such as SUM and COUNT, perform rounding and ranking, and generate random numbers.
12 videos |
48m
Assessment
Badge
SHOW MORE
FREE ACCESS
COURSES INCLUDED
Inserting PivotTables
This 11-video course provides learners with an in-depth exploration of how to use PivotTables in Excel for Office 365. PivotTables are highly customizable and can be used to extract patterns and trends that you may have initially missed in your data. You will learn how to create a PivotTable, and to modify it to change which fields have been inserted, and change the performing calculations. Next, you will learn to improve the appearance of your PivotTable by changing the style, color settings, and the fonts. This course demonstrates how to use the automatic sorting tools, drag and drop labels, and to sort your data by value. You will examine filters in Excel, and how label filters can be used to show and hide data based on the label associated with data values. You will observe how to use slicers to filter and manipulate data in a PivotTable, which provides a clear visual guide to the table's contents. Finally, you will learn to use the Timeline tool to work with dates in your PivotTable.
11 videos |
34m
Assessment
Badge
Working with Data in PivotTables
Explore ways to analyze data for trends by using a PivotTable in Excel for Office 365, in this 8-video course, which demonstrates how to organize fields, add extra levels of detail to data, and to insert multiple value fields in a single table. You will observe how to use a data model to pull data from multiple tables and build a relational data source inside a workbook. This course demonstrates how to pull data from external sources, for example, an Access database, and analyze it in a PivotTable. You will learn to insert calculated fields that use already inserted data in the PivotTable. You will also learn how to change a summary calculation or apply a comparison in a PivotTable, and how to visualize data rank as a percentage or as a difference. You will learn how to create a new PivotChart or convert already inserted data in a PivotTable. Finally, you to use PivotTable options to change how null data values and errors are displayed.
8 videos |
29m
Assessment
Badge
Using Conditional Formulas
This 8-video course explores how to use built-in formulas to perform a calculation on a range of values in Excel for Office 365. You will begin by learning how to insert a conditional sum using SUMIF formulas to perform a sum calculation on selected data values in your range. You will next learn how to use the IF function to determine whether a condition is met or not met, and to use the IF function in conjunction with other formulas. This course continues by demonstrating how to embed multiple IF formulas within one another to obtain multiple result options. You will learn to combine qualifying and alternate conditions using the IF and OR in conditional formulas. Next, learners will observe how to use Conditional Formulas to count value occurrences. You will learn to use reference positions in Conditional Formulas. Finally, this course demonstrates how to keep your table up to date with Conditional Formulas by using formulas such as COUNTA and OFFSET.
8 videos |
39m
Assessment
Badge
Finding & Analyzing Information with Formulas
Learners can explore the wide variety of tools available in Excel 365 for Office to retrieve, return, and calculate data in Excel, in this 9-video course. First, learn several formulas to automatically find a date for a specific month, day, or year. Then learn how to use Excel's RANK function to find a specific value in a data list, and how to use SMALL and LARGE formulas. This course demonstrates how to use the CONCAT and TEXT JOIN formulas to combine data from multiple cells into a single cell. You will observe how to use SUMPRODUCT formula to link calculations to produce a summary of a data table. Continue by learning how to use the VLOOKUP and HLOOKUP formulas to cross-reference the contents of two lists, and to find data in a table or data range in one list by using a search term from another list. Finally, you will learn how to use the VLOOKUP formula to perform lookup operations with lists and return corresponding values.
9 videos |
41m
Assessment
Badge
Configuring Options & Settings
This 10-video course offers learners an in-depth exploration of how to customize Excel for Office 365 to their specific requirements. Learn how to connect to SharePoint, OneDrive and the Office Store from your Microsoft account. Then learn how to search the add-in store, install an add-in, and to manage installed add-ins from the Office ribbon. Learners will observe how to create a custom template, and make it a default template. This course demonstrates how to activate and deactivate the Live Preview function, to switch off the Quick Analysis tools, hide the mini-toolbar, and other customizations. You will learn to specify the number of worksheets in a new document, change the default font, and the View Mode. Continue by learning how to configure AutoSave, and to adjust the default Save format and location. This course demonstrates how to change the background and theme, customize your Office copy, change your window and status appearance, and language settings. Finally, you will learn how to add shortcuts with the Quick Access Toolbar, and customize the Office Ribbon.
10 videos |
35m
Assessment
Badge
SHOW MORE
FREE ACCESS
COURSES INCLUDED
Custom & Conditional Formatting
To customize data, you can use the built-in formats in Excel 2016, or you can use your own. Learn how to create custom formats for numbers, text, and date and time, as well as how to create and use conditional formatting.
7 videos |
31m
Assessment
Badge
Finding, Sorting & Filtering Data
Excel 2016 includes a number of methods for locating and displaying only certain entries. Learn how to work with specific data using the Find and Replace tools, sorting and filtering, hiding duplicates, and grouping.
11 videos |
45m
Assessment
Badge
Referencing Data
Many times, you will use a cell value in a formula or another location. Discover absolute and relative cell references, using data across multiple worksheets, formula auditing, and interpreting formula errors in Excel 2016.
10 videos |
47m
Assessment
Badge
Working with Formulas
In addition to simple formulas, Excel 2016 has the power to solve more complex calculations. Explore how to calculate loan interest and payments, use the Goal Seek and forecast tools, and find and prevent duplicate values.
10 videos |
40m
Assessment
Badge
Creating Charts & Graphics
Analyze and present your data in a visually attractive manner in Excel 2016. Learn how to insert and customize charts, create chart templates, work with different chart types, and use trendlines.
15 videos |
1h 7m
Assessment
Badge
Creating PivotTables & PivotCharts
Excel 2016 includes powerful tools to summarize, sort, count, and chart data. Learn how to create, edit, and format PivotTables and PivotCharts; use calculations; sort, filter, and group data; and work with a slicer.
15 videos |
1h 5m
Assessment
Badge
Using Conditional Formulas
In some cases, you may need to create formulas using data based on specific criteria in your range. Learn how to create and work with conditional formulas in Excel 2016, including SUMIF, SUMIFS, and SUMPRODUCT.
9 videos |
41m
Assessment
Badge
Extracting Information with Formulas
Excel 2016 has a number of formulas for extracting both numeric and textual data from cells. Discover how to use some of these formulas, including MONTH, DAY, YEAR, MAX, MIN, CONCATENATE, SEARCH, LEN, LOOKUP, and VLOOKUP.
13 videos |
49m
Assessment
Badge
Configuring Options & Settings
Get more out of Excel 2016 by customizing it to your own needs. Learn how to manage your account, connected services, and add-ins; configure input and formula options; and customize the interface, ribbon, and Quick Access Toolbar.
8 videos |
28m
Assessment
Badge
SHOW MORE
FREE ACCESS
COURSES INCLUDED
Using the Power View Add-in
You can use the Power View add-in to create reports in Excel 2016. Discover the capabilities of Power View, including illustrating and organizing reports, filtering data, and adding PivotTables and charts to reports.
17 videos |
1h 6m
Assessment
Badge
Using the Power Pivot Add-in
You can create advanced PivotTables and analyze data from a variety of different sources using the Power Pivot add-in for Excel 2016. Learn how to use Power Pivot to import databases, create and modify tables, and create a dashboard.
14 videos |
57m
Assessment
Badge
EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.BOOKS INCLUDED
Book
Essential Excel 2019: A Step-By-Step Guide, Second EditionChock full of visuals, user-friendly instructions, and reader exercises, this in-depth guide makes it easy for you to get on the bandwagon taking advantage of this powerful software and what it can do.
8h 8m
By David Slager
Book
Microsoft Excel Functions and Formulas: With Excel 2019 / Office 365, Fifth EditionEasy-to-understand with numerous step-by-step instructions, this book's extensive examples and the latest tips, worksheets, and shortcuts make it an excellent resource for all Excel users who want to understand, create, and apply formulas.
3h 10m
By Bernd Held, Brian Moriarty, Theodor Richardson
Book
Excel 2019 BibleWhether you are just starting out or an Excel novice, this complete, easy-to-navigate resource is your comprehensive, go-to guide for all your Excel 2019 needs.
15h 14m
By Dick Kusleika, John Walkenbach, Michael Alexander
Book
Excel 2019 All-in-One for DummiesExcel is the number one number-crunching program just about everywhere. Everything you need to know to take advantage of this winning spreadsheet application is right here!
14h 40m
By Greg Harvey
Book
Excel 2019 for DummiesWritten by a bestselling author and seasoned educator, this easy-to-follow guide has been updated to reflect the major changes and features made to Excel and covers everything you need to know to perform any spreadsheet task at hand.
7h 19m
By Greg Harvey
Book
Office 365 for Dummies, 3rd EditionIf you are considering moving to Office 365 or have already moved, then this book is the first book you should read to get up to speed on the concepts and terms as quickly as possible.
4h 33m
By Jennifer Reed, Ken Withee, Rosemarie Withee
BOOKS INCLUDED
Book
Excel 2016 BibleWritten by expert author and Excel Guru John Walkenbach, this comprehensive, go-to guide will lead you through the powerful new features and capabilities of Excel and teach you to incorporate templates, implement formulas, create pivot tables, analyze data, and much more.
14h 51m
By John Walkenbach
Book
Excel 2016 FormulasOffering all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas, this comprehensive book explains how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more.
10h 54m
By Dick Kusleika, Michael Alexander
Book
Excel 2016 All-in-One For DummiesIf you're looking to bring your Excel skills from "meh" to excellent, this friendly guide offers everything you need to grasp basic Excel functions, such as creating and editing worksheets, setting up formulas, importing data, performing statistical functions, editing macros with Visual Basic, and beyond.
14h 6m
By Greg Harvey
Book
Excel 2016 in Easy StepsUsing detailed images and easy-to-follow instructions to get you up to speed with Excel, this concise yet comprehensive guide shows you how to quickly get to grips with the new features of Microsoft's latest version of this popular spreadsheet application.
1h 38m
By Michael Price, Mike McGrath
Book
Essential Excel 2016: A Step-by-Step GuideLoaded with screen shots, step-by-step instructions, and reader exercises, this complete guide shows you how easy it is to create, edit, sort, analyze, summarize and format data as well as graph it.
7h 14m
By David Slager
Book
Teach Yourself VISUALLY Excel 2016Packed with visually rich tutorials and step-by-step instructions that will help you take your Excel skills to new heights, this friendly and approachable guide will have you creating, editing, and manipulating Excel spreadsheets in no time.
3h 5m
By Paul McFedries
SHOW MORE
FREE ACCESS
BOOKS INCLUDED
Book
Essential Excel 2019: A Step-By-Step Guide, Second EditionChock full of visuals, user-friendly instructions, and reader exercises, this in-depth guide makes it easy for you to get on the bandwagon taking advantage of this powerful software and what it can do.
8h 8m
By David Slager
Book
Microsoft Excel Functions and Formulas: With Excel 2019 / Office 365, Fifth EditionEasy-to-understand with numerous step-by-step instructions, this book's extensive examples and the latest tips, worksheets, and shortcuts make it an excellent resource for all Excel users who want to understand, create, and apply formulas.
3h 10m
By Bernd Held, Brian Moriarty, Theodor Richardson
Book
Excel 2019 in Easy StepsUsing detailed images and easy-to-follow instructions to get you up to speed with Excel, this concise, yet comprehensive guide shows you how to quickly get to grips with the new features of Microsoft's latest version of this popular spreadsheet application.
1h 48m
By Michael Price
Book
Excel 2019 BibleWhether you are just starting out or an Excel novice, this complete, easy-to-navigate resource is your comprehensive, go-to guide for all your Excel 2019 needs.
15h 14m
By Dick Kusleika, John Walkenbach, Michael Alexander
Book
Excel 2019 All-in-One for DummiesExcel is the number one number-crunching program just about everywhere. Everything you need to know to take advantage of this winning spreadsheet application is right here!
14h 40m
By Greg Harvey
Book
Excel 2019 for DummiesWritten by a bestselling author and seasoned educator, this easy-to-follow guide has been updated to reflect the major changes and features made to Excel and covers everything you need to know to perform any spreadsheet task at hand.
7h 19m
By Greg Harvey
SHOW MORE
FREE ACCESS
BOOKS INCLUDED
Book
Excel 2016 BibleWritten by expert author and Excel Guru John Walkenbach, this comprehensive, go-to guide will lead you through the powerful new features and capabilities of Excel and teach you to incorporate templates, implement formulas, create pivot tables, analyze data, and much more.
14h 51m
By John Walkenbach
Book
Advance Excel 2016 Training GuideExplaining the difficult concepts in a familiar language, this comprehensive book offers a variety of examples along with their systematically worked out solutions, covering the complex functionality of Excel 2016.
1h 11m
By Ritu Arora
Book
Essential Excel 2016: A Step-by-Step GuideLoaded with screen shots, step-by-step instructions, and reader exercises, this complete guide shows you how easy it is to create, edit, sort, analyze, summarize and format data as well as graph it.
7h 14m
By David Slager
Book
Excel 2016 in Easy StepsUsing detailed images and easy-to-follow instructions to get you up to speed with Excel, this concise yet comprehensive guide shows you how to quickly get to grips with the new features of Microsoft's latest version of this popular spreadsheet application.
1h 38m
By Michael Price, Mike McGrath
Book
Excel 2016 FormulasOffering all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas, this comprehensive book explains how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more.
10h 54m
By Dick Kusleika, Michael Alexander
Book
Excel 2016 All-in-One For DummiesIf you're looking to bring your Excel skills from "meh" to excellent, this friendly guide offers everything you need to grasp basic Excel functions, such as creating and editing worksheets, setting up formulas, importing data, performing statistical functions, editing macros with Visual Basic, and beyond.
14h 6m
By Greg Harvey
SHOW MORE
FREE ACCESS
BOOKS INCLUDED
Book
Advance Excel 2016 Training GuideExplaining the difficult concepts in a familiar language, this comprehensive book offers a variety of examples along with their systematically worked out solutions, covering the complex functionality of Excel 2016.
1h 11m
By Ritu Arora
Book
Essential Excel 2016: A Step-by-Step GuideLoaded with screen shots, step-by-step instructions, and reader exercises, this complete guide shows you how easy it is to create, edit, sort, analyze, summarize and format data as well as graph it.
7h 14m
By David Slager
Book
Excel 2016 in Easy StepsUsing detailed images and easy-to-follow instructions to get you up to speed with Excel, this concise yet comprehensive guide shows you how to quickly get to grips with the new features of Microsoft's latest version of this popular spreadsheet application.
1h 38m
By Michael Price, Mike McGrath
Book
Excel 2016 BibleWritten by expert author and Excel Guru John Walkenbach, this comprehensive, go-to guide will lead you through the powerful new features and capabilities of Excel and teach you to incorporate templates, implement formulas, create pivot tables, analyze data, and much more.
14h 51m
By John Walkenbach
SHOW MORE
FREE ACCESS