Excel Training for Beginners

Excel Training for Beginners

Over 9 hours of online video training

This training is for anyone who is new to Excel 2003* or has started using Excel but knows very little about its features.

You will learn the skills needed to start using Excel effectively in the workplace. Many of the concepts in Excel are presented with pictures, diagrams, and animations. Use the skills you learn from this training to quickly setup your financial data in Excel and use many of its functions to perform both simple and complex calculations. If you are working in an environment where Excel competency is expected, this training will get you up to speed quickly with Excel and its powerful features. The teaching style assumes no previous knowledge of Excel. The lessons are presented in full motion video and audio.

Excel Training for Beginners
Title (click on title below for course outline)	Demo
Excel for Beginners

Multimedia Online Training:
With online training, the lectures were video taped and then digitized and presented to you in Full Motion Video, Audio, & Graphics.

System Requirements: 1 GHz Processor (minimum), High-Speed Internet Connection, 512 MB RAM, Sound Card. Available Hard Disk 200 MB. 800x600 Minimum Screen Resolution (1024x768 or higher recommended). Browser: Internet Explorer 7, Firefox 3.6, Chrome 4.0, Safari 4.0, Mobile Safari 4.0, or Opera 10.5 or higher. Flash Player 10 or higher (non IOS devices). Windows XP, Vista, 7, MAC OS X 10.5, or iOS 4.0 or higher.

Excel for Beginners Course Outline:

Length - 9 Hours 13 Minutes

Level 1 – Introduction (15 Minutes)

• 1.01 Course Introduction – 1:10
• 1.02 What Is A Spreadsheet – 1:08
• 1.03 Columns And Rows – 2:51
• 1.04 Entering Data – 10:11

Level 2 – User Interface (41 Minutes)

• 2.01 Section Introduction – 0:40
• 2.02 The Excel Window – 2:29
• 2.03 Moving Around In Cells – 6:39
• 2.04 The Task Pane – 2:00
• 2.05 Toolbars - 3:26
• 2.06 Customizing Toolbars - 3:52
• 2.07 The Excel Menu – 4:10
• 2.08 Saving A File – 1:31
• 2.09 Opening Files – 2:43
• 2.10 Creating A New Workbook - 2:31
• 2.11 Using the Mouse – 4:38
• 2.12 Keyboard Basics – 6:05
• 2.13 Section Conclusion – 0:41

Level 3 – Working with Data (19 Minutes)

• 3.01 Section Introduction – 0:19
• 3.02 Selecting Cells – 3:27
• 3.03 Entering Data Into Cells – 2:08
• 3.04 Moving Cells – 8:50
• 3.05 Deleting Values and Cells – 2:23
• 3.06 Formatting Numbers as Text – 1:50
• 3.07 Section Conclusion – 0:28

Level 4 – Formatting Data (1 Hour 31 Minutes)

• 4.01 Section Introduction – 0:29
• 4.02 Changing Fonts – 1:17
• 4.03 Changing Cell Size – 5:10
• 4.04 Justifying Text – 3:52
• 4.05 Text Attributes – 6:18
• 4.06 Auto Sizing – 1:16
• 4.07 Column Width – 3:25
• 4.08 Worksheets – 2:29
• 4.09 Changing The Enter Key Behavior – 1:11
• 4.10 Intro To The AutoSum Function – 4:33
• 4.11 Automatic Calculation – 4:23
• 4.12 Formatting Numbers – 4:27
• 4.13 More Formatting – 5:22
• 4.14 Special Formatting Options – 5:13
• 4.15 Using Formatting – 7:29
• 4.16 Deleting Cells – 2:20
• 4.17 Inserting Rows And Columns – 2:39
• 4.18 Creating Borders – 8:44
• 4.19 Border Styles – 4:38
• 4.20 Merge And Center – 2:51
• 4.21 Adding Background Color – 5:31
• 4.22 Intro To AutoFormat – 1:19
• 4.23 Intro To Conditional Formatting – 4:43
• 4.24 Session Conclusion – 0:44

Level 5 – Formulas (5 Hours 17 Minutes)

• 5.01 Section Introduction – 1:11
• 5.02 Reference Operators – 3:43
• 5.03 Range Reference Part I – 4:48
• 5.04 Range Reference Part II – 4:55
• 5.05 Range Reference Part III – 5:40
• 5.06 Union Reference Part I – 6:03
• 5.07 Union Reference Part II – 3:22
• 5.08 Mixing Range and Union Reference Part I – 6:26
• 5.09 Mixing Range and Union Reference Part II – 2:20
• 5.10 Mixing Range and Union Reference Part III – 2:13
• 5.11 Mixing Range and Union Reference Part IV – 3:32
• 5.12 Introduction to Formulas – 4:44
• 5.13 Introduction to Functions – 5:04
• 5.14 More On Formulas and Functions – 4:33
• 5.15 Using Formulas – 2:53
• 5.16 More On Functions – 7:28
• 5.17 Operator Precedence Part I – 4:48
• 5.18 Operator Precedence Part II – 5:18
• 5.19 Exercises In Formulas Functions And Precedence Part I – 5:08
• 5.20 Exercises With Formulas Functions And Precedence Part II – 6:56
• 5.21 Exercises With Formulas Functions and Precedence Part III – 8:56
• 5.22 Cell Referencing Part I – 3:50
• 5.23 Cell Referencing Part II– 6:30
• 5.24 Cell Referencing Part III – 5:28
• 5.25 Cell Referencing Part IV – 4:55
• 5.26 Cell Referencing Part V – 4:51
• 5.27 Cell Referencing Part VI – 6:00
• 5.28 Cell Referencing Part VII – 4:40
• 5.29 Cell Referencing Part VIII – 5:08
• 5.30 Cell Referencing Part VIII Supplement – 7:04
• 5.31 Mixed Mode References – 5:06
• 5.32 Mixed Mode Examples – 6:15
• 5.33 Using Mixed Mode – 3:22
• 5.34 Why Mixed Mode Works – 8:34
• 5.35 Using Mixed Mode and Fill – 6:15
• 5.36 Mixed Mode Loan Table – 12:40
• 5.37 Cell Referencing Exercises – 6:18
• 5.38 Section Conclusion – 0:40

Level 6 – Formulas and Functions (1 Hour 31 Minutes)

• 6.01 Section Introduction – 0:47
• 6.02 Introduction to the SUM Function – 4:44
• 6.03 More on the SUM Function – 3:09
• 6.04 Using the SUM Function – 3:20
• 6.05 Selecting Cells with the Keyboard Part I – 5:12
• 6.06 Selecting Cells with the Keyboard Part II – 1:39
• 6.07 Selecting Cells with the Mouse – 4:38
• 6.08 Selecting Cells with Keyboard and Mouse – 2:07
• 6.09 Using The Fill Handle – 3:25
• 6.10 Filling Right – 2:47
• 6.11 Filling – 4:00
• 6.12 Fill Overwrite – 1:49
• 6.13 Using Fill with Formulas – 4:03
• 6.14 Auto Function Introduction – 4:09
• 6.15 Using The AutoSum Function – 5:11
• 6.16 The Average Function – 4:51
• 6.17 The Count Function – 5:01
• 6.18 The Max Function – 2:51
• 6.19 The Min Function – 2:39
• 6.20 Comparison Operators – 3:48
• 6.21 Using Comparison Operators – 3:41
• 6.22 The IF Function – 4:18
• 6.23 How The IF Function Works – 6:15
• 6.24 Advanced IF Topics – 5:54
• 6.25 Section Conclusion – 0:39

Level 7 – Pivot Tables and Charts (1 Hour 13 Minutes)

• 7.01 Introduction to PivotTables and Reporting – 2:32
• 7.02 Large Amounts of Data Filtered – 4:27
• 7.03 PivotTable Options – 5:40
• 7.04 PivotTable Theory – 2:22
• 7.05 PivotTable Customization – 3:28
• 7.06 More PivotTable Customization – 4:20
• 7.07 Introduction to Charts – 5:11
• 7.08 Chart Creation – 5:03
• 7.09 Other Chart Types – 7:14
• 7.10 Chart Options – 4:56
• 7.11 More Chart Options – 9:31
• 7.12 Step 4 of the Chart Wizard – 1:42
• 7.13 Modifying Charts – 7:21
• 7.14 Customizing Chart Options – 4:49
• 7.15 Charts are Dynamic – 3:58
• 7.16 Section Conclusion – 1:00

Level 8 – Tips and Tricks (21 Minutes)

• 8.01 Freezing Panes – 3:08
• 8.02 Closing All Open Workbooks – 1:37
• 8.03 Opening a Workspace – 3:32
• 8.04 Using Constants – 3:56
• 8.05 Selection Calculation – 3:18
• 8.06 Smart Fill – 5:24

Click here