Excel: Excel 2016 (Mac) intermediate

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=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=69470212&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=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=69470212&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 https://www.skillsoft.com/channel/excel-3356fb80-e248-11e6-91a7-0242c0a80704?technologyandversion=69470212&expertiselevel=3597583
  • 4 Courses | 3h 8m 33s
  • 6 Books | 45h 29m
  • 6 Courses | 4h 40m 18s
  • 6 Books | 45h 29m
  • 2 Courses | 1h 11m 49s
  • 7 Courses | 6h 33m 57s
  • 3 Books | 28h 43m
  • 7 Courses | 5h 23m 6s
  • 6 Books | 38h 19m
  • 7 Courses | 5h 6m 2s
  • 6 Books | 53h 17m
  • 2 Courses | 1h 30m 16s
  • 6 Books | 45h 29m
  • 2 Courses | 2h 30m 31s
  • 6 Books | 56h 36m
  • 9 Courses | 7h 12m
  • 5 Books | 40h 49m
  • Includes Test Prep
  • 9 Courses | 5h 31m 14s
  • 5 Books | 52h 55m
  • 10 Courses | 6h 42m 25s
  • 2 Courses | 53m 35s
  • 6 Books | 45h 29m
  • 8 Courses | 4h 39m 9s
  • 6 Books | 45h 29m
  • 5 Courses | 2h 45m 5s
  • 9 Courses | 8h 20m 2s
  • 3 Books | 19h 46m
  • 2 Courses | 2h 12m 28s
  • 4 Books | 14h 19m
  • 10 Courses | 7h 18m 2s
  • 6 Books | 38h 19m
  • 14 Courses | 8h 3m 53s
  • 7 Books | 58h 32m
  • 2 Courses | 57m 45s
  • 6 Books | 45h 29m
  • 3 Courses | 4h 7m 26s
  • 6 Books | 56h 36m
  • 9 Courses | 6h 57m 20s
  • 5 Books | 40h 49m
  • Includes Test Prep
  • 15 Courses | 7h 51m 18s
  • 4 Books | 38h 46m
  • 9 Courses | 7h 13m 31s
  • 3 Courses | 1h 53m 18s
  • 4 Books | 39h 1m
  • 2 Courses | 2h 50m 33s
  • 6 Books | 52h 52m
  • 2 Courses | 2h 3m 58s
  • 5 Books | 22h 45m
  • Includes Test Prep
  • 4 Courses | 2h 14m 38s
  • 1 Book | 15h 4m
  • 4 Courses | 3h 20m 8s
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
 
Excel is the powerful spreadsheet component of Microsoft Office. Discover Excel and its many uses.

GETTING STARTED

Using Workbooks in Excel iPad

  • 5m 23s
  • 2m 50s

GETTING STARTED

Opening & Setting Up Excel 2016 for Mac

  • 3m 35s
  • 5m 22s

GETTING STARTED

Discovering the Application in Excel for the Web

  • 4m 53s
  • 4m 57s

GETTING STARTED

Getting Started in Excel 2013 for Windows

  • 6m 48s
  • 4m 25s

GETTING STARTED

Getting Started in Excel 2010 for Windows

  • 4m 2s
  • 5m 26s

GETTING STARTED

Getting Started in Excel 2019 for Windows

  • 3m 14s
  • 6m 43s

GETTING STARTED

Using Workbooks in Excel for iPhone

  • 3m 56s
  • 6m 4s

GETTING STARTED

Complete Guide to Excel 365: Getting Started

  • 1m 59s
  • 9m 58s

GETTING STARTED

Getting Started in Excel 2016 for Windows

  • 2m 53s
  • 4m 13s

GETTING STARTED

Getting started in Excel 365

  • 50s
  • 4m 48s

GETTING STARTED

Getting started in Excel 365 (2023)

  • 55s
  • 4m 46s

GETTING STARTED

Visualizing Data in Tables & Charts in Excel iPad

  • 3m 45s
  • 3m 56s

GETTING STARTED

Custom & Conditional Formatting in Excel 2016 for Mac

  • 3m 53s
  • 4m 38s

GETTING STARTED

Inserting & Editing data in Excel for the Web

  • 3m 26s
  • 2m 21s

GETTING STARTED

Custom & Conditional Formatting in Excel 2013 for Windows

  • 6m 53s
  • 5m 48s

GETTING STARTED

The Power View Add-in in Excel 2013 for Windows

  • 3m 25s
  • 5m 53s

GETTING STARTED

Custom & Conditional Formatting in Excel 2010 for Windows

  • 4m 40s
  • 4m 2s

GETTING STARTED

Custom & Conditional Formatting in Excel 2019 for Windows

  • 5m 5s
  • 5m 36s

GETTING STARTED

Inserting Tables & Illustrations in Excel for iPhone

  • 3m 17s
  • 4m 40s

GETTING STARTED

Complete Guide to Excel 365: Using Formatting, Styles, & Themes

  • 2m 20s
  • 11m 9s

GETTING STARTED

Custom & Conditional Formatting in Excel 2016 for Windows

  • 5m 34s
  • 3m 17s

GETTING STARTED

Customizing text & number formats in Excel 365

  • 49s
  • 5m 2s

GETTING STARTED

Enhancing a worksheet with visual elements in Excel 365 (2024)

  • 53s
  • 4m 48s

GETTING STARTED

Getting to Know Macros in Excel 2019 for Windows

  • 3m 1s
  • 3m 24s

GETTING STARTED

Complete Guide to Excel 365: What-If Analysis, Solver, & Analysis ToolPak

  • 2m 20s
  • 11m 23s

GETTING STARTED

Using the Power View Add-in in Excel 2016 for Windows

  • 4m 2s
  • 4m 31s

GETTING STARTED

Performing data analysis and forecasting in Excel 365

  • 50s
  • 3m 22s

GETTING STARTED

Creating and Managing PivotTables in Excel 365 (2024)

  • 1m
  • 5m 22s

COURSES INCLUDED

Using Workbooks in Excel iPad
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 in Excel iPad
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 in Excel iPad
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 in Excel iPad
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 2016 for Mac
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 in Excel 2016 for Mac
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 in Excel 2016 for Mac
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 in Excel 2016 for Mac
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 in Excel 2016 for Mac
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 in Excel 2016 for Mac
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 in Excel for the Web
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
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 in Excel 2013 for Windows
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 in Excel 2013 for Windows
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 in Excel 2013 for Windows
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 in Excel 2013 for Windows
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 in Excel 2013 for Windows
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 in Excel 2013 for Windows
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 in Excel 2013 for Windows
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 in Excel 2010 for Windows
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 in Excel 2010 for Windows
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 in Excel 2010 for Windows
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 in Excel 2010 for Windows
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 in Excel 2010 for Windows
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 in Excel 2010 for Windows
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 in Excel 2010 for Windows
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 in Excel 2019 for Windows
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 in Excel 2019 for Windows
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 in Excel 2019 for Windows
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 in Excel 2019 for Windows
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 in Excel 2019 for Windows
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 in Excel 2019 for Windows
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 | 52m has Assessment available Badge
Sharing & Collaborating on a Document in Excel 2019 for Windows
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
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Using Workbooks in Excel for iPhone
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 in Excel for iPhone
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 in Excel 2016 for Windows
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 in Excel 2016 for Windows
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 in Excel 2016 for Windows
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 in Excel 2016 for Windows
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 in Excel 2016 for Windows
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 in Excel 2016 for Windows
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 2016 for Windows 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 in Excel 2016 for Windows
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 in Excel 2016 for Windows
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. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
12 videos | 41m has Assessment available Badge
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. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
13 videos | 44m has Assessment available Badge
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. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
11 videos | 36m has Assessment available Badge
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. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
9 videos | 29m has Assessment available Badge
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. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
11 videos | 42m has Assessment available Badge
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. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
10 videos | 31m has Assessment available Badge
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. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
6 videos | 25m has Assessment available Badge
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. In order to practice what you have learned, you will find practice exercises in the Course Contents pane or in the Resources section.
9 videos | 42m has Assessment available Badge
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. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
11 videos | 37m has Assessment available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Getting started in Excel 365 (2023)
Microsoft Excel 365 is a powerful spreadsheet application that can help you organize, analyze, and present data. This course introduces you to the fundamental skills you need to start using the app. First, you will see how to open Excel and navigate its interface. You will also learn how to input and edit worksheet data, as well as insert and remove worksheets, columns, rows, and cells. Next, the course teaches you how to save your work and open saved spreadsheets. In addition, you will learn how to remove data from a worksheet, as well as how to undo and redo actions as you edit. Finally, discover how to find and use basic functions to manipulate spreadsheet data. See also how to create a worksheet from a template, customize the application interface, and share your worksheets with other users. This course aligns with the objectives of Exam MO-210: Microsoft Excel (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
10 videos | 43m has Assessment available Badge
Entering data in Excel 365 (2023)
Before you can begin analyzing data in Excel, you need to know how to input it into a worksheet. This course explores a variety of tools and techniques for adding and arranging data in Excel 365. The first part of this course introduces you to essential data entry tools. Find out how to use the clipboard commands and Paste Special to copy and move data between cells and sheets. Learn how to use AutoFill and Flash-Fill to copy data, complete series, and find patterns in your data. See also how to insert drop-downs to allow users to select cell values from a list. Next, the course explores two ways to enter data in multiple worksheets or workbooks. See how to arrange and navigate between multiple windows, as well as how to group worksheets to edit several sheets simultaneously. Finally, learn how to import data from external sources, such as text files, online sources, and images. This course aligns with the objectives of Exams MO-210: Microsoft Excel (Microsoft 365 Apps) and MO-211: Microsoft Excel Expert (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
11 videos | 42m has Assessment available Badge
Viewing & printing worksheets in Excel 365 (2023)
In Excel, you can change the way you view your worksheet data depending on your purpose. You can also print worksheets for others to see. This course covers various techniques for viewing and printing worksheets in Excel 365. The first part of the course covers different ways to view your worksheet. You will see how to adjust row and column dimensions. You will discover how to view and arrange multiple windows. You will also see how to view different parts of a worksheet at once by freezing panes and splitting worksheets, as well as how to view your worksheet in Full-Screen Mode, Page Layout View, and Page Break Preview. The second part of the course covers techniques to help you optimize your worksheet for printing. You will learn how to adjust the print page layout, set print areas, and configure layout for multiple pages. See also how to insert headers and footers, and configure print settings. This course aligns with the objectives of Exam MO-210: Microsoft Excel (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
11 videos | 45m has Assessment available Badge
Formatting cells in Excel 365 (2023)
Excel 365 offers a wide range of formatting options to enhance the presentation of your worksheet data. This video explores essential formatting tools in Excel. First, you will see how to change the appearance of cells. See how to add style to your worksheets by formatting text, borders, and cell backgrounds. Next, you will learn how to change the way data is arranged in your spreadsheet. Find out how to merge cells together and modify the vertical and horizontal alignment of text. See also how to wrap text and change text orientation. In addition, the course explores a number of other tools for formatting cells and worksheets. Discover how to use the Format Cells dialog box and change your cells' number format. Learn how to apply consistent formatting with Cell Styles, Format Painter, and by grouping worksheets. Finally, see how to clear formatting from selected cells. This course aligns with the objectives of Exam MO-210: Microsoft Excel (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
10 videos | 34m has Assessment available Badge
Referencing cells in Excel 365 (2023)
References are Excel are a way to refer to a cell, range, worksheet, or workbook in a formula. This course shows you how to use references to create formulas that dynamically update as the referenced cells change. The course begins by covering the basics of referencing. You will learn how to reference cells, ranges, rows, and columns. You will then see how to use them with the most common functions and operators in Excel to perform simple calculations. Next, the course explores the differences between relative references, which change as they are copied to other rows or columns, and absolute references, which stay the same. You will see how to use both types of reference in a formula, as well as mixed references, a combination of the two. In addition, you will learn how to reference cells in external worksheets and workbooks. You will also see how to give names to cells and ranges and to reference values by name. This course aligns with the objectives of Exams MO-210: Microsoft Excel (Microsoft 365 Apps) and MO-211: Microsoft Excel Expert (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
8 videos | 27m has Assessment available Badge
Exploring essential functions in Excel 365 (2023)
Excel functions cover a wide array of uses, from formatting text to performing calculations. This course delves into several of the most common functions in Excel 365. The course begins by exploring fundamental functions for working with data. You will see how to perform operations based on specific conditions using the IF() function. Learn how to use functions to count cells, round numbers, and generate numeric data. You will also discover the OFFSET() function, which lets you extract specific values from a dataset. The second part of the course covers some helpful functions for working with text. See how to clean up your text by removing spaces and changing letter case. Find out how to count characters and character positions using LEN(), SEARCH(), and FIND(). Finally, you will see how to use functions to extract text, combine multiple text strings, and replace one string with another. This course aligns with the objectives of Exam MO-210: Microsoft Excel (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
11 videos | 43m has Assessment available Badge
Working with tables in Excel 365 (2023)
Tables are a powerful tool for organizing, analyzing, and presenting data. In this course, you will learn all about creating and using tables. First, find out how to add and modify tables. See how to create a table from a range, as well as how to add, remove, and reorganize table rows and columns. Next, the course shows you how to use table styles to enhance the presentation of your data. See how to apply built in styles, configuring table style options, and creating custom styles to meet your specific needs. Finally, you will discover how to efficiently manipulate your table data. Learn how to perform calculations using calculated columns and structured references. See also how to organize your data by removing duplicates and using slicers to filter out certain values. This course aligns with the objectives of Exam MO-210: Microsoft Excel (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
9 videos | 39m has Assessment available Badge
Getting started with charts in Excel 365 (2023)
Visualizing information with charts and graphs is a critical skill in today's data-driven environment. This course walks you through everything you need to know to create, format, and manage charts in Excel 365. The course begins by introducing you to the process of creating various chart types from a range or table. See how to browse through column charts, line graphs, and more, and choose the type that fits your data best. You'll then learn to modify these charts, managing their layout, style, and data. Next, find out how to add and configure titles, axes, and a wide variety of other chart elements from error bars to trendlines. See how to format the style and properties of these elements to highlight specific data points. You'll also learn how to add and format sparklines, small in-line charts that you can use to succinctly communicate trends. This course aligns with the objectives of Exam MO-210: Microsoft Excel (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
11 videos | 48m has Assessment available Badge
Setting your work preferences in Excel 365 (2023)
You can get more out of Excel 365 by customizing the app. This course explores different ways to tailor the Excel application and interface to your needs. First, see how to personalize elements of the interface. You will see how to change your Office account options, including the Office Theme and application background. Find out how to customize the Quick Access Toolbar and Ribbon as well. Next, you will learn how to configure other key aspects of Excel. In particular, see how to modify save settings and default workbook settings. Finally, discover other ways to customize your experience in Excel. See how to create your own custom templates and install add-ins to extend the app's functionality. This course aligns with the objectives of Exam MO-210: Microsoft Excel (Microsoft 365 Apps).
9 videos | 35m has Assessment available Badge
10 common tools in Excel 365 (2023)
To make the most out of Excel 365, you need to be familiar with some of its most frequently-used features. This course highlights ten tools to help take your Excel proficiency to the next level. In this course, you will see how to use the Selection Pane and related tools to select objects in a worksheet. Find out how to quickly apply commands with keyboard shortcuts, search, and KeyTips. Discover a number of features designed to help you review your worksheet, including spell check, AutoCorrect, Smart Lookup, and Translate. In addition, the course explores different ways to find and resolve issues in your workbooks. See how to check for issues related to compatibility with older versions of Excel, accessibility to users with different needs, as well as privacy and confidentiality. Finally, find out how to recover unsaved workbooks. This course aligns with the objectives of Exam MO-210: Microsoft Excel (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
11 videos | 42m has Assessment available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Visualizing Data in Tables & Charts in Excel iPad
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 in Excel iPad
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 Excel 2016 for Mac
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 Excel 2016 for Mac
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 in Excel 2016 for Mac
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 in Excel 2016 for Mac
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 in Excel 2016 for Mac
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 in Excel 2016 for Mac
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 in Excel 2016 for Mac
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 2016 for Mac
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 in Excel for the Web
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 in Excel for the Web
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 in Excel for the Web
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 in Excel for the Web
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 in Excel for the Web
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 in Excel 2013 for Windows
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 in Excel 2013 for Windows
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 in Excel 2013 for Windows
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 in Excel 2013 for Windows
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 in Excel 2013 for Windows
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 in Excel 2013 for Windows
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 in Excel 2013 for Windows
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 in Excel 2013 for Windows
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 2013 for Windows
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 in Excel 2013 for Windows
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 in Excel 2013 for Windows
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 Excel 2010 for Windows
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 Excel 2010 for Windows
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 in Excel 2010 for Windows
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 in Excel 2010 for Windows
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 in Excel 2010 for Windows
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 in Excel 2010 for Windows
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 in Excel 2010 for Windows
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 in Excel 2010 for Windows
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 2010 for Windows
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 for Windows
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 in Excel 2019 for Windows
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
Finding & Grouping Data in Excel 2019 for Windows
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 available Badge
Sorting & Filtering Data in Excel 2019 for Windows
The first step in analyzing the data in a worksheet is often taken with Excel's sorting and filtering tools. These tools help you to control what is displayed in your data range, and how the values are organized. Key concepts covered in this 10-video course include how to sort data in a worksheet according to a specific data type; how to customize sort options when sorting data in a worksheet and sort data by using multiple criteria and sort levels; and how to create and use custom sort lists to sort data. Next, learn how to use column filters to filter data in a worksheet; to use column filters to apply multiple filters to data in a worksheet; and to create filter arguments by using text and number data types. Finally, you will learn to sort and filter data by using colors applied to data; learn to use the advanced filter tools to filter and extract data; and learn to use filter tools to hide duplicate values in a data range. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Sorting & Filtering Data Exercise as well as the associated materials in the Resources section.
10 videos | 37m has Assessment available Badge
Referencing Data in Excel 2019 for Windows
Manipulating data in Excel begins with knowing how to reference cells. This involves using cell coordinates to extract the specified cells value. You can reference individual cells, a range of cells and entire columns and rows. In this 10-video course, you will discover absolute and relative cell references, by using data across multiple worksheets, and formula auditing in Excel 2019. Key concepts covered in this course include how to reference cells in your Excel worksheet; how to use data across multiple worksheets to reference data for formulas; and how to define absolute and relative cell references. Next, you will learn how to create named ranges to refer to data and facilitate calculations; how to use the Name Manager to visualize, edit, and delete existing named ranges; and how to perform calculations using constant values. Finally, learn how to use cell references indirectly; how to monitor data entries for changes and errors; how to activate and configure automatic updates; and how to use formula auditing tools to track data. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Referencing Data Exercise as well as the associated materials in the Resources section.
10 videos | 43m has Assessment available Badge
Forecasting & Solving Problems in Excel 2019 for Windows
Discover how to go further with your Excel document through understanding potential formula errors, use intelligent data types, and set goals to reach targets as well as problem-solve with the Solver and Forecast tools offered by Excel 2019. Key concepts in this 7-video course include how to identify formula errors and to understand the wide range of formula error messages; how to check for and evaluate formulas in a workbook; and how to use formulas to estimate loan-related costs and help you estimate and managed repayments. Continue by learning how to use the Goal Seek tool to modify a data variable and reach a target value; how to use the Solver add-in to analyze constraints and variables and optimize data values; and how to insert a Forecast worksheet to display trends and predictions based on available historic data. Finally, observe how to use Data Tables to create what if, variable-based scenarios, and once created, learn to adjust the values and change the calculation options. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Forecasting & Solving Problems Exercise as well as the associated materials in the Resources section.
7 videos | 33m has Assessment available Badge
Creating Charts & Graphics in Excel 2019 for Windows
Analyze and present your data in a more visually attractive manner in Excel 2019. Excel features several different chart types, each of which can be customized to suit your needs. In this 9-video course, you will learn how to insert and customize charts; to create chart templates and work with different chart types; and how to use trendlines. Key concepts covered in this course include how to insert, edit, and remove charts; how to customize chart labels including adding a chart title and data labels; land how to change a chart appearance by using the chart format tools. Next, learn how to customize individual chart elements in Excel, including customizing chart axes, moving a chart, and customizing the chart's titles, labels, and axes; how to create a chart template if you plan on reusing your customized chart; and how to present negative values in a chart. Finally, learn how to insert and customize trendlines that can be used for data ranges, movements, or correlations. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Creating Charts & Graphics Exercise as well as the associated materials in the Resources section.
9 videos | 34m has Assessment available Badge
Working with Different Chart Styles in Excel 2019 for Windows
Excel offers a variety of different chart types and styles for presenting and analyzing data in attractive and interesting ways. Learn how to insert, format, and manipulate Pie, Radar, Scatter, Bubble, Map, and Combo charts. Key concepts covered in this 6-video course include how to insert and edit pie charts, helpful when working with percentages; how to create and edit scatter charts be used to cross-reference values and combine different data types; land how to create and edit a bubble chart used to cross-reference three different types of information in a single chart. Continue by learning how to create and edit radar charts, which can be used to plot five different data values, and how to combine two types of chart by using the combo chart which you can use to create a graphic that combines multiple data types. Finally, you will observe how to create and edit a map chart for situations when you have data relating to locations, so you can use the map chart to plot values on a geographic display. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Working with Different Chart Styles Exercise as well as the associated materials in the Resources section.
6 videos | 23m has Assessment available Badge
Working with Excel Tables in Excel 2019 for Windows
Excel tables are a useful tool for quickly managing, analyzing, and manipulating data in a range. Once configured as a table, you can easily sort, filter, and perform calculations on your data, as well as change its appearance and formatting. Key concepts covered in this 6-video course include how to convert a data range into an table and edit its contents, giving you greater control over the inserted information; and how to perform calculations and manipulate data in an table such as create calculated columns to perform automatic calculations on data, quickly clean up your data with a sweep, and transform your data range into a PivotTable. Learners continue by examining how tables are highly customizable, as you learn how to use formatting tools and styles to change the appearance of a table, then learn to customize the table settings and tools. Finally, you will learn how to use slicers which can be used to filter and manipulate data in a table; and how to resize and format a slicer. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Working with Excel Tables Exercise as well as the associated materials in the Resources section.
6 videos | 18m has Assessment available Badge
Inserting PivotTables in Excel 2019 for Windows
Excel includes powerful tools to summarize, sort, count, and chart data. In this 11-video course, you will learn how to create, edit, and format pivot tables, sort, filter, and group data, and work with slicers and timelines. Key concepts covered in this course include how to create and insert a PivotTable; how to edit the source data and field setup in a PivotTable; how to use predefined styles and formatting tools to change the appearance of a PivotTable; and how to copy and move a PivotTable within a workbook. Next, learn how to use sort tools to change the display of data; how to use filter tools to show and hide data; and how to use label and value filters to analyze data. Finally, learn how to use group tools to sort and analyze related data and use a slicer to filter data; examine how to customize the behavior and appearance of a slicer; and observe how to customize the behavior and appearance of a slicer. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Inserting PivotTables Exercise as well as the associated materials in the Resources section.
11 videos | 31m has Assessment available Badge
Working with Data in PivotTables in Excel 2019 for Windows
Once your Excel PivotTables have been created, you will need to know how to manage and work with the data contained within. In this 8-video course, learners will learn how to analyze, calculate, collaborate, and more with Excel PivotTables. Key concepts covered in this course include how to use a PivotTable to find trends and drill into data, adding extra levels of detail and multiple value fields in a single table; how to use the Data Model to work with data from multiple tables; and how to import existing database tables into the Data Model and use them in a PivotTable. Next, learners will examine how to add Calculated fields that use already inserted data; how to use the Value field settings to work with values for comparison calculations; and how to see data from a PivotTable in a PivotChart then customize and format the PivotChart. Finally, because a PivotTable is highly customizable, you will observe how to configure and customize a PivotTable's display and control settings. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Working with Data in PivotTables Exercise as well as the associated materials in the Resources section.
8 videos | 28m has Assessment available Badge
Using Conditional Formulas in Excel 2019 for Windows
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 in this 8-video course. Key concepts covered in this course include how to insert a conditional sum formula to perform a sum calculation on certain data values in your range; how to insert a conditional message formula which can be used to display one message if a condition is met, and another if a condition is not met; and how to perform complex conditional formulas to create conditions based on calculations and analyze your data in a variety of different ways. Learners will continue by observing how to create multiple conditions; how to use IF & OR in conditional formulas; and how to use conditional formulas to count up value occurrences. Finally, you will learn to use reference positions in conditional formulas; and learn how to keep your table up to date with conditional formulas. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Using Conditional Formulas Exercise as well as the associated materials in the Resources section.
8 videos | 38m has Assessment available Badge
Finding & Analyzing Information with Formulas in Excel 2019 for Windows
A wide variety of Excel tools can be used to retrieve, return, and calculate data. In this 9-video course, learners will see how to retrieve date information and rank values, combine and separate data already available, and automate and simplify calculations with look-up tools and SUMPRODUCT. Key concepts covered here include how to extract date values and perform calculations by using dates; how to retrieve information relating to dates in the past, present, and future; and how to use ranking formulas to find smallest and largest values in a list. Next, learn how to extract data and separate values into separate cells; how to combine existing data values in a single cell; and how to analyze complex tables with multiple arrays to obtain summarized results. Continue by observing how to use VLOOKUP and HLOOKUP formulas to cross-reference data lists and check for missing values; how to use conditional formulas to perform a search across multiple tables and automatically insert data; and how to use VLOOKUP formula to cross-reference data lists and retrieve corresponding values. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Finding & Analyzing Information with Formulas Exercise as well as the associated materials in the Resources section.
9 videos | 36m has Assessment available Badge
Configuring Options & Settings in Excel 2019 for Windows
Get more out of Excel by customizing it to your own needs. In this 10-video course, you will learn how to manage your account, connected services, and add-ins; configure input, template, and formula options; and customize the interface, ribbon, and Quick Access Toolbar. Key concepts covered in this course include how to configure your account and services, including connecting multiple services to your account; how to install an add-in, access to manage it, and install add-ins from the Office Ribbon; and how to create a custom template and save that template for future use. Next, you will learn how to configure user and input behavior; how to change default formula and calculation settings; and how to change the workbook default settings. Learners then observe how to customize the way in which workbooks are saved; how to customize the appearance of the Excel application; and how to customize the Quick Access Toolbar and its commands. Finally, learn how to customize the Office Ribbon and its commands. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Configuring Options & Settings Exercise as well as the associated materials in the Resources section.
10 videos | 32m has Assessment available Badge
Managing Data in Excel 2019 for Windows
Excel offers a set of tools that allows you to explore more in detail data analysis and complex formulae. In this 8-video course, you will learn how to use different formulae to make calculations when you have multiple conditions imposed. You will also become able to forecast data by using the NPER function. Key concepts covered in this course include how to import, edit, and update data from a text file; how to import, edit and update data from a .csv file; and how to use the LOOKUP, MATCH, and INDEX functions to extract data. Next, you will learn how to run multiple conditions without nesting other functions; examine how to calculate averages by using one or more conditions; and learn how to calculate the smallest and the largest numbers that meet one or more criteria. Finally, learn how to count cells that meet one or more criteria; and how to calculate the number of periods to pay a loan and forecast loan approval that meet one or more criteria. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Managing Data Exercise as well as the associated materials in the Resources section.
8 videos | 42m has Assessment available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Inserting Tables & Illustrations in Excel for iPhone
You can add a variety of different objects to your Excel workbook. Charts and tables help you analyze and visualize your data, while images, shapes, and hyperlinks allow you to illustrate and enrich your documents.
8 videos | 33m available Badge
Using Collaboration Tools in Excel for iPhone
Excel for iPhone 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.
6 videos | 24m available Badge

COURSES INCLUDED

Complete Guide to Excel 365: Using Formatting, Styles, & Themes
Conditional formatting is a significant and powerful feature in Excel. In this course, you'll begin by using some of the more straightforward types of conditional formattings, such as those based on specific values or ranking. You'll then use the more visually appealing types of conditional formatting, such as data bars, icon sets, and color scales, before advancing to more complex custom formatting rules using worksheet functions and a cell's row and column information. Additionally, you'll distinguish the purpose of notes versus comments and how to work with them both. Finally, you'll learn to use built-in styles and themes, create custom styles and themes and export them for use in other Office 365 products, such as PowerPoint, to apply a uniform look-and-feel to all your spreadsheets and presentations.
11 videos | 1h 17m has Assessment available Badge
Complete Guide to Excel 365: Linking, Printing, & Protecting Workbooks
Some of the core benefits of working with data in Excel include connecting data combined from different workbooks and controlling how it's presented and who has access to it. In this course, you'll begin by linking data in different Excel workbooks, before editing, testing, and cleanly breaking those links. Next, you'll work with an often-ignored but powerful aspect of Excel - precise control over how a workbook is laid out and printed. You'll configure headers, footers, page numbers, background, images, and the views used to print only parts of a workbook. Finally, you'll use Excel's protection features for individual cells and cell ranges, worksheets, and workbooks. This includes setting roles and passwords, working with read-only workbooks, and utilizing editable cell ranges.
11 videos | 1h 20m has Assessment available Badge
Complete Guide to Excel 365: Validating, Cleaning, & Performing Lookups on Data
Excel is not only used for aggregating and analyzing data, but also for data cleansing. There are several data cleaning, validation, and checking techniques available, some of which are among Excel's most well-known and widely-used functions. In this course, you'll start by using various string and data manipulation functions to clean data and fill in missing values. Next, you'll perform simple data validation based on specific numeric thresholds and text lengths, before moving on to validation using lists. You'll then combine data validation to implement a formidable, dynamic data validation mechanism using named ranges and the INDIRECT formula. Finally, you'll use one-dimensional lookups - the classic HLOOKUP and VLOOKUP worksheet functions - as well as more complex, two-dimensional lookups utilizing a combination of INDEX and MATCH.
13 videos | 1h 29m has Assessment available Badge

COURSES INCLUDED

Custom & Conditional Formatting in Excel 2016 for Windows
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 in Excel 2016 for Windows
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 in Excel 2016 for Windows
Many times, you will use a cell value in a formula or another location. Discover absolute and relative cell references, using data across multiple worksheets, formula auditing, and interpreting formula errors in Excel 2016.
10 videos | 47m has Assessment available Badge
Working with Formulas in Excel 2016 for Windows
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 in Excel 2016 for Windows
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 in Excel 2016 for Windows
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 Excel 2016 for Windows
In some cases, you may need to create formulas using data based on specific criteria in your range. Learn how to create and work with conditional formulas in Excel 2016, including SUMIF, SUMIFS, and SUMPRODUCT.
9 videos | 41m has Assessment available Badge
Extracting Information with Formulas in Excel 2016 for Windows
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 in Excel 2016 for Windows
Get more out of Excel 2016 by customizing it to your own needs. Learn how to manage your account, connected services, and add-ins; configure input and formula options; and customize the interface, ribbon, and Quick Access Toolbar.
8 videos | 28m has Assessment available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Customizing text & number formats in Excel 365
To configure how your data displays, you can use the various built-in formatting options in Excel 365, or create your own. In this course, you will learn how to use formulas to separate data entries into various cells as well as to modify the case of your text. In addition, you will find out how to create custom formats for text and date or time values - including how to create custom color formatting for data entries. You will explore how to create randomized values, rank values; and round numbers up or down. Finally, you will explore how to use formulas to make substitutions or replacements for values. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
11 videos | 41m has Assessment available Badge
Finding and grouping data in Excel 365
Excel 365 includes several methods for locating and arranging data entries into groupings. In this course, you will learn how to use the Find and Replace tools when working with specific-data, and use the Group and Outline tools to manipulate data. To start, you will explore how to jump to specific locations in a worksheet and find items with basic search queries using the Find tools. Then you will learn how to use the advanced Find tools to customize and refine search queries, including how to use the Find and Replace tools when working specifically with formulas. Finally, you will explore how to replace cell contents and formats using the Replace tools, observe how to group rows and columns in a worksheet, control their display, and use the Group tools to create outlines. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
7 videos | 23m has Assessment available Badge
Filtering and sorting data in Excel 365
Excel 365 includes various sort and filtering tools, which you can use to analyze the data in a worksheet. You can use these tools to organize and choose what values are shown in a range. The key concepts in this course include how to use filter tools and how to remove duplicate values in a data range. See how to use column filters to filter data and apply multiple filters to values in a worksheet. Create filter arguments using text and number data types to show values that meet defined filter criteria. Finally, you will learn how to sort and filter data according to their background fill color; sort data in a worksheet according to a specific data type; customize the sort options; apply multiple criteria and sort levels, and create and use custom sort lists. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
11 videos | 34m has Assessment available Badge
Using conditional formulas in Excel 365
Conditional formulas let you perform calculations in Excel 365 on a range of values by specifying the criteria the data must meet. In this course, discover how to use built-in conditional formulas and create your own. Key concepts covered in this course include how to insert a conditional SUM formula to perform a sum calculation on certain data values; insert a conditional message formula that can be used to display one message if a condition is met, and another if a condition is not met; check if a value is not equal to another; and how to perform complex conditional formulas to create conditions based on calculations and analyze your data in a variety of different ways. You will also explore how to create multiple conditions; how to use IF and OR in conditional formulas; and how to use conditional formulas to count up value occurrences or call out data. Finally, you will learn to use reference positions in conditional formulas and analyze data ranges with conditional formulas. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
9 videos | 31m has Assessment available Badge
Applying custom formatting in Excel 365
To customize data even further, you can create your own conditional formatting in Excel 365. In this course, you will observe how to create and use conditional formatting, work with intelligent data types, and convert values from the default base-10 number system into binary and hexadecimal. To start, you will discover how to apply advanced conditional custom formatting to data values and create conditional formatting rules to enhance how your data values display. You will also delve into managing conditional formatting rules and using intelligent data types that can be mapped automatically to existing values in a data range, thereby enriching your worksheets and reports. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
6 videos | 19m has Assessment available Badge
Finding and analyzing data with formulas in Excel 365
A wide variety of Excel 365 tools can be used to retrieve, return, and calculate data. In this course, you will explore how to use formulas to retrieve specific types of information as well as how to automate and simplify calculations with lookup tools. Key concepts covered include how to automate formulas using the Fill Down tool, how to use formulas to extract date values, and perform calculations by using dates. Next, you will learn how to use VLOOKUP and HLOOKUP formulas to cross-reference data lists and check for missing values; how to find a value in a double-entry table; and how to create automatic reports summarizing a data table with the SUMPRODUCT formula. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
11 videos | 36m has Assessment available Badge
Referencing data in Excel 365
In Excel 365, manipulating data requires knowing how to reference cells. This involves using cell coordinates to extract a specified cell's value. You can reference individual cells, a range of cells, or entire columns and rows. In this course, you will learn about absolute and relative cell references and how to use data references across multiple worksheets. Key concepts covered in this course include how to reference cells in your Excel worksheet; how to use data across multiple worksheets to reference data for formulas; and how to define absolute and relative cell references. Next, you will learn how to work with named ranges to refer to data and facilitate calculations, how to use cell references indirectly, and how to perform calculations using constant values. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
7 videos | 22m has Assessment available Badge
Solving data problems in Excel 365
Discover how to go further with your Excel 365 content by understanding the potential for formula errors. See how to use error checking and formula auditing tools, use the Goal Seek tool to let Excel 365 update variables for a formula to meet a specific outcome, and use the Watch Window tool to monitor data entries stored in different locations. Key concepts in this course include how to identify formula errors and understand the wide range of error messages. You will also learn how to check for and evaluate formulas in a workbook and how to use the Goal Seek tool to change constraints and variables to optimize your data values accordingly. Finally, you will explore how to use the Watch Window tool to monitor specific data entries, even from other workbooks. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
6 videos | 16m has Assessment available Badge
Using visual elements in Excel 365
An Excel 365 worksheet can contain more than just numbers and text. In this course, you will discover how to make your worksheets more visually appealing using hyperlinks, images, screenshots, shapes, icons, special characters, as well as colors and themes. Start by learning how to insert an image or photograph, which can be used to illustrate your data, and then learn how to insert a screenshot. Discover how to edit an image once it has been inserted into your Excel spreadsheet. You will then explore how to adjust an image's brightness, contrast, saturation levels, apply a variety of artistic effects and even add a border. You can also create diagrams using shapes and insert icons to help illustrate a worksheet. You will explore the different types of links and hyperlinks you can insert into your document. You will learn how to insert special characters into a cell and see how to use colors and themes to help data stand out and make a table easier to read. Also, you will discover how to create and edit clean, professional-looking titles with WordArt. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
12 videos | 39m has Assessment available Badge
Customizing charts in Excel 365
You can analyze and present your Excel 365 data in a more visually appealing way using Excel 365's various chart types. In this course, you will learn how to work with different chart types; and how to change a chart's appearance using the chart formatting tools. Next, you will learn how to customize individual chart elements, including customizing chart axes, moving or combining two types of chart, and customizing the chart's titles, labels, and axes. You will also explore how to insert and customize trendlines that can be used for data ranges, movements, or correlations; as well as how to add and modify Sparklines, which are at-a-glance visualizations. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
9 videos | 31m has Assessment available Badge
Creating advanced charts in Excel 365
Analyze and present your Excel data in a more visually appealing way using Excel 365's various chart types. In this course, you will learn how to work with different chart types; and how to change a chart's appearance using the chart formatting tools. Next, you will learn how to edit a chart's data series and customize the chart's titles, labels, and axes. You will also see how to save a chart type or chart formatting choice as a template to make it easier to use and include in future spreadsheets. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
11 videos | 29m has Assessment available Badge
Collaborating effectively in Excel 365
With Excel 365's sharing and collaboration tools, working as a team has never been easier. To facilitate efficient collaboration, see how to keep track of workbook versions, track changes, and comments. Excel 365 also enables one to easily share workbooks via email or upload them to OneDrive and SharePoint. In this course, you will explore how to collaborate with other users on an Excel workbook; how to edit a workbook's properties; track any changes made to your workbook data; and learn how to manage a workbook's version history. You will also discover how to protect Excel workbooks from unwanted edits, and manage a workbook's comments. Furthermore, you will discover how to manage your Excel 365 account and the services you have connected to it and how to save your workbooks to OneDrive. Explore how to use the integrated email function to send your Excel workbook to other users via email. You will discover how to share workbooks via a link. And manage link access and permissions, so you can change link editing permissions to be more restrictive or open. Finally, you can choose the format for the workbook, send it as a PDF, and view a workbook's statistics. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
14 videos | 49m has Assessment available Badge
Creating PivotTables and PivotCharts in Excel 365
Excel 365 includes powerful tools to summarize data. In this course, you will learn how to create, edit, and format PivotTables and PivotCharts; and how to use slicers. Key concepts covered in this course include how to use a PivotTable to find trends in data, and how to add extra levels of detail and multiple value fields in a single table. Because a PivotTable is highly customizable, you will observe how to configure and customize its display and control settings. Next, you will examine how to use label and value filters to analyze data, how to use a slicer to filter data, and how to customize the appearance of a slicer. Finally, you will explore how to use data from a PivotTable to create a PivotChart and then customize and format the PivotChart. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
11 videos | 37m has Assessment available Badge
Manipulating PivotTable data in Excel 365
Once you have created your Excel PivotTables, you will need to know how to manage and work with the data contained in them. In this course, you will learn how to analyze, calculate, compare, and work with Excel PivotTables as well as use the timeline. Key concepts covered in this course include how to edit the source data and field setup in a PivotTable; how to organize data logically by creating data groups within a PivotTable; and how to incorporate data from external sources to analyze in an Excel 365 PivotTable. You will also learn how to use sort tools to change the display of data; use filter tools to show and hide data, and work with values for comparison calculations. Finally, you will discover how to troubleshoot common PivotTable issues in Excel 365. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
11 videos | 39m has Assessment available Badge
Troubleshooting common issues in Excel 365
In Excel 365, it is easy to prevent and resolve issues when working with multiple workbooks. In this course, you will learn how to check whether your workbook has compatibility issues with older versions of Excel, whether it contains personal information that you may not want to share with others, as well as how to recover unsaved documents. Also, you will learn how to ensure formulas are updated automatically when changes are made. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
6 videos | 19m has Assessment available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Enhancing a worksheet with visual elements in Excel 365 (2024)
Excel 365 offers a suite of tools to beautify and enhance worksheets. Users can easily insert hyperlinks, add informative and attractive images, and tailor these images to fit their needs through resizing, cropping, or rotating. The Picture Tools tab provides a variety of editing options, such as brightness and contrast adjustments, along with artistic and decorative effects for comprehensive image customization. For further visual impact, shapes, and icons can be inserted and styled with a range of colors, gradients, and textures. The Symbol dialog box simplifies the inclusion of special characters, while WordArt allows for the creation of dynamic titles with various styles and effects. The workbook's overall look can be unified with themes from the Page Layout tab, which users can customize to reflect their personal or brand style. This course aligns with the objectives of Exam MO-210: Microsoft Excel (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
12 videos | 51m has Assessment available Badge
Collaborating safely in Excel 365 (2024)
Discover the power of seamless collaboration with Excel 365. This course covers essential skills for sharing, managing, and protecting your workbooks. Learn how to share data effortlessly using links, and take control of who has access with comprehensive permission settings. Delve into the nuances of managing comments for efficient teamwork, and explore real-time collaboration tools that allow you to work on workbooks simultaneously with colleagues. Understand the importance of version history to track and revert changes, ensuring data integrity. Gain knowledge on saving workbooks in various formats for compatibility and distribution. Ensure your data remains secure by learning how to protect both individual worksheets and entire workbooks, preventing unwanted alterations. Finally, become adept at viewing and modifying workbook properties to keep your information organized and up-to-date. This course aligns with the objectives of Exams MO-210: Microsoft Excel (Microsoft 365 Apps) and MO-211: Microsoft Excel Expert (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
11 videos | 50m has Assessment available Badge
Managing data in Excel 365 (2024)
Excel 365 provides a variety of methods for effectively handling data entries. In this course, explore options for navigating and selecting special items, finding and replacing data values, as well as grouping, sorting, and filtering data entries. First, discover how to navigate and locate specific items using basic search queries with the 'Go To' command. For selecting unique items, such as blank cells and visible data values, learn how to use the 'Go To Special' options. Next, explore the Find and Replace features to refine search and replacement queries, particularly when dealing with formulas. Sorting and filtering are key to managing data in Excel 365. Learn to categorize and display data by cell values or types, organize it with various sorting options, and apply multiple criteria for filtering. Furthermore, delve into using column filters to sift through information and implement multiple filters for values in a worksheet. Additionally, discover how to filter data to show unique values, eliminate duplicate entries in a data range, and reveal values that meet specific filter criteria. Finally, explore the options for grouping rows and columns in a worksheet by creating outlines or adding subtotals. This course aligns with the objectives of Exams MO-210: Microsoft Excel (Microsoft 365 Apps) and MO-211: Microsoft Excel Expert (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
12 videos | 52m has Assessment available Badge
Using Custom and Conditional Formatting in Excel 365 (2024)
Excel 365 provides various advanced tools for data presentation and analysis. In this course, discover the different techniques for customizing number, date, and time formats, as well as using conditional formatting to enhance data management. First, learn how to tailor number formats to meet specific requirements, which include creating unique custom number formats and adjusting date and time formats for better clarity and locale-specific presentation. Next, discover the power of conditional formatting, a feature in Excel 365 that enables users to apply formatting rules to cells based on their values or other criteria. Learn how to analyze data effectively using conditional formatting, customize these rules for more complex data scenarios, apply them using formulas for dynamic formatting, and manage multiple formatting rules efficiently. Lastly, explore how to use intelligent data types in Excel 365, a feature that enhances the functionality of spreadsheets by allowing users to work with rich, contextual data. This course aligns with the objectives of Exams MO-210: Microsoft Excel (Microsoft 365 Apps) and MO-211: Microsoft Excel Expert (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
10 videos | 45m has Assessment available Badge
Performing logical and conditional calculations in Excel 365 (2024)
Enhance your data analysis skills with our in-depth course on advanced formula techniques for Excel 365. In this course, discover how to build powerful nested formulas with logical and conditional functions, helping you to tackle complex problems with ease. First, learn to optimize your workflow by combining different logical functions and using the IFS and SWITCH functions for effective decision-making processes. Understand how to sum up data based on specific conditions and use conditional average functions to get useful insights from your datasets. Next, discover important techniques for counting data with conditions, using the MAXIFS and MINIFS functions to find maximum and minimum values within given criteria. Moreover, you'll learn the LET function make your calculations simpler and faster. This course aligns with the objectives of Exam MO-211: Microsoft Excel Expert (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
9 videos | 44m has Assessment available Badge
Using advanced functions in Excel 365 (2024)
Excel 365 offers a variety of advanced functions for data management and formula creation. In this course, discover how to build formulas to find information in tables, work with data arrays, and obtain date-related information. First, enhance your data management and analysis skills with powerful lookup functions such as VLOOKUP, HLOOKUP, and the newly introduced XLOOKUP. These tools are crucial for cross-referencing data across different lists, identifying and filling in missing information, and precisely inserting relevant data. Next, learn techniques to retrieve, manipulate, and analyze information based on dates. Deal effectively with historical records, current data, or future projections by mastering date-related functions such as NOW, TODAY, WEEKDAY, and WORKDAY in Excel 365. Additionally, learn to summarize complex tables containing multiple arrays, equipping you with the analytical skills to extract meaningful insights from extensive datasets. For instance, use the RANDARRAY function to create random arrays for simulation or sampling purposes, enhancing your modeling and analytical capabilities for various scenarios. Finally, refine your ability to organize and clarify your data with advanced sorting and filtering techniques using formulas, ensuring that you can present your findings clearly and impactfully. This course aligns with the objectives of Exam MO-211: Microsoft Excel Expert (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
10 videos | 48m has Assessment available Badge
Troubleshooting errors in Excel 365 (2024)
Excel 365 is equipped with robust data management and error-checking features that enhance data integrity, streamline the resolution of formula errors, and improve spreadsheet performance. This course provides detailed insights into configuring tools to prevent and resolve errors in data entry and formula creation. Data validation is a pivotal feature that confines data entry to specific types, such as items from a drop-down menu, dates, or text, to ensure consistency and accuracy. This feature also enables the implementation of input messages and error alerts to guide accurate data entry. Formulas can be a frequent source of errors in Excel. The course offers techniques to effectively identify and rectify these errors. It teaches how to interpret error messages, employ formula auditing tools to track down and correct inaccuracies, and develop a comprehensive understanding of Excel's error-checking functions. Moreover, the course delves into advanced error-checking strategies and formula evaluation techniques. It introduces the Watch Window for real-time monitoring of critical data points and formula outcomes, which removes the need for navigating between sheets. Lastly, learn how to configure formula calculation options to customize how formulas function, set error checking rules, and manage data calculations. This course aligns with the objectives of Exams MO-210: Microsoft Excel (Microsoft 365 Apps) and MO-211: Microsoft Excel Expert (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
9 videos | 41m has Assessment available Badge
Analyzing and forecasting data in Excel 365 (2024)
Excel 365 is a powerful tool for data management tasks, such as consolidating, analyzing, and forecasting. This course offers a deep dive into these advanced features of Excel 365 to optimize how to handle data from different sources and get useful insights. First, discover the different What-If Analysis tools to evaluate different scenarios. Learn how to use the Scenario Manager tool to compare different data outcomes and delve into What-If Analysis with data tables to perform sensitivity analysis. The course further explores Goal Seek for achieving specific data outcomes and employs the Solver add-in for solving complex optimization problems. Next, discover different tools to forecast data in Excel. For example, use the Forecast Sheet tool for visual predictions. Financial analysis is not overlooked, as the course covers estimating loan-related costs using Excel functions such as PMT, IPMT, and PPMT. Excel also provides two intelligent tools to get insights on how to analyze your data. Discover the Analyze Data feature for AI-powered analysis, and get to grips with the Copilot tool for advanced data insights through natural language processing. Lastly, discover how to consolidate data from various sources for streamlining the process of analysis and reporting. Explore Power Query, an essential part of Excel for data importation, transformation, and efficient data source management, including maintaining connections and automating data refreshes. This course aligns with the objectives of Exam MO-211: Microsoft Excel Expert (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
13 videos | 59m has Assessment available Badge
Working with advanced charts in Excel 365 (2024)
For individuals working with large data sets, the ability to display data clearly and efficiently is a crucial step in data analysis. This Excel 365 course offers a comprehensive review of various chart types available to improve data visualization skills. Discover how to create pie charts, focusing on the effective depiction of data proportions. Learn to summarize statistical distributions across data sets by creating and formatting box and whisker charts. To represent different data types within a single visual framework, learn how to prepare your data for creating combo charts and customize chart axes for precise and insightful data interpretation. Additionally, the course includes instruction on creating funnel charts, which are useful for illustrating process progressions, and generating histograms that help reveal frequency distributions and data patterns. The use of sunburst and waterfall charts is also thoroughly explored, offering techniques for visualizing hierarchical information and sequential data changes, respectively. Lastly, learn how to create chart templates, which can standardize the chart-making process to improve efficiency and consistency. This course aligns with the objectives of Exam MO-211: Microsoft Excel Expert (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
9 videos | 40m has Assessment available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Getting to Know Macros in Excel 2019 for Windows
If you have tasks in Excel 2019 that you do repeatedly, you can record a macro to automate those tasks. When you create a macro, you are recording your mouse clicks and keystrokes. After you create a macro, you can edit it to make minor changes to the way it works. Key concepts covered in this 10-video course include how to record macros and perform actions that can be implemented in Excel workbooks, how to save a workbook with macros and an Excel macro-enabled workbook, how to find and use macro tools that are available in multiple locations, and how to add macro recording to your status bar for easy access. Then learn how to navigate the VBA Editor interface, an application easily accessible via Excel, to manage your macros and workbook VBA code; how to manage macros, edit macros, and enable macros in a workbook; and how to access macro security settings and manage macro security options. Finally, you will observe how to use macros across multiple workbooks. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Getting to Know Macros Exercise as well as the associated materials in the Resources section.
10 videos | 33m has Assessment available Badge
Creating & Editing Macros in Excel 2019 for Windows
In Excel 2019 you can use the Visual Basic Editor to create and manage your macros. It's important to identify the key objects in your macro in order to start writing code for your Excel document. In this course you will see how to insert procedures and start writing code. You will also see how to use objects and even create events to interact with those objects. Once you start writing code it's important to know how to identify and correct errors found in your code. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Creating & Editing Macros Exercise as well as the associated materials in the Resources section.
10 videos | 42m has Assessment available Badge
Working with Macros in Excel 2019 for Windows
If you are using your Excel worksheet to input data, you can create form to fill out you worksheets more easily. With the VBA editor you can insert, edit and customize your forms to make inputting data easier for your users. Excel 2019 also gives you the possibility to use macros within formulas. You can use macros in formulas to format text, perform calculations and even export charts to easily share or present to others. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Working with Macros Exercise as well as the associated materials in the Resources section.
8 videos | 36m has Assessment available Badge

COURSES INCLUDED

Complete Guide to Excel 365: What-If Analysis, Solver, & Analysis ToolPak
Excel's Scenario Manager allows you to create named scenarios with different values for key variables. These scenarios can be quickly examined and summarized using the What-If Analysis tool. In this course, you'll use GoalSeek and Solver, both of which are mathematical tools. Goal Seek comes in handy when solving quadratic, cubic, or other equations. Solver is much more powerful and allows complex constrained optimization problems to be easily defined and addressed. As you'll recognize, Solver's interface, used for specifying objective functions and constraints, is intuitive and easy to use. Next, you'll use several heavy-duty statistical techniques in Analysis ToolPak. These range from the creation of correlation and covariance matrices, hypothesis testing, and F-test and T-test interpretations to ANOVA, random and periodic sampling, and the construction and analysis of linear regression models.
12 videos | 1h 35m has Assessment available Badge
Complete Guide to Excel 365: Pivot, PowerPivot, & Financial Modeling
In this course, you'll recognize how relational data - data with schema and clearly-defined column names - can be imported into Excel as a set of data tables. This data can be sliced-and-diced using classic Excel pivot tables or the more robust PowerPivot add-in. Now a standard part of Excel, this add-in vastly expands the tool's capabilities with some serious entity-relationship modeling and big data analysis. Excel has powerful capabilities to detect relationships across models and infer foreign key relationships between parent and child tables. Creating, visualizing, and modeling such relationships is an important aspect of working with relational databases. As you'll recognize, you can now accomplish much of that from within Excel using PowerPivot. In this course, you'll use some classic yet powerful worksheet functions that have ensured Excel's use in Wall Street for decades. These functions can be used to compute the yield of a bond and the present and future values of a set of cash flows. They can also be used to perform complex operations on settlement dates and compounding rates of financial instruments.
9 videos | 1h 14m has Assessment available Badge

COURSES INCLUDED

Using the Power View Add-in in Excel 2016 for Windows
You can use the Power View add-in to create reports in Excel 2016. Discover the capabilities of Power View, including illustrating and organizing reports, filtering data, and adding PivotTables and charts to reports.
17 videos | 1h 6m has Assessment available Badge
Using the Power Pivot Add-in in Excel 2016 for Windows
You can create advanced PivotTables and analyze data from a variety of different sources using the Power Pivot add-in for Excel 2016. Learn how to use Power Pivot to import databases, create and modify tables, and create a dashboard.
14 videos | 57m has Assessment available Badge

COURSES INCLUDED

Performing data analysis and forecasting in Excel 365
Explore how to make the most of your Excel 365 content by understanding the potential for data analysis and forecasting. Key concepts in this course include how to use formulas to estimate loan-related costs, and manage repayments. Learn how to insert a forecast worksheet to display trends and make predictions based on available historical data. You will find out how to combine the NPER function with the IF and OR functions to forecast data that meets one or more criteria; and observe how to use what-if, variable-based scenarios that, once created, let you adjust values and change your calculation options. Additionally, you will explore how to use the Analyze Data tool to analyze a dataset to look for patterns in the data and how to use the Power Query tool to import or connect to an external data source, such as a database. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
9 videos | 32m has Assessment available Badge
Creating and editing macros in Excel 365
If you have tasks in Excel 365 that you perform repeatedly, you can record a macro to automate those tasks. When creating a macro, you are recording your mouse clicks and keystrokes. After you create a macro, you can edit it to change the way it works. In this course, you will explore how to record macros and perform actions that can be implemented in Excel workbooks, and how to save in an Excel macro-enabled workbook. Find and use macro tools that are available in multiple locations, use macros across multiple workbooks, and add the Macro recording button to your status bar for easier access. In addition, you will learn how to navigate the VBA Editor interface, which is an application that's accessible via Excel, to manage your macros and workbook VBA code. You will further explore how to manage macros, edit macros, and enable macros in a workbook; and how to access and manage macro security settings. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
11 videos | 34m has Assessment available Badge
Managing macros in Excel 365
In Excel 365, you can use the Visual Basic Editor to create and manage your macros. It's important to learn how to identify macro components, so you can start writing code for your Excel workbook. In this course, you will explore how to insert procedures and write code in the VBA Editor. You will also learn about using objects and even creating events to interact with those objects. Once you start creating macros, it's important to know how to identify and correct errors found in your code. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
11 videos | 37m has Assessment available Badge
Using macros in Excel 365
If you are using your Excel worksheet to input data, you can create forms to quickly fill out your worksheets. With the VBA editor, you can insert, edit, and customize your forms to make inputting data easier for your users. Excel 365 also makes it possible to use macros within formulas to format text, perform calculations, and even export charts to easily share or present the data to others. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.
9 videos | 31m has Assessment available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Creating and Managing PivotTables in Excel 365 (2024)
PivotTables in Excel 365 are vital for organizing, summarizing, and refining large data sets efficiently. In this course, you will learn how to create and customize PivotTables, selecting the appropriate data for analysis and enhancing the table's visual layout for better readability. Next, discover advanced features such as slicers for dynamic data filtering, which enhance the user's ability to explore and present data. Additionally, you will learn how to apply label and value filters to focus on specific data points. The course also covers adding calculations within PivotTables for complex data operations. Lastly, you will learn to address common PivotTable issues, offering troubleshooting strategies that help users solve problems independently and maintain the quality of their data analysis. This course aligns with the objectives of MO-211: Microsoft Excel Expert (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
10 videos | 43m has Assessment available Badge
Using PivotTables and PivotCharts in Excel 365 (2024)
PivotTables and PivotCharts are useful tools to enhance Excel 365's data analysis capabilities. In this course, discover the different techniques to manipulate data in a PivotTable and create an insightful PivotChart to visualize data. First, discover how to sort and filter data within PivotTables to concentrate on pertinent information, and to group data to uncover trends and summarize complex datasets. To filter data by time periods, learn how to insert and work with a Timeline. Next, analyze data within PivotTables by comparing values and extracting significant insights. Similarly, learn how to manage PivotTables connected to multiple data sources, enabling the transformation of extensive databases into concise reports. In addition to data analysis, discover how to work with PivotCharts, a dynamic visual tool to represent PivotTable data effectively. For instance, learn how to customize and modify PivotCharts to ensure data visualization aligns with presentation objectives. This course aligns with the objectives of MO-211: Microsoft Excel Expert (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
11 videos | 51m has Assessment available Badge
Automating tasks in Excel 365 (2024)
Unlock the full potential of Excel 365 by automating repetitive tasks and transforming yourself into an efficiency expert. Discover how to automate basic tasks by creating macros and using the new Office Scripts. First, learn how to confidently activate macros within Excel 365. Then, discover how to record a macro to automate repetitive tasks, saving time and minimizing errors. Once you have created a macro, it's important to know how to save a workbook with macros, maintaining the integrity of your automated processes. This course also covers how to run macros smoothly, and view and modify them to ensure that you can tailor your automated tasks to your specific needs. As you become more proficient, discover the Visual Basic for Applications (VBA) Editor with ease, learning advanced techniques for editing macros to streamline complex tasks. Applying macros across different workbooks will no longer be a challenge as you master the methods to extend automation beyond a single file. Lastly, get an introduction to Office Scripts, a powerful feature of Excel 365. Learn to record, manage, and deploy Office Scripts, enabling cross-platform automation within Excel and OneDrive. This course aligns with the objectives of MO-211: Microsoft Excel Expert (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
12 videos | 52m has Assessment available Badge
Working with macros in Excel 365 (2024)
Macros in Excel 365 help you automate tasks, create custom functions, and enhance your productivity. In this course, discover how to use Visual Basic for Applications (VBA) to its full potential, transforming your Excel 365 experience and significantly boosting your efficiency. First, learn how to work with modules, insert procedures, and write effective VBA code. Explore the use of variables and constants to make your code flexible and robust. Gain a solid understanding of Excel objects, enabling you to manipulate workbooks, worksheets, and ranges with precision. Next, discover how to use operators and conditions to control the flow of your programs. Also, learn how to create and handle events to make your applications responsive to user actions. In addition, see how to design and program UserForms to create interactive forms for data input. Finally, learn how to address error management, ensuring that your macros run smoothly and efficiently. Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
12 videos | 53m has Assessment available Badge
SHOW MORE
FREE ACCESS

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

Office for iPad and Mac For Dummies
Packed with easy-to-follow, step-by-step instructions, this friendly guide walks you through every facet of Office, from installing the software to working with Word, Excel, and PowerPoint-and beyond.
book Duration 4h 40m book Authors By Peter Weverka

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 For Dummies
Whether you've used older versions of this popular program or have never gotten a headache from looking at all those grids, this hands-on guide will get you up and running with the latest version of Microsoft Excel quickly and painlessly.
book Duration 6h 57m book Authors By Greg Harvey

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
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

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 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 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

Office for iPad and Mac For Dummies
Packed with easy-to-follow, step-by-step instructions, this friendly guide walks you through every facet of Office, from installing the software to working with Word, Excel, and PowerPoint-and beyond.
book Duration 4h 40m book Authors By Peter Weverka

Book

Excel 2016 For Dummies
Whether you've used older versions of this popular program or have never gotten a headache from looking at all those grids, this hands-on guide will get you up and running with the latest version of Microsoft Excel quickly and painlessly.
book Duration 6h 57m book Authors By Greg Harvey

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
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

Book

Excel 2013 Bible
Whether you're an Excel beginner who is looking to get more savvy or an advanced user looking to become a power user, this perennial bestseller provides you with comprehensive coverage as well as helpful tips, tricks, and techniques that you won't find anywhere else.
book Duration 14h 43m book Authors By John Walkenbach

Book

Excel 2013 All-in-One For Dummies
Whether you're an Excel newbie or a veteran user who wants to learn the latest version, this handy guide shows you Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA.
book Duration 13h 47m book Authors By Greg Harvey

Book

Excel 2013 In Pictures
Helping students learn how to create and use Microsoft Excel spreadsheets, this book covers performing basic calculations, formatting worksheets, manipulating data, advanced calculations, and making data visible.
book Duration 13m book Authors By In Pictures, Inc.

BOOKS INCLUDED

Book

Excel 2010 All-in-One For Dummies
For newcomers to Excel or veterans who just want to learn the latest version, this guide - featuring eight self-contained minibooks - shows how to set up your first spreadsheet, collaborate on a worksheet, present results with charts and graphs, and more.
book Duration 14h 7m book Authors By Greg Harvey

Book

Excel 2010 In Pictures
Helping students learn how to create and use Microsoft Excel spreadsheets, this book covers performing basic calculations, formatting worksheets, manipulating data, advanced calculations, and making data visible.
book Duration 13m book Authors By In Pictures, Inc.

Book

Excel 2010 eLearning Kit For Dummies
Offering chapter summaries, practice exercises, discussions of concepts and essential terms, this guide shows you step by step to create worksheets, work with formulas and functions, format data, use financial functions, create charts and PivotTables, and more.
book Duration 2h 51m book Authors By Faithe Wempen

Book

Straight to the Point: Microsoft Excel 2010
Assessing what's new in Microsoft Excel 2010, this book introduces spreadsheet basics, creating worksheets, advanced techniques, charts, web-based commands, functions, keyboard shortcuts and more.
book Duration 2h 24m book Authors By Dinesh Maidasani

Book

Excel 2010 Bible
Presenting material in a clear, concise, logical format that is ideal for all levels of Excel experience, this authoritative guide provides comprehensive, soup-to-nuts coverage, delivering hundreds of pages of Excel tips, tricks, and techniques you won't find anywhere else.
book Duration 14h 27m book Authors By John Walkenbach

Book

Excel 2010 Made Simple
Containing over 500 screen visuals and clear-cut instructions to guide you through the features of Excel 2010, this hands-on book takes a practical and highly effective approach to showing you the best way to complete your most common spreadsheet tasks.
book Duration 4h 17m book Authors By Abbott Katz
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

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 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

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 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

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

Office 2019 All-in-One for Dummies
If you need to make sense of Office 2019 and don't have time to waste, this book is your crash course in every part of the Office suite, with valuable tips for making the most out of all of its applications.
book Duration 11h 6m book Authors By Peter Weverka
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

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 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

Office for iPad and Mac For Dummies
Packed with easy-to-follow, step-by-step instructions, this friendly guide walks you through every facet of Office, from installing the software to working with Word, Excel, and PowerPoint-and beyond.
book Duration 4h 40m book Authors By Peter Weverka

Book

Excel 2016 For Dummies
Whether you've used older versions of this popular program or have never gotten a headache from looking at all those grids, this hands-on guide will get you up and running with the latest version of Microsoft Excel quickly and painlessly.
book Duration 6h 57m book Authors By Greg Harvey

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
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

Book

Microsoft Excel 365 Complete: In Practice, 2019
Offering a fresh approach to teaching today's students Microsoft Excel skills, this book builds a foundation for success by helping students apply what they learn, and provides transferable skills that allow students to grasp critical thinking beyond the textbook assignments.
book Duration 14h 25m book Authors By Kathleen Stewart, Randy Nordell

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 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 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 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

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
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

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 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 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

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 For Dummies
Whether you've used older versions of this popular program or have never gotten a headache from looking at all those grids, this hands-on guide will get you up and running with the latest version of Microsoft Excel quickly and painlessly.
book Duration 6h 57m book Authors By Greg Harvey
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

Book

MrExcel 2021: Unmasking Excel
Written for those who already use Excel 40 hours a week, this book provides "aha" tips that uncover secret methods in Excel.
book Duration 3h 59m book Authors By Bill Jelen

Book

Microsoft Excel 365 Complete: In Practice, 2019
Offering a fresh approach to teaching today's students Microsoft Excel skills, this book builds a foundation for success by helping students apply what they learn, and provides transferable skills that allow students to grasp critical thinking beyond the textbook assignments.
book Duration 14h 25m book Authors By Kathleen Stewart, Randy Nordell

Book

Excel Formulas & Functions For Dummies, 6th Edition
Unlock the power of Excel with a step-by-step roadmap to its formulas and functions.
book Duration 5h 18m book Authors By Ken Bluttman

Book

Excel All-in-One For Dummies
You'll learn how to design worksheets, use formulas and functions, collaborate with colleagues and review their work, create charts and graphics, manage and analyze data, and create macros.
book Duration 14h 9m book Authors By Greg Harvey, Paul McFedries

Book

Microsoft Excel 365 Bible
The Excel 365 Bible carries over the best content from the best-selling Excel 2019 Bible while reflecting how a new generation uses Excel in Excel 365.
book Duration 15h 4m book Authors By Dick Kusleika, Michael Alexander
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

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

Book

Office for iPad and Mac For Dummies
Packed with easy-to-follow, step-by-step instructions, this friendly guide walks you through every facet of Office, from installing the software to working with Word, Excel, and PowerPoint-and beyond.
book Duration 4h 40m book Authors By Peter Weverka

Book

Excel 2016 For Dummies
Whether you've used older versions of this popular program or have never gotten a headache from looking at all those grids, this hands-on guide will get you up and running with the latest version of Microsoft Excel quickly and painlessly.
book Duration 6h 57m book Authors By Greg Harvey

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
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

Book

Excel 2016 For Dummies
Whether you've used older versions of this popular program or have never gotten a headache from looking at all those grids, this hands-on guide will get you up and running with the latest version of Microsoft Excel quickly and painlessly.
book Duration 6h 57m book Authors By Greg Harvey

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

Office for iPad and Mac For Dummies
Packed with easy-to-follow, step-by-step instructions, this friendly guide walks you through every facet of Office, from installing the software to working with Word, Excel, and PowerPoint-and beyond.
book Duration 4h 40m book Authors By Peter Weverka

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
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

Book

Excel 2013 Bible
Whether you're an Excel beginner who is looking to get more savvy or an advanced user looking to become a power user, this perennial bestseller provides you with comprehensive coverage as well as helpful tips, tricks, and techniques that you won't find anywhere else.
book Duration 14h 43m book Authors By John Walkenbach

Book

Excel 2013 for Scientists, Revised and Expanded, Third Edition
Enabling greater productivity and efficiency, this thorough reference teaches scientists the tips and techniques of Excel and will help them to tailor each specifically to their experiments, designs, and research.
book Duration 3h 20m book Authors By Gerard M. Verschuuren

Book

Excel 2013
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 43m book Authors By Michael Price

BOOKS INCLUDED

Book

Beginning Power BI with Excel 2013: Self-Service Business Intelligence Using Power Pivot, Power View, Power Query, and Power Map
Taking you through each tool in turn, using hands-on activities to consolidate what you've learned in each chapter, this step-by-step resource is your practical guide to getting maximum insight from your data, and presenting it with impact.
book Duration 2h 52m book Authors By Dan Clark

Book

Power Pivot and Power BI: The Excel User's Guide to DAX Power Query, Power BI & Power Pivot in Excel 2010-2016, 2nd Edition
Introducing the concepts in a simple, step-by-step manner tailored to the learning style of Excel users everywhere, this easy-to-follow guide presents techniques that allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce.
book Duration 5h 11m book Authors By Avi Singh, Rob Collie

Book

Excel Sales Forecasting for Dummies, 2nd Edition
Loaded with confidence boosters for anyone who succumbs to sweaty palms when sales predictions are mentioned, this trusted guide shows you how to use the many tools Excel provides to arrange your past data, set up lists and pivot tables, use moving averages, and so much more.
book Duration 5h 55m book Authors By Conrad Carlberg

Book

MS Excel: Let's Advance to The Next Level
An attempt to take you to the next orbit of competence in this fascinating world, this practical book is a ready reckoner for any practitioner who seeks to further his/her understanding of the tools and utilities.
book Duration 21m book Authors By Anurag Singal
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

Book

Excel 2010 Bible
Presenting material in a clear, concise, logical format that is ideal for all levels of Excel experience, this authoritative guide provides comprehensive, soup-to-nuts coverage, delivering hundreds of pages of Excel tips, tricks, and techniques you won't find anywhere else.
book Duration 14h 27m book Authors By John Walkenbach

Book

Straight to the Point: Microsoft Excel 2010
Assessing what's new in Microsoft Excel 2010, this book introduces spreadsheet basics, creating worksheets, advanced techniques, charts, web-based commands, functions, keyboard shortcuts and more.
book Duration 2h 24m book Authors By Dinesh Maidasani

Book

Excel 2010 eLearning Kit For Dummies
Offering chapter summaries, practice exercises, discussions of concepts and essential terms, this guide shows you step by step to create worksheets, work with formulas and functions, format data, use financial functions, create charts and PivotTables, and more.
book Duration 2h 51m book Authors By Faithe Wempen

Book

Excel 2010 In Pictures
Helping students learn how to create and use Microsoft Excel spreadsheets, this book covers performing basic calculations, formatting worksheets, manipulating data, advanced calculations, and making data visible.
book Duration 13m book Authors By In Pictures, Inc.

Book

Excel 2010 All-in-One For Dummies
For newcomers to Excel or veterans who just want to learn the latest version, this guide - featuring eight self-contained minibooks - shows how to set up your first spreadsheet, collaborate on a worksheet, present results with charts and graphs, and more.
book Duration 14h 7m book Authors By Greg Harvey

Book

Excel 2010 Made Simple
Containing over 500 screen visuals and clear-cut instructions to guide you through the features of Excel 2010, this hands-on book takes a practical and highly effective approach to showing you the best way to complete your most common spreadsheet tasks.
book Duration 4h 17m book Authors By Abbott Katz
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

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 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 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

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

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 Formulas & Functions for Dummies, 5th Edition
Including helpful, real-world examples and step-by-step instructions, this practical book is a must-read for beginning to intermediate Excel users who want to find out how to use Excel's powerful built-in functions.
book Duration 5h 15m book Authors By Ken Bluttman

Book

Office 2019 All-in-One for Dummies
If you need to make sense of Office 2019 and don't have time to waste, this book is your crash course in every part of the Office suite, with valuable tips for making the most out of all of its applications.
book Duration 11h 6m book Authors By Peter Weverka
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

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 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 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

Office for iPad and Mac For Dummies
Packed with easy-to-follow, step-by-step instructions, this friendly guide walks you through every facet of Office, from installing the software to working with Word, Excel, and PowerPoint-and beyond.
book Duration 4h 40m book Authors By Peter Weverka

Book

Excel 2016 For Dummies
Whether you've used older versions of this popular program or have never gotten a headache from looking at all those grids, this hands-on guide will get you up and running with the latest version of Microsoft Excel quickly and painlessly.
book Duration 6h 57m book Authors By Greg Harvey

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
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

Book

Microsoft Excel 365 Complete: In Practice, 2019
Offering a fresh approach to teaching today's students Microsoft Excel skills, this book builds a foundation for success by helping students apply what they learn, and provides transferable skills that allow students to grasp critical thinking beyond the textbook assignments.
book Duration 14h 25m book Authors By Kathleen Stewart, Randy Nordell

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 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 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 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

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 For Dummies
Whether you've used older versions of this popular program or have never gotten a headache from looking at all those grids, this hands-on guide will get you up and running with the latest version of Microsoft Excel quickly and painlessly.
book Duration 6h 57m book Authors By Greg Harvey

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 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 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
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

Book

MrExcel 2021: Unmasking Excel
Written for those who already use Excel 40 hours a week, this book provides "aha" tips that uncover secret methods in Excel.
book Duration 3h 59m book Authors By Bill Jelen

Book

Microsoft Excel 365 Complete: In Practice, 2019
Offering a fresh approach to teaching today's students Microsoft Excel skills, this book builds a foundation for success by helping students apply what they learn, and provides transferable skills that allow students to grasp critical thinking beyond the textbook assignments.
book Duration 14h 25m book Authors By Kathleen Stewart, Randy Nordell

Book

Excel Formulas & Functions For Dummies, 6th Edition
Unlock the power of Excel with a step-by-step roadmap to its formulas and functions.
book Duration 5h 18m book Authors By Ken Bluttman

Book

Microsoft Excel 365 Bible
The Excel 365 Bible carries over the best content from the best-selling Excel 2019 Bible while reflecting how a new generation uses Excel in Excel 365.
book Duration 15h 4m book Authors By Dick Kusleika, Michael Alexander
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

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 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 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 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

Microsoft Excel 365 Complete: In Practice, 2019
Offering a fresh approach to teaching today's students Microsoft Excel skills, this book builds a foundation for success by helping students apply what they learn, and provides transferable skills that allow students to grasp critical thinking beyond the textbook assignments.
book Duration 14h 25m book Authors By Kathleen Stewart, Randy Nordell

Book

Excel Macros for Dummies, 2nd Edition
Helping you save time, automate, and be more productive-even with no programming experience at all, this book offers macros you can implement right away, with practical exercises that extend your knowledge and help you understand the mechanics at work.
book Duration 3h 35m book Authors By Michael Alexander

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 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 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
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

Book

Power Pivot and Power BI: The Excel User's Guide to DAX Power Query, Power BI & Power Pivot in Excel 2010-2016, 2nd Edition
Introducing the concepts in a simple, step-by-step manner tailored to the learning style of Excel users everywhere, this easy-to-follow guide presents techniques that allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce.
book Duration 5h 11m book Authors By Avi Singh, Rob Collie

Book

Power Excel with MrExcel: 617 Excel Mysteries Solved, 2017 Edition
Based on real questions from author Bill Jelen's Power Excel Seminars, this lighthearted yet practical book discusses 617 of the most common and irritating problems in Excel, and provides the solutions you need to solve the problems.
book Duration 10h 7m book Authors By Bill Jelen

Book

Excel Sales Forecasting for Dummies, 2nd Edition
Loaded with confidence boosters for anyone who succumbs to sweaty palms when sales predictions are mentioned, this trusted guide shows you how to use the many tools Excel provides to arrange your past data, set up lists and pivot tables, use moving averages, and so much more.
book Duration 5h 55m book Authors By Conrad Carlberg

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

MS Excel: Let's Advance to The Next Level
An attempt to take you to the next orbit of competence in this fascinating world, this practical book is a ready reckoner for any practitioner who seeks to further his/her understanding of the tools and utilities.
book Duration 21m book Authors By Anurag Singal
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

Book

Microsoft Excel 365 Bible
The Excel 365 Bible carries over the best content from the best-selling Excel 2019 Bible while reflecting how a new generation uses Excel in Excel 365.
book Duration 15h 4m book Authors By Dick Kusleika, Michael Alexander

SKILL BENCHMARKS INCLUDED

Excel 2019
This benchmark evaluates your proficiency in key areas of Microsoft Excel 2019. Being aware of your proficiency level allows you to better understand your current skills and areas for improvement, so you can find suitable content and curate your own learning path. The courses recommended at the end of this benchmark can help you fill potential gaps in your knowledge.
24m    |   24 questions

SKILL BENCHMARKS INCLUDED

Excel 365 (2021)
This benchmark evaluates your proficiency in key areas of Microsoft Excel 365. Being aware of your proficiency level allows you to better understand your current skills and areas for improvement, so you can find suitable content and curate your own learning path. The courses recommended at the end of this benchmark can help you fill potential gaps in your knowledge.
27m    |   27 questions

SKILL BENCHMARKS INCLUDED

Excel 365 (2024)
This benchmark evaluates your proficiency in key areas of Excel 365 (2024). Being aware of your proficiency level allows you to better understand your current skills and areas for improvement, so you can find suitable content and curate your own learning path.
23m    |   23 questions

SKILL BENCHMARKS INCLUDED

Excel 2019
This benchmark evaluates your proficiency in key areas of Microsoft Excel 2019. Being aware of your proficiency level allows you to better understand your current skills and areas for improvement, so you can find suitable content and curate your own learning path. The courses recommended at the end of this benchmark can help you fill potential gaps in your knowledge.
24m    |   24 questions

SKILL BENCHMARKS INCLUDED

Excel 365 (2021)
This benchmark evaluates your proficiency in key areas of Microsoft Excel 365. Being aware of your proficiency level allows you to better understand your current skills and areas for improvement, so you can find suitable content and curate your own learning path. The courses recommended at the end of this benchmark can help you fill potential gaps in your knowledge.
27m    |   27 questions

SKILL BENCHMARKS INCLUDED

Excel 365 (2024)
This benchmark evaluates your proficiency in key areas of Excel 365 (2024). Being aware of your proficiency level allows you to better understand your current skills and areas for improvement, so you can find suitable content and curate your own learning path.
23m    |   23 questions

SKILL BENCHMARKS INCLUDED

Excel 2019
This benchmark evaluates your proficiency in key areas of Microsoft Excel 2019. Being aware of your proficiency level allows you to better understand your current skills and areas for improvement, so you can find suitable content and curate your own learning path. The courses recommended at the end of this benchmark can help you fill potential gaps in your knowledge.
24m    |   24 questions

SKILL BENCHMARKS INCLUDED

Excel 365 (2021)
This benchmark evaluates your proficiency in key areas of Microsoft Excel 365. Being aware of your proficiency level allows you to better understand your current skills and areas for improvement, so you can find suitable content and curate your own learning path. The courses recommended at the end of this benchmark can help you fill potential gaps in your knowledge.
27m    |   27 questions

SKILL BENCHMARKS INCLUDED

Excel 365 (2024)
This benchmark evaluates your proficiency in key areas of Excel 365 (2024). Being aware of your proficiency level allows you to better understand your current skills and areas for improvement, so you can find suitable content and curate your own learning path.
23m    |   23 questions