DigitalLiteracy AI Coach
AccessSign in required
← Browse all courses

Productivity · PROD-102

Microsoft Excel

Organize data, use essential formulas, and build clear tables and charts.

LEVELBeginner
LESSON TIMEAbout 5 hours
FORMAT6 self-paced lessons
PATHWAYCDAP required

Practice and the final project time is additional to the lesson estimate.

Check if it fits youSee the full syllabus

IS THIS COURSE FOR YOU?

What to expect from Microsoft Excel

Learners who want to organize, calculate, and present information in spreadsheets.

What you will learn

  • Build organized tables
  • Use essential formulas accurately
  • Create and interpret clear charts

LESSON OUTLINE SAMPLE

Navigate workbooks and worksheets

Navigate workbooks and worksheets is more than a term to remember: it is a practical skill that requires you to understand the situation, select an appropriate method, complete the work carefully, and verify the result. Use this study guide to connect the underlying ideas to the decisions you will make in the lesson activity.

This sample shows the lesson goals and selected takeaways. Enroll to access the complete lesson notes, activities, and assignments.

What this lesson covers

  • Explain the purpose and everyday value of Microsoft Excel.
  • Recognize the core skills and safe practices introduced in this course.
  • Apply the introductory concepts to a realistic activity.

Selected takeaways

  • Excel works best when each column contains one type of information, each row represents one record, and formulas reference cells consistently. Clean data before analysis, distinguish inputs from calculations, verify formulas with known examples, and choose charts that match the question the data should answer.
  • Spreadsheet foundations: Enter, organize, and format data accurately.
  • For Getting started with Microsoft Excel, practice with sample information, verify the result, and record the safe process you followed.

COMPLETE SYLLABUS

3 modules · 6 lessons

6 follow-up assignments · 3 assessments
01
Spreadsheet foundationsEnter, organize, and format data accurately.
2 lessons
  1. 1.1Navigate workbooks and worksheets
  2. 1.2Structure clean tables
02
Calculate and analyzeUse formulas and functions to answer practical questions.
2 lessons
  1. 2.1Write essential formulas
  2. 2.2Sort, filter, and summarize data
03
Communicate with dataTurn spreadsheet results into useful insights.
2 lessons
  1. 3.1Create clear charts
  2. 3.2Check and share a workbook

FINAL COURSE PROJECT

Decision-Ready Excel Workbook

Submit a clean dataset, formulas, validation checks, summary metrics, charts and a decision memo, supporting evidence of your process, and a concise reflection. Do not include passwords, private records or confidential information.

Approximately 4 hours · Instructor reviewed

How success is evaluated

  • The project responds directly to the stated audience, purpose and scenario.
  • The submitted artifact demonstrates skills from multiple modules rather than one isolated lesson.
  • The learner provides evidence of testing, verification and revision.
  • The work addresses data integrity, formula accuracy, usability, visualization choices and defensible interpretation.
  • The explanation is original, clear, well organized and suitable for instructor review.

GRADING AND CERTIFICATE POLICY

Progress by demonstrating mastery

This course is completed through verified evidence of learning—not by averaging every activity into a traditional grade. You can use feedback, revise your work, and resubmit when an instructor requests changes.

  1. Complete the lessonsFinish the required lessons and applied practice in the published course release.
  2. Pass knowledge checksMeet each assessment’s published passing score. Attempt limits and retry guidance are shown before starting.
  3. Demonstrate practical skillsSubmit required assignments using safe, non-confidential evidence and receive instructor approval.
  4. Pass the final projectComplete the course-specific project and satisfy its published marking rubric. Revise and resubmit when requested.
  5. Unlock the certificateThe certificate becomes eligible only after every required lesson, assessment, assignment approval, and final-project requirement is verified.
How grading decisions are made
  • Courses use mastery-based completion rather than an averaged GPA or assignment-category percentage.
  • Practice activities help learners improve and do not reduce a course grade.
  • The rubric displayed with the active assignment in My Learning is authoritative.
  • Accuracy, safety, privacy, accessibility, or ethical failures may require revision even when other work is strong.
  • Instructor feedback and earlier submissions remain visible when work is revised and resubmitted.

Published assessment requirements: Spreadsheet foundations knowledge check: 75% passing score, up to 3 attempts · Calculate and analyze knowledge check: 75% passing score, up to 3 attempts · Communicate with data knowledge check: 75% passing score, up to 3 attempts

Ready to begin?

Study at your pace and keep access to your learning record and feedback.

Microsoft Excel