Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel - A Step by Step Complete Course
The Excel 2016 Introduction
Introduction (2:56)
Tabs of ribbon (6:45)
Ribbon User Interface (9:11)
Entering the values (8:20)
Find replace search (6:19)
The Excel 2016 - User Experience
Entering data (9:08)
Customizing quick access toolbox (9:29)
Surfing work area (9:39)
Formula bar (7:15)
key board keys (6:02)
Entering date time (4:44)
Fabricating formulas (8:15)
Formula flub ups (10:36)
Auto fill (6:53)
Inserting functions (3:56)
Aauto fill flash fill (7:02)
Finding totals (5:27)
Saving excel file (4:15)
To Make it all Look Pretty
Selecting cells (7:34)
Format as table (6:50)
Custom table style cell formatting (8:56)
Number formats (9:28)
Rows columns (6:17)
Fonts alignment (4:25)
Formatting via quick analysis tool (4:24)
Going Through Changes
Opening workbooks (9:06)
Drag drop copying (7:04)
Find workbook files (4:07)
Cut paste (7:13)
Paste from clipboard task pane (6:50)
Deletig inserting stuff (8:01)
Spelling errors (4:35)
Printing the Sheets
Preview page sprint screen (5:32)
Page setup (5:44)
Header footer (6:21)
Maintaining the Worksheet
Page break problem print formulas (4:34)
Zooming in out splitting worksheet (9:16)
Managing comments (4:12)
Range name (8:55)
Controlling recalculation protection (4:44)
Maintaining Multiple Works
Juggling multiple worksheets (5:06)
Opening windows (3:20)
Shifting sheets (7:14)
What-If Analysis
Goal seek scenario (9:00)
One two variable data table (4:46)
Charts & Graphics
Charts (8:27)
Adding graphics (10:01)
Pivot Tables
Pivot tables (5:51)
Data Lists
Creating data list (5:13)
Sorting filtering (1:52)
Advanced
Addins (6:52)
Hyperlinks (4:07)
Macros (7:05)
Sharing sheets (7:45)
Slicer & timelines (4:19)
Macros
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock