Essential Excel Skills for Data Preparation and Analysis
Development Academy of the Philippines
Enrollment is Closed
Course Overview
Excel spreadsheet is one of the most vital pieces of software used in workplaces. This course will help you learn the essentials of Microsoft Excel, which you may use in performing calculations, creating visualizations, formatting spreadsheets. The course will impart skills in operating and navigating the Excel software thereby using it for better efficiency and productivity.
What You Will Learn
Upon completion of this course, the learners are expected to:
- perform basic spreadsheet tasks that may be used to have better efficiency and productivity in carrying out business tasks;
- professionally use Excel in creating visualizations and summary of data through tables, charts and graphs; and
- be proficient in Excel calculations using various functions and formulas that will strengthen business reports and analysis.
Requirements
You will need a computer or laptop with Microsoft Excel installed. Computer or laptop requirements are:
- For Windows: Core i3 or better, 4GB RAM or better, MS Excel 2007 or better
- For MacBook: ideally MS Excel 2013 or newer should be installed (some functions require this version on the Mac). If the version of MS Excel is 2011, download and install StatPlus.
Note to SPARTA scholars: Upon enrollment, you will have 6 months to finish a SPARTA course. Failure to complete the course in 6 months and/or inactivity for 3 months will result in course access revocation.
Course Instructor
Gabriel Kristopher Soong
Subject Matter Expert
Course Content
Week 1
3 Videos | 9 Demonstration Lessons | 3 Activities
3 Videos
- Welcome to the course!
- Overview
- Summary
9 Demonstration Lessons
- Spreadsheet Tasks for Cells Part 1
- Spreadsheet Tasks for Cells Part 2
- Spreadsheet Features Part 1
- Spreadsheet Features Part 2
- Basic Navigation Tasks
- fx Button (function wizard); SUM and AVERAGE Functions
- COUNT, COUNTA, and COUNTBLANK Functions; MAX and MIN Functions
- IF Function; VLOOKUP and HLOOKUP Functions
- Common Math Functions
3 Activities
- Quiz: Spreadsheet Features
- Quiz: Spreadsheet Tasks for Navigation
- Quiz: Basic Excel Functions
Week 2
2 Videos | 2 Demonstration Lessons | 1 Activity
2 Videos
- Overview
- Summary
2 Demonstration Lessons
- Conditional Formatting
- Data Validation
1 Activity
- Quiz: Worksheet Entry and Design
Week 3
2 Videos |7 Demonstration Lessons | 1 Activity
2 Videos
- Overview
- Summary
7 Demonstration Lessons
- Y2K Problem; NOW and TODAY Functions; YEAR, MONTH, DAY and WEEKDAY Functions
- DATEDIF Function; DATE and DATEVALUE Functions; TRIM and VALUE; CONCATENATING Text
- Parsing with Common Text Values
- COUNTIF, SUMIF and AVERAGEIF Functions
- COUNTIFS, SUMIFS and AVERAGEIFS Functions
- SUMPRODUCT Functions
- Short Exercise
1 Activity
- Quiz: Formulas and Functions Part 1
Week 4
2 Videos | 8 Demonstration Lessons |1 Activity
2 Videos
- Overview
- Summary
8 Demonstration Lessons
- MEDIAN, PERCENTILE and QUARTILE Functions
- STDEV and VAR Functions
- CORREL and COVAR Functions
- RANK LARGE and SMALL Functions
- INDEX Function
- MATCH Function
- OFFSET Function
- Recording a Macro
1 Activity
- Quiz: Formulas and Functions Part 2
Week 5
2 Videos | 3 Demonstration Lessons | 2 Activities
2 Videos
- Overview
- Key Takeaways
3 Demonstration Lessons
- Tables
- Pivot Tables
- Creating, Locating, and Modifying a Chart
2 Activities
- Quiz: Data Presentation
- Capstone Project