Excel: Excel 2019 (Windows) Beginner

https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597572&expertiselevel=3597571 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597573&expertiselevel=3597571 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597574&expertiselevel=3597571 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597575&expertiselevel=3597571 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597576&expertiselevel=3597571 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597578&expertiselevel=3597571 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597580&expertiselevel=3597571 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597581&expertiselevel=3597571 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597582&expertiselevel=3597571 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597584&expertiselevel=3597571 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597585&expertiselevel=3597571 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597572&expertiselevel=3597579 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597573&expertiselevel=3597579 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597574&expertiselevel=3597579 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597575&expertiselevel=3597579 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597576&expertiselevel=3597579 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597576&expertiselevel=3597583 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597578&expertiselevel=3597579 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597580&expertiselevel=3597579 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597581&expertiselevel=3597579 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597582&expertiselevel=3597579 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597584&expertiselevel=3597579 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597585&expertiselevel=3597579 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597580&expertiselevel=3597583 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597582&expertiselevel=3597583 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597584&expertiselevel=3597583 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=3597585&expertiselevel=3597583
  • 4 Courses | 3h 8m 33s
  • 6 Books | 45h 29m
  • 5 Books | 40h 49m
  • 6 Courses | 4h 40m 18s
  • 6 Books | 45h 29m
  • 2 Courses | 1h 11m 49s
  • 7 Courses | 6h 33m 57s
  • 7 Books | 42h 9m
  • 7 Courses | 5h 23m 6s
  • 8 Books | 60h 49m
  • 7 Courses | 5h 5m 14s
  • 6 Books | 53h 17m
  • Includes Lab
  • 2 Courses | 1h 30m 16s
  • 6 Books | 45h 29m
  • 2 Courses | 2h 30m 31s
  • 6 Books | 56h 36m
  • Includes Lab
  • 9 Courses | 7h 12m
  • 5 Books | 40h 49m
  • Includes Test Prep
  • 9 Courses | 5h 31m
  • 4 Books | 37h 51m
  • 2 Courses | 53m 35s
  • 6 Books | 45h 29m
  • 5 Books | 40h 49m
  • 8 Courses | 4h 39m 9s
  • 6 Books | 45h 29m
  • 5 Courses | 2h 45m 5s
  • 9 Courses | 8h 20m 2s
  • 7 Books | 48h 8m
  • 2 Courses | 2h 12m 28s
  • 4 Books | 14h 19m
  • 10 Courses | 7h 18m 2s
  • 8 Books | 60h 49m
  • 14 Courses | 8h 3m 53s
  • 7 Books | 58h 32m
  • Includes Lab
  • 2 Courses | 57m 45s
  • 6 Books | 45h 29m
  • 9 Courses | 7h 47m 51s
  • 6 Books | 56h 36m
  • Includes Lab
  • 9 Courses | 6h 57m 20s
  • 5 Books | 40h 49m
  • Includes Test Prep
  • 15 Courses | 7h 48m 44s
  • 3 Books | 23h 42m
  • 3 Courses | 1h 53m 18s
  • 4 Books | 39h 1m
  • Includes Lab
  • 5 Courses | 4h 50m 56s
  • 6 Books | 52h 52m
  • Includes Lab
  • 2 Courses | 2h 3m 58s
  • 6 Books | 23h 53m
  • Includes Test Prep
  • 4 Courses | 2h 13m 43s
Likes 3070 Likes 3070
 
Excel is the powerful spreadsheet component of Microsoft Office. Discover Excel and its many uses.

GETTING STARTED

Using Workbooks

  • Playable
    1. 
    Using the app
    5m 23s
    NOW PLAYING
  • Playable
    2. 
    Creating a new document
    2m 50s
    UP NEXT

GETTING STARTED

Opening & Setting Up Excel

  • Playable
    1. 
    Finding & opening the application
    3m 35s
    NOW PLAYING
  • Playable
    2. 
    Using Excel 2016
    5m 22s
    UP NEXT

GETTING STARTED

Discovering the Application

  • Playable
    1. 
    Signing in to Excel for the Web
    4m 53s
    NOW PLAYING
  • Playable
    2. 
    Discovering the Home page
    4m 57s
    UP NEXT

GETTING STARTED

Getting Started

  • Playable
    1. 
    Using Excel 2013
    6m 48s
    NOW PLAYING
  • Playable
    2. 
    Using the zoom function
    4m 25s
    UP NEXT

GETTING STARTED

Getting Started

  • Playable
    1. 
    Finding & opening the application
    4m 2s
    NOW PLAYING
  • Playable
    2. 
    Using Excel 2010
    5m 26s
    UP NEXT

GETTING STARTED

Getting Started

  • Playable
    1. 
    Finding & opening the application
    3m 14s
    NOW PLAYING
  • Playable
    2. 
    Exploring the application
    6m 43s
    UP NEXT

GETTING STARTED

Using Workbooks

  • Playable
    1. 
    Finding & opening the application
    3m 56s
    NOW PLAYING
  • Playable
    2. 
    Using the app
    6m 4s
    UP NEXT

GETTING STARTED

Complete Guide to Excel 365: Getting Started

  • Playable
    1. 
    Course Overview
    1m 59s
    NOW PLAYING
  • Playable
    2. 
    Launching and Customizing Excel
    9m 58s
    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

Getting started in Excel 365

  • Playable
    1. 
    Course Overview: Getting started in Excel 365
    50s
    NOW PLAYING
  • Playable
    2. 
    Opening and exploring the application
    4m 48s
    UP NEXT

GETTING STARTED

Visualizing Data in Tables & Charts

  • Playable
    1. 
    Creating a quick table
    3m 45s
    NOW PLAYING
  • Playable
    2. 
    Resizing columns & rows
    3m 56s
    UP NEXT

GETTING STARTED

Custom & Conditional Formatting

  • Playable
    1. 
    Customizing the date & time formats
    3m 53s
    NOW PLAYING
  • Playable
    2. 
    Customizing your number formats
    4m 38s
    UP NEXT

GETTING STARTED

Inserting & Editing data

  • Playable
    1. 
    Selecting cells
    3m 26s
    NOW PLAYING
  • Playable
    2. 
    Inputting data
    2m 21s
    UP NEXT

GETTING STARTED

Custom & Conditional Formatting

  • Playable
    1. 
    Customizing your number formats
    6m 53s
    NOW PLAYING
  • Playable
    2. 
    Customizing your text formats
    5m 48s
    UP NEXT

GETTING STARTED

The Power View Add-in

  • Playable
    1. 
    Activating Power View
    3m 25s
    NOW PLAYING
  • Playable
    2. 
    Creating a new report
    5m 53s
    UP NEXT

GETTING STARTED

Custom & Conditional Formatting

  • Playable
    1. 
    Customizing your number formats
    4m 40s
    NOW PLAYING
  • Playable
    2. 
    Customizing your text formats
    4m 2s
    UP NEXT

GETTING STARTED

Custom & Conditional Formatting

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

GETTING STARTED

Inserting Tables & Illustrations

  • Playable
    1. 
    Creating a quick table
    3m 17s
    NOW PLAYING
  • Playable
    2. 
    Editing a table
    4m 40s
    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

Customizing text & number formats in Excel 365

  • Playable
    1. 
    Course Overview: Customizing text and number formats in Excel 365
    49s
    NOW PLAYING
  • Playable
    2. 
    Separating data into multiple cells
    5m 2s
    UP NEXT

GETTING STARTED

Getting to Know Macros

  • Playable
    1. 
    Recording a macro
    3m 1s
    NOW PLAYING
  • Playable
    2. 
    Saving a workbook with macros
    3m 24s
    UP NEXT

GETTING STARTED

Getting to Know Macros in Excel

  • Playable
    1. 
    Recording a macro
    2m 32s
    NOW PLAYING
  • Playable
    2. 
    Saving a workbook with macros
    3m 42s
    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

GETTING STARTED

Performing data analysis and forecasting in Excel 365

  • Playable
    1. 
    Overview: Performing data analysis and forecasting in Excel 365
    50s
    NOW PLAYING
  • Playable
    2. 
    Consolidating data
    3m 22s
    UP NEXT

COURSES INCLUDED

Using Workbooks
Get the most out of Excel for iPad. Discover the interface, and learn where to locate tools, how to create, open, manage, save, and print workbooks, and convert file formats.
8 videos | 26m available Badge
Inserting & Manipulating Data
A spreadsheet without data is of little use. Discover how to work with data and other elements in Excel for iPad, including copying or moving data, undoing and redoing actions, freezing panes, and adding and modifying images.
14 videos | 53m available Badge
Formatting Data
To get the most out of your data, it must be accurate and easy to read. Discover data formatting techniques in Excel for iPad, including how to set a cell's format, align data, use colors and styles, and insert borders and hyperlinks.
10 videos | 34m available Badge
Using Formula Tools
A major benefit of a spreadsheet is the ability to perform calculations on its data. Discover how to use Excel for iPad's Function Library, and work with formulas to count cells, perform rounding and ranking, and locate duplicates.
17 videos | 1h 13m available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Opening & Setting Up Excel
Get started with Excel 2016 for Mac, and explore the interface. Discover tools, the zoom function, view modes, and how to navigate between multiple documents.
5 videos | 21m available Badge
Creating, Saving & Sharing Workbooks
There are numerous ways to set up a document in Excel. Discover how to create, save, print, and manage documents; edit document properties; work with the protection settings; and share documents via email and OneDrive.
17 videos | 1h 7m available Badge
Manipulating Data
It's possible to manually edit data in Excel; however, this can become tedious, especially with a lot of data. Work smarter, not harder, by exploring various methods for efficiently and effectively inserting and manipulating data in Excel.
16 videos | 59m available Badge
Formatting Data
You can make your data more meaningful by changing its appearance in the spreadsheet. Learn how to set the data type, format your data using colors and themes, work with tables and titles, and insert borders in your Excel spreadsheet.
14 videos | 52m available Badge
Illustrating Documents
There are numerous elements you can add to improve the appearance of your Excel documents. Discover how to work with images, photos, screenshots, shapes, and diagrams; insert a hyperlink; and use the Smart Lookup tool.
6 videos | 24m available Badge
Basic Formulas
The Function Library in Excel contains a large number of ready-to-use formulas. Discover how to work with both basic formulas and conditional formulas to extract the values you need.
12 videos | 55m available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Discovering the Application
Excel for the Web is the spreadsheet online application in the Microsoft Office 365 suite. Learn how to sign-in and sign-out from the platform, as well as creating and opening your workbooks located in OneDrive. Explore the interface and some of its features, including the ribbon, status bar, and various view modes.
10 videos | 39m has Assessment available Badge
Saving & Managing Documents
In Excel for the Web, it is easy to create and save new workbooks. Learn how to save and download a copy of your documents, as well as protect your Excel workbooks from unwanted edits or use. In Excel for the Web worksheet can contain more than numbers and text, so learn how to search for spelling mistakes and accessibility issues. You will also see how te get statistics concerning the data in your workbook. In this course you will also discover how to work with various workbooks at the same time, manage spreadsheets, and create sheet views.
9 videos | 31m has Assessment available Badge

COURSES INCLUDED

Getting Started
Before starting to work in Excel 2013, it's important to learn about the interface and its features. Explore the interface, and learn about the zoom function, view modes, and how to move between workbooks.
4 videos | 23m available Badge
Creating, Saving, & Exporting Workbooks
Learn the basics of working with Excel 2013, including creating workbooks, using templates, saving, adding headers and footers, adjusting print options and printing, editing workbook properties, and protecting a workbook.
15 videos | 1h 27m available Badge
Sharing & Exporting Workbooks
Easily share spreadsheets with colleagues using Excel 2013 collaboration features. Discover how to share workbooks via email, OneDrive, and Office 365; publish workbooks online, and use comments and track changes.
6 videos | 38m available Badge
Manipulating Data
Learn the basics of working with data in Excel 2013, including selecting cells, inputting data, undoing and redoing actions, filling, spellchecking, copy and pasting, moving data to another worksheet, and consolidating data.
15 videos | 1h 20m available Badge
Formatting Data
Excel 2013 provides numerous features that allow you to display data in a visually appealing way. Learn how to format and align data, use colors and themes, create titles and tables, resize and insert columns and rows, and add borders.
13 videos | 1h 14m available Badge
Illustrating Documents
Excel 2013 includes some built-in features for working with images and allows you to link inside and outside of a workbook. Learn how to insert images and screenshots into a workbook, edit an image, and insert a hyperlink.
4 videos | 25m available Badge
Basic Formulas
Get the most out of Excel 2013 by learning about formulas, functions, and totals. Explore using the function library, using automated formulas, inserting subtotals, ranking values, converting number types, and creating random values.
12 videos | 1h 3m available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Getting Started
Get started with Excel 2010, and explore the interface. Discover tools, the zoom function, view modes, and how to navigate between multiple documents.
5 videos | 19m available Badge
Saving & Sharing Workbooks
There are numerous ways to set up a document in Excel. Discover how to save, share, and manage your documents with Excel 2010.
17 videos | 1h 10m available Badge
Manipulating Data
It's possible to manually edit data in Excel; however, this can become tedious, especially with a lot of data. Work smarter, not harder, by exploring various methods for efficiently and effectively inserting and manipulating data in Excel.
16 videos | 53m available Badge
Formatting Data
You can make your data more meaningful by changing its appearance in the spreadsheet. Discover how to set data type, format data using colors and themes, work with tables and titles, and insert borders in your Excel spreadsheet.
14 videos | 50m available Badge
Illustrating Documents
There are numerous elements you can add to improve the appearance of your Excel documents. Discover how to work with images, photos, screenshots, shapes, diagrams, and hyperlinks.
5 videos | 23m available Badge
Basic Formulas
The Function Library in Excel contains a large number of ready-to-use formulas. Discover how to work with both basic formulas and conditional formulas to extract the values you need.
12 videos | 51m available Badge
Tools
Excel 2010 offers a number of powerful tools for working with styles, themes, charts, and PivotTables. Explore the various tools found in Excel 2010.
7 videos | 55m available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Getting Started
Get started with Excel 2019, the spreadsheet application included with the Microsoft Office 2019 Suite. During this course, you will familiarise yourself with the interface and some of its features, including the ribbon, status bar, zoom, and various view modes. Begin the course by learning how to find the application on the desktop and open it. To get the most out of Excel, you need to understand how the interface is laid out, so the course next explores the application. This leads into the zoom function, which can be used to adjust how to visualize the spreadsheet in Excel by making data entries larger or smaller. Discover how to examine mode views, which in Excel features three different preset view modes: Normal, Page Layout, and Page Break. Conclude the course by observing how to move between documents, allowing work on multiple documents simultaneously while using a number of tools to organize a workspace. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Getting Started Exercise as well as the associated materials in the Resources section.
5 videos | 21m has Assessment available Badge
Creating & Saving Workbooks
Create a new spreadsheet and workbook, with Excel 2019. During this course, you will begin by learning how to create and open a document, and then learn how to use document templates. This leads into how to manage worksheets, which are used in Excel to manage different sets of data within a workbook. Next, observe how to save your worksheet or workbook as an Excel version or pdf; and recover unsaved documents. Learn how to insert headers and footers, useful if you have additional information to insert into a spreadsheet. Examine how to set your print area; adjust your print page layout, and then print your document. Discover how to check for compatibility issues; edit your document properties; and check for personal information in your document. The course concludes by showing how to create an accessible document, and how to protect your document or restrict all access with a password. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Creating & Saving Workbooks Exercise as well as the associated materials in the Resources section.
15 videos | 1h 3m has Assessment available Badge
Inserting & Manipulating Data
Delve into data manipulation techniques with Excel 2019 for Windows. In this course, learners can explore various ways to insert, edit, and manipulate data. Begin by learning how to select cells in order to apply changes to individual or multiple cells. Then learners will discover different ways of inserting, editing, and replacing data in a spreadsheet, and observe how to insert special characters. The course continues by demonstrating how to edit multiple worksheets simultaneously; delete items in a spreadsheet; and how to use the undo and redo actions. Explore how to create automatic data series; use the Flash Fill feature, and insert dropdown menus. Delve into configuring the spell check and autoCorrect options; transferring, and copying and pasting data. Complete this course by observing how to move data from one worksheet to another, and transpose a data range. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Inserting & Manipulating Data Exercise as well as the associated materials in the Resources section.
17 videos | 1h 2m has Assessment available Badge
Formatting Data
Refine your data's appearance with Excel 2019 for Windows. In this course, you will discover how you can align data, use colors and themes, resize rows and columns, and insert tables and borders in Excel 2019 to change data presentation. Learners will begin by observing how to set a data type, and then format and align their data. Next, observe how to use colors, which can help data stand out for the reader and make the table easier to read. Discover how to change the cell style; use document themes, and use formulas to modify the text case. Explore how to create clean, professional looking titles, and format titles to make them presentable. Create tables to ease organization; resize columns and rows; insert borders, and columns and rows. Conclude the course by observing how to transfer format styles. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Formatting Data Exercise as well as the associated materials in the Resources section.
14 videos | 49m has Assessment available Badge
Illustrating Documents
Augment the descriptive power of your data with Excel 2019 for Windows. In this course, learners will discover how to insert and edit images, screenshots, and shapes, insert hyperlinks, and use the new Smart Lookup feature. Begin by learning how to insert an image or photograph, which can be used to illustrate your table, and then learn how to insert a screenshot. Discover how to edit an image, adjust its brightness, contrast, saturation levels, and apply different artistic effects or add a border. Learners can also observe how to create diagrams by using shapes and insert icons to help illustrate a worksheet. There are several different types of links that can be inserted into your document, including hyperlinks. Finally, learners will explore how to use the Smart Lookup tool in Excel to quickly access additional information about words used in a document. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Illustrating Documents Exercise as well as the associated materials in the Resources section.
7 videos | 31m has Assessment available Badge
Using Basic Formulas
Put formulas to work with Excel 2019 for Windows. In this 12-video course, learners will observe how to work with formulas, including built-in formulas such as SUM and COUNT. You will begin by discovering how to insert a formula by using the function library, and then perform simple calculations within an individual cell. Explore how to use automated formulas in a table; create automated cumulative tools; and insert subtotals. Following on from this, you will learn how to count cells in a range by using different formulas, and then rank values, which is extremely useful if you want to find out where a particular value places on a list of data entries. The course also explores how to examine rounding a number, to round up or down your data values; use replacement formulas when you need to make changes; convert number types, and factorize the results of a division. Conclude the course by observing how to create random values. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Using Basic Formulas Exercise as well as the associated materials in the Resources section.
12 videos | 51m has Assessment available Badge Certification PMI PDU
Sharing & Collaborating on a Document
Excel 2019 enables one to easily share documents via email or upload them to OneDrive and SharePoint for team collaboration. During this course, you will learn how to share your spreadsheet, or send it as a .xls or .pdf in Excel. You will learn how to set its editing permissions and send a link. Other topics include how to view your shared documents and save your Excel documents online with OneDrive, so that collaborators can check out a document to prevent others from working on it at the same time. Explore how to coordinate document modification to allow collaborators to make comments, and track document changes. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Sharing & Collaborating on a Document Exercise as well as the associated materials in the Resources section.
7 videos | 25m has Assessment available Badge Certification PMI PDU
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Using Workbooks
Get the most out of Excel for iPhone. Discover the interface, and learn where to locate tools, how to create, open, manage, save, and print workbooks, and convert file formats.
7 videos | 32m available Badge
Inserting & Manipulating Data
A spreadsheet without data is of little use. Discover how to work with data and other Excel elements on your iPhone screen, including copying, moving and formatting data, undoing and redoing actions, and inserting functions.
12 videos | 58m available Badge

COURSES INCLUDED

Complete Guide to Excel 365: Getting Started
Microsoft Excel has many potential applications, offering extensive, customizable features to suit virtually all tasks and workflows. At first, Excel can be intimidating, but the benefits of knowing how to eke out every bit of this tool's productivity far outweigh the slight learning curve. In this course, you'll learn how to set up Excel, identify and choose an Excel template, locate and recognize the purpose of each primary menu item group in the Quick Access Toolbar, and apply customization to this toolbar. Next, you'll execute basic cell operations, such as copy-pasting data and inserting and deleting rows and columns. You'll and apply a range of cell formatting options, such as alignment, font, and currency formats. Finally, you'll import delimited and fixed-width data and work with Excel's Flash Fill functionality.
10 videos | 1h 13m has Assessment available Badge
Complete Guide to Excel 365: Working With Charts & Sparklines
One of the primary purposes of using Excel is to analyze and present data in a focused, accessible, and accurate way. A great way to do this is with charts and sparklines. In this course, you'll create basic chart types, such as line, bar, and pie charts, as well as more advanced charts, like treemaps and sunburst charts. In doing this, you'll work with the different aspects of Excel's chart customization capabilities, from chart element transparency to the orientation and exploding out of slices in a pie chart. Next, you'll advance to use more statistically-oriented chart types, including histograms, scatter plots, and box-and-whisker plots. Finally, you'll learn to create, customize, and work with Excel's sparklines, which are lightweight visualizations usually contained within a single cell.
11 videos | 1h 16m has Assessment available Badge

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
Using Excel with Office 365
If you or your organization has a qualifying Office 365 subscription, you can use it to install Excel 2016 and get the latest software updates released by Microsoft. During this course, you will discover the power of Excel to organize, calculate, analyze, revise, update, and present your data. See how to use the full functionality of the Excel worksheet and workbook. Explore the expanded possibilities of cloud computing. With your qualifying Office 365 subscription, you can install Excel 2016, and download the latest releases from Microsoft. Recent Excel updates include streamlined document management, annotation, shared interfaces, additional PivotTable configuration tools, and icon insertion capabilities.
10 videos | 53m available Badge
Creating Tours with 3D Maps
3D Maps for Excel 2016 is a 3D data visualization tool that's great for geographically or spatially mapping your data. During this course, you will learn how to create, navigate and manage a 3D map. You'll start by building a map tour that presents geographical data and the tools required to manage it. You'll learn how to organize your map tour into segments, called scenes. Observe how to build visual tours that explore and analyze the data in your 3D map. Create, move, copy, edit, rename, customize, and delete scenes. See how to add titles and text boxes. The course also covers how to configure the presentation and playback options. Finally, you can share your tour, either as a screenshot, or as a video file.
9 videos | 40m has Assessment available Badge
Working with Data in 3D Maps
Knowing how to bring in data and map it to your 3D Maps tours is key to getting the most out of your data. During this course, you will learn how to use data from multiple tables, add layers, timestamps, and filters to better understand your tours, and how to customize the information on display. You will start by creating your map from your initial data table with details such as time zones, place names, and zip codes. Then you will learn how to add, refresh, format, annotate, and delete data. From there you can explore how to combine data from separate tables into one 3D map; employ layers to differentiate, shape, and display different data sets, and customize and insert charts into your data layers. Other topics include how to adjust your 3D map display, how to add legends, apply data filters, show or hide elements, and change map views.
11 videos | 53m has Assessment available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Getting started in Excel 365
Excel 365 is the spreadsheet application in the Microsoft 365 suite. In this course, you will explore how to find and open the Excel 365 application, navigate the interface and create spreadsheets. Key concepts covered in this course include accessing the app and exploring the interface, which features a ribbon with multiple tabs, a status bar, and a Quick Access Toolbar with multiple tools for visualizing your spreadsheet data. You will also learn how to open a new workbook and how to create a worksheet from a template. You will explore how to add data to a spreadsheet, copy and paste data into a spreadsheet, resize columns and rows; and delete items from a spreadsheet. In addition, you will discover how to undo recent actions you may have performed in error, or redo an action to save time. You will also look at how to insert one of the built-in formulas from the Function library to perform calculations on your data; how to save a worksheet or workbook that you've created; and how to share your spreadsheets with others.
12 videos | 41m has Assessment available Badge Certification PMI PDU
Adding & arranging data in Excel 365
In Excel 365, it is easy to add new content to workbooks and change how values are arranged. This course demonstrates how to add and manage content in your worksheets, including how to insert columns and rows, and data into cells. You will begin by learning how to fill cells using the AutoFill feature; as well as how to insert columns and rows into a worksheet. Next, you will observe how to paste copied data using the Paste Special tools; how to align values in cells; as well as how to freeze rows or columns to avoid unnecessary scrolling. Finally, you'll explore how to select cells and ranges; and how to merge content across various cells or unmerge if necessary.
13 videos | 44m has Assessment available Badge Certification PMI PDU
Working with tables in Excel 365
Tables are a useful tool for quickly managing, analyzing, and manipulating data as a range in Excel 365. In this course, you will discover how you can easily create tables from a data range; insert borders, and change the appearance and formatting of a table. You will start by learning how to insert a table, and convert a data range into a table. In addition, you'll learn how to transpose a data range, which means inverting the columns and rows. You will see that tables are highly customizable, as you learn how to use the formatting tools and styles to change the appearance of a table. Also, see how to use the Border tool to make the data in your table stand out more. You will learn how to use slicers to filter and manipulate data in a table; and how to resize and format a slicer tile. Finally, you will explore how to add subtotals to your data tables and how to manipulate the table date in other ways.
11 videos | 36m has Assessment available Badge Certification PMI PDU
Getting started with charts in Excel 365
Present your Excel 365 data visually by using charts. Excel features several built-in charts, each of which can be customized to suit your needs. In this course, you will learn how to insert charts and add charts quickly with the Quick Analysis tool. You will explore how to create a bar chart, pie chart, line chart, and add chart labels. This includes adding a chart title and data labels, and discovering how to present negative values in a chart. Finally, you will explore how to apply basic formatting, such as default colors, to your charts.
9 videos | 29m has Assessment available Badge Certification PMI PDU
Formatting cells and ranges in Excel 365
Excel 365 contains several features to aid in data formatting and manipulation. In this course, you will explore various ways to format your data by type, which serves as a way of classifying the data. Learn how to create drop-down menus, fill cells using the Flash Fill feature, and how to create an automatic data series. Next, you will discover how to create an automatic data series using the advanced Fill Series options and how to format data, including options to configure its size or apply font effects such as bold, italic, and underline. Then you'll also see how to apply cell styles; how to format cells with the Format Painter tool; how to create customized number formats; how to apply custom cell formats; and how to clear all formatting from cells.
11 videos | 42m has Assessment available Badge Certification PMI PDU
Performing data calculations using formulas in Excel 365
The power of Excel 365 lies in the support given when using formulas with your data, which automatically update when the underlying data changes to ensure your calculations are always up to date. In this course, you will observe how to perform simple and more advanced calculations with formulas, including the use of built-in formulas such as SUM and COUNT, as well as working with formulas that include IFS, SWITCH, MAXIFS, MINIFS, COUNTA, OFFSET, COUNTIFS, MOD, QUOTIENT, and AVERAGEIFS. You will start by discovering how to perform simple calculations within an individual cell; then explore how to use formulas to create automated cumulative totals in a table and insert subtotals. Following this, you will learn how to use different formulas to count cells in a range. Learn how to perform logical operations such as IFS and SWITCH, MAXIFS, and MINIFS, and keep your data up to date with COUNTA and OFFSET formulas. Finally, you will explore how to configure default formula options, find data with multiple conditions, factorize the results of a division, and calculate average values under different criteria.
10 videos | 31m has Assessment available Badge Certification PMI PDU
Printing spreadsheets in Excel 365
Excel 365 offers an array of tools for making printouts of your spreadsheet data. In this course, you will learn how to add headers and footers to the pages in a spreadsheet if you would like to include additional information. And you will learn how to set your print area, adjust your print page layout, configure the print settings, and print your spreadsheets in Excel 365.
6 videos | 25m has Assessment available Badge Certification PMI PDU
Setting your work preferences in Excel 365
Get the most out of Excel 365 by customizing it to your own needs. In this course, you will learn how to customize the interface, ribbon, and Quick Access Toolbar; manage your account add-ins; configure user input and template options, and customize default document settings. Key concepts covered in this course include how to customize the appearance of the Excel 365 interface, including options to customize the Quick Access Toolbar and its commands as well as the Office ribbon and its commands. You will also discover how to install an add-in and manage it, install add-ins from the Office ribbon, and create custom templates and save those templates for future use. Next, you will learn how to configure user and input behavior, customize how workbooks are saved; and change the workbook default settings.
9 videos | 42m has Assessment available Badge Certification PMI PDU
Ten common tools in Excel 365
To make the most out of working in Excel 365, you need to know your way around the interface as well as understand some of its frequently-used features. This course will explore how to use the Zoom tools, make selections in your worksheet, and use the various view modes. You will also explore how to navigate between worksheets. In addition, you'll learn how to use the spellcheck tool, and learn more about the AutoCorrect and Smart Lookup features. Finally, you will explore how to translate text and create an accessible document.
11 videos | 37m has Assessment available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Visualizing Data in Tables & Charts
You can make your data in Excel for iPad easier to read and analyze using tables and charts. Learn how to create and modify tables and PivotTables, sort and filter data, and insert and format charts.
11 videos | 35m available Badge
Using Collaboration Tools
Excel for iPad makes it easy for others to collaborate with you on your documents. Learn how to share your documents using email or a cloud service, and how to add comments and annotations to your worksheets.
5 videos | 17m available Badge

COURSES INCLUDED

Custom & Conditional Formatting
In addition to the formats built into Excel, you can also use custom formats. Learn to create and use custom date, time, number, and text formats, and work with the conditional formatting tools in Excel.
6 videos | 25m available Badge
Finding, Sorting, & Filtering Data
In large spreadsheets, it is not always easy to locate the data you need. Discover the tools in Excel to find, replace, sort, and filter data. Also, learn how to create an outline, freeze panes, and hide duplicate values.
9 videos | 29m available Badge
Referencing Data
To use the contents of a cell, you must know how to reference that cell. Explore absolute and relative cell referencing, and discover how to work with named data ranges, formula auditing tools, and formula error messages in Excel.
7 videos | 32m available Badge
Working with Formulas
Excel includes tools and formulas for solving more advanced problems. Discover how to calculate loan interest, use the Goal Seek and Solver tools, and handle duplicate values in your spreadsheet.
6 videos | 26m available Badge
Charts & Graphics
Using charts is an effective way to present data in your Excel spreadsheet. Learn how to insert, format, and customize different chart types in Excel, and how to insert and work with trendlines.
14 videos | 58m available Badge
PivotTables
A PivotTable is one of the most powerful and intimidating features in Excel. Learn how to get the most out of a PivotTable to help you summarize and extract information from your data.
10 videos | 41m available Badge
Extracting Information with Formulas
Excel includes a number of formulas for extracting information from data. Discover how to use a number of these formulas, including MAX, MIN, LARGE, SMALL, CONCAT, and VLOOKUP.
10 videos | 43m available Badge
Configuring Excel
Excel 2016 for Mac is a highly customizable application. Learn how to customize the interface, view settings, input options, ribbon, and Quick Access toolbar, and how to install and manage add-ins.
6 videos | 21m available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Inserting & Editing data
Excel for the Web 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. To enhance your worksheets, also learn how to insert pictures, shapes, and hyperlinks.
10 videos | 34m has Assessment available Badge
Formatting Data
Excel for the Web makes it easier to enhance the presentation of your worksheets. Discover how you can customize your font options, align data, and use colors. If you are working with large amounts of data, it will be useful to know how to resize rows and columns, as well as set borders. In this course you will also learn how to create table and customize them with the formatting style options to improve the presentation of your data.
10 videos | 31m has Assessment available Badge
Analyzing & Manipulating Data Entries
Excel for the Web includes a wide variety of options for locating, displaying, and analyzing data entries. To start working with the data in a worksheet, use the sorting and filtering options for choosing what is the data displayed. You can also use the grouping tools to create groups and subgroups within a worksheet. In this course learn how to use the Find and Replace tools to quickly locate and change data values in a data range or worksheet. Another option to easily insert values in a cell is using dropdown menus. The power of Excel for the Web is the support provided for using formulas on your data. Learn how to work with formulas, including built-in formulas such as SUM, CHOOSE, and INDEX to quickly get totals or reference data and values. Also discover how to insert cell references to use data across multiple worksheets.
10 videos | 37m has Assessment available Badge
Analyzing Data with Tables & Charts
Analyze and present your data in a visually attractive manner in Excel for the Web. Learn how to prepare your data to insert your charts. Discover also how to change the appearance of your charts by changing the chart type or formatting different elements as titles, legends, and axis. Excel for the Web includes powerful tools to summarize, sort, count, and chart data. Learn how to create, edit, and format PivotTables. You can also sort and filter your data with labels, values, or even slicers. Even if Excel for the Web does not have an option to insert PivotCharts, you will see how to insert one from the Recommended Charts options and the Ideas tool.
9 videos | 39m has Assessment available Badge
Working in a Document with Other Users
Excel for the Web enables you to easily share your documents via email or upload them to OneDrive and SharePoint to collaborate with your team. This version of Excel also comes with a comments feature to communicate with others editors.
6 videos | 21m has Assessment available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Custom & Conditional Formatting
Excel 2013 is highly customizable when it comes to formats. Learn how to customize number, text, and date and time formats; create conditional formats; use conditional formatting tools; and apply color to the first new entry in a list.
6 videos | 38m available Badge
Finding, Sorting, & Filtering Data
You can easily find specific data and format how data displays in Excel 2013. Learn how to use the Find and Replace tools, sort and filter data, and hide duplicate values. Explore freezing panes, grouping items, and creating an outline.
9 videos | 42m available Badge
Referencing Data
Increase your Excel 2013 mastery by learning about referencing cells, using data across worksheets, absolute and relative references, and named ranges. In addition, explore automatic updates, formula auditing, and formula errors.
10 videos | 1h 9m available Badge
Working with Formulas
Learn how to use Excel 2013 for common tasks like calculating the interest on a loan, reaching a target value, solving problems, creating automatic reports, as well as finding, visualizing, and preventing duplicate values.
9 videos | 45m available Badge
Charts & Graphics
Display your data visually using Excel's built-in charting features. Learn how to insert, label, and format a chart; create various types of charts; combine types of charts; create comparative charts; and insert and customize trendlines.
14 videos | 1h 15m available Badge
PivotTables & PivotCharts
Analyze data efficiently using Excel 2013. Discover how to work with PivotTables, including formatting, sorting, filtering, grouping, and using slicers. In addition, explore how to insert, modify, and analyze using PivotCharts.
14 videos | 1h 19m available Badge
Conditional Formulas
Conditional formulas let you perform a calculation on a range of values by specifying the criteria the data must meet. Discover how to use built-in conditional formulas and create your own.
9 videos | 51m available Badge
Extracting Information with Formulas
You can use formulas to extract and analyze data in your spreadsheet. Discover how to use the MAX, MIN, LARGE, and SMALL formulas, and work with VLOOKUP to cross-reference the contents of two lists.
13 videos | 1h 9m available Badge
Configuring Excel
Excel can be customized to suit the user's preferences and work habits. Discover how you can adjust the input options, document view settings, interface, ribbon, and Quick Access Toolbar.
5 videos | 28m available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

The Power View Add-in
Power View allows you to create reports you can use to extract, analyze, and present data contained in the different tables in your workbook. Learn how to use Power View, including creating and formatting reports and creating relationships.
14 videos | 1h 7m available Badge
The Power Pivot Add-in
Power Pivot allows you to create advanced PivotTables and PivotCharts in Excel 2013. Discover how to work with Power Pivot, so you can analyze data from a variety of sources.
13 videos | 1h 5m available Badge

COURSES INCLUDED

Custom & Conditional Formatting
In addition to the formats built into Excel, you can also use custom formats. Discover how to create and use custom date, time, number, and formats, and work with conditional formatting in Excel.
7 videos | 27m available Badge
Finding, Sorting, & Filtering Data
In large spreadsheets, it is not always easy to locate the data you need. Discover the tools in Excel to find, replace, sort, and filter data. Also, learn how to create an outline, freeze panes, and hide duplicate values.
10 videos | 32m available Badge
Referencing Data
To use the contents of a cell, you must know how to reference that cell. Explore absolute and relative cell referencing, and discover how to work with named data ranges, formula auditing tools, and formula error messages in Excel.
10 videos | 43m available Badge
Working with Formulas
Excel includes tools and formulas for solving more advanced problems. Discover how to calculate loan interest, solve problems, and prevent duplicate values.
9 videos | 38m available Badge
Charts & Graphics
Using charts is an effective way to present data in your Excel spreadsheet. Discover how to insert, format, and customize different chart types in Excel, and how to insert and work with trendlines.
15 videos | 1h 2m available Badge
PivotTables & PivotCharts
A PivotTable is one of the most powerful and intimidating features in Excel. Discover how to get the most out of a PivotTable or PivotChart to help you summarize and extract information from your data.
14 videos | 58m available Badge
Conditional Formulas
Excel includes a number of formulas for extracting information from data. Discover how to use a number of these formulas, translate data, and keep tables up-to-date in Excel.
9 videos | 43m available Badge
Extracting Information with Formulas
Excel 2010 is a highly customizable application. Discover how to extract information with formulas, cross reference data lists, insert data automatically, and more.
13 videos | 1h available Badge
Configuring Excel
Excel can be customized to suit the user's preferences and work habits. Discover how to adjust the input options, document view settings, interface, ribbon, and Quick Access toolbar.
5 videos | 18m available Badge
Migrating from Excel 2003 to Excel 2010
Migrating from a previous version of Microsoft Excel can be made easier by understanding the similarities and differences between versions. Explore Excel's data manipulation, printing, formulas, and problem solving tools.
7 videos | 51m available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Custom & Conditional Formatting
To customize data, you can use the built-in formats in Excel 2019, or you can use your own. In this 10-video course, learners will observe how to create custom formats for numbers, text, and date and time, as well as how to create and use conditional formatting. To begin, discover how to customize your number formats, formatting currency, percentages, and phone numbers for data values. Next, observe how to customize your text formats, changing the text format by adding or modifying a text element's appearance; create custom color formatting for data entries; and apply conditional custom formatting to data values. Delve into creating conditional format rules to enhance your data values display; use conditional formatting to highlight data in cells, rows, and columns; and use conditional formatting tools to analyze your data further. This leads into exploring advanced conditional formatting tools, and using these tools to find duplicate values or hide values. Conclude the course by discovering how to organize conditional formatting rules applied to a worksheet. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Custom & Conditional Formatting Exercise as well as the associated materials in the Resources section.
10 videos | 46m has Assessment available Badge Certification PMI PDU
Finding & Grouping Data
Excel 2019 includes a number of methods for locating, displaying, and manipulating data entries. In this 8-video course, learners observe how to work with specific data using the Find and Replace tools, and manipulate data with the Group and Outline tools. Begin by learning how to find items in a worksheet, by using the Find tools to jump to locations in a worksheet and find items with basic search queries. Then learn how to use advanced Find tools to customize and refine search queries; the Selection tools to locate and select graphical objects in a worksheet; and the Replace tools to replace cell contents and formats. Next, examine how to use the Find and Replace tools when working specifically with formulas, and use the Freeze tools to change the view settings within a worksheet. Finally, observe how to group rows and columns in a worksheet and control their display, and use the Group tools to create Outlines in a worksheet. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Finding & Grouping Data Exercise as well as the associated materials in the Resources section.
8 videos | 35m has Assessment