Please click the title of the blog post you’re interested in below to access available downloads.I hope you find these downloads useful. If you have any suggestions or feedback, please feel free to send me a message by clicking here.

Blog Post Example Downloads

P003 An Introduction to Formulas Part 1

P004 An Introduction to Formulas Part 2

P005 An Introduction to Formulas Part 3

P006 How to Use The SUMIFS Function

P007 Introduction to Conditional Formatting Part 1

P008 Introduction to Conditional Formatting Part 2

P009 Conditional Formatting Icon Sets

P012 How to Use The VLOOKUP Function

P013 Introduction to Pivot Tables Part 1

P014 Introduction to Pivot Tables Part 2

P015 Introduction to Pivot Tables Part 3

P016 How to Write Relative and Absolute Cell References

P019 How to Use the Excel Logical Functions

P020 How to Create a Named Constant

P022 How to Use INDEX MATCH to find Data

P023 Introduction to Excel Date Functions Part 1

P024 Introduction to Excel Date Functions Part 2

P025 Introduction to Excel Date Functions Part 3

P026 How to Perform a Two-Way LOOKUP Using INDEX MATCH MATCH

Example Spreadsheet


P027 How to Use Excel Wildcard Characters in Formulas

Example Spreadsheet


P028 How to Use The COUNTIF Function

Example Spreadsheet


P029 How to Handle Excel Errors in Formulas

Example Spreadsheet


P030 How to Use The AVERAGEIFS Function

Example Spreadsheet


P031 How to Use VLOOKUP and MATCH to Perform a Two-Way Lookup

Example Spreadsheet


P032 How to Control User Data Input Using Data Validation Part 1

Example Spreadsheet


P033 How to Control User Data Input Using Data Validation Part 2

Example Spreadsheet


P034 How to Create a Dynamic Named Range

Example Spreadsheet