TOSA Excel: TOSA Excel 2019 Beginner
Certification Exam:
Expertise:
- 6 Courses | 5h 39m 5s
- 6 Books | 53h 4m
- 6 Courses | 4h 53m 44s
- 6 Books | 51h 48m
- Includes Lab
- Includes Test Prep
- 10 Courses | 7h 9m 20s
- 6 Books | 50h 19m
- 9 Courses | 7h 7m 50s
- 6 Books | 49h 54m
- Includes Lab
- Includes Test Prep
- 2 Courses | 2h 15m 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 with Excel for Office 365
-
1.Finding & opening the application3m 25sNOW PLAYING
-
2.Exploring the Interface6m 18sUP NEXT
GETTING STARTED
Getting Started
-
1.Finding & opening the application2m 53sNOW PLAYING
-
2.Exploring the Interface4m 13sUP NEXT
GETTING STARTED
Custom & Conditional Formatting
-
1.Customizing your number formats5m 22sNOW PLAYING
-
2.Customizing your text formats4m 55sUP 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 with Excel for Office 365
Get started with Excel Office 365. This course explores the interface and some of it's features and functions. See how to Find Excel from your Windows 10 search bar, and start menu; pin the Excel icon to the task bar for easy access. Familiarize yourself with the Excel interface. Discover Excel’s features and functions, such as the ribbon with multiple tabs, the status bar, and the Quick Access toolbar. Zoom in on your work, or zoom out to get the big picture. Preview page breaks, page layout, and enter data in normal mode. Open multiple worksheets simultaneously. Finally, explore how to adjust and move between views.
5 videos |
24m
Assessment
Badge
Creating & Saving Workbooks
Creating a new spreadsheet and workbook, with Excel Office 365 for Windows couldnt be easier. Learn how to browse the Excel template library and download and configure a spreadsheet template. Next, navigate between your worksheets and modify their properties. Save your worksheet or workbook as an Excel version or a pdf. Other topics in this course include how to recover unsaved documents, use headers and footers, print your spreadsheet, preview and adjust page breaks, layout, orientation, margins, and the print area. You'll also learn how to edit workbook properties, locate and shield confidential information with the Document Inspector; improve handicap accessibility with the Document Scanner; protect your worksheet and workbook from changes, or restrict all access with a password.
15 videos |
1h 19m
Assessment
Badge
Inserting & Manipulating Data
Delve into data manipulation techniques with Excel Office 365 for Windows. In this course, learners can explore numerous ways to insert, edit, replace or delete data. Key concepts covered in this course include; how to insert a text character or symbol if this is not located on your computer; how to perform simultaneous edits of data cells with the same cell locations, but found on different worksheets. Learn how to simultaneously edit cells across multiple worksheets; undo previous actions; create an automatic data series; and flash fill data ranges, based on patterns. Other topics include how to limit values and speed up data entry with drop down menus; how to use and configure spell check and autocorrect; edit the dictionary and copy and paste data. Explore how to format values and formulas within spreadsheets, between spreadsheets, or within workbooks; transpose a data range. Finally, familiarize yourself with how to extract data from multiple worksheets and consolidate.
17 videos |
1h 17m
Assessment
Badge
Formatting Data
Formatting data makes the data easier to see and work with. Refine your data's appearance, with Excel Office 365 for Windows. During this course, you will learn how to align data, use colors, and themes, resize rows and columns, and insert tables and borders in Excel to change the presentation of data. You will learn how to organize your data into a table, format, sort, and apply filters and themes, and format a title. Explore topics such as how to adjust color, outlines, rotation, shadows, glows, and reflections; resize columns and rows; insert new columns and rows; change cell styles. Add cell borders. Alter background and data colors. Standardize your data's typographical appearance. Adjust the vertical and horizontal alignment of data. Adjust font effects. Employ text conversion formulas, to change capitalization and proper nouns. Transfer your format to another data selection.
14 videos |
59m
Assessment
Badge
Illustrating Documents
An Excel for Office 365 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. Key concepts covered in this 7-video course include how to insert images and photographs to illustrate a table; how to insert a screenshot and to move, resize, or crop it; and how to edit an image by adjusting its brightness, contrast, and saturation levels and even adding a border. Next, you will learn how to create diagrams by using shapes and adding shape effects; learn how to insert and modify icons in a worksheet; and learn the best practices for inserting a hyperlink into your sheet. Finally, you will learn how to use the Smart Lookup tool to quickly access additional information about words used in your document and see images, definitions, and information appearing on the Web, related to the selected word, by using this tool.
7 videos |
39m
Assessment
Badge
Using Basic Formulas
Formulas in MS Excel for Office 365 are useful in helping you visualize data. This course explores the large collection of formulas available in the Excel searchable library. Learn how to program each data cell to perform calculations, insert subtotals, create automated cumulative totals, and apply a formula to a large number of entries with the fill down function. Observe how to employ the COUNTA, COUNTIF, number rounding, and replacement formulas. Other topics explore how to rank a value with the rank function; convert between binary and hexadecimal number systems; factorize division results with the QUOTIENT and MODE formulas, and generate random values.
12 videos |
58m
Assessment
Badge
SHOW MORE
FREE ACCESS
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 |
21m
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 20m
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
Custom & Conditional Formatting
In this 10-video course, learners can explore how to use built-in formulas in Excel for Office 365, and how to create their own formats. This course demonstrates how to properly display a value—for example, a fraction, currency, or telephone number. You will then learn how to use the custom text format menu to insert additional data into cells, and to change the appearance of existing text. You will learn to use a variety of date and time formats built into Excel, how to create a customized format, and how to modify the color applied to data in a spreadsheet. This course demonstrates how to use Conditional Formatting highlights by adding visual indicators to data values, for example, to highlight specific cells, rows, or columns. You will learn how to use several Conditional Formatting tools to analyze data, and to use advanced conditional formatting by highlighting specific data criteria. Finally, learn how to set the hierarchical order of the Conditional Formatting rules apply, and how to resolve rule conflicts in Excel.
10 videos |
58m
Assessment
Badge
Sorting & Filtering Data
This 10-video course offers learners an in-depth exploration of Excel's sorting and filtering tools used to analyze data in a spreadsheet. You will learn how to control what is displayed in a data range, and how the values are organized in a worksheet. This course then demonstrates how to sort a data range by alphabetical order, and in value ranges. Learn how to include or exclude a header, and change the sort orientation from vertical to horizontal. Then learn how to create multiple sort levels to change how data are presented. You will learn how to create a custom sort list, and how to use column filters to show or hide different data values in your data range. You will learn to filter the data of a range and show values to meet specified criteria. This course demonstrates how to apply color coding to data items in a table, and how to use these codes to sort and filter data. Finally, learners observe how to create advanced filter criteria by using a separate table.
10 videos |
44m
Assessment
Badge
Referencing Data
Explore how to use reference cells in Excel for Office 365 in this 10-video course, which shows learners how to use cell coordinates to extract specified cell values, to reference individual cells, a range of cells, and entire columns and rows. First, learn how to reference data stored in different workbooks. Then you will examine when to use absolute, relative, and mixed cell references using the Fill function, or to copy formulas to a different cell or spreadsheet. You will learn how to name data ranges, how to refer to them in later calculations, and how to edit, adjust, and manage named ranges. This course demonstrates how to visualize, edit, and remove name ranges. You will learn how to use the INDIRECT formula to refer to a cell indirectly. You will learn how to use the Watch Window to monitor selected data entries from separate spreadsheets simultaneously, and how to activate and deactivate automatic updates. Finally, you will learn how to audit formulas in Excel.
10 videos |
52m
Assessment
Badge
Creating Charts & Graphics
Learners can explore the use of charts in Excel for Office 365 to enhance the look of data in this 10-video course, which demonstrates how to use several of Excel's charts, and how to customize charts for specific data. You will learn to use the Quick Analysis tool to insert a chart, and how to use visualized patterns to display data. This course then examines how to label charts, and how to choose which elements to show, including labels, legends, and titles. Learners will observe how to use the Formatting tools to change a chart's appearance. You will learn to customize your chart axes, how to adjust measurements, how to move maximum and minimum values, and how to change the point where the two axes cross in the chart. This course examines how to use Sparklines to represent an overall trend of a selected data range, and to format them further. Finally, you will learn how to select a color scheme, mark different data points, and even highlight the negative values in a trend.
10 videos |
43m
Assessment
Badge
Working with Different Chart Styles
In this 6-video course, you will explore the variety of chart types and templates available in Excel for Office 365 to visually enhance the displayed data. First, learn how to insert, format, and manipulate charts, starting with a pie chart. You will then learn how to insert and use a scatter chart to analyze correlations and relationships between different data series. This course demonstrates the use of bubble charts to reference three different types of information in a single chart. Learners will examine how to use a radar chart to plot five different data values, and how to compare the form and size of the shape created along the five different axes to get an overall representation of the data series. You will learn to use a combo chart to create a graphic that combines multiple data types. Finally, when you have data relating to regions, countries, or other locations, you will learn how to use the map chart to plot values on a geographic display.
6 videos |
26m
Assessment
Badge
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 |
39m
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 |
33m
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 |
43m
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 |
46m
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 |
40m
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 |
51m
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 |
44m
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 |
31m
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 12m
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 |
1h 3m
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
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
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
