2015
Pluralsight
Bob Flisser
2:53
English
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.
Getting Acquainted with Excel
47m 29s
What's on the Screen? 7m 41s
File Management Techniques 7m 35s
Editing the Content of a Worksheet 15m 37s
Creating a Sample Worksheet 8m 50s
In a Hurry? Use a Template 7m 44s
Data Entry Techniques
13m 1s
Using AutoFill to Enter Data Quickly 4m 46s
Select an Area for Faster Data Entry 3m 11s
Enter Numbers Quickly Using Automatic Decimals 2m 32s
Generate a List Automatically Using FlashFill 2m 30s
Managing Lists with Excel 2016
36m 22s
Editing a List of Names and Addresses 12m 14s
Using a Table for Advanced Sorting 8m 14s
Filtering with the Advanced Filter 10m 44s
Finding and Replacing Data 5m 8s
Calculating with Formulas and Functions
27m 42s
How Do You Write a Formula? 2m 4s
Adding, Subtracting Basic Number Formatting 6m 34s
The Order of Calculations is Critical 2m 37s
Squaring and Cubing Numbers 4m 30s
Understanding How Functions Work 1m 12s
SUM Function and AutoSum Tool 7m 20s
Adding a Whole Worksheet with Just Two Clicks 3m 21s
Formatting Worksheets
27m 42s
Row and Column Size and Alignment 4m 54s
Using and Modifying Built-in Styles 9m 51s
Inserting and Modifying Pictures 7m 35s
Inserting Pictures from Online Sources 5m 20s
Printing Worksheets
21m 10s
Page Layout: How Everything Fits 9m 12s
Inserting Headers and Footers 5m 28s
Printing and Print Settings 6m 30s
pluralsight.com/courses/excel-2016-windows-and-mac-essentials
Download File Size:777.16 MB
|
