This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
EXCEL 2016: Excel from beginner to professional
Getting Started
Jumping Straight in to Excel 2016 - Our First small Excel Spreadsheet (5:57)
Creating an Excel Workbook using a template (2:28)
First look at Excel Formula - Creating a Worksheet in Excel 2016 (9:16)
Quick Charts - How to quickly add charts to your Excel 2016 Spreadsheet (4:21)
Quick Sorting - How to quickly sort your Excel 2016 Spreadsheet (3:50)
Flash Fill - Excel 2016's incredible time saving fill feature (4:25)
Formatting Data Types in Excel 2016 - Numbers, Text, Percentages and more (7:26)
Increasing Efficiency to save time in Excel
Copy Paste - How to increase your efficiency in Excel 2016 (7:53)
Transposing with Copy Paste (1:32)
Inserting, Deleting and Hiding Rows in Excel 2016 (7:45)
Absolute Reference - Copy and Pasting with Absolute Reference in 2016 (4:37)
Exploring the Clipboard using Multiple Copy and Paste in Excel 2016 (2:26)
Named Range Referencing - Simplifying Excel Cross Worksheet Referencing (4:12)
Copying Moving and Deleting Excel 2016 Sheets (3:37)
Changing Excel Sheet Tab Colors (3:01)
Using Excel's Autocorrect to Speed Up Typing (3:07)
Adding, Editing and Deleting Comments in your Excel 2016 Sheet (2:22)
Managing Excel Sheets - Best Practices for Cleaning up Raw Data (5:15)
Using the data in your Excel 2016 spreadsheet
3D Maps - Creating 3D maps and plotting addresses from your Excel spreadsheet (12:08)
SumIf Function - How to use it in an Excel Spreadsheet (6:46)
Creating a Drop Down Cell - Using SumIf command with it (3:38)
Creating an Independent Drop Down - Using SumIf (3:25)
VLookUp Part 1 - How it works, and how it makes your life easier in Excel (6:02)
VlookUp Part 2 - More indepth and pulling information from other Excel sheets (10:06)
Left, Right and Mid Functions - Editing Text in Excel (5:28)
Find and Len Functions - And using nested formula (6:39)
Creating a Table Within your Excel 2016 Spreadsheet (6:19)
Using Slicers in your Table for Quick Filtering your Excel 2016 Sheet (4:41)
Pivot Tables - How to use them in Excel 2016 and why you should
Pivot Tables Part 1 - Setting up for first Excel Pivot Table, and how it works (8:46)
Pivot Tables Part 2 - Adding Automatically Updating Charts (4:04)
Pivot Tables Part 3 - Using Slicers in your Pivot Table for Quick Filtering (3:29)
Pivot Tables Part 4 - Using Timeline for even easier filtering in Excel sheets (3:36)
More functions - General Excel 2016 Functions
Concatenate - How to join text together in Excel 2016 (2:39)
Lower, Proper, and Upper functions - Formatting text in Excel 2016 (2:12)
Repeat Function - Using REPT in your Excel 2016 sheet for quick duplication (1:19)
Substitute - Easily replace pieces of text with other pieces of text in Excel (2:30)
Trim - An Excel function to quickly format out extra spaces (1:38)
Flash Fill - Excel 2016's incredible time saving fill feature
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock