Embedded Files
Homework Assignments for Week One (February 1, 2020) - Please complete all Assignments, Quiz
and review the videos.
Read the following files listed below in class:
Excel 2016 Solid Enhancement, 10 Ways to show off your data, What's New, Excel Environment, Spreadsheet Fundamentals Syllabus, SharePoint Tasks
Read the following files for homework:
Excel reference, Explorer Ribbon, New Features, Keyboard shortcuts
Project:
Team A - Create a Supply Business - Step Up Medical Supplies
101 Easy St
Happyville, NC 12345
Team B - Create a MT Business - DJ Auto Supplies
121 Auto Parts Blvd
Jacksonville, NC 28558
**Required to Brainstorm**
Business Name, Business Location, Business Hours of Operation, Business Startup Cost, Business History, Business Organizational Chart, Business Employees List, Business Customers List, Business Equipment List, Business Vendors List, Videos, Music, Sound Recordings, Pictures or Graphics, Question and Answer.
Objective
Each team has fifteen minutes to conduct a PowerPoint presentation with 15 slides of their respective business in front of the class on the last day for a grade.
Lab exercise:
Address Book
Watch the videos:
Excel Tutorial Part One (beginner - intermediate)
Excel Tutorial Part Two (intermediate - advanced)
Homework Assignments for Week Two (February 8, 2020) - Please complete all Assignments, Quiz
and review the videos.
Read the following files listed below in class:
Spreadsheet Fundamentals Syllabus Recap, Subtotal Evaluation Values,
Auto format, SharePoint Tasks
Read the following files for homework:
10 Subtotal Tips, 3D Reference Summarized, Excel Relationships
Lab exercise:
Monthly Budget Report, Inventory List
Watch the videos:
Homework Assignments for Week Three (February 15, 2020) - Please complete all ssignments, Quiz
and review the videos.
Read the following files listed below in class:
Spreadsheet Fundamentals Syllabus Recap, Conditional Formatting Rows, Customize Conditional formatting Exercise, SharePoint Tasks
Read the following files for homework:
Finding Duplicates in Excel, Flash Fill, Multiple Subtotaling, SumIF () Helper Column
Lab exercise:
HLookup, Text to column, Equipment List, Inventory Data
Watch the videos:
Conditional Formatting , HLookup
Homework Assignments for Week Four (March 7, 2020) - Please complete all Assignments, Quiz
and review the videos.
Read the following files listed below in class:
Spreadsheet Fundamentals Syllabus Recap, Sparklines worksheet, SharePoint Tasks
Read the following files for homework:
SumIF () Wildcard, SumIF () Negative Value
Lab exercise:
Create Company Balance Worksheet, Equipment List Part#2
Watch the videos:
Homework Assignments for Week Five (March 14, 2020) - Please complete all Assignments, Quiz
and review the videos.
Read the following files listed below in class:
Spreadsheet Fundamentals Syllabus Recap, SharePoint Tasks
Read the following files for homework:
Transposing Data Fixed, Auto fill shortcuts
Lab:
Inventory, Consolidate and Goal Seek
Project:
Team A - Create a Supply Business
Team B - Create a MT Business
**Required to Brainstorm**
Business Name, Business Location, Business Hours of Operation, Business Startup Cost, Business History, Business Organizational Chart, Business Employees List, Business Customers List, Business Equipment List, Business Vendors List, Videos, Music, Sound Recordings, Pictures or Graphics, Question and Answer.
Objective
Each team has fifteen minutes to conduct a PowerPoint presentation with 15 slides of their respective business in front of the class on the last day for a grade.
Lab exercise:
Complete Company Balance Worksheet
Watch the videos:
Page updated
Google Sites
Report abuse