- Teacher: Julia Lang-Shapiro
Welcome to "Excelling with Microsoft Excel". The syllabus with deadlines is found at the end of this message.
There are ten main topics and 15 specific lessons. Each lesson has an assignment for you to complete. Most assignments involve submission of work in Excel. When Word is utilized as well, it is typically utilized for you to send feedback or answers through the Word document format. In one of our lessons, Word is used in coordination with Excel to produce a multi-page document which brings data from Excel into Word. Therefore, you need to have Word and Excel, and since almost everyone who has Excel has a Microsoft Office suite that includes Word, this should present no issue.
Please let me know through "messaging" which version of Excel yo have. This can be seen when the first screen displays as Excel is loading. If you are not sure, let me know that as well, and I will help you figure it out.
The instructions are for all versions including very old versions that still exist in some schools. I work painstakingly to try to have as much clarification as possible in the instructions, but lease do not hesitate to send me a message if you are confused. You could also e-mail me at email@example.com.
The first two lessons are posted under Topic 1.
Files needed for this course are e-mailed to you in the first week. Hence, send me an e-mail in the first week of this course so that I ahve the correct e-mail address you would like to use for this course, when needed. Once I receive your e-mail, I will send you the files. Utilize them by name when the lesson in a specific topic asks for you to use that file by name.
I wish you the best throughout the course.
Syllabus for "Excelling with Microsoft Excel"
Topic 1: Introduction: All work for this topic is due by February 10, 11:59 p.m.
---Lesson 1: Navigating spreadsheets and Often-Used Terminology
---Lesson 2: Basic Data Manipulation
Topic 2: Setting up a Simple Record Book for Routine Adminsitrative Tasks: All work for this topic is due by February 10, 11:59 p.m.
---Lesson 3: Basic Formulas
Topic 3: Creating and Working with Templates: All work for this topic is due by February 17, 11:59 p.m.
---Lesson 4: Using Templates for Greater Efficiency
Topic 4: Setting up a Gradebook in Excel: All work for this topic is due by February 24, 11:59 p.m.
---Lesson 5: Creating the Gradebook You Want
---Lesson 6: Formatting the Gradebook, and Accessing Statistical Results Quickly
Topic 5: Practice with Simple Charts: All work for this topic is due by March 3, 11:59 p.m.
---Lesson 7: Deciding on the Correect Charts for Your Data, and Creating Them
Topic 6: Everything You Ever Need to Understand Better about Pie Charts: All work for this topic is due by March 10, 11:59 p.m.
---Lesson 8: Pie Chart Creation and Formatting
Topic 7: Creating More Chart Types: All work for this topic is due by March 17, 11:59 p.m.
---Lesson 9: Advanced Charting and Chart Formatting
Topic 8: Advanced Functions and Formulas: All work for this topic is due by March 24, 11:59 p.m.
---Lesson 10: Using Excel for Minutia, Including Rational Numbers
---Lesson 11: Advanced Charting
---Lesson 12: Explaining the Charts as a Teacher Would Need to Do
Topic 9: Advanced Features: All work for this topic is due by April 4, 11:59 p.m.
---Lesson 13: Mail Merging Between Word and Excel
---Lesson 14: Sharing Data Between Workbooks
Topic 10: Final Work: All work for this topic is due by April 4, 11:59 p.m.
---Lesson 15: Final Exam and Timesheet Submission
- Teacher: Thomas Jeffery
- Teacher: Anthony Auciello
- Teacher: Mary Parisi