Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel Basics– the Ultimate Beginner’s Course
Welcome to Excel Basics - The Ultimate Beginner's course
Welcome to Excel Basics (1:55)
Important Points (2:20)
Excel Basics
The Excel Interface (3:55)
Creating a New Workbook (4:06)
Pointer Shapes (3:29)
Opening and Closing Workbooks (3:42)
Moving around with Keyboard and Mouse (5:14)
Opening Multiple Workbooks
Renaming Sheets (2:38)
Copying and Moving Sheets (4:35)
Inserting and Deleting Sheets (5:52)
Changing Sheet Tab Colours (2:15)
Copying and Moving Cells (6:22)
Copying and Moving by Dragging (3:46)
Using the Fill Handle (4:15)
Quiz 1: Quick Quiz
Worksheets
Inserting Rows and Columns (3:51)
Deleting Rows and Columns (5:42)
Hiding Rows and Columns (4:06)
Adjusting Column Widths (5:31)
Adjusting Row Height (5:10)
Copying by Using the Fill Handle (6:22)
Copying Using the Shortcut Menus (9:39)
Worksheets Quiz
Formatting
Selection Methods (6:32)
Cell Alignment (5:02)
The Format Painter (3:44)
Simple Formatting (6:47)
Fonts, Font Size and Font Colour (7:10)
Cell Borders (3:20)
Cell Patterns (3:48)
Formatting Quiz
Formulas
Introduction to Formulas and Functions (8:03)
Invoice Walkthrough (3:54)
Absolute Cell References (6:33)
Functions (6:39)
Named Ranges (5:27)
Outlining (5:42)
Calculations Quiz
Sorting and Filtering Data
Sorting (4:53)
Filtering (5:28)
Tables (8:48)
Sorting and Filtering Quiz
Charts
Inserting Charts in Excel 2010 (4:16)
Adding Charts in Excel 2013 (4:59)
Sparklines (4:07)
Chart Quiz
Printing
Setting and Clearing a Print Area (4:28)
Page Breaks and Column Headers (4:18)
Printing Quiz
Opening Multiple Workbooks
Download
Jan1.xlsx
Download
Jan2.xlsx
Complete and Continue