Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

## Microsoft Excel Essentials: Level 1 Basics - Master Excel Step-By-Step - Learn Excel Fundamentals!

#### Alan Jarvis, Everything Is Easy, Once You Know How

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
53 Videos (3h 23m)
• Introduction - Welcome To The Course

1:43
• Opening Excel, & Creating A Shortcut

3:45
• The Anatomy Of A Workbook

15:19
• A Quick Review Of What's Where

6:11
• Always Do This FIRST! - Save Your New Workbook

2:00
• Let's Enter Some Data - Text

1:41
• Editing Data - Text

1:42
• Ooops. I Made A Mistake - Undo and Redo

1:20
• Changing The Appearance Of Text With Formatting - Fonts

9:03
• A Quick Word On Formatting

1:20
• Formatting Text - Alignment

3:07
• Saving Time with AutoFilling Sequences

4:41

4:23
• Saving Time with Format Painter

2:48
• Changing The Column Width

3:33
• Merge And Centre

3:01
• Entering Data - A Couple Of Shortcuts

3:57
• Sums - The Old Fashioned Way!

3:11
• Sums - Using Autosum

5:32
• Copying Formulas

3:16
• SUMming Horizontally

3:16
• Basic Formulas - Subtraction

2:28
• Basic Formulas - Multiplication

1:32
• Basic Formulas - Division

1:21
• Average Function

2:41
• The Order Of Mathematical Operation

6:38
• POWER USER - Evaluate Formula Function

4:50
• Inserting New Columns And Rows

6:21
• Moving Existing Columns And Rows

2:27
• Cutting, Copying, Inserting And Deleting

6:07
• Hiding Columns And Rows

2:41
• ROUNDing Functions

5:55
• Formatting Numbers

2:12
• A Primer On Building Complex Formulas

3:10
• Building A Complex Formula

4:19
• Sorting

4:16
• Wrapping Text And Soft Enter

3:59

1:07
• Creating A Simple Chart

4:20

2:36

2:11
• Simple Printing

3:34
• Freezing For An Easier View

4:06
• Getting Help

1:39
• Filters

6:21
• Highlighting Cells

2:03
• Closing - Thank You!

1:30
• Bonus 1 Whizzing Around Excel Revision

6:45
• Bonus 2 Keyboard Shortcuts

11:18
• A1 Style - Relative Relative

2:15
• \$A1 Style - Absolute Relative

2:16
• \$A\$1 Style - Absolute Absolute

2:44
• A\$1 Style - Relative Absolute

2:01
39 students are watching this class