Add Rows and Columns | E3 Online Academy

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Microsoft Excel

Basic: Excel Fundamentals

Introduction to the Course (7:03)
Understand the Screen and Create Workbooks (13:04)
Navigate Worksheets (6:02)
Open Workbooks (4:47)
Save Workbooks (5:41)
AutoRecover (2:38)
The Quick Access Toolbar (4:13)
Print (3:17)
Help (3:59)
Close and Exit (2:04)

Basic: Edit a Workbook

Select Cells and Ranges (8:10)
Edit Cell Data (4:39)
Cut, Copy, and Paste (5:34)
Undo, Redo, and Repeat (7:51)
More Pasting Options (10:05)
Insert and Move Cells (4:15)
Delete Cells (3:10)
Check Spelling (2:21)
Find and Replace Text (11:04)
Hide Columns and Rows (3:10)
Document Properties (6:00)

Basic: Basic Formulas

Formula Basics (7:08)
Auto Fill (6:38)
Sums and Averages (3:48)
MIN and MAX Functions (1:40)
COUNT Function (2:49)

Basic: Basic Formatting

Format Text (6:23)
Align and Merge Cells (6:30)
Format Numbers and Dates (5:47)
Borders and Background Colors (4:05)
Copy Formatting (2:29)
Row Heights and Column Widths (4:56)

Basic: Insert Objects

Insert Images (3:20)
Insert Shapes (2:57)
Insert Hyperlinks (3:26)
Object Properties and Alt Text (5:19)

Basic: View and Manage Worksheets

View Worksheets (4:10)
Custom Views (2:55)
Multiple Windows (3:26)
Move and Copy Worksheets (3:37)
Insert, Rename, and Delete Worksheets (3:51)
Freeze Rows and Columns (3:05)
Hide Worksheets and Gridlines (3:37)

Intermediate: Charts

Create Charts (4:46)
Move and Resize (4:15)
Chart Types (2:02)
Layout and Style (2:59)
Titles and Legends (4:48)
Gridlines, Labels, and Data Tables (2:44)
Emphasize Chart Data (3:49)
Modify Chart Data (3:24)
Filter Charts (2:12)
Trendlines (4:14)
Dual Axis Charts (4:34)
Chart Templates (3:04)
Sparklines (3:13)

Intermediate: Print and Distribute

Page Size and Scale (3:41)
Print Area (3:22)
Page Breaks (1:32)
Print Titles, Gridlines, and Headings (2:55)
Headers and Footers (4:21)
Margins and Orientation (1:43)
Inspect for Issues (4:49)

Intermediate: Intermediate Formulas

Reference External Worksheets (5:40)
Absolute and Relative References (6:35)
Order of Operations (4:10)
Cell and Range Names (4:54)
Insert Functions (3:11)
CONCAT Function (2:48)
PMT Function (5:13)
Display Formulas (2:24)
Date Formulas (4:10)

Intermediate: Manage Data

Quick Analysis (4:21)
Outline and Subtotal (8:07)
Data Validation (7:18)
Flash Fill (2:40)
Import and Export Data (8:39)

Intermediate: Tables

Insert a Table (6:33)
Sort Data (2:55)
Filter Data (2:31)
Add Rows and Columns (4:56)
Table Styles (1:52)
Remove Duplicates (2:01)
Slicers (3:59)
Structured References (4:14)

Intermediate: Intermediate Formatting

Apply and Manage Conditional Formatting (7:26)
Apply and Remove Cell Styles (2:54)
Create and Modify Cell Styles (4:25)
Find and Replace Formatting (4:44)
Apply a Theme (2:27)

Intermediate: Collaborate with Excel

Cell Comments (4:46)
Share Workbooks (5:09)
Co-author Workbooks (2:30)
Version History (4:08)
Protect a Worksheet (4:57)
Protect Workbook Structure (2:36)
Password Protection (3:53)

Advanced: PivotTables

Create PivotTables (7:46)
Add Multiple PivotTable Fields (4:38)
Change a PivotTable's Calculation (3:51)
Add Calculated Fields (3:25)
The GETPIVOTDATA Function (3:00)
Filter PivotTables (2:46)
Timelines (3:15)
PivotTable Layout (2:47)
Group Values (2:00)
Refresh a PivotTable (3:39)
Format a PivotTable (2:25)

Advanced: PivotCharts

Create PivotCharts (5:53)
PivotChart Options (5:54)
PivotChart Styles (2:46)
Drill Down Data (4:40)

Advanced: Troubleshoot Formulas

Formula Errors
The Watch Window
Evaluate Formulas

Advanced: Advanced Formatting

Customize Conditional Formatting
Conditional Formatting with Formulas
Manage Conditional Formatting
International Currency and Formats
Body and Heading Options
Color Formats
Custom Themes
Form Controls
Save Form Templates

Advanced: Advanced Formulas

IF Function
Nested Functions
AND, OR, and NOT Functions
SUMIF, AVERAGEIF, and COUNTIF Functions
VLOOKUP
HLOOKUP
INDEX and MATCH
UPPER, LOWER, and PROPER
RIGHT, LEFT and MID
Formula Calculation Options

Advanced: Analyze Data

Goal Seek
Scenario Manager
Consolidate Data

Advanced: Macros

Enable Macros
Create Macros
Modify Macros
Copy Macros

Teach online with

Add Rows and Columns

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock