Shortcut: bit.ly/ncc-excel
Our Excel class is taught by Rich Malloy at Norwalk Community College. The six-session course is generally taught in the spring, summer, and fall. For information on registering for the course, click: norwalk.edu/extended-studies/.
Date/Time: Tuesdays, 6–9 pm, six session starting Feb. 1.
For the course syllabus, Excel Syllabus.
Survey of Students: Click here.
Session 1: Introduction to Spreadsheets
- Slide Show: Introduction to Excel 2019
- Handout: Handout 1 – Excel
- Projects: Restaurant Invoice, Checkbook Register
- The Excel User Interface
- Navigating and Editing a Worksheet
- Your First Spreadsheet
- The Four Rules of Formulas
- Basic Formatting
- Videos: The Restaurant Check Project
- Part 1: https://youtu.be/uHvJHh7VXGo
- Part 2: https://youtu.be/fSRLk_-9f0M
- Part 3: https://youtu.be/uf6zNl01hgU
- Homework: Basic Excel Exercises
- Homework: Checkbook-Register-Project
- Video: Checkbook Register Project: Checkbook Register Video
Session 2: Formatting and Formulas:
- Slide Show: Slideshow-Formats and Functions
- Handout: Handout 2 – Excel
- Workbook File: Session-2-Workbook
- Projects: Sales Report, Budget
- Auto-Fill
- Functions: SUM, AVERAGE, COUNT
- Using Absolute References in Formulas
- Number and Date Formats
- The PMT Function
- Cell Styles
- Conditional Formatting
- Printing: Margins, Orientation, Headers/Footers
- Video: Simple Budget
Session 3: Database Features and Charts
- Slide Show: Slides-Databases Charts
- Handout: Handout-Session-3
- Workbook File: Workbook-Session-3
- Projects: Salary Analysis, Sales Performance
- Freezing Panes and Print Titles
- Page Breaks and Print Areas
- Sorting and Filtering
- The Subtotal tool
- The SUMIF and AVERAGEIF functions
- Format as Table: The Excel Table
- Charts and Annotation
- Backup Site: Click here
Session 4: Managing Multiple Sheets
- Handout: Excel 2016 Handout 4
- Workbook File: EX04-Workbook-Session-4
- Workbook File with Solutions: Workbook-Session-4-(Solutions)
- Projects: Quarterly Sales Report
- COUNTIF, SUMIF, and AVERAGEIF functions
- Naming Ranges
- Multiple Sheets: Insert Sheets, Moving/Copying Sheets, Naming Sheets
- Grouping Sheets Together
- Linking Worksheets
- Hyperlinks
- Printing Multiple Sheets
- Adjusting Charts
- Text Functions
Session 5: Pivot Tables and Collaboration
- Handout: Handout Excel 5
- Workbook File: Workbook-Excel-Session-5
- Workbook File with Solutions: Session-5-Workbook-(Solutions)
- Slide show: Slideshow-Pivot Tables
- Projects: Sales Analysis, Salary Analysis, Invoice
- Powerful Pivot Tables
- Pivot Charts
- Collaboration Tools
Session 6: VLOOKUP and Auditing
- Handout: Handout Session 6
- Project Files: Workbook Session 6
- Mail Merge Files: Mail Merge Address List, Mail Merge Letter
- Projects: Invoice, Roster
- Customizing the Quick Access Toolbar
- Checking Formulas
- The Powerful VLOOKUP Function
- Data Validation – Choose from a list
- Mail Merge with Excel
- If Time Permits: Scenarios & Goal Seek
- Special Gift!
Microsoft Certification
Microsoft offers two exams that qualify you to be certified as a Microsoft Office Specialist in Excel 2016. This course covers almost all the topics for the Core exam. The Expert exam covers some more advanced topics.
To learn more, click: www.microsoft.com/en-us/learning/exam-77-727.aspx
Recommended book: MOS 2016 Study Guide for Microsoft Excel, $13.10 at Amazon, Published October 2016
Nearest Exam Location: Westchester Community College, Contact: [email protected]