Skip to main content

Essential Excel Skills for Data Preparation and Analysis


Development Academy of the Philippines

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.

Course Instructor

Course Staff Image #1

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
  1. Course Number

    SP201
  2. Classes Start

  3. Classes End

  4. Estimated Effort

    1-3 hours/week
  5. Price

    Php1000
Enroll