Excel: learn how to make a price tag
Create lists with raw materials, units of measure and cost hours/personnel. Set up a template with the calculations of expenses and profits in the manufacture of the products, earnings per unit and profitability. Attendees will carry out the exercise prepared with the relevant explanations so that they can then do it with their business data
Specific goals | Temary
RECOMMENDATION: The assistant must be familiar with the Excel spreadsheet, she does not need to be an expert.
Create lists of raw materials/products of the business.
Control of the same expenses
Control of the final profit of each of them
Being able to detect in which of them lies the biggest/smallest final gain
1.- Creation of data tables with raw materials and other information
2.- Set up a template with all the information for the creation of the products
3.- Create a main menu with access to all parts of the spreadsheet
4.- Creation of notices with conditional format
Mon 18/12/23 (16:00-20:00h)
AC_Cibernàrium Nou Barris
Carrer Marie Curie, 8 - 14,
Fri 19/01/24 (10:00-14:00h)
IMPORTANT: In the event that the format is virtual streaming, it will be done through the free Microsoft Teams platform. Registrants will receive an invitation link and access instructions by email prior to the start of the session.
>> Entry to the classroom will not be allowed after 15 minutes, once the activity has started.
>> The language in which each session is given is reported in the description of each activity.
>> Any of Cibernàrium's training actions can be recorded through a system
of capturing images whose purpose is their subsequent dissemination through a medium or support
in the scope of Barcelona Activa's mission to contribute to economic promotion and employment.
In the recording process, images of the attendees may eventually be recorded
formation. Registration for Cibernàrium activities implies the authorization to Barcelona Activa of
make use of these images for the above purpose.
Lesson taught by
There is a new version of Personal Information Protection law.
Please, accept it before continuing the registration.