Excel: Excel for the Web intermediate
Technology:
Expertise:
- 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
Excel is the powerful spreadsheet component of Microsoft Office. Discover Excel and its many uses.
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 2019 for Windows
-
3m 14s
-
6m 43s
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
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
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
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
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
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
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
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
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
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
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
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
Assessment
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
Assessment
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
Badge