TOSA Excel: TOSA Excel 2019 Beginner

https://www.skillsoft.com/channel/tosa-excel-51cb3531-a223-4ef9-8fc4-b488bd73e383?certification-exam=1211689&expertiselevel=1211688 https://www.skillsoft.com/channel/tosa-excel-51cb3531-a223-4ef9-8fc4-b488bd73e383?certification-exam=1211691&expertiselevel=1211688 https://www.skillsoft.com/channel/tosa-excel-51cb3531-a223-4ef9-8fc4-b488bd73e383?certification-exam=1211689&expertiselevel=1211690 https://www.skillsoft.com/channel/tosa-excel-51cb3531-a223-4ef9-8fc4-b488bd73e383?certification-exam=1211691&expertiselevel=1211690 https://www.skillsoft.com/channel/tosa-excel-51cb3531-a223-4ef9-8fc4-b488bd73e383?certification-exam=1211691&expertiselevel=1211692
  • 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
Likes 126 Likes 126
 
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

  • Playable
    1. 
    Finding & opening the application
    2m 53s
    NOW PLAYING
  • Playable
    2. 
    Exploring the Interface
    4m 13s
    UP NEXT

GETTING STARTED

Inserting PivotTables

  • Playable
    1. 
    Creating a PivotTable
    4m 33s
    NOW PLAYING
  • Playable
    2. 
    Editing your PivotTable
    3m 31s
    UP NEXT

GETTING STARTED

Custom & Conditional Formatting

  • Playable
    1. 
    Customizing your number formats
    5m 34s
    NOW PLAYING
  • Playable
    2. 
    Customizing your text formats
    3m 17s
    UP NEXT

GETTING STARTED

Using the Power View Add-in

  • Playable
    1. 
    Activating Power View
    4m 2s
    NOW PLAYING
  • Playable
    2. 
    Creating a new report
    4m 31s
    UP 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 Edition
Chock 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.
book Duration 8h 8m book Authors By David Slager

Book

Microsoft Excel Functions and Formulas: With Excel 2019 / Office 365, Fifth Edition
Easy-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.
book Duration 3h 10m book Authors By Bernd Held, Brian Moriarty, Theodor Richardson

Book

Excel 2019 Bible
Whether 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.
book Duration 15h 14m book Authors By Dick Kusleika, John Walkenbach, Michael Alexander

Book

Excel 2019 All-in-One for Dummies
Excel 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!
book Duration 14h 40m book Authors By Greg Harvey

Book

Excel 2019 for Dummies
Written 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.
book Duration 7h 19m book Authors By Greg Harvey

Book

Office 365 for Dummies, 3rd Edition
If 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.
book Duration 4h 33m book Authors By Jennifer Reed, Ken Withee, Rosemarie Withee

BOOKS INCLUDED

Book

Excel 2016 Bible
Written 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.
book Duration 14h 51m book Authors By John Walkenbach

Book

Excel 2016 Formulas
Offering 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.
book Duration 10h 54m book Authors By Dick Kusleika, Michael Alexander

Book

Excel 2016 All-in-One For Dummies
If 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.
book Duration 14h 6m book Authors By Greg Harvey

Book

Excel 2016 in Easy Steps
Using 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.
book Duration 1h 38m book Authors By Michael Price, Mike McGrath

Book

Essential Excel 2016: A Step-by-Step Guide
Loaded 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.
book Duration 7h 14m book Authors By David Slager

Book

Teach Yourself VISUALLY Excel 2016
Packed 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.
book Duration 3h 5m book Authors By Paul McFedries
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

Book

Essential Excel 2019: A Step-By-Step Guide, Second Edition
Chock 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.
book Duration 8h 8m book Authors By David Slager

Book

Microsoft Excel Functions and Formulas: With Excel 2019 / Office 365, Fifth Edition
Easy-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.
book Duration 3h 10m book Authors By Bernd Held, Brian Moriarty, Theodor Richardson

Book

Excel 2019 in Easy Steps
Using 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.
book Duration 1h 48m book Authors By Michael Price

Book

Excel 2019 Bible
Whether 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.
book Duration 15h 14m book Authors By Dick Kusleika, John Walkenbach, Michael Alexander

Book

Excel 2019 All-in-One for Dummies
Excel 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!
book Duration 14h 40m book Authors By Greg Harvey

Book

Excel 2019 for Dummies
Written 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.
book Duration 7h 19m book Authors By Greg Harvey
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

Book

Excel 2016 Bible
Written 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.
book Duration 14h 51m book Authors By John Walkenbach

Book

Advance Excel 2016 Training Guide
Explaining 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.
book Duration 1h 11m book Authors By Ritu Arora

Book

Essential Excel 2016: A Step-by-Step Guide
Loaded 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.
book Duration 7h 14m book Authors By David Slager

Book

Excel 2016 in Easy Steps
Using 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.
book Duration 1h 38m book Authors By Michael Price, Mike McGrath

Book

Excel 2016 Formulas
Offering 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.
book Duration 10h 54m book Authors By Dick Kusleika, Michael Alexander

Book

Excel 2016 All-in-One For Dummies
If 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.
book Duration 14h 6m book Authors By Greg Harvey
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

Book

Advance Excel 2016 Training Guide
Explaining 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.
book Duration 1h 11m book Authors By Ritu Arora

Book

Essential Excel 2016: A Step-by-Step Guide
Loaded 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.
book Duration 7h 14m book Authors By David Slager

Book

Excel 2016 in Easy Steps
Using 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.
book Duration 1h 38m book Authors By Michael Price, Mike McGrath

Book

Excel 2016 Bible
Written 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.
book Duration 14h 51m book Authors By John Walkenbach
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

CHANNEL TOSA PowerPoint
Likes 23 Likes 23  
Likes 1 Likes 1