From the course: Excel 2013 Essential Training
Using the exercise files - Microsoft Excel Tutorial
From the course: Excel 2013 Essential Training
Using the exercise files
If you have access to the Exercise Files for this course, you can download them at the lynda.com library. Open the folder Exercise Files and then, for example, if you are viewing Chapter 5, 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.
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?1m 49s
-
(Locked)
Using the menu system4m 30s
-
(Locked)
The Quick Access Toolbar4m 41s
-
(Locked)
The structure of a worksheet or workbook3m 41s
-
Using the Formula bar1m 43s
-
(Locked)
Using the Status bar2m 24s
-
(Locked)
Navigation and mouse pointers2m 20s
-
(Locked)
Shortcut menus and the Mini toolbar3m 24s
-
(Locked)
Using the built-in help2m 54s
-
(Locked)
Creating new files2m 11s
-
-
-
Creating simple formulas: Totals and averages5m 25s
-
(Locked)
Copying a formula for adjacent cells2m 54s
-
Calculating year-to-date profits3m 9s
-
(Locked)
Creating a percentage-increase formula4m 7s
-
(Locked)
Working with relative, absolute, and mixed references4m 7s
-
(Locked)
Using SUM and AVERAGE3m 25s
-
(Locked)
Using other common functions7m
-
-
-
(Locked)
Exploring font styles and effects4m 7s
-
(Locked)
Adjusting row heights and column widths3m 37s
-
(Locked)
Working with alignment and Wrap Text4m 2s
-
(Locked)
Designing borders3m 26s
-
Exploring numeric and special formatting5m 36s
-
(Locked)
Formatting numbers and dates4m 31s
-
(Locked)
Conditional formatting4m 21s
-
(Locked)
Creating and using tables9m 59s
-
(Locked)
Inserting shapes, arrows, and other visual features6m 28s
-
(Locked)