Microsoft Excel 2013 Course Beginners/ Intermediate Training

Course Curriculum

Chapter 1: 01. Start Here

Lecture 1: Working Files – Download These First

Lecture 2: 0101 Let's Get Started With Excel 2013

Lecture 3: 0102 The Excel Workbook Explained

Lecture 4: 0103 Signing Up For Your Own Free SkyDrive

Lecture 5: 0104 Customize The Quick Access Toolbar

Lecture 6: 0105 Using The Included Working Files

Chapter 2: 02. Managing Excel Workbooks And Worksheets

Lecture 1: 0201 Creating And Saving A New Workbook

Lecture 2: 0202 Opening Workbooks And Save As Options

Lecture 3: 0203 Saving And Opening SkyDrive Files

Lecture 4: 0204 Navigating An Excel Workbook

Lecture 5: 205 Adding And Removing Worksheets

Lecture 6: 0206 Renaming Copying And Moving Worksheets

Chapter 3: 03. Entering And Editing Data In Cells

Lecture 1: 0301 Entering Text, Numbers, And Dates

Lecture 2: 0302 Entering Numbers As Text

Lecture 3: 0303 Editing The Contents Of A Cell

Lecture 4: 0304 Undo And Redo Actions

Lecture 5: 0305 Cut, Copy, And Paste

Lecture 6: 0306 Dragging And Dropping Cells

Lecture 7: 0307 The Fill Handle

Lecture 8: 0308 Inserting And Deleting Cells Columns And Rows

Lecture 9: 0309 Changing Column Widths And Row Heights

Lecture 10: 0310 Hiding And Un-Hiding Columns And Rows

Lecture 11: 0311 Searching For Values In A Workbook

Chapter 4: 04. Math Basics

Lecture 1: 0401 Getting Started With Basic Math Formulas

Lecture 2: 0402 Order Of Operation With BODMAS

Lecture 3: 0403 Introduction To Basic Formulas

Lecture 4: 0404 Copying Formulas And Functions

Lecture 5: 0405 Displaying Formulas On A Worksheet

Chapter 5: 05. Formatting Worksheets

Lecture 1: 0501 Selecting Cells For Formatting

Lecture 2: 0502 Modifying Typeface Font, Size, And Colour

Lecture 3: 0503 Merging And Wrapping Cell Contents

Lecture 4: 0504 Using Number Formats

Lecture 5: 0505 Cell Content Alignment And Orientation

Lecture 6: 0506 Adding And Removing Borders From A Selection

Lecture 7: 0507 Applying A Date Format To A Cell Or Range

Lecture 8: 0508 The Format Painter

Lecture 9: 0509 Finding And Replacing Formats

Lecture 10: 0510 Clearing Cell Contents Vs. Clearing Cell Formatting

Chapter 6: 06. Workbook And Worksheet Management

Lecture 1: 0601 Worksheet Navigation And Coloured Worksheet Tabs

Lecture 2: 0602 Moving Or Copying Worksheets Within And Between Workbooks

Lecture 3: 0603 Viewing And Scrolling Multiple Workbooks At The Same Time

Lecture 4: 0604 Hiding And Un-Hiding Sheets

Lecture 5: 0605 Modifying More Than One Worksheet At A Time

Chapter 7: 07. Page Setup And Printing

Lecture 1: 0701 Using Print Titles And Print Areas

Lecture 2: 0702 Paper Size, Orientation, Margins, And Scaling Options

Lecture 3: 0703 Creating Headers and Footers

Lecture 4: 0704 Using The Page Break And The Page Layout Views

Lecture 5: 0705 Printing A Range Of Cells

Lecture 6: 0706 Running The Spell Checker

Lecture 7: 0707 Controlling Most Print Settings In One Place

Chapter 8: 08. Mathematical Formulas

Lecture 1: 0801 The Sum Function

Lecture 2: 0802 Copying Formulas And Functions

Lecture 3: 0803 Other Mathematical Functions: Average, Min, And Max

Lecture 4: 0804 Useful Count Functions

Lecture 5: 0805 Absolute Referencing Explained

Lecture 6: 0806 Formulas Across Worksheets

Lecture 7: 0807 3D Referencing

Lecture 8: 0808 Making Use Of Named Cells And Ranges

Chapter 9: 09. Advanced Formatting

Lecture 1: 0901 Enhancing Worksheets Using Themes

Lecture 2: 0902 Adding, Editing, And Deleting Comments

Lecture 3: 0903 Creating Your Own Autofill List

Lecture 4: 0904 Converting Data To A Table For Formatting

Chapter 10: 10. Security

Lecture 1: 1001 Activating And Deactivating Worksheet Protection

Lecture 2: 1002 Protecting Part Of A Worksheet To Aid Data Entry

Lecture 3: 1003 Password Protecting The Whole Workbook

Chapter 11: 11. Excel 2013 Templates

Lecture 1: 1101 Using The 2013 Templates

Lecture 2: 1102 Creating And Using Your Own Template

Chapter 12: 12. Graphics Objects

Lecture 1: 1201 Obtaining And Inserting Online Images

Lecture 2: 1202 Using SmartArt Graphics

Lecture 3: 1203 Inserting Shapes And Screenshots

Lecture 4: 1204 Formatting Graphical Objects

Lecture 5: 1205 The Stacking Order

Lecture 6: 1206 Grouping Multiple Objects Together

Lecture 7: 1207 Using Graphical Objects And Mathematical Formulas

Chapter 13: 13. Using Charts In Excel

Lecture 1: 1301 The New Recommended Charts Option

Lecture 2: 1302 Create A Chart Using The Long Or The Short Method

Lecture 3: 1303 Formatting A Chart With The 2013 Shortcut Options

Lecture 4: 1304 Modifying The Chart Type

Lecture 5: 1305 Formatting Chart Elements

Lecture 6: 1306 Adding A Trendline

Lecture 7: 1307 The Pie Chart In Detail

Lecture 8: 1308 Mini Graphs: Sparklines

Chapter 14: 14. Excel As A Database

Lecture 1: 1401 Fixing On Screen Rows And Columns

Lecture 2: 1402 Fixing Print Rows And Columns

Lecture 3: 1403 Sorting Data In Excel

Lecture 4: 1404 Filtering Data To Reduce Dataset Size