Macros

Example of Using the Trim Function

An Excel file that teaches how to perform Example of Using the Trim Function operation.

60 0 XLSM
Charts

Chore Chart for Children

An Excel file that teaches how to perform Chore Chart for Children operation.

60 1 XLSX
Power Query

Quarantine Countdown Calendar

An Excel file that teaches how to perform Quarantine Countdown Calendar operation.

60 0 XLSX
Business

Advanced Conditional Formatting Rules Application

Excel file teaching how to perform Advanced Conditional Formatting Rules Application operation.

51 0 XLSM
Business

Solving Equations with Four Unknowns

An Excel file that teaches how to perform Solving Equations with Four Unknowns operation.

59 0 XLSX
Statistics

Calculating the Average of the First and Last Values

Excel file teaching how to perform Calculating the Average of the First and Last Values operation.

59 0 XLSX
Formulas

Validation for Gap-Free Data Entry

An Excel file that teaches how to perform Validation for Gap-Free Data Entry operation.

54 0 XLSM
Macros

Learning to Use the Address Formula

An Excel file that teaches how to perform Learning to Use the Address Formula operation.

54 0 XLSM
Templates

Examples of Array Formulas with the SUM Function

Excel file teaching how to perform Examples of Array Formulas with the SUM Function operation.

60 0 XLSX
Charts

Line Chart with Linear Trend Line and Colored Band

Excel file teaching how to perform Line Chart with Linear Trend Line and Colored Band operation.

52 0 XLSX
Engineering

Age Calculation Based on Date of Birth

An Excel file that teaches how to perform Age Calculation Based on Date of Birth operation.

57 4 XLSX
Power Query

Profit and Loss Statement

An Excel file that teaches how to perform Profit and Loss Statement operation.

57 0 XLSX
Business

Automatically Generate 100 Animal Puzzles

An Excel file that teaches how to perform Automatically Generate 100 Animal Puzzles operation.

55 0 XLSM
Engineering

Calculating the Days Between Start and End Dates

Excel file teaching how to perform Calculating the Days Between Start and End Dates operation.

60 0 XLSM
Formulas

Summing Cells with Blanks and Errors

An Excel file that teaches how to perform Summing Cells with Blanks and Errors operation.

64 0 XLSX
Business

Comparing the ADO Method with the VBA Method

An Excel file that teaches how to perform Comparing the ADO Method with the VBA Method operation.

55 0 XLSM
Templates

Grouping with Random Selection

An Excel file that teaches how to perform Grouping with Random Selection operation.

75 2 XLSX
Charts

Kanban Board Template

An Excel file that teaches how to perform Kanban Board Template operation.

58 0 XLSX
Charts

The Graph of a Segment Identified on a Line Chart

Excel file teaching how to perform The Graph of a Segment Identified on a Line Chart operation.

54 0 XLSX
Power Query

Break-Even Point Calculation Table

An Excel file that teaches how to perform Break-Even Point Calculation Table operation.

60 0 XLSX
Charts

Creating a Pipe Weight and Circle Ring Graph

An Excel file that teaches how to perform Creating a Pipe Weight and Circle Ring Graph operation.

51 0 XLSX
Macros

Preparing ADO Sample Files

An Excel file that teaches how to perform Preparing ADO Sample Files operation.

51 0 XLSM
Power Query

Holidays with Continuous Monthly Calendar

An Excel file that teaches how to perform Holidays with Continuous Monthly Calendar operation.

50 0 XLSX