Embedded Files
Assignments for Day One (December 9, 2019) - Please complete all Assignments, and Quiz.
Classroom:
Syllabus, Windows 10 Reference, Getting Started (Introduction to Power Excel, Power Excel Workflow), Power Query (Introduction to Power Query, Ribbon and Button Overview), and Connect (Import data from external data network, Connect to an Excel data table, Connect to a SQL Server database, Combine data from multiple data sources).
Homework:
Read Windows 10 Reference, Microsoft Excel 2016 Reference, Microsoft Excel 2016 Intermediate Guidebook (Chapter One).
Reminders:
Each Team are tasked to create a respective business utilizing all of the information taught through-out the course. Each team will give a 15 minute PowerPoint presentation in front of the class, with a special guess in attendance. Team A - P and C Trucking and Team B - Carolina Arms Parts Supply Company are required to discuss the following during the presentation:
Business Plan, History, Business Location with a map, Hours of Operation, Organiational Chart, Employee List, Customer List, Equipment List, Videos, Music, Sound Recordings, Graphics/Pictures, Favorite Links, Questions and Answers, etc.
Lab:
Create Monthly Budget Report and Home Inventory (Excel Workbook)
Create Business Plan (Word Document)
Create Business Presentation (PowerPoint)
Team presentations:
Carolina Arms Parts Supply Company
Review videos:
import data from external data sources
connect to sql server database
Assignments for Day Two (December 10, 2019) - Please complete all Assignments, and Quiz.
Classroom:
Syllabus, Windows 10 Reference, Transform (Add a query to an Excel worksheet, Edit query step settings, Shape data), Combine - Share (View and Manage Queries in a Workbook, Share queries in the Power BI Data Catalog, Combine multiple queries, Merge queries).
Homework:
Read Windows 10 Reference, Microsoft Excel 2016 Reference, Microsoft Excel 2016 Intermediate Guidebook (Chapter Two).
Lap:
Create Inventories and Inventories List (Workbook)
Create Business Database (Access)
Review videos:
Assignments for Day Three (December 11, 2019) - Please complete all Assignments, and Quiz.
Classroom:
Syllabus, Windows 10 Reference, Query Editor (Options for loading data in MS Excel, Basic Power Query table transformations), Text-specific query editing tools, Number-specific query editing tools, Date-specific query editing tools.
Homework:
Read Windows 10 Reference, Microsoft Excel 2016 Reference, Microsoft Excel 2016 Intermediate Guidebook (Chapter Three).
Reminders:
Each Team are tasked to create a respective business utilizing all of the information taught through-out the course. Each team will give a 15 minute PowerPoint presentation in front of the class, with a special guess in attendance. Team A - P and C Trucking and Team B - Carolina Arms Parts Supply Company are required to discuss the following during the presentation:
Business Plan, History, Business Location with a map, Hours of Operation, Organiational Chart, Employee List, Customer List, Equipment List, Videos, Music, Sound Recordings, Graphics/Pictures, Favorite Links, Questions and Answers, etc.
Review videos:
Assignments for Day Four (December 12, 2019) - Please complete all Assignments, and Quiz.
Classroom:
Syllabus, Windows 10 Reference, Create a rolling calendar with Power Query, Add-index and conditional columns with Power Query, Group and aggregate data with Power Query, Modify Excel workbook queries.
Homework:
Read Windows 10 Reference, Microsoft Excel 2016 Reference, Microsoft Excel 2016 Intermediate Guidebook (Chapter Four).
Review videos:
Assignments for Day Five (December 13, 2019) - Please complete all Assignments, and Quiz.
Classroom:
Syllabus, Windows 10 Reference, Merge Queries, Append Queries, Connect Excel to a folder of files, Excel Power Queries Best Practices.
Homework:
Read Windows 10 Reference, Microsoft Excel 2016 Reference, Microsoft Excel 2016 Advanced Guidebook (Chapter One only).
Reminders:
Each Team are tasked to create a respective business utilizing all of the information taught through-out the course. Each team will give a 15 minute PowerPoint presentation in front of the class, with a special guess in attendance. Team A - P and C Trucking and Team B - Carolina Arms Parts Supply Company are required to discuss the following during the presentation:
Business Plan, History, Business Location with a map, Hours of Operation, Organiational Chart, Employee List, Customer List, Equipment List, Videos, Music, Sound Recordings, Graphics/Pictures, Favorite Links, Questions and Answers, etc.
Review videos:
Assignments for Day Six ( ) - Please complete all Assignments, and Quiz.
Classroom:
Syllabus, Windows 10 Reference, What is Power Pivot?, When to use Power Pivot, Creating a Power Pivot Table, Importing data into Power Pivot.
Homework:
Read Windows 10 Reference, Microsoft Excel 2016 Reference, Microsoft Excel 2016 Advance Guidebook (Chapter Two only)
Review videos:
What is Power Pivot and Power Query?
Assignments for Day Seven ( ) - Please complete all Assignments, and Quiz.
Classroom:
Syllabus, Windows 10 Reference, Data Transformation (Working with Rows, Filtering Rows, Working with Duplicates), Working with Columns (Remove, Splitting, Extracting).
Homework:
Read Windows 10 Reference, Microsoft Excel 2016 Reference, Microsoft Excel 2016 Advance Guidebook (Chapter Three only)
Review videos:
Assignments for Day Eight ( ) - Please complete all Assignments, and Quiz.
Classroom:
Syllabus, Windows 10 Reference, Merging (Duplicate, Index Columns), Pivot and unpivoting data with Power Query, Grouping data, Cut and Paste Query.
Homework:
Read Windows 10 Reference, Microsoft Excel 2016 Reference, Microsoft Excel 2016 Advance Guidebook (Chapter Four only)
Review videos:
Page updated
Google Sites
Report abuse