In this 8-week course, students will master the use of Excel by navigating around the spreadsheet, using colors, fonts, and other styling techniques to present data visually, quickly perform calculations and analysis through formulas and functions, refine and slice data using tables and filters, present data using charts and graphs and create layouts for quick printing and sharing.
Week # | Topic |
Week 1 | Introduction to spreadsheets, navigating around spreadsheets |
Week 2 | Formatting your numbers, tables, and data |
Week 3 | Applying formulas and functions to analyze data |
Week 4 | Using tables, filters to organize and slice data |
Week 5 | Charts, Graphs, Layouts, and Printing |
Week 6 | Advanced data org. techniques |
Week 7 | Content Review |
Week 8 | Final Project |