From the course: Excel 2016 Essential Training
Using the exercise files
- If you have access to the Exercise Files for this course you can download them on the lynda.com library. Open the folder Exercise Files, and for example, if you're viewing chapter five simply open the folder, and then the file, and you'll see various worksheets within each file. And usually there's a separate worksheet for each movie within the file.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
-
Exercise File: Subscribe to access.
Ex_Files_Excel_2016_EssT.zip -
Exercise File: Subscribe to access.
Glossary_Excel2016_Essential.zip
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
What is Excel used for?2m 14s
-
(Locked)
Using the menu system5m 50s
-
(Locked)
Using the Quick Access Toolbar6m 49s
-
(Locked)
Understanding workbooks and worksheets4m 45s
-
(Locked)
Using the Formula bar1m 37s
-
(Locked)
Using the Status bar5m 20s
-
(Locked)
Using navigation tools3m 24s
-
(Locked)
Using shortcut menus and the Mini toolbar4m 25s
-
(Locked)
Creating new workbooks2m 37s
-
(Locked)
Using Excel Help5m 28s
-
-
-
(Locked)
Creating simple formulas7m 11s
-
(Locked)
Copying a formula into adjacent cells3m 48s
-
(Locked)
Calculating year-to-date totals3m 49s
-
(Locked)
Creating a percentage-change formula7m 37s
-
(Locked)
Working with relative, absolute, and mixed references5m 32s
-
(Locked)
Using SUM and AVERAGE5m 18s
-
(Locked)
Using other common functions7m 44s
-
(Locked)
-
-
Exploring font styles and effects3m 17s
-
(Locked)
Adjusting row heights and column widths5m 40s
-
(Locked)
Working with alignment and Wrap Text6m 34s
-
(Locked)
Designing borders2m 55s
-
(Locked)
Exploring numeric and special formatting8m 1s
-
(Locked)
Formatting numbers and dates7m 18s
-
(Locked)
Using conditional formatting8m 13s
-
(Locked)
Creating and using tables11m 18s
-
(Locked)
Inserting shapes, arrows, and other visual features9m 35s
-
-
-
(Locked)
Sorting data9m 44s
-
(Locked)
Inserting subtotals in a sorted list8m 39s
-
(Locked)
Using filters6m 43s
-
(Locked)
Splitting data into multiple columns8m 26s
-
(Locked)
Splitting and combining columnar data with Flash Fill6m 40s
-
(Locked)
Removing duplicate records2m 23s
-
(Locked)
Using validation tools10m 45s
-
(Locked)