Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel Beginners Series
Introduction to Excel - Let's Get Started
Open, Name and Save files (2:14)
Search for & adapt templates Online (2:12)
Tabs, Ribbons, Groups & Launch buttons (1:52)
Worksheets & Workbooks (3:02)
Columns, Rows, Cells, Range (2:25)
Zoom Function (1:21)
Enter or Replace data (2:21)
Resize Columns & Rows (Click & Drag Method) (3:29)
Resize Columns & Rows (Double-click Method) (2:38)
Resize Columns & Rows (Numerically) (2:10)
Moving around the cells (0:55)
Formatting Fonts (3:59)
Alignment, Orientation, Merge (4:41)
Add line breaks (1:01)
Insert images
Insert background images into worksheets (4:18)
Insert images in cells & worksheets (3:56)
Insert images into shapes (2:24)
Tip - Insert screenshot (0:58)
Move, Copy & Paste Functions
Move & Copy cells (3:12)
Paste Values & Formulas (2:40)
Paste & Keep Source Column Widths (2:20)
Copy & Paste Link (N) (1:33)
Copy & Transpose (T) (1:11)
Copy & Paste Special (& Select Operations) (2:27)
Import data from other sources
Import data from PDF files (1:26)
Useful Excel Functions
Change Case of Text (3:54)
Joining text from different cells (2:48)
TRIM Function (1:56)
Basic Formulas (1:23)
SUM Functions (1:30)
Date, Day, Day Name & Time Functions (2:37)
TODAY Function (3:17)
IF Function (1:16)
IFS Function (2:11)
VLOOKUP Function (3:21)
#NA Error in VLOOKUP (3:31)
Autofill
Autofill (1:53)
Autofill - More Applications (4:30)
Autofill - Custom Lists (4:09)
Flash Fill
Introduction to Flash Fill (1:29)
Applications with Flash Fill (2:37)
Limitations of Flash Fill (2:37)
Dropdown Lists
Add Simple Dropdown List (4:47)
Create Dynamic Dropdown Lists (2:39)
Create Drop Down Lists using data from different worksheets (2:04)
Create Dynamic Drop Down Lists using data from different worksheets (Part 2) (2:51)
DYNAMIC Array (3:42)
Create worksheets with checkboxes
Create worksheets with checkboxes (2:18)
Incorporate interactive checkboxes into worksheets (1:18)
Introduction to Tables
Introduction to Tables (5:30)
More about Tables (4:09)
Tips to Learn Tables
Introduction to Pivot Tables
Set-up Table (5:32)
Recommended Pivot Table (2:52)
Understanding the fields, areas and layout options (4:04)
Customise Pivot Tables (12:15)
Tip - Add a Slicer (1:58)
Introduction to Charts
Insert Column or Bar Chart into worksheets (3:17)
Adjust or Improve Chart Layout (8:07)
Insert Line or Area Chart into worksheets (4:48)
Insert Pie Chart into worksheets (2:09)
Insert Combo Chart into worksheets (2:47)
Move Charts (1:27)
Tip - Apply data Bars & Icon Sets (2:06)
More Favourite Shortcuts & Tips
Shortcuts - Quick navigation (0:44)
Shortcut to create a table (0:55)
Shortcut to Insert Charts (0:39)
Shortcuts to Close, Open & Save (1:09)
Shortcut - Cut, Copy, Paste & Undo (0:45)
More shortcuts to navigate within & across worksheets (0:44)
Shortcut to insert Current Date & Time (0:42)
Shortcuts to format cells with numbers (1:04)
Tip - Add another line in the same cell (0:36)
Shortcut - Fill data in a Flash! (0:33)
Shortcuts to make selections quickly! (1:52)
Shortcut to copy data and format and fill selected cell range with the same data (0:45)
Shortcut - Select ALL the data in worksheets quickly (0:46)
Tip to select only visible data (0:54)
Tips to unhide Hidden Rows (1:15)
Tip - Define names to make formulas more meaningful (1:47)
Shortcut to Sum values (0:42)
Shortcut - Import data (0:51)
Identify duplicate values (0:50)
Tip to format long text in cells correctly (0:52)
Shortcut - Remove Rows & Columns (0:30)
Shortcut - Hide Rows & Columns (0:22)
Tip - Copy & Transpose Data (T) (0:48)
Tip - Use Center Across Selection (1:23)
Tip - Lock cell reference for accurate calculations (2:02)
Tip - Format multiple worksheets at the same time! (1:47)
Tip - Filter by Selected Cell's Value (0:35)
Tip - Split Worksheet and/or Freeze Panes (2:37)
Tip - Open a new window (1:00)
Tip - Add Sparklines (0:53)
Tip - Diagonal cell border (0:53)
Tip - Select & Delete Blank Rows (0:58)
Tip - Excel camera (3:41)
Tip - Change Tab Colour to increase efficiency
Tip - Find hidden columns & rows (0:45)
Tip - Text to Columns (1:20)
Shortcut - Hide rows & columns (0:22)
Spell check (0:33)
Change data in multiple cells (0:40)
Create Dynamic Drop Down Lists using data from different worksheets (Part 2)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock