Excel 2016 for Windows and Mac: Essentials
By Bob Flisser
If you're new to Excel or need a refresher, this course will get you up to speed so you can be proficient quickly.
Course info
Rating
Level
Beginner
Updated
Dec 21, 2015
Duration
2h 53m
Table of contents
Getting Acquainted with Excel
What's on the Screen?
8m
File Management Techniques
8m
Editing the Content of a Worksheet
16m
Creating a Sample Worksheet
9m
In a Hurry? Use a Template
8m
Data Entry Techniques
Using AutoFill to Enter Data Quickly
5m
Select an Area for Faster Data Entry
3m
Enter Numbers Quickly Using Automatic Decimals
3m
Generate a List Automatically Using FlashFill
3m
Managing Lists with Excel 2016
Editing a List of Names and Addresses
12m
Using a Table for Advanced Sorting
8m
Filtering with the Advanced Filter
11m
Finding and Replacing Data
5m
Calculating with Formulas and Functions
How Do You Write a Formula?
2m
Adding, Subtracting Basic Number Formatting
7m
The Order of Calculations is Critical
3m
Squaring and Cubing Numbers
5m
Understanding How Functions Work
1m
SUM Function and AutoSum Tool
7m
Adding a Whole Worksheet with Just Two Clicks
3m
Formatting Worksheets
Row and Column Size and Alignment
5m
Using and Modifying Built-in Styles
10m
Inserting and Modifying Pictures
8m
Inserting Pictures from Online Sources
5m
Printing Worksheets
Description
Course info
Rating
Level
Beginner
Updated
Dec 21, 2015
Duration
2h 53m
Description
Learn the fundamentals of using and creating Excel spreadsheets, including entering and editing data, managing lists, writing formulas and using functions, formatting sheets, and printing your work.
About the author
About the author
Bob Flisser has been a computer trainer since the 1980s. He has authored over two dozen video courses and books, and is the Vice President of Software School, Inc., a training and graphic design company in New Jersey.