About this Course
Course Introduction
Introduction to Microsoft Excel 2016
Understanding Common Terms used in Excel and Spreadsheets
-
5. Understanding common terms used in Excel and spreadsheets - Part 1 (0:54)
-
5. Understanding common terms used in Excel and spreadsheets - Part 2 (0:56)
-
5. Understanding common terms used in Excel and spreadsheets - Part 3 (1:08)
-
5. Understanding common terms used in Excel and spreadsheets - Part 4 (0:34)
-
5. Understanding common terms used in Excel and spreadsheets - Part 5 (0:44)
-
5. Understanding common terms used in Excel and spreadsheets - Part 6 (0:20)
Navigating Your Way Around Excel
Excel General Options
Adding, Copying and Moving Worksheets
Working with Cells, Columns and Rows
-
9. Working with cells, columns and rows - Part 1 (1:08)
-
9. Working with cells, columns and rows - Part 2 (2:07)
-
9. Working with cells, columns and rows - Part 3 (2:13)
-
9. Working with cells, columns and rows - Part 4 (1:00)
-
9. Working with cells, columns and rows - Part 5 (1:51)
-
9. Working with cells, columns and rows - Part 6 (1:34)
Excel Basic Formatting
Autofill and Flash Fill Options
Workbook View Options
Saving Workbooks
Basic Calculations and Cell References
-
14. Basic calculations and cell references - Part 1 (4:46)
-
14. Basic calculations and cell references - Part 2 (4:19)
-
14. Basic calculations and cell references - Part 3 (3:04)
-
14. Basic calculations and cell references - Part 4 (2:45)
-
14. Basic calculations and cell references - Part 5 (5:07)
-
14. Basic calculations and cell references - Part 6 (2:49)
Working with Comments
Working with Paste Special Commands
Optimizing the Data (Autofilter)
Basic Sorting Methods
Using Subtotal Functions to Analyze the Data
Search and Editing the Data
Data Visualization - Basic Illustrations
Building Basic Charts
Manipulate with Chart Elements
Building Sparklines
Page Layout Options
Conclusion
