Image 1 of 1
Build Your Own Cosmetic Manufacturing Batch Sheet 11/21/2026 10:00 am EST
A Live, Hands-On Microsoft Excel Workshop On Zoom
A well-designed batch sheet can become one of the most useful tools in your manufacturing operation.
In this guided workshop, you’ll learn how to build a functional batch sheet in Microsoft Excel for your own cosmetic products. We’ll work through the structure, formulas, calculations, and formatting needed to create a spreadsheet that supports product development, ingredient costing, and batch documentation.
This isn’t a general Excel course. It’s a practical workshop focused on using Excel to manage an important part of your cosmetic manufacturing process.
What You’ll Learn
Build a Batch Sheet
Learn how to organize a batch sheet so that information is easy to understand, access, and use during production.
Work With Formulations and Percentages
Learn how to enter ingredients and quantities, calculate formula percentages, and use an Excel pie chart to see the composition of your formula visually. You’ll also learn how to adjust quantities and use the spreadsheet to calculate the corresponding percentages.
Calculate Ingredient and Product Costs
Set up calculations that help determine ingredient costs and understand your product’s cost per ounce and per unit.
Organize Production Information
Learn how to incorporate important manufacturing details, including ingredient lot numbers, production instructions, and batch records.
Make Your Spreadsheet Work for You
Learn how to format and arrange your worksheet so that it is practical for everyday use, including making it easy for a technician to follow during production.
Print or Maintain Digital Records
Set up a batch sheet that can be printed for paper documentation or maintained digitally. Learn how to save and organize your records for future reference.
What You’ll Build
We’ll start together with a simple three-ingredient body oil formula. You’ll learn how to build the batch sheet, enter the formula, use calculations, and create a visual representation of the formula percentages.
Then you’ll apply what you’ve learned to a formula of your own.
By the end of the workshop, you’ll have the foundation for a customized batch sheet that you can continue using and adapting for your business.
Before You Take the Class
This is a hands-on workshop, so you’ll need a few things ready before we begin.
1. Microsoft Excel
You must have access to Microsoft Excel on a computer. This workshop is taught using Excel, not Google Sheets. Please make sure you can open and work in Excel before class begins.
2. A Computer
A desktop or laptop computer is required. A phone or tablet is not recommended because you’ll need to work directly in the spreadsheet while following the demonstration.
3. Basic Computer Skills
You don’t need to be an Excel expert, but you should be comfortable with basic computer tasks, including:
Opening and saving files.
Selecting cells and typing information.
Using the menus and tabs at the top of the Excel window.
Moving around a spreadsheet.
Making simple edits to information.
Copying and pasting information.
4. Basic Spreadsheet Familiarity
It will help if you understand a few basic terms:
Workbook: The Excel file itself.
Worksheet: An individual spreadsheet or tab inside a workbook. A workbook can contain multiple worksheets.
Cell: An individual box where you enter information. Each cell has an address, such as A1 or B4.
Formula: An instruction entered into a cell that tells Excel to perform a calculation.
5. Basic Math Operators
Excel uses familiar mathematical symbols when creating formulas:
+ Addition
- Subtraction
* Multiplication
/ Division
Excel formulas generally begin with an equals sign (=). You can also begin a formula with a plus sign (+).
6. A Little About the Order of Operations
Excel follows the standard mathematical order of operations, commonly remembered as PEMDAS:
P – Parentheses
E – Exponents
M/D – Multiplication and Division
A/S – Addition and Subtraction
Multiplication and division have equal priority, as do addition and subtraction. When operations have equal priority, Excel evaluates them from left to right. Parentheses can be used to control the order of a calculation.
You don’t need to memorize complicated formulas before class. Just becoming familiar with these basic principles will help you follow along.
7. Bring a Product Formula
Bring a formula for a product you would like to use as your first customized batch sheet. You should also have your ingredient information and, if possible, your current supplier list and ingredient prices available.
This will allow you to work with information relevant to your own business instead of using an unrelated example.
A Little Practice Before Class
If you’re new to Excel, spend a few minutes getting comfortable with the program before the workshop.
Open a blank workbook and try these exercises:
Click a cell and type a number.
Click another cell and type a different number.
In an empty cell, enter =10+5 and press Enter.
Try =10-5, =10*5, and =10/5.
Enter =10+5*2 in another cell. Notice the result.
Now enter =(10+5)*2. Notice how the parentheses change the result.
Add another worksheet using the plus sign near the worksheet tabs.
Rename a worksheet by double-clicking its tab.
Save your workbook with a name you can find again.
That’s enough practice to become familiar with the basic layout and a few simple calculations.
If you need additional help, Microsoft provides introductory Excel tutorials and formula guides through its support website.
Workshop Details
Format: Live online workshop via Zoom
Investment: $120
This is a guided, hands-on session. You’ll follow along as we build the batch sheet together, with opportunities to ask questions as we work.
Build a Better Foundation for Manufacturing.
A batch sheet can do much more than record what you made. When it’s designed properly, it becomes a working tool for product development, formulation calculations, costing, and production documentation.
Learn how to build one for your brand.
Your Class Registration and Zoom Information
Once your registration is complete, you’ll receive a downloadable class ticket with everything you need to attend your live Zoom workshop.
Your ticket will include:
Class date and time
Zoom meeting link
Meeting ID and passcode, if applicable
Instructions for joining the session
A short pre-class checklist to help you prepare
Please save your ticket so you can easily access your meeting information on class day.
We recommend joining Zoom five minutes before the scheduled start time so you’re ready when the class begins.
Registration and Refund Policy
Class registrations are nonrefundable. Please review the class date and time carefully before purchasing.
If you’re unable to attend:
If you register but cannot attend the scheduled session, you’ll still receive the digital class materials included with your registration. You may register for another session in the future if one is offered and space is available. A transfer to another session is not guaranteed.
If Makeup Engineering cancels or reschedules a class:
If we cancel or reschedule a class, you will receive a full refund of your registration fee, along with the digital class materials.
A Live, Hands-On Microsoft Excel Workshop On Zoom
A well-designed batch sheet can become one of the most useful tools in your manufacturing operation.
In this guided workshop, you’ll learn how to build a functional batch sheet in Microsoft Excel for your own cosmetic products. We’ll work through the structure, formulas, calculations, and formatting needed to create a spreadsheet that supports product development, ingredient costing, and batch documentation.
This isn’t a general Excel course. It’s a practical workshop focused on using Excel to manage an important part of your cosmetic manufacturing process.
What You’ll Learn
Build a Batch Sheet
Learn how to organize a batch sheet so that information is easy to understand, access, and use during production.
Work With Formulations and Percentages
Learn how to enter ingredients and quantities, calculate formula percentages, and use an Excel pie chart to see the composition of your formula visually. You’ll also learn how to adjust quantities and use the spreadsheet to calculate the corresponding percentages.
Calculate Ingredient and Product Costs
Set up calculations that help determine ingredient costs and understand your product’s cost per ounce and per unit.
Organize Production Information
Learn how to incorporate important manufacturing details, including ingredient lot numbers, production instructions, and batch records.
Make Your Spreadsheet Work for You
Learn how to format and arrange your worksheet so that it is practical for everyday use, including making it easy for a technician to follow during production.
Print or Maintain Digital Records
Set up a batch sheet that can be printed for paper documentation or maintained digitally. Learn how to save and organize your records for future reference.
What You’ll Build
We’ll start together with a simple three-ingredient body oil formula. You’ll learn how to build the batch sheet, enter the formula, use calculations, and create a visual representation of the formula percentages.
Then you’ll apply what you’ve learned to a formula of your own.
By the end of the workshop, you’ll have the foundation for a customized batch sheet that you can continue using and adapting for your business.
Before You Take the Class
This is a hands-on workshop, so you’ll need a few things ready before we begin.
1. Microsoft Excel
You must have access to Microsoft Excel on a computer. This workshop is taught using Excel, not Google Sheets. Please make sure you can open and work in Excel before class begins.
2. A Computer
A desktop or laptop computer is required. A phone or tablet is not recommended because you’ll need to work directly in the spreadsheet while following the demonstration.
3. Basic Computer Skills
You don’t need to be an Excel expert, but you should be comfortable with basic computer tasks, including:
Opening and saving files.
Selecting cells and typing information.
Using the menus and tabs at the top of the Excel window.
Moving around a spreadsheet.
Making simple edits to information.
Copying and pasting information.
4. Basic Spreadsheet Familiarity
It will help if you understand a few basic terms:
Workbook: The Excel file itself.
Worksheet: An individual spreadsheet or tab inside a workbook. A workbook can contain multiple worksheets.
Cell: An individual box where you enter information. Each cell has an address, such as A1 or B4.
Formula: An instruction entered into a cell that tells Excel to perform a calculation.
5. Basic Math Operators
Excel uses familiar mathematical symbols when creating formulas:
+ Addition
- Subtraction
* Multiplication
/ Division
Excel formulas generally begin with an equals sign (=). You can also begin a formula with a plus sign (+).
6. A Little About the Order of Operations
Excel follows the standard mathematical order of operations, commonly remembered as PEMDAS:
P – Parentheses
E – Exponents
M/D – Multiplication and Division
A/S – Addition and Subtraction
Multiplication and division have equal priority, as do addition and subtraction. When operations have equal priority, Excel evaluates them from left to right. Parentheses can be used to control the order of a calculation.
You don’t need to memorize complicated formulas before class. Just becoming familiar with these basic principles will help you follow along.
7. Bring a Product Formula
Bring a formula for a product you would like to use as your first customized batch sheet. You should also have your ingredient information and, if possible, your current supplier list and ingredient prices available.
This will allow you to work with information relevant to your own business instead of using an unrelated example.
A Little Practice Before Class
If you’re new to Excel, spend a few minutes getting comfortable with the program before the workshop.
Open a blank workbook and try these exercises:
Click a cell and type a number.
Click another cell and type a different number.
In an empty cell, enter =10+5 and press Enter.
Try =10-5, =10*5, and =10/5.
Enter =10+5*2 in another cell. Notice the result.
Now enter =(10+5)*2. Notice how the parentheses change the result.
Add another worksheet using the plus sign near the worksheet tabs.
Rename a worksheet by double-clicking its tab.
Save your workbook with a name you can find again.
That’s enough practice to become familiar with the basic layout and a few simple calculations.
If you need additional help, Microsoft provides introductory Excel tutorials and formula guides through its support website.
Workshop Details
Format: Live online workshop via Zoom
Investment: $120
This is a guided, hands-on session. You’ll follow along as we build the batch sheet together, with opportunities to ask questions as we work.
Build a Better Foundation for Manufacturing.
A batch sheet can do much more than record what you made. When it’s designed properly, it becomes a working tool for product development, formulation calculations, costing, and production documentation.
Learn how to build one for your brand.
Your Class Registration and Zoom Information
Once your registration is complete, you’ll receive a downloadable class ticket with everything you need to attend your live Zoom workshop.
Your ticket will include:
Class date and time
Zoom meeting link
Meeting ID and passcode, if applicable
Instructions for joining the session
A short pre-class checklist to help you prepare
Please save your ticket so you can easily access your meeting information on class day.
We recommend joining Zoom five minutes before the scheduled start time so you’re ready when the class begins.
Registration and Refund Policy
Class registrations are nonrefundable. Please review the class date and time carefully before purchasing.
If you’re unable to attend:
If you register but cannot attend the scheduled session, you’ll still receive the digital class materials included with your registration. You may register for another session in the future if one is offered and space is available. A transfer to another session is not guaranteed.
If Makeup Engineering cancels or reschedules a class:
If we cancel or reschedule a class, you will receive a full refund of your registration fee, along with the digital class materials.