Embedded Files
Assignments for Week One (January 13, 2020) - Please complete all Assignments, and Quiz in
the Microsoft Excel 2016 Introduction book.
Classroom:
Syllabus, Creating and Mange Worksheets and Workbooks
Requirements:
Create (Business Plan, Address Book, Budget and IF Function)
Lab:
Create worksheets and workbooks, navigate in worksheets and workbooks, format worksheets and workbooks, customize options and views for worksheets and workbooks, moving the cell pointer, selecting a range of cells, creating a new workbook, inserting, renaming and deleting workbooks, entering constant values, using auto-fill to enter data, saving a workbook, editing cell contents,
clearing, working with undo and redo.
Homework:
Download the 3D Reference and Summarize file on your personal computer. Print and Review the document prior to the next class.
Favorite Links:
Please click Blackboard for Online files.
Please click SharePoint for Shared files.
Review videos:
Assignments for Week Two (January 14, 2020) - Please complete all Assignments, and Quiz in
the Microsoft Excel 2016 Introduction book.
Classroom:
Syllabus recap, Advanced Workbook Formatting, Tracking customer data
Requirements:
Create (Equipment List, Home Inventory and Index & Match)
Lab:
Configure worksheets and workbooks for distribution, manage data cells and ranges,
insert date in cells and ranges, summarize and organize data, date functions and conditional
formatting, financial functions and what-if analysis, advanced functions for text and analysis,
lookup functions and outlines, insert sparklines, create tables, create and manage tables,
manage table styles and options, filter and sort a table, entering formulas.
Homework:
Download the Auto-fill and Excel Relationship file on your personal computer. Print and Review the document prior to the next class.
Favorite Links:
Please click Blackboard for Online files.
Please click SharePoint for Shared files.
Review videos:
share workbook and track changes
Assignments for Week Three (January 15, 2020) - Please complete all Assignments, and Quiz in
the Microsoft Excel 2016 Intermediate book.
Classroom:
Syllabus Recap, Manage Data cells and ranges, using auto-fill with formulas
Requirements:
Create (Inventories and Online)
Lab:
Using the Sum function, summing columns or rows automatically, using statistical functions,
working with range finder, using formula error checking, perform operations with formulas
and functions, using the IF function, nesting functions, using multiple conditions with the
IF function, nesting IF functions, summarizing data by using functions.
Homework:
Download the Auto-fill and Finding Duplicates, Sum ( ) and Negative value file on your personal computer. Print and Review the document prior to the next class.
Favorite Links:
Please click Blackboard for Online files.
Please click SharePoint for Shared files.
Review videos:
Assignments for Week Four (January 16, 2020) - Please complete all Assignments, and Quiz in
the Microsoft Excel 2016 Intermediate book.
Classroom:
Syllabus recap, Date functions, and perform conditional operations by using functions
Requirements:
Create (Macros, Text to Column, VLOOKUP and Text Function)
Lab:
Format and modify text by using functions, understanding chart types, creating a chart, changing
the chart location and size, changing the chart type, modifying chart element, formatting chart
elements, adding and removing a data series.
Homework:
Download the Flash-fill and Multiple subtotaling, Sum ( ) and Wild Cards, and Transposing Data
file on your personal computer. Print and Review the document prior to the next class.
Favorite Links:
Please click Blackboard for Online files.
Please click SharePoint for Shared files.
Review videos:
Assignments for Week Five (January 17, 2020) - Please complete all Assignments, and Quiz in
the Microsoft Excel 2016 Intermediate book.
Classroom:
Syllabus recap, Create Chart and Applying a chart filter
Requirements:
Create (Company Balanced Budget)
Lab:
Printing charts, create charts and objects, create charts, format charts, insert and format charts,
pivot tables and pivot charts.
Homework:
Download the Sum ( ) and helper, Sum ( ) and Wild Cards, and Transposing Data file on your personal computer. Print and Review the document prior to the next class.
Favorite Links:
Please click Blackboard for Online files.
Please click SharePoint for Shared files.
Project:
Team A - Create a Training Business
Team B - Create a Science Business
Each team is required to produce 15 PowerPoint slides for their respective presentation. Presentation will include Business Name, Business Location, Cost to startup the business, Organizational Chart, Equipment List, Personnel List, Customer List, Contact List, Hours of Operation, Videos, Graphics or Pictures, Sound Bits, Music, etc. Both teams will have 15 minutes to discuss their business in front of the audience with special guess and instructor for evaluation purposes only.
Review videos:
Page updated
Google Sites
Report abuse