From the course: Excel 2016 Essential Training
Welcome
- [Voiceover] Hi, I'm Dennis Taylor and welcome to Excel 2016 Essential Training. In this course I will show you how to use this popular and powerful software. We'll begin by getting you familiar with Excel's menu system, how to create formulas and use simple functions, how to format your data for appearance sake, how to use printing and charting capabilities of Excel, and how to work with powerful functions like if and V look up. I'll show you a few data analysis tools, like Goal Seek and Solver and how to automate your work via macros. We've got a lot to cover, so let's get started with Excel 2016 Essential Training.
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)