Skip to main content
  • Pricing
Tutorials

WGU D388 Fundamentals of Spreadsheets and Data Presentation: an Excel study guide

By Oakgen TeamPublished 3 min read

Share
WGU D388 Fundamentals of Spreadsheets and Data Presentation: an Excel study guide

The WGU spreadsheets course is built around three competencies: common spreadsheet tasks (formatting, formulas, functions), preparing data for analysis, and presenting data with tables, PivotTables and charts. The best preparation is to practise exactly those skills on a small dataset until each one feels routine. The syllabus says mastery is shown through an objective assessment of those competencies.

What the syllabus says

The version of the syllabus that could be read is the WGU Academy course syllabus for D388A. If you are enrolled in a WGU degree program, your own course page is the authority, and details such as assessment format can differ.

The syllabus calls the course an Excel training course in three sections. Its outline lists what you should be able to do after each:

ModuleAbilities listed in the syllabus
Performs common spreadsheet tasksDescribe spreadsheet use in business, identify components, sort and filter, create a basic functional spreadsheet, apply calculations and functions
Prepares data for analyticsClean data, organize data, review a dataset for accuracy, determine the relevance of a dataset
Creates presentations from spreadsheet datasetsCreate tables, create PivotTables, create data visualizations, choose an appropriate graph or chart

There is no prerequisite. Competence is shown through an objective assessment, and you must be ranked Competent to pass. The syllabus also says to expect proctoring for at least one test.

Module 1: formulas and references

Microsoft's formula overview explains the three kinds of cell reference, which are the most common source of broken spreadsheets:

  • Relative (A1): adjusts when you copy or fill the formula. Copying =A1 from B2 to B3 gives =A2.
  • Absolute ($A$1): always points to one location. Copied from B2 to B3 it stays =$A$1.
  • Mixed ($A1 or A$1): locks either the column or the row.

A quick drill: put units in column A, price in column B, and a tax rate in cell E1. In C2 enter =A2B2(1+$E$1) and fill down. With 10 units at 4.50 and a rate of 0.08, the result is 10 x 4.50 x 1.08 = 48.60. If you forget the dollar signs, the tax reference slides down to E2, E3 and returns wrong or empty results, which is exactly the mistake the exercise is meant to show.

Module 2: preparing data

The syllabus names cleaning, organizing, reviewing for accuracy and judging relevance. Microsoft's PivotTable guidance gives a practical checklist for source data: organize it in columns with a single header row, give every column a unique non-blank label, avoid blank rows or columns, and keep the same data type in each column. Run through that checklist on any dataset before you analyze it. Sorting and filtering are the quickest ways to spot blanks, duplicates and values that do not belong.

For lookups, Microsoft says XLOOKUP searches a range and returns the matching item from another range, defaults to an exact match, and returns #N/A if nothing matches unless you supply an if-not-found value. It is not available in Excel 2016 or Excel 2019, so older workbooks may use VLOOKUP instead. Whether the course requires a particular lookup function is something to confirm in your course materials.

Module 3: PivotTables and charts

To build a PivotTable, Microsoft says to select your data, choose Insert > PivotTable, pick where to place it and select OK. Fields you tick are placed by default: non-numeric fields go to Rows, date and time hierarchies to Columns and numeric fields to Values. A numeric field in Values is summed by default; if Excel reads the data as text it counts instead. Right-click the PivotTable and choose Refresh after the source data changes.

For charts, the steps are to select the data, choose Insert > Recommended Charts, preview and click OK. Pressing Alt+F1 creates a chart immediately, though Microsoft warns it may not be the best chart for the data. Microsoft's chart-type guidance, useful for the "choose an appropriate chart" objective, says:

  • Column charts compare items across categories.
  • Line charts show trends over evenly spaced intervals such as months.
  • Pie charts suit one data series with no more than seven categories and no negative values.
  • Bar charts work when labels are long.
  • Scatter charts plot numeric x-y pairs.

A one-week practice plan

  1. Day 1: build a small sales table, then sort and filter it.
  2. Day 2: write formulas using relative, absolute and mixed references.
  3. Day 3: clean a messy copy: remove blanks, standardize data types, check for duplicates.
  4. Day 4: build a PivotTable that totals sales by region and by month.
  5. Day 5: turn the PivotTable into the right chart and justify the chart type in one sentence.
  6. Day 6: repeat days 2 to 5 without notes.
  7. Day 7: take the course's practice quizzes, if your course provides them. The syllabus says lessons include practice quizzes.

Take this further with Oakgen Agent

Write the plan and practice questions, create a downloadable csv or xlsx sample dataset and explain each answer.

Looking for a recap of one specific YouTube video? The YouTube Summarizer does that today.

Open this task in Oakgen Agent

The prompt is filled in for you. Nothing is sent until you press send.

Open in Oakgen Agent

Frequently asked questions

What competencies does the course cover?

The WGU course syllabus lists three: the learner performs common spreadsheet tasks requiring basic formatting, formulas and functions; the learner prepares data for analysis; and the learner creates a presentation from a spreadsheet dataset. It describes the course as an Excel training course that moves from the basics to PivotTables, charts and graphs.

How is the course assessed?

The syllabus lists one final exam and three competency units. You must reach a ranking of Competent on each assessment to pass, and you may attempt the assessment two times before additional support is necessary. It also says the course includes at least one proctored test, which needs a microphone, speakers and an external webcam, plus the Guardian browser.

Do I need Excel installed?

The syllabus says you will use Microsoft Excel Online to complete the course activities, which requires an internet connection and a Microsoft account. It also says you need the MyEducator Add-in installed in Excel and points to a Device Setup module for set-up steps.

What is the difference between VLOOKUP and XLOOKUP?

Microsoft's documentation says XLOOKUP uses a lookup array and a return array, whereas VLOOKUP uses a single table array followed by a column index number. XLOOKUP returns an exact match by default and is not available in Excel 2016 and Excel 2019. Microsoft's example pairs =XLOOKUP(F2,B2:B11,D2:D11) with the VLOOKUP equivalent =VLOOKUP(F2,B2:D11,3,FALSE).

Sources

  1. WGU Academy, Fundamentals of Spreadsheets and Data Presentations (D388A) Course Syllabus (read 2026-11-19)
  2. Microsoft Support, Overview of formulas in Excel (read 2026-11-19)
  3. Microsoft Support, XLOOKUP function (read 2026-11-19)
  4. Microsoft Support, Create a PivotTable to analyze worksheet data (read 2026-11-19)
  5. Microsoft Support, Create a chart from start to finish (read 2026-11-19)
Share