Specialized
 

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




CONTENT


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


Editions

Edition 1

Mon 18/12/23 (16:00-20:00h)

AC_Cibernàrium Nou Barris

Carrer Marie Curie, 8 - 14,

BARCELONA

Opening of registration 03/12/2023 to 08:30 h.
Edition 2

Fri 19/01/24 (10:00-14:00h)

Virtual classroom

Language: Catalan
Opening of registration 04/01/2024 to 08:30 h.

General information

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.

Mon 18/12/23 (16:00-20:00h)
Modality: Attended session
Duration: 1 session

AC_Cibernàrium Nou Barris - Carrer Marie Curie, 8 - 14,
BARCELONA
Opening of registration 03/12/2023 to 08:30 h.
Duration: 1 session
Price: This activity is free
Level: Specialized
Theme: Business and company

Course ratings

Average
9.52

Lesson taught by

ENRIC

FERRER MARTÍNEZ

Average
9.76

Related courses

There is a new version of Personal Information Protection law.
Please, accept it before continuing the registration.

Excel: learn how to make a price tag: Edition 1

Attended session

Mon 18/12/23 16:00-20:00h

AC_Cibernàrium Nou Barris

Carrer Marie Curie, 8 - 14,

BARCELONA

Excel: learn how to make a price tag: Edition 2

Fri 19/01/24 10:00-14:00h

Virtual classroom

Personal information

Full name:

NIF/NIE: 10158

Email: default@liferay.com

Birthday: 28/06/2016

I agree registration conditions