Sara's One Stop Computer Shop
COME SOCIALIZE WITH US!
  • Home
    • Contact Us
    • Inside My Store
    • Terabit T-Rex
    • Staff Login
  • Our Services
    • Take A Class
    • Repairs and Maintenance
    • Virus Removal
    • Website Design
  • Support
    • Worry-Free Support
    • Tips & Tricks >
      • iCloud
      • Backing Up Your Computer
    • LastPass
    • Remote Help
  • Online Classes
  • Test Your Skills

Microsoft Excel 2019
Introductory
​Student Area

Module 1: Getting Started with Excel

OBJECTIVES:
  • Open and close a workbook
  • Navigate through a workbook and worksheet
  • Select cells and ranges
  • Plan and create a workbook
  • Insert, rename, and move worksheets
  • Enter text, dates, and numbers
  • Undo and redo actions
  • Resize columns and rows
  • Enter formulas and the SUM and COUNT functions
  • Copy and paste formulas
  • Move or copy cells and ranges
  • Insert and delete rows, columns, and ranges
  • Create patterned text with Flash Fill
  • Add cell borders and change font size
  • Change worksheet views
  • Prepare a workbook for printing

​Module 1 - Student Files

Module 1 - Text
Excel 2019 - Module 1 PDF
File Size: 92431 kb
File Type: pdf
Download File

Module 1 - Overview
​Video Overview
​PowerPoint Slides
npexcel2019_m01_ppt-ce.pptx
File Size: 6190 kb
File Type: pptx
Download File

Module 1 - Data Files
Case 1
np_ex_1-2.xlsx
File Size: 14 kb
File Type: xlsx
Download File

Case 2
np_ex_1-3.xlsx
File Size: 48 kb
File Type: xlsx
Download File

Module
np_ex_1-1.xlsx
File Size: 78 kb
File Type: xlsx
Download File

Module 1 - Test
Microsoft Excel 2019 - Module 1 Test

Module 2: Formatting Workbook Text and Data

OBJECTIVES:
  • Change fonts, font style, and font color
  • Add fill colors and a background image
  • Create formulas to calculate sales data
  • Format numbers as currency and percentages
  • Format dates and times
  • Align, indent, and rotate cell contents
  • Merge a group of cells
  • Use the AVERAGE function
  • Apply cell styles
  • Copy and paste formats with the Format Painter
  • Find and replace text and formatting
  • Change workbook themes
  • Highlight cells with conditional formats
  • Format a worksheet for printing

​Module 2 - Student Files

Module 2 - Text
Excel 2019 - Module 2 PDF
File Size: 100566 kb
File Type: pdf
Download File

Module 2 - Overview
​Video Overview
PowerPoint Slides
npexcel2019_m02_ppt-ce.pptx
File Size: 10727 kb
File Type: pptx
Download File

Module 2 - Data Files
Case 1
np_ex_2-3.xlsx
File Size: 29 kb
File Type: xlsx
Download File

Case 2
np_ex_2-4.xlsx
File Size: 13 kb
File Type: xlsx
Download File

Module
np_ex_2-1.xlsx
File Size: 14 kb
File Type: xlsx
Download File

support_ex_2_background.jpg
File Size: 13 kb
File Type: jpg
Download File

Review
np_ex_2-2.xlsx
File Size: 12 kb
File Type: xlsx
Download File

support_ex_3_texture.jpg
File Size: 12 kb
File Type: jpg
Download File

Module 2 - Test

Module 3: Performing Calculations with Formulas and Functions

OBJECTIVES:
  • Translate an equation into a function
  • Do calculations with dates and times
  • Extend data and formulas with AutoFill
  • Use the Function Library
  • Calculate statistics
  • Using the Quick Analysis toolbar
  • Use absolute and relative cell references
  • Use a logical function
  • Retrieve data with lookup tables
  • Do what-if analysis with Goal Seek

​​Module 3 - Student Files

Module 3 - Text
Excel 2019 - Module 3 PDF
File Size: 64644 kb
File Type: pdf
Download File

​Module 3 - Overview
​​Video Overview
​PowerPoint Slides
npexcel2019_m03_ppt-ce.pptx
File Size: 1701 kb
File Type: pptx
Download File

Module 3 - Data Files
Case 1
np_ex_3-3.xlsx
File Size: 298 kb
File Type: xlsx
Download File

Case 2
np_ex_3-4.xlsx
File Size: 12 kb
File Type: xlsx
Download File

Module
np_ex_3-1.xlsx
File Size: 71 kb
File Type: xlsx
Download File

Review
np_ex_3-2.xlsx
File Size: 109 kb
File Type: xlsx
Download File

Module 3 - Test

Module 4: Analyzing and Charting Financial Data

OBJECTIVES:
  • Create a pie chart
  • Format chart elements
  • Create a line chart
  • Work with chart legends
  • Create a combination chart
  • Create a scatter chart
  • Edit a chart data source
  • Create a data callout
  • Insert shapes and icons into a worksheet
  • Create and edit a data bar
  • Create and edit a group of sparklines

​​Module 4 - Student Files

Module 4 - Text
Excel 2019 - Module 4 PDF
File Size: 90897 kb
File Type: pdf
Download File

​Module 4 - Overview
​Video Overview
​PowerPoint Slides
npexcel2019_m04_ppt-ce.pptx
File Size: 11402 kb
File Type: pptx
Download File

Module 4 - Data Files
Case 1
np_ex_4-3.xlsx
File Size: 18 kb
File Type: xlsx
Download File

​Case 2
np_ex_4-4.xlsx
File Size: 52 kb
File Type: xlsx
Download File

Module
np_ex_4-1.xlsx
File Size: 27 kb
File Type: xlsx
Download File

​Review
np_ex_4-2.xlsx
File Size: 25 kb
File Type: xlsx
Download File

Module 4 - Test

Sara's One Stop Computer Shop
24056 State Road 35 / 70
Siren, WI 54872

715-349-GEEK (4335)
EMAIL US
CONTACT US
Apple®, iPad® and iPhone® are trademarks of Apple Inc., registered in the U.S. and other countries.
Google®, Gmail®, Drive®, Docs®, Sheets® are trademarks of Google Inc., registered in the U.S. and other countries