Macros

Kolmogorov Smirnov Normality Test

An Excel file that teaches how to perform Kolmogorov Smirnov Normality Test operation.

255 14 XLSM
Charts

Creating Colored Drop-Down List

An Excel file that teaches how to perform Creating Colored Drop-Down List operation.

346 33 XLSX
Macros

Color Scale Application

An Excel file that teaches how to perform Color Scale Application operation.

158 6 XLSM
Macros

Conditional Counting Examples

An Excel file that teaches how to perform Conditional Counting Examples operation.

261 21 XLSM
Business

Summing with Conditions

An Excel file that teaches how to perform Summing with Conditions operation.

200 7 XLSX
Macros

Creating Conditional Drop-Down List

An Excel file that teaches how to perform Creating Conditional Drop-Down List operation.

1,700 237 XLSM
Business

Conditional Formatting with Formula

An Excel file that teaches how to perform Conditional Formatting with Formula operation.

297 10 XLSX
Statistics

Performing Conditional Formatting

An Excel file that teaches how to perform Performing Conditional Formatting operation.

82 0 XLSX
Engineering

Counting with Specific Criteria

An Excel file that teaches how to perform Counting with Specific Criteria operation.

90 0 XLSX
Macros

Filtering with Slicer in Pivot Table

An Excel file that teaches how to perform Filtering with Slicer in Pivot Table operation.

137 0 XLSM
Macros

Technical Service Tracking Program

An Excel file that teaches how to perform Technical Service Tracking Program operation.

194 9 XLSM
Charts

Creating Multiplication Table with Single Formula

Excel file teaching how to perform Creating Multiplication Table with Single Formula operation.

88 0 XLSX
Statistics

Summing Dates by Month

An Excel file that teaches how to perform Summing Dates by Month operation.

77 0 XLSX
Charts

Converting Date to Text

An Excel file that teaches how to perform Converting Date to Text operation.

72 0 XLSX
Statistics

Converting Date to Text as Month and Year

An Excel file that teaches how to perform Converting Date to Text as Month and Year operation.

89 0 XLSX
Macros

Creating Date Countdown

An Excel file that teaches how to perform Creating Date Countdown operation.

88 0 XLSM
Power Query

Creating Pivot Table by Date Range

An Excel file that teaches how to perform Creating Pivot Table by Date Range operation.

100 2 XLSM
Macros

Querying Data from TAPDK Website

An Excel file that teaches how to perform Querying Data from TAPDK Website operation.

96 0 XLSM
Charts

Creating Blood Pressure Tracking Chart

An Excel file that teaches how to perform Creating Blood Pressure Tracking Chart operation.

127 0 XLSX
Charts

Creating Blood Pressure Chart

An Excel file that teaches how to perform Creating Blood Pressure Chart operation.

87 0 XLSX
Macros

Filtering with TextBox

An Excel file that teaches how to perform Filtering with TextBox operation.

111 0 XLSM
Macros

Filtering on Sheet with TextBox

An Excel file that teaches how to perform Filtering on Sheet with TextBox operation.

89 1 XLSM
Templates

Data Filtering with TextBox and ListView

An Excel file that teaches how to perform Data Filtering with TextBox and ListView operation.

115 0 XLSM
Macros

Filtering ListBox with TextBox

An Excel file that teaches how to perform Filtering ListBox with TextBox operation.

106 0 XLSM