Homework Assignments for Day One (July 9, 2018) - Please complete all Assignments,
Quiz and review the videos.
Read the following files listed below in the classroom:
Syllabus, Word 2013 Reference, Keyboard Shortcuts, Chapter One and
Two Microsoft Office 2013 Word Intermediate Custom Guide Book
Read the following files for homework:
Chapter Three Microsoft Office 2013 Word Intermediate Custom
Guide Book
Lab exercise:
Table of Contents and Letter Development
Instructor's video:
Word 2013 Features Part One , Word 2013 Features Part Two , Word 2013 Features Part Three ,
Word 2013 Features Part Four , Word 2013 Features Part Five
Watch the videos:
Homework Assignments for Day Two (July 10, 2018) - Please complete all Assignments,
Quiz and review the videos. As a Friendly Reminder bring your Thumb drive to class on Wednesday to
copy file, etc.
Read the following files listed below in the classroom:
Syllabus Recap, Chapter Four and Five Microsoft Office 2013 Word Intermediate
Custom Guide Book
Please read the following file for homework:
Chapter Six Microsoft Office 2013 Word Intermediate Custom Guide Book
Lab exercise:
Contacts and Mail Merge
Instructor's video:
Watch the videos:
Homework Assignments for Day Three (July 11, 2018) - Please complete all Assignments,
Quiz and review the videos.
Read the following files listed below in class:
Syllabus Recap, Excel 2013 Reference Sheets, Chapters One and Two Microsoft Office 2013 Excel Intermediate Custom Guide Book
Read the following files for homework:
Chapters Three Microsoft Office 2013 Excel Intermediate Custom Guide Book, Conditional Formatting Rows, and Customize Conditional formatting Exercise,
4 Simple Ways to work with Excel and Word, 10 Ways to Show off your Excel
2013 Data, Conditional Formatting for Rows
Lab exercise:
Contacts, Addressbook, Budget, Equipment List, Company Balance Sheet Part One through Three
Instructor's Video:
Equipment List , Company Balance Part One , Company Balance Part two , Company Balance Part Three
Watch the videos:
Excel 2013 Overview , Conditional Formatting
Homework Assignments for Day Four (July 12, 2018) - Please complete all Assignments,
Quiz and review the videos.
Read the following files listed below in class:
Syllabus Recap, Chapter Four Microsoft Office 2013 Excel Intermediate Custom Guide Book, Chapter One and Two Microsoft Office 2013 PowerPoint Intermediate Custom Guide Book
Read the following files for homework:
Chapter Three Microsoft Office 2013 PowerPoint Intermediate Custom Guide Book,
Excel 2013 Solid Enhancements, If Error_VLookup_Range, Protecting Formulas in Excel 2007 and 2013, Subtotal Evaluation Values, VLookup Class Examples
Lab exercise:
Company Balance Sheet Part Four and Five, HLookup, VLookup, Text to Column, Inventory, Goal Sheet, Consolidation, Data Validation, Company Balance Part Four through Five
Instructor's Video:
Company Balance Part Four , Company Balance Part Five
Watch the videos:
VLookup , HLookup , Data Validation
Homework Assignments for Day Five (July 13, 2018) - Please complete all Assignments,
Quiz and review the videos.
Read the following files listed below in class:
Syllabus Recap and Chapter Four and Five Microsoft Office 2013 PowerPoint Intermediate Custom Guide Book
Read the following files for homework:
None
Lab exercise:
Chapter Six Microsoft Office 2013 PowerPoint Intermediate Custom Guide Book, Individual Presentation in front of the class - What have you learned? Each student will have approximately five to ten minutes to present ten slides to the class utilizing PowerPoint. To be fair to the other students, Please do not go over your designated time limits. Good Luck!!
Watch the videos: