WGU D100: Introduction to Spreadsheets

Why D100 Shows Up Early in So Many WGU Business Degree Plans

Introduction to Spreadsheets (D100) is the course where WGU makes sure you can actually drive a spreadsheet before a later class asks you to build a budget, trace a cash flow, or defend a data analysis. It is a 1-competency-unit, lower-division School of Business course with no prerequisites, and it sits near the front of business and IT-management degree plans for exactly that reason. WGU's own framing is refreshingly plain: by the end you should be able to build spreadsheet models that report, analyze, and show what the numbers mean in charts.

Direct answer: Pass D100 by doing the work inside Excel yourself instead of watching someone else do it. Complete every practice problem and assignment in the course material until the automated grader stops correcting you, drill formulas, absolute versus relative references, tables and PivotTables until they feel automatic, then use the pre-assessment to find your weakest unit and rebuild only that before you schedule the objective assessment.

Students arrive in D100 in one of two states: you have used spreadsheets casually for years and assume you already know this, or you have avoided them entirely and are quietly dreading it. Both groups stumble in the same place. The course does not reward recognizing a feature, it rewards producing a correct result, and knowing that a PivotTable exists is not the same as building one that answers a question.

It is worth understanding the payoff, because it is unusually concrete for a foundational course. The functions you learn here reappear directly in accounting and finance coursework such as D102 Financial Accounting and D196 Principles of Financial and Managerial Accounting, and the data-shaping habits carry over into anything analytics-flavored later in your plan. Time spent genuinely learning D100 is time you do not spend fighting Excel in five other classes.

What the D100 Objective Assessment Actually Covers

The D100 courseware is delivered through MyEducator as a structured Excel training course, organized into five units plus a pre-assessment. The first unit handles orientation and getting Excel installed and configured on your machine; the assessed material begins after that. Here is how the content breaks down.

Each lesson pairs readings and lecture videos with practice problems and an assignment, and an automated grader tells you immediately whether you got it right. That feedback loop is the most valuable thing in the course, and it is wasted if you only read.

Assessment is a single proctored objective assessment. There is no performance assessment to write, which is good news if writing tasks are what usually slow you down. Published descriptions of the exam's length and question format vary, so treat your own course's assessment information page as the authority there. The in-course pre-assessment is the single most useful diagnostic tool you have. Students consistently report that the middle of the course, formulas and functions plus tables and PivotTables, is where the exam concentrates, with basics and charting rounding it out.

You will need access to Microsoft Excel to complete the course. WGU provides current students with Microsoft 365 access, but the license type has changed over the years, so check in the student portal what yours includes. Unit 1 walks you through setup either way. If you are studying through WGU Academy rather than a degree program, the equivalent course is coded D100A.

Is D100 Hard? Setting Realistic Expectations

By WGU standards, D100 is widely considered one of the gentler courses in a business plan, and many students report finishing it well ahead of the pacing schedule. That said, treat "one of the easier courses" as a description of the ceiling, not a promise about your timeline. Two things reliably stretch it out.

The first is starting from zero. If you have never written a formula, the jump from Unit 2 to Unit 3 is real, and rushing it just means you fail the pre-assessment and lose the time anyway. Budget honestly.

The second is overconfidence. Students who use spreadsheets at work often skim the material, hit the pre-assessment, and discover that their practical habits do not cover the specific behaviors the course tests, particularly around reference types and PivotTable construction. If that is you, take the pre-assessment early. It will either confirm you are ready or tell you exactly which two units to review, and both outcomes save time.

Plan on one unit per study session, with practice problems done in Excel rather than read. Do not schedule the OA until your pre-assessment comes back comfortably clear.

How to Prepare for D100 Without Wasting Evenings

The course material is unusually well suited to active practice because the built-in grader gives you immediate, specific feedback. Lean into that instead of passive review.

• Build, do not watch. Keep Excel open beside the lecture videos and reproduce every example in your own workbook as it happens. If you only watch, you will recognize the steps on the exam without being able to reproduce them.
• Rework missed practice problems from scratch. When the grader flags something, do not just fix the cell. Clear the sheet and rebuild the exercise; redoing the full path is what makes it stick.
• Drill references deliberately. Make a small grid and practice writing one formula that fills correctly across both rows and columns. Absolute, relative, and mixed references are the highest-return twenty minutes in this course.
• Space your review. Revisit Unit 3 functions two or three days after you first learn them, then again before the OA. Recalling them cold beats rereading them warm.
• Predict before you press Enter. Say aloud what a formula will return, then run it. This trains the exact skill an objective assessment measures.
• Rebuild one PivotTable from a blank workbook. Import or type a small data set, make it a table, and summarize it three different ways. If you can do that unaided, Unit 4 is handled.
• Use the pre-assessment as a map, not a verdict. Note which units your misses cluster in and study only those, then retake it.

If you find you genuinely enjoy the tables-and-PivotTables portion, that is a signal worth following; it is the same instinct rewarded in courses like D492 Data Analytics - Applications later on. You can browse related School of Business guides on our business college hub or the full guide index.

Where Students Lose Points in D100

The failure patterns in this course are remarkably consistent, and all of them are avoidable.

• Treating it as a reading course. Spreadsheet skill does not transfer from text to fingers. Every hour of reading without Excel open is an hour that has to be repeated.
• Skipping Unit 2 because it looks trivial. Formatting and worksheet structure questions are easy points, and students who skip ahead lose them.
• Fuzzy reference habits. Getting a formula right in one cell and then dragging it into nonsense is the most common single mistake in the course.
• Memorizing function names without their arguments. Knowing what a function is called does not help if you cannot say what goes in it or what it returns.
• Choosing charts by appearance. Unit 5 is about matching the chart type to what the data is meant to communicate, not about picking the one that looks nicest.
• Scheduling the OA off a borderline pre-assessment. A marginal result means one more evening of targeted review, not a booking.
• Ignoring the setup unit. Discovering an Excel installation problem the week you planned to test is an avoidable delay.

D100 Readiness Checklist

• Can you write a formula using absolute, relative, and mixed references and fill it in both directions without breaking it?
• Can you look at an unfamiliar formula and state what it will return before running it?
• Can you convert a raw data range into a structured table, then sort and filter it to answer a specific question?
• Can you build a PivotTable from scratch and change what it summarizes without starting over?
• Can you explain why one chart type suits a data set better than another, and build that chart correctly?
• Can you apply number and cell formatting so a report reads clearly to someone who did not build it?
• Have you completed every practice problem and assignment in the course, including the ones you initially missed?
• Did your most recent pre-assessment come back clearly passing rather than borderline?
• Do you have a working, tested Excel installation and a proctoring setup you have already checked?

D100 FAQ

Is D100 an OA or a PA?

D100 is assessed by a single proctored objective assessment. There is no performance assessment or written submission, so all of your preparation goes toward the exam itself.

What software do I need for D100?

You need access to Microsoft Excel. WGU provides Microsoft 365 to current students, and Unit 1 walks you through getting it installed and configured. Sort that out on day one so it never becomes a scheduling problem, and confirm in the student portal what your license includes.

How long does D100 usually take?

Many students report clearing it in one to two weeks of focused study, and those with real spreadsheet experience often move faster. Your honest starting point matters more than anyone else's timeline, so let the pre-assessment tell you when you are ready.

Do I need spreadsheet experience before starting?

No. D100 has no prerequisites and the course material starts from the basics. Complete beginners do fine here; they simply need to give Unit 3 more time than experienced users do.

What should I study if my pre-assessment score was low?

Look at where your misses cluster. In practice that is usually formulas and functions or tables and PivotTables. Rework those units' practice problems from a blank workbook rather than rereading the lessons, then retake the pre-assessment.

Is D100 the same as WGU's other spreadsheet course?

No. WGU also offers D388 Fundamentals of Spreadsheets and Data Presentations, which appears in a number of current degree plans and has its own separate courseware and assessment. Check your own degree plan for the course code you are actually assigned rather than assuming the two are interchangeable.