Excel 2013 LearnKey Plan

Session 1 Pre-Assessment

Watch Session 1: Introduction [26 minutes]

Fill-in-the-Blanks Session 1: Question 1-5 (workbook page 12-13)

Course Support File: 1-CONCATENATE

Session 1 Lab 1: Quick Access Toolbar

Session 1 Lab 2: Adding Buttons to a Tab on the Ribbon

Session 1 Project 1: Customizing the Ribbon (workbook page14)

Course Support File: 1-CONCATENATE

Watch Session 1: Navigating Excel [6 minutes]

Fill-in-the-Blanks Session 1: Question 6-8

Session 1 Project 2: Excel Interface (workbook page 15)

Course Support File: 1-CONCATENATE

Watch Session 1: Shortcuts [31 minutes]

Fill-in-the-Blanks Session 1: Questions 9-16

Course Support File: 1-CONCATENATE

Session 1 Project 3: Shortcuts (workbook page 16)

Course Support File: 1-CONCATENATE

Watch Session 1: Creating and Manipulating Data [29 minutes]

Fill-in-the-Blanks Session 1: Questions 17-21

Course Support File: 1-CONCATENATE

Session 1 Lab 3: Opening Custom Lists

Session 1 Project 4: Creating and Manipulating Data (workbook page 18)

Session 1 Lab 4: Extracting

Session 1 Lab 5: Grouping

Course Support File: 1-CONCATENATE

Watch Session 1: Managing Worksheets [10 minutes]

Fill-in-the-Blanks Session 1: Questions 22-25

Session 1 Lab 6: Rename Worksheets

Session 1 Project 5: Managing Worksheets (workbook page 19)

Course Support File: 1-CONCATENATE

Watch Session 1: Paste Special [18 minutes]

Fill-in-the-Blanks Session 1: Questions 26-29

Session 1 Lab 7: Paste Special Steps

Session 1 Project 6: Paste Special (workbook page 20)

Course Support File: 1-CONCATENATE

Watch Session 1: Changing Views [20 minutes]

Fill-in-the-Blanks Session 1: Question 30

Session 1 Lab 8: New Window

Session 1 Lab 9: Page Breaks

Session 1 Lab 10: Custom View

Course Support File: 1-CONCATENATE

2-LinkedFormulas

Session 1 Project 7: Changing Views (workbook page 21)

Session 1 Project 8: Sales Convention Travel Expenses (workbook page 22)

Session 1 Project 9: Birthday Wish List (workbook page 23)

Session 1 Project 10: Product Analysis (workbook page 24)

Session 1 Project 10: Product Analysis (Continued)

Review and discuss Excel 2013 Session 1

Excel 2013 Session 1Post Assessment

 

 

 

 

 

 

 

 

 

Session 2 Pre-Assessment

Watch Session 2: Formatting Data [14 minutes]

Fill-in-the-Blanks Session 2: Questions 1-7 (workbook page 26-27)

Session 2 Lab 1: Backgrounds

Session 2 Project 1: Formatting Data (workbook page 28)

Course Support File: 1-CONCATENATE

2-LinkedFormulas

Watch Session 2: Modify Cells [19 minutes]

Fill-in-the-Blanks Session 2: Questions 8-11

Session 2 Lab 2: Horizontal Alignment

Session 2 Lab 3: Number Formats

Course Support File: 1-CONCATENATE

Session 2 Project 1: Modify Cells (workbook page 29)

Watch Session 2: Tables [22 minutes]

Fill-in-the-Blanks Session 2: Questions 12-17

Session 2 Lab 4: Filtering Data

Course Support File: 5-AdvFilter-Criteria

Session 2 Project 3: Tables (workbook page 30)

Watch Session 2: Tables [28 minutes]

Fill-in-the-Blanks Session 2: Questions 18-22

Course Support File: 1-CONCATENATE

Session 2 Lab 5: Split Cell Contents

Session 2 Project 4: Using CONCATENATE and Splitting Cell Contents (workbook page 31)

Session 2 Project 5: Using Formulas (workbook page 32)

Watch Session 2: Operations [22 minutes]

Fill-in-the-Blanks Session 2: Questions 23-29

Session 2 Lab 6: AVERAGE Formula

Course Support File: 1-CONCATENATE

Session 2 Project 6: Using Operations and Number Formulas (workbook page 33)

Session 2 Project 7: Formula Auditing and Cell References (workbook page 34)

Session 2 Project 8: Bank Statement (workbook page 35)

Session 2 Project 9: Shopping (workbook page 36)

Session 2 Project 10: Fantasy Football (workbook page 37)

Discuss and review Excel 2013 Session 2

Excel 2013 Session 2 Post Assessment

 

 

 

Session 3 Pre-Assessment

Watch Session 3: Totals and Sparklines [18 minutes]

Fill-in-the-Blank Session 3: Questions 1-6  (workbook page 40-41)

Session 3 Lab 1: Grand Totals

Course Support File:

2-LinkedFormulas

3-Consolidate

Session 3 Project 1: Using Total Sheets (workbook page 42)

Session 3 Project 2: Sparkline Graphics and Tools (workbook page 43)

Session 3 Project 3: Incorrect Data and Consolidation (workbook page 44)

Watch Session 3: Subtotals [7 minutes]

Fill-in-the-Blank Session 3: Questions 7-8

Session 3 Project 4: Subtotals (workbook page 45)

Course Support File: 4-Sales-Subtotals

Session 3 Project 5: Payroll (workbook page 46)

Watch Session 3: VLOOKUP [13 minutes]

Fill-in-the-Blank Session 3: Questions 9-11

Session 3 Project 6: VLOOKUP (workbook page 48)

Course Support File: 8-VLOOKUP1

Session 3 Project 7: Gradebook (workbook page 47)

Watch Session 3: Nested Formulas [16 minutes]

Fill-in-the-Blanks Session 3: Questions 12-15

Session 3 Project 8: Nested Formulas (workbook page 49)

Watch Session 3: Conditional Logic: Using Conditional Logic- COUNTIF [26 minutes]

Fill-in-the-Blanks Session 3: Questions 16-21

Session 3 Lab 2: IFERROR

Course Support File: 5-AdvFilter-Criteria

12-SUMIF-COUNTIFAVERAGEIF

Watch Session 3: Conditional

Logic:  AVERAGEIF- COUNTIFS [9 minutes]

Fill-in-the-Blanks Session 3: Questions 22-25

Session 3 Lab 3: SUMIFS Formula

Course Support File: 13-SUMIFs-AVERAGEIFs- COUNTIFs

Review and discuss Session 4: Conditional Logic

Session 3 Project 9: Conditional Logic (workbook page 50)

Session 3 Project 10: Fundraisers (workbook page 52)

Review and discuss Excel 2013 Session 3

Excel 2013 Session 3 Post Assessment

Advertisements

Create a free website or blog at WordPress.com.

%d bloggers like this: