Spreadsheets
Issued by
Community College of Vermont
Earners of this badge are able to build a variety of spreadsheets using simple and complex formulas, functions, graphics, database features, sorts, linkages within spreadsheets and between spreadsheets, and macros.
- Type Validation
- Level Foundational
- Time Weeks
- Cost Paid
Earning Criteria
-
Complete readings and assignments in 15 modules. Topics include spreadsheets basics, cloud file management, formatting and efficiency tools, conditional formatting, in-cell graphing, advanced functions, tables and ranges, forms, formula auditing, working between sheets and books, charts and graphs, maps, data integrity, subtotals, validations, working across worksheets and workbooks, excel forms, hyperlinks and office integration, pivot tables, what if analysis, and data security.
-
Apply knowledge of spreadsheets concepts through a series of quizzes.
-
Develop 6 projects that apply knowledge of spreadsheets to a real-world scenario. Topics include functions and sparklines, essential skills, data visualization, creating a Google Map from a spreadsheet, Excel 2D or 3D map, and advanced functions.