Excel Formulas and Practical Spreadsheet

Skills
Original educational reference document • General informational use

Introduction
Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes.

Original educational guide | Page 1

1. Spreadsheet Foundations
Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A useful way to apply this concept is to begin with a clearly stated objective.
Write down the question before selecting a tool or method. Next identify the inputs, assumptions,
constraints, and expected output. This prevents the common mistake of collecting large amounts of
information without knowing what decision the information is supposed to support. In this section, the key
practical question is how the principle can be translated into a repeatable workflow. Step 1 is to define the
relevant evidence and check it against the intended outcome. The goal is a process that can be reviewed,
repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Quality control should be built into the process rather than added at the end.
Check source information, units, dates, naming conventions, missing values, and unusual observations. If
an unexpected result appears, investigate the input and method before accepting the result. Keep notes
about important changes so another person can understand how the final output was produced. In this
section, the key practical question is how the principle can be translated into a repeatable workflow. Step 2
is to define the relevant evidence and check it against the intended outcome. The goal is a process that
can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A practical workflow also benefits from iteration. Start with a small example,
evaluate what works, correct obvious problems, and then expand. This approach reduces the cost of
mistakes. When the work becomes repetitive, document the steps and consider a reusable template,
checklist, script, or standard operating procedure. In this section, the key practical question is how the
principle can be translated into a repeatable workflow. Step 3 is to define the relevant evidence and check
it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Communication is part of technical quality. A result that is accurate but
impossible for another person to interpret is difficult to use. Present the main finding first, explain the
evidence behind it, define specialized terms, and clearly distinguish measured information from
assumptions or estimates. In this section, the key practical question is how the principle can be translated

Original educational guide | Page 2

into a repeatable workflow. Step 4 is to define the relevant evidence and check it against the intended
outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Finally, review limitations. Every method has situations where it performs
poorly. State what the approach can answer, what it cannot answer, and what additional evidence would
increase confidence. This habit is useful in business, science, finance, education, and software because it
reduces overconfidence and improves decisions. In this section, the key practical question is how the
principle can be translated into a repeatable workflow. Step 5 is to define the relevant evidence and check
it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A useful way to apply this concept is to begin with a clearly stated objective.
Write down the question before selecting a tool or method. Next identify the inputs, assumptions,
constraints, and expected output. This prevents the common mistake of collecting large amounts of
information without knowing what decision the information is supposed to support. In this section, the key
practical question is how the principle can be translated into a repeatable workflow. Step 6 is to define the
relevant evidence and check it against the intended outcome. The goal is a process that can be reviewed,
repeated, and improved.

Original educational guide | Page 3

2. Essential Calculation Formulas
Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Quality control should be built into the process rather than added at the end.
Check source information, units, dates, naming conventions, missing values, and unusual observations. If
an unexpected result appears, investigate the input and method before accepting the result. Keep notes
about important changes so another person can understand how the final output was produced. In this
section, the key practical question is how the principle can be translated into a repeatable workflow. Step 1
is to define the relevant evidence and check it against the intended outcome. The goal is a process that
can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A practical workflow also benefits from iteration. Start with a small example,
evaluate what works, correct obvious problems, and then expand. This approach reduces the cost of
mistakes. When the work becomes repetitive, document the steps and consider a reusable template,
checklist, script, or standard operating procedure. In this section, the key practical question is how the
principle can be translated into a repeatable workflow. Step 2 is to define the relevant evidence and check
it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Communication is part of technical quality. A result that is accurate but
impossible for another person to interpret is difficult to use. Present the main finding first, explain the
evidence behind it, define specialized terms, and clearly distinguish measured information from
assumptions or estimates. In this section, the key practical question is how the principle can be translated
into a repeatable workflow. Step 3 is to define the relevant evidence and check it against the intended
outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Finally, review limitations. Every method has situations where it performs
poorly. State what the approach can answer, what it cannot answer, and what additional evidence would
increase confidence. This habit is useful in business, science, finance, education, and software because it
reduces overconfidence and improves decisions. In this section, the key practical question is how the
principle can be translated into a repeatable workflow. Step 4 is to define the relevant evidence and check

Original educational guide | Page 4

it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A useful way to apply this concept is to begin with a clearly stated objective.
Write down the question before selecting a tool or method. Next identify the inputs, assumptions,
constraints, and expected output. This prevents the common mistake of collecting large amounts of
information without knowing what decision the information is supposed to support. In this section, the key
practical question is how the principle can be translated into a repeatable workflow. Step 5 is to define the
relevant evidence and check it against the intended outcome. The goal is a process that can be reviewed,
repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Quality control should be built into the process rather than added at the end.
Check source information, units, dates, naming conventions, missing values, and unusual observations. If
an unexpected result appears, investigate the input and method before accepting the result. Keep notes
about important changes so another person can understand how the final output was produced. In this
section, the key practical question is how the principle can be translated into a repeatable workflow. Step 6
is to define the relevant evidence and check it against the intended outcome. The goal is a process that
can be reviewed, repeated, and improved.

Original educational guide | Page 5

3. Logical and Conditional Formulas
Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A practical workflow also benefits from iteration. Start with a small example,
evaluate what works, correct obvious problems, and then expand. This approach reduces the cost of
mistakes. When the work becomes repetitive, document the steps and consider a reusable template,
checklist, script, or standard operating procedure. In this section, the key practical question is how the
principle can be translated into a repeatable workflow. Step 1 is to define the relevant evidence and check
it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Communication is part of technical quality. A result that is accurate but
impossible for another person to interpret is difficult to use. Present the main finding first, explain the
evidence behind it, define specialized terms, and clearly distinguish measured information from
assumptions or estimates. In this section, the key practical question is how the principle can be translated
into a repeatable workflow. Step 2 is to define the relevant evidence and check it against the intended
outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Finally, review limitations. Every method has situations where it performs
poorly. State what the approach can answer, what it cannot answer, and what additional evidence would
increase confidence. This habit is useful in business, science, finance, education, and software because it
reduces overconfidence and improves decisions. In this section, the key practical question is how the
principle can be translated into a repeatable workflow. Step 3 is to define the relevant evidence and check
it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A useful way to apply this concept is to begin with a clearly stated objective.
Write down the question before selecting a tool or method. Next identify the inputs, assumptions,
constraints, and expected output. This prevents the common mistake of collecting large amounts of
information without knowing what decision the information is supposed to support. In this section, the key
practical question is how the principle can be translated into a repeatable workflow. Step 4 is to define the
relevant evidence and check it against the intended outcome. The goal is a process that can be reviewed,

Original educational guide | Page 6

repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Quality control should be built into the process rather than added at the end.
Check source information, units, dates, naming conventions, missing values, and unusual observations. If
an unexpected result appears, investigate the input and method before accepting the result. Keep notes
about important changes so another person can understand how the final output was produced. In this
section, the key practical question is how the principle can be translated into a repeatable workflow. Step 5
is to define the relevant evidence and check it against the intended outcome. The goal is a process that
can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A practical workflow also benefits from iteration. Start with a small example,
evaluate what works, correct obvious problems, and then expand. This approach reduces the cost of
mistakes. When the work becomes repetitive, document the steps and consider a reusable template,
checklist, script, or standard operating procedure. In this section, the key practical question is how the
principle can be translated into a repeatable workflow. Step 6 is to define the relevant evidence and check
it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Original educational guide | Page 7

4. Lookup and Reference Tools
Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Communication is part of technical quality. A result that is accurate but
impossible for another person to interpret is difficult to use. Present the main finding first, explain the
evidence behind it, define specialized terms, and clearly distinguish measured information from
assumptions or estimates. In this section, the key practical question is how the principle can be translated
into a repeatable workflow. Step 1 is to define the relevant evidence and check it against the intended
outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Finally, review limitations. Every method has situations where it performs
poorly. State what the approach can answer, what it cannot answer, and what additional evidence would
increase confidence. This habit is useful in business, science, finance, education, and software because it
reduces overconfidence and improves decisions. In this section, the key practical question is how the
principle can be translated into a repeatable workflow. Step 2 is to define the relevant evidence and check
it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A useful way to apply this concept is to begin with a clearly stated objective.
Write down the question before selecting a tool or method. Next identify the inputs, assumptions,
constraints, and expected output. This prevents the common mistake of collecting large amounts of
information without knowing what decision the information is supposed to support. In this section, the key
practical question is how the principle can be translated into a repeatable workflow. Step 3 is to define the
relevant evidence and check it against the intended outcome. The goal is a process that can be reviewed,
repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Quality control should be built into the process rather than added at the end.
Check source information, units, dates, naming conventions, missing values, and unusual observations. If
an unexpected result appears, investigate the input and method before accepting the result. Keep notes
about important changes so another person can understand how the final output was produced. In this
section, the key practical question is how the principle can be translated into a repeatable workflow. Step 4

Original educational guide | Page 8

is to define the relevant evidence and check it against the intended outcome. The goal is a process that
can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A practical workflow also benefits from iteration. Start with a small example,
evaluate what works, correct obvious problems, and then expand. This approach reduces the cost of
mistakes. When the work becomes repetitive, document the steps and consider a reusable template,
checklist, script, or standard operating procedure. In this section, the key practical question is how the
principle can be translated into a repeatable workflow. Step 5 is to define the relevant evidence and check
it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Communication is part of technical quality. A result that is accurate but
impossible for another person to interpret is difficult to use. Present the main finding first, explain the
evidence behind it, define specialized terms, and clearly distinguish measured information from
assumptions or estimates. In this section, the key practical question is how the principle can be translated
into a repeatable workflow. Step 6 is to define the relevant evidence and check it against the intended
outcome. The goal is a process that can be reviewed, repeated, and improved.

Original educational guide | Page 9

5. Text and Date Functions
Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Finally, review limitations. Every method has situations where it performs
poorly. State what the approach can answer, what it cannot answer, and what additional evidence would
increase confidence. This habit is useful in business, science, finance, education, and software because it
reduces overconfidence and improves decisions. In this section, the key practical question is how the
principle can be translated into a repeatable workflow. Step 1 is to define the relevant evidence and check
it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A useful way to apply this concept is to begin with a clearly stated objective.
Write down the question before selecting a tool or method. Next identify the inputs, assumptions,
constraints, and expected output. This prevents the common mistake of collecting large amounts of
information without knowing what decision the information is supposed to support. In this section, the key
practical question is how the principle can be translated into a repeatable workflow. Step 2 is to define the
relevant evidence and check it against the intended outcome. The goal is a process that can be reviewed,
repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Quality control should be built into the process rather than added at the end.
Check source information, units, dates, naming conventions, missing values, and unusual observations. If
an unexpected result appears, investigate the input and method before accepting the result. Keep notes
about important changes so another person can understand how the final output was produced. In this
section, the key practical question is how the principle can be translated into a repeatable workflow. Step 3
is to define the relevant evidence and check it against the intended outcome. The goal is a process that
can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A practical workflow also benefits from iteration. Start with a small example,
evaluate what works, correct obvious problems, and then expand. This approach reduces the cost of
mistakes. When the work becomes repetitive, document the steps and consider a reusable template,
checklist, script, or standard operating procedure. In this section, the key practical question is how the

Original educational guide | Page 10

principle can be translated into a repeatable workflow. Step 4 is to define the relevant evidence and check
it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Communication is part of technical quality. A result that is accurate but
impossible for another person to interpret is difficult to use. Present the main finding first, explain the
evidence behind it, define specialized terms, and clearly distinguish measured information from
assumptions or estimates. In this section, the key practical question is how the principle can be translated
into a repeatable workflow. Step 5 is to define the relevant evidence and check it against the intended
outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Finally, review limitations. Every method has situations where it performs
poorly. State what the approach can answer, what it cannot answer, and what additional evidence would
increase confidence. This habit is useful in business, science, finance, education, and software because it
reduces overconfidence and improves decisions. In this section, the key practical question is how the
principle can be translated into a repeatable workflow. Step 6 is to define the relevant evidence and check
it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Original educational guide | Page 11

6. Data Cleaning and Organization
Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A useful way to apply this concept is to begin with a clearly stated objective.
Write down the question before selecting a tool or method. Next identify the inputs, assumptions,
constraints, and expected output. This prevents the common mistake of collecting large amounts of
information without knowing what decision the information is supposed to support. In this section, the key
practical question is how the principle can be translated into a repeatable workflow. Step 1 is to define the
relevant evidence and check it against the intended outcome. The goal is a process that can be reviewed,
repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Quality control should be built into the process rather than added at the end.
Check source information, units, dates, naming conventions, missing values, and unusual observations. If
an unexpected result appears, investigate the input and method before accepting the result. Keep notes
about important changes so another person can understand how the final output was produced. In this
section, the key practical question is how the principle can be translated into a repeatable workflow. Step 2
is to define the relevant evidence and check it against the intended outcome. The goal is a process that
can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A practical workflow also benefits from iteration. Start with a small example,
evaluate what works, correct obvious problems, and then expand. This approach reduces the cost of
mistakes. When the work becomes repetitive, document the steps and consider a reusable template,
checklist, script, or standard operating procedure. In this section, the key practical question is how the
principle can be translated into a repeatable workflow. Step 3 is to define the relevant evidence and check
it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Communication is part of technical quality. A result that is accurate but
impossible for another person to interpret is difficult to use. Present the main finding first, explain the
evidence behind it, define specialized terms, and clearly distinguish measured information from
assumptions or estimates. In this section, the key practical question is how the principle can be translated

Original educational guide | Page 12

into a repeatable workflow. Step 4 is to define the relevant evidence and check it against the intended
outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Finally, review limitations. Every method has situations where it performs
poorly. State what the approach can answer, what it cannot answer, and what additional evidence would
increase confidence. This habit is useful in business, science, finance, education, and software because it
reduces overconfidence and improves decisions. In this section, the key practical question is how the
principle can be translated into a repeatable workflow. Step 5 is to define the relevant evidence and check
it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A useful way to apply this concept is to begin with a clearly stated objective.
Write down the question before selecting a tool or method. Next identify the inputs, assumptions,
constraints, and expected output. This prevents the common mistake of collecting large amounts of
information without knowing what decision the information is supposed to support. In this section, the key
practical question is how the principle can be translated into a repeatable workflow. Step 6 is to define the
relevant evidence and check it against the intended outcome. The goal is a process that can be reviewed,
repeated, and improved.

Original educational guide | Page 13

7. Charts and Reporting
Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Quality control should be built into the process rather than added at the end.
Check source information, units, dates, naming conventions, missing values, and unusual observations. If
an unexpected result appears, investigate the input and method before accepting the result. Keep notes
about important changes so another person can understand how the final output was produced. In this
section, the key practical question is how the principle can be translated into a repeatable workflow. Step 1
is to define the relevant evidence and check it against the intended outcome. The goal is a process that
can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A practical workflow also benefits from iteration. Start with a small example,
evaluate what works, correct obvious problems, and then expand. This approach reduces the cost of
mistakes. When the work becomes repetitive, document the steps and consider a reusable template,
checklist, script, or standard operating procedure. In this section, the key practical question is how the
principle can be translated into a repeatable workflow. Step 2 is to define the relevant evidence and check
it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Communication is part of technical quality. A result that is accurate but
impossible for another person to interpret is difficult to use. Present the main finding first, explain the
evidence behind it, define specialized terms, and clearly distinguish measured information from
assumptions or estimates. In this section, the key practical question is how the principle can be translated
into a repeatable workflow. Step 3 is to define the relevant evidence and check it against the intended
outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Finally, review limitations. Every method has situations where it performs
poorly. State what the approach can answer, what it cannot answer, and what additional evidence would
increase confidence. This habit is useful in business, science, finance, education, and software because it
reduces overconfidence and improves decisions. In this section, the key practical question is how the
principle can be translated into a repeatable workflow. Step 4 is to define the relevant evidence and check

Original educational guide | Page 14

it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A useful way to apply this concept is to begin with a clearly stated objective.
Write down the question before selecting a tool or method. Next identify the inputs, assumptions,
constraints, and expected output. This prevents the common mistake of collecting large amounts of
information without knowing what decision the information is supposed to support. In this section, the key
practical question is how the principle can be translated into a repeatable workflow. Step 5 is to define the
relevant evidence and check it against the intended outcome. The goal is a process that can be reviewed,
repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Quality control should be built into the process rather than added at the end.
Check source information, units, dates, naming conventions, missing values, and unusual observations. If
an unexpected result appears, investigate the input and method before accepting the result. Keep notes
about important changes so another person can understand how the final output was produced. In this
section, the key practical question is how the principle can be translated into a repeatable workflow. Step 6
is to define the relevant evidence and check it against the intended outcome. The goal is a process that
can be reviewed, repeated, and improved.

Original educational guide | Page 15

8. Practical Mini Project
Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A practical workflow also benefits from iteration. Start with a small example,
evaluate what works, correct obvious problems, and then expand. This approach reduces the cost of
mistakes. When the work becomes repetitive, document the steps and consider a reusable template,
checklist, script, or standard operating procedure. In this section, the key practical question is how the
principle can be translated into a repeatable workflow. Step 1 is to define the relevant evidence and check
it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Communication is part of technical quality. A result that is accurate but
impossible for another person to interpret is difficult to use. Present the main finding first, explain the
evidence behind it, define specialized terms, and clearly distinguish measured information from
assumptions or estimates. In this section, the key practical question is how the principle can be translated
into a repeatable workflow. Step 2 is to define the relevant evidence and check it against the intended
outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Finally, review limitations. Every method has situations where it performs
poorly. State what the approach can answer, what it cannot answer, and what additional evidence would
increase confidence. This habit is useful in business, science, finance, education, and software because it
reduces overconfidence and improves decisions. In this section, the key practical question is how the
principle can be translated into a repeatable workflow. Step 3 is to define the relevant evidence and check
it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A useful way to apply this concept is to begin with a clearly stated objective.
Write down the question before selecting a tool or method. Next identify the inputs, assumptions,
constraints, and expected output. This prevents the common mistake of collecting large amounts of
information without knowing what decision the information is supposed to support. In this section, the key
practical question is how the principle can be translated into a repeatable workflow. Step 4 is to define the
relevant evidence and check it against the intended outcome. The goal is a process that can be reviewed,

Original educational guide | Page 16

repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Quality control should be built into the process rather than added at the end.
Check source information, units, dates, naming conventions, missing values, and unusual observations. If
an unexpected result appears, investigate the input and method before accepting the result. Keep notes
about important changes so another person can understand how the final output was produced. In this
section, the key practical question is how the principle can be translated into a repeatable workflow. Step 5
is to define the relevant evidence and check it against the intended outcome. The goal is a process that
can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A practical workflow also benefits from iteration. Start with a small example,
evaluate what works, correct obvious problems, and then expand. This approach reduces the cost of
mistakes. When the work becomes repetitive, document the steps and consider a reusable template,
checklist, script, or standard operating procedure. In this section, the key practical question is how the
principle can be translated into a repeatable workflow. Step 6 is to define the relevant evidence and check
it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Original educational guide | Page 17

9. Common Errors and Troubleshooting
Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Communication is part of technical quality. A result that is accurate but
impossible for another person to interpret is difficult to use. Present the main finding first, explain the
evidence behind it, define specialized terms, and clearly distinguish measured information from
assumptions or estimates. In this section, the key practical question is how the principle can be translated
into a repeatable workflow. Step 1 is to define the relevant evidence and check it against the intended
outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Finally, review limitations. Every method has situations where it performs
poorly. State what the approach can answer, what it cannot answer, and what additional evidence would
increase confidence. This habit is useful in business, science, finance, education, and software because it
reduces overconfidence and improves decisions. In this section, the key practical question is how the
principle can be translated into a repeatable workflow. Step 2 is to define the relevant evidence and check
it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A useful way to apply this concept is to begin with a clearly stated objective.
Write down the question before selecting a tool or method. Next identify the inputs, assumptions,
constraints, and expected output. This prevents the common mistake of collecting large amounts of
information without knowing what decision the information is supposed to support. In this section, the key
practical question is how the principle can be translated into a repeatable workflow. Step 3 is to define the
relevant evidence and check it against the intended outcome. The goal is a process that can be reviewed,
repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Quality control should be built into the process rather than added at the end.
Check source information, units, dates, naming conventions, missing values, and unusual observations. If
an unexpected result appears, investigate the input and method before accepting the result. Keep notes
about important changes so another person can understand how the final output was produced. In this
section, the key practical question is how the principle can be translated into a repeatable workflow. Step 4

Original educational guide | Page 18

is to define the relevant evidence and check it against the intended outcome. The goal is a process that
can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A practical workflow also benefits from iteration. Start with a small example,
evaluate what works, correct obvious problems, and then expand. This approach reduces the cost of
mistakes. When the work becomes repetitive, document the steps and consider a reusable template,
checklist, script, or standard operating procedure. In this section, the key practical question is how the
principle can be translated into a repeatable workflow. Step 5 is to define the relevant evidence and check
it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Communication is part of technical quality. A result that is accurate but
impossible for another person to interpret is difficult to use. Present the main finding first, explain the
evidence behind it, define specialized terms, and clearly distinguish measured information from
assumptions or estimates. In this section, the key practical question is how the principle can be translated
into a repeatable workflow. Step 6 is to define the relevant evidence and check it against the intended
outcome. The goal is a process that can be reviewed, repeated, and improved.

Original educational guide | Page 19

10. Quick Reference Checklist
Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Finally, review limitations. Every method has situations where it performs
poorly. State what the approach can answer, what it cannot answer, and what additional evidence would
increase confidence. This habit is useful in business, science, finance, education, and software because it
reduces overconfidence and improves decisions. In this section, the key practical question is how the
principle can be translated into a repeatable workflow. Step 1 is to define the relevant evidence and check
it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A useful way to apply this concept is to begin with a clearly stated objective.
Write down the question before selecting a tool or method. Next identify the inputs, assumptions,
constraints, and expected output. This prevents the common mistake of collecting large amounts of
information without knowing what decision the information is supposed to support. In this section, the key
practical question is how the principle can be translated into a repeatable workflow. Step 2 is to define the
relevant evidence and check it against the intended outcome. The goal is a process that can be reviewed,
repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Quality control should be built into the process rather than added at the end.
Check source information, units, dates, naming conventions, missing values, and unusual observations. If
an unexpected result appears, investigate the input and method before accepting the result. Keep notes
about important changes so another person can understand how the final output was produced. In this
section, the key practical question is how the principle can be translated into a repeatable workflow. Step 3
is to define the relevant evidence and check it against the intended outcome. The goal is a process that
can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. A practical workflow also benefits from iteration. Start with a small example,
evaluate what works, correct obvious problems, and then expand. This approach reduces the cost of
mistakes. When the work becomes repetitive, document the steps and consider a reusable template,
checklist, script, or standard operating procedure. In this section, the key practical question is how the

Original educational guide | Page 20

principle can be translated into a repeatable workflow. Step 4 is to define the relevant evidence and check
it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Communication is part of technical quality. A result that is accurate but
impossible for another person to interpret is difficult to use. Present the main finding first, explain the
evidence behind it, define specialized terms, and clearly distinguish measured information from
assumptions or estimates. In this section, the key practical question is how the principle can be translated
into a repeatable workflow. Step 5 is to define the relevant evidence and check it against the intended
outcome. The goal is a process that can be reviewed, repeated, and improved.

Excel is most useful when a workbook is treated as a small information system. Good spreadsheets
separate raw data, calculations, assumptions, and presentation. Use one record per row, one variable per
column, clear headings, consistent formats, and documented assumptions. SUM, AVERAGE, MIN, MAX,
COUNT, COUNTIF, SUMIF, IF, XLOOKUP, INDEX, MATCH, text functions, and date functions cover a
large share of everyday analysis. Always test formulas with small examples before applying them to a large
dataset. Check for text stored as numbers, duplicate identifiers, missing values, inconsistent dates, and
accidental range changes. Finally, review limitations. Every method has situations where it performs
poorly. State what the approach can answer, what it cannot answer, and what additional evidence would
increase confidence. This habit is useful in business, science, finance, education, and software because it
reduces overconfidence and improves decisions. In this section, the key practical question is how the
principle can be translated into a repeatable workflow. Step 6 is to define the relevant evidence and check
it against the intended outcome. The goal is a process that can be reviewed, repeated, and improved.

Original educational guide | Page 21

Quick Reference and Conclusion
Checklist 1: define the objective; verify the inputs; record assumptions; apply the appropriate method;
review the output; identify limitations; document the next action.

Checklist 2: define the objective; verify the inputs; record assumptions; apply the appropriate method;
review the output; identify limitations; document the next action.

Checklist 3: define the objective; verify the inputs; record assumptions; apply the appropriate method;
review the output; identify limitations; document the next action.

Checklist 4: define the objective; verify the inputs; record assumptions; apply the appropriate method;
review the output; identify limitations; document the next action.

Checklist 5: define the objective; verify the inputs; record assumptions; apply the appropriate method;
review the output; identify limitations; document the next action.

Checklist 6: define the objective; verify the inputs; record assumptions; apply the appropriate method;
review the output; identify limitations; document the next action.

Checklist 7: define the objective; verify the inputs; record assumptions; apply the appropriate method;
review the output; identify limitations; document the next action.

Checklist 8: define the objective; verify the inputs; record assumptions; apply the appropriate method;
review the output; identify limitations; document the next action.

Checklist 9: define the objective; verify the inputs; record assumptions; apply the appropriate method;
review the output; identify limitations; document the next action.

Checklist 10: define the objective; verify the inputs; record assumptions; apply the appropriate method;
review the output; identify limitations; document the next action.

Checklist 11: define the objective; verify the inputs; record assumptions; apply the appropriate method;
review the output; identify limitations; document the next action.

Checklist 12: define the objective; verify the inputs; record assumptions; apply the appropriate method;
review the output; identify limitations; document the next action.

Checklist 13: define the objective; verify the inputs; record assumptions; apply the appropriate method;
review the output; identify limitations; document the next action.

Checklist 14: define the objective; verify the inputs; record assumptions; apply the appropriate method;
review the output; identify limitations; document the next action.

Original educational guide | Page 22