In-Person or Online Excel Courses
15% DISCOUNT
until February 28!
Limited Spots. Register now!
Practical Learning
Increased Productivity
Guaranteed Excellence
Enhance your Excel skills with practical and guided courses.
Whatever your level of knowledge, we have training tailored to your needs:
- Intermediate Course: Deepen essential knowledge to increase efficiency in daily tasks.
- Advanced Course: Reach a new level of expertise by exploring advanced features and automation.
Compare available courses
Master Excel and Increase Your Productivity
Excel is an indispensable tool in today’s job market. From basic organizational tasks to complex data analysis, mastering this tool can make all the difference in your professional performance.
Intermediate Excel
Description
This course aims to refresh and enhance knowledge of the main functionalities of Microsoft Excel spreadsheets, enabling participants to create spreadsheets using formulas and functions to process numbers, organize, filter and handle information and make advanced use of the resources Excel offers.
Target Audience
All employees who wish to develop their skills in Excel.
Program
- Module 1 – Review of Concepts and Usage;
- Module 2 – Building a Spreadsheet
- Introduction and data editing;
- Data types;
- Operations with cells, columns, and rows;
- Operations with sheets;
- Navigation in the sheet and workbook;
- Auto-fill;
- Custom lists.
- Module 3 – Formatting:
- Formatting numbers, text, and dates;
- Cell formatting;
- Conditional formatting.
- Module 4 – Formulas and Functions:
- Operators;
- Simple calculations;
- Using Text, Date|Time, Logical, Lookup, Information functions.
- Module 5 – Charts:
- Construction;
- Formatting.
- Module 6 – Data Exploration:
- Data sorting;
- Automatic and advanced filters;
- Data consolidation.
- Module 7 – Printing and Other Tools:
- Page setup;
- Preview;
- Cell, sheet, and workbook protection;
- Course evaluation and closure.
Dates
- In-Person: March 10
- Online: March 11, 12, and 17
- 7 hours
- Online
- In-Person
Advanced Excel
Description
This course aims to provide participants with a set of more in-depth knowledge of MS Excel.
Target Audience
All employees who wish to develop their skills in Excel.
Program
- Module 1 – Pivot Tables and Charts
- General description of Pivot Tables
- General description of Pivot Charts
- Create a pivot table or chart from spreadsheet data
- Module 2 – File Management
- Basic Concept of Databases
- Creating a Data List
- Using Forms
- Data Entry Validation
- Protect Cells, Sheets, and Workbooks
- Module 3 – Hypothesis Analysis and Data Simulation
- Simulation Tables
- Scenarios
- Goal Seek
- Solver Function
- Module 4 – Excel Macros and Add-ins:
- Power Query
- Inquire
- PowerPivot
- Course evaluation and closure.
Dates
- In-Person: February 10 and 12 / April 7 and 14
- Online: March 31, April 1, 4, 8, and 9
- 14 hours
- Online
- In-Person
Our clients' opinions
We always strive to innovate and find new solutions to improve our services and our offer.
The opinions of our clients and partners help us understand that we are making the right decisions.
A Centralmed é desde 1997 uma referência no panorama da Segurança e Saúde no Trabalho, Segurança Alimentar e Formação Profissional, visando a prevenção dos riscos profissionais e alimentares, promovendo a saúde dos trabalhadores e consumidores.
