Zenler Player
Your course is loading. Hang tight.
Excel 2016: Excel Skills for Life
Back to curriculum
0% Complete
0% Complete
Course Introduction
Introduction Licensing
Understanding Licensing Models
Getting Started
Quick Tour
SignIn
Creating Excel Workbook
Opening Existing Workbooks
Ribbon
Quick Access Toolbar
Formula bar
Statusbar
Navigation
Introduction
Entering Data
Data & Data Time
Copy and Paste
Selecting Data
Adding Comments
Search & Replace
AutoFill & FlashFill
Resources
Introduction
Adding Worksheets
Deleting Worksheets
Renaming and adding color to the worksheet tab
Moving and Copying a worksheet
Viewing a worksheet in multiple windows
Splitting the worksheet window into panes
Using Freeze Panes
Hiding and Unhiding Worksheets
Resources
Introduction
Copying and Pasting Rows and Columns
Hiding and Unhide Rows and Columns
Changing Column Width and Row Height
Grouping & Ungrouping
Cell & Ranges
Resources
Introduction
What are Tables?
Working with Tables
Sorting and Filtering
Removing Duplicates
Total Row
Table Style Options
Resources
Introduction
Formatting Tools
Fonts
Alignment
Number Formatting
Borders and Fill
Named Style
Resources
Introduction
Hightlight
Top Bottom
DB CS IS
Managing
Resources
Introduction
Inserting Pictures, Online Pictures, Shapes, Icons, SmartArt, Screenshot
Inserting Text Box, Header & Footer, WordArt, Hyperlink
Resources
Introduction
QuickSort and CustomSort
Auto Filter
Custom Filters
Advanced Filters
Resources
Introduction
Excel Extensions Formats
Excel Compatibility
Resources
Introduction
Exploring-Templates
Creating-Templates
Introduction
Print Preview
Page Break Preview
Page Layout
Print Scaling
Print Settings
Introduction
General Math Rules
Basic Math
Cell References
Named References
Excel Functions
3D Formulas
Resources
Introduction
options
WholeNumber
Decimal
List
Date
Time
Text Length
Custom
Project - Part 1
Project - Part 2
Project - Part 3
Resources
Keyboard Shortcuts
Congrats!
Course Introduction
Course Introduction
Preview
Excel Versions
Introduction Licensing
Preview
Understanding Licensing Models
Preview
Getting Started with Excel
Getting Started
Preview
Quick Tour
Preview
SignIn
Preview
Creating Excel Workbook
Preview
Opening Existing Workbooks
Ribbon
Quick Access Toolbar
Formula bar
Statusbar
Navigation
Entering Data
Introduction
Entering Data
Data & Data Time
Copy and Paste
Selecting Data
Adding Comments
Search & Replace
AutoFill & FlashFill
Resources
Working with Worksheets
Introduction
Adding Worksheets
Deleting Worksheets
Renaming and adding color to the worksheet tab
Moving and Copying a worksheet
Viewing a worksheet in multiple windows
Splitting the worksheet window into panes
Using Freeze Panes
Hiding and Unhiding Worksheets
Resources
Working with Rows, Columns and Cells
Introduction
Copying and Pasting Rows and Columns
Hiding and Unhide Rows and Columns
Changing Column Width and Row Height
Grouping & Ungrouping
Cell & Ranges
Resources
Working with Tables
Introduction
What are Tables?
Working with Tables
Sorting and Filtering
Removing Duplicates
Total Row
Table Style Options
Resources
Formatting Data
Introduction
Formatting Tools
Fonts
Alignment
Number Formatting
Borders and Fill
Named Style
Resources
Visualizing Data With Conditional Formatting
Introduction
Hightlight
Top Bottom
DB CS IS
Managing
Resources
Working with Images and Shapes
Introduction
Inserting Pictures, Online Pictures, Shapes, Icons, SmartArt, Screenshot
Inserting Text Box, Header & Footer, WordArt, Hyperlink
Resources
Sorting and Filtering Data
Introduction
QuickSort and CustomSort
Auto Filter
Custom Filters
Advanced Filters
Resources
Excel File Formats
Introduction
Excel Extensions Formats
Excel Compatibility
Resources
Working with Templates
Introduction
Exploring-Templates
Creating-Templates
Printing
Introduction
Print Preview
Page Break Preview
Page Layout
Print Scaling
Print Settings
Introduction to Formulas and Functions
Introduction
General Math Rules
Basic Math
Cell References
Named References
Excel Functions
3D Formulas
Resources
Using Data Validation
Introduction
options
WholeNumber
Decimal
List
Date
Time
Text Length
Custom
Project - Part 1
Project - Part 2
Project - Part 3
Resources
Other Resources
Keyboard Shortcuts
Conclusion
Congrats!
×
This is an unpublished lesson. This lesson will not be shown for students unless you set it as Public.
Back to Dashboard
No contents are available in this lesson!
No lessons available !
Back to Dashboard
Lesson contents locked
Enroll to unlock this lesson.
Enroll to unlock
Next Lesson