D100 teaches the practical spreadsheet skills business students use in almost every later course: formulas, functions, tables and charts that turn raw data into decisions.
WGU's B.S. Information Technology Management program guide describes the course as helping students become proficient in using spreadsheets to analyze business problems.
Students demonstrate competency in spreadsheet development and analysis for business applications, using essential functions, formulas, tables and charts. The guide lists it at 1 competency unit with no prerequisites.
The course is short, but it rewards hands-on practice. Most mistakes come from small details: a missing dollar sign in a reference, or a chart that hides the point it should show.
Course at a Glance
| Item | Details |
|---|---|
| University | Western Governors University (WGU) |
| Code | D100 |
| Level | Undergraduate |
| Competency units | 1 (B.S. IT Management program guide) |
| Prerequisites | None listed |
| Typical work | Hands-on spreadsheet tasks (check your course page for the assessment format) |
What D100 Covers
| Competency (summarized) | Skills involved |
|---|---|
| Apply formulas and functions to aggregate and summarize data | SUM, AVERAGE, COUNTIF, SUMIF, IF, lookups |
| Create charts and graphs for professional use | Choosing and formatting the right chart type |
| Create formatted spreadsheets that organize and present data | Number formats, layout, headers, consistency |
| Create tables to summarize and analyze data for decisions | Excel tables, sorting, filtering, PivotTables |
Key Concepts Explained
Relative and Absolute References
A relative reference such as A2 changes when copied; an absolute reference such as $B$1 stays fixed. Mixing them up is the most common spreadsheet error.
Example: Sales amounts are in A2:A20 and a commission rate of 6% is in B1. In B2 type =A2*$B$1 and copy down. Each row multiplies its own sale by the same fixed rate. Without the dollar signs, the copied formula would point at B2, B3 and so on, returning wrong results.
Conditional Functions
IF returns one value when a condition is true and another when false. COUNTIF and SUMIF count or add only rows that meet a condition; COUNTIFS and SUMIFS handle several conditions.
Example: With regions in column B and sales in column C, =SUMIF(B2:B200,"West",C2:C200) totals West sales. =IF(C2>=5000,"Target met","Below target") labels each row.
Lookups
VLOOKUP, and its more flexible successor XLOOKUP where available, find a value in one table and return related information, such as a product price from a product code.
PivotTables
A PivotTable summarizes large datasets in seconds: total sales by region and month, for example, without writing a single formula.
Choosing the Right Chart
| Purpose | Chart |
|---|---|
| Compare categories | Column or bar |
| Show change over time | Line |
| Show parts of a whole (few parts) | Pie or stacked bar |
| Show a relationship | Scatter |
Professional charts have a clear title, labeled axes, sensible scales and no clutter. A title that states the finding, such as "West region sales grew fastest in Q3", is more useful than "Sales chart".
Typical Tasks and How to Approach Them
| Task type | What it tests | How to approach it |
|---|---|---|
| Formula building | Correct functions and references | Test each formula on one row before copying |
| Data summary | Tables and PivotTables | Convert data to a table first so ranges update |
| Chart creation | Choosing and formatting visuals | Pick the chart by purpose, then label clearly |
| Formatting | Professional presentation | Consistent fonts, number formats and alignment |
Preparing Data Before You Analyze It
Summaries are only as good as the data behind them. Before building formulas, check a dataset for common problems:
- Extra spaces and inconsistent spellings ("West", "west ", "W.").
- Numbers stored as text, which SUM ignores.
- Blank rows that break tables and filters.
- Duplicate records.
TRIM removes extra spaces, Remove Duplicates handles repeated rows, and Text to Columns splits combined fields. Converting the range to an Excel table then keeps formulas and charts up to date as data is added.
Where Students Get Stuck
- Hard-coded numbers. Type inputs once in cells and reference them.
- Lookup errors. #N/A often means extra spaces or the wrong match type.
- Wrong chart type. Pie charts with many slices are hard to read.
- Inconsistent formats. Mixed decimal places and currency symbols look unprofessional.
Study Tips for D100
- Practice every day for short periods with a small sample dataset.
- Learn keyboard shortcuts for copying, filling and switching references (F4).
- Use Excel's Formulas tab to trace precedents when a result looks wrong.
- Rebuild a worked example from scratch without looking.
How We Help with D100
Send the task instructions and your workbook. A spreadsheet tutor can explain formulas, build worked examples on similar data or review your file for errors and presentation.
GradeEssays is independent of Western Governors University. We provide tutoring and model files for practice only; we never complete assessments or access your course account. Every order is written from scratch, includes free revisions within the scope of your original request and is refunded in full if it is late.
Get Confident with Spreadsheets
Share your workbook and task. We prepare worked examples that explain every formula step by step.
Start My Spreadsheet HelpFree revisions · Full refund if late · Written from scratch for your order
Frequently Asked Questions
Formulas and functions to summarize data, charts and graphs, formatted spreadsheets and tables for analysis and decisions.
WGU's B.S. IT Management program guide states that it has none.
The program guide we checked lists it at 1 competency unit, so it is a short course.
No. D388, Fundamentals of Spreadsheets and Data Presentations, is a separate course that also covers presenting data. Check which one your degree plan lists.
WGU's related spreadsheet course descriptions refer to Microsoft Excel. Check your course page for the version required.
Yes. Send the file and we explain each error and the correct approach.