TOSA Excel: TOSA Excel 2016 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 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
Likes 98 Likes 98
 
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

  • Playable
    1. 
    Finding & opening the application
    3m 25s
    NOW PLAYING
  • Playable
    2. 
    Exploring the Interface
    6m 18s
    UP NEXT

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

Custom & Conditional Formatting

  • Playable
    1. 
    Customizing your number formats
    5m 22s
    NOW PLAYING
  • Playable
    2. 
    Customizing your text formats
    4m 55s
    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 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 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 20m 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

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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 has Assessment available 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 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 | 33m 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 | 43m 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 | 46m 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 | 40m 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 | 51m 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 | 44m 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 | 31m 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 12m 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 | 1h 3m 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
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

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 Excel
Likes 2186 Likes 2186