Excel 2016 for Windows and Mac: Essentials

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
(83)
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
Page Layout: How Everything Fits 9m Inserting Headers and Footers 5m Printing and Print Settings 7m
Description
Course info
Rating
(83)
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

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT