Basic Excel Training

Workload:

16 hours

Course Dates:

We will soon open new classes

Course Schedule:

We will soon open new classes

Link to Registration

We will soon open new classes

Investment:

1 x R$ 199.70 via PIX upon registration

3 x R$89.22 via Credit Card in Installments

6 x R$46.90 via Credit Card in Installments

Program content:

Module 1: Introduction to Excel1.1. Presentation of the Excel1.2 interface. Navigation and useful shortcuts1.3. Opening, saving and closing files

Module 2: Spreadsheet Fundamentals2.1. Creating a new worksheet2.2. Inserting and formatting cells2.3. Moving, copying and deleting data2.4. Organization of spreadsheets and guides

Module 3: Basic Formulas and Functions3.1. Introduction to formulas3.2. Mathematical operators3.3. Simple functions (SUM, AVERAGE, MAXIMUM, MINIMUM)3.4. Cell and range references3.5. Copy and fill formulas

Module 4: Data Formatting4.1. Formatting numbers and dates4.2. Cell styles4.3. Conditional formatting4.4. Borders and shading

Module 5: Graphs and Visualizations5.1. Creating column, bar, and pie charts5.2. Graphics customization5.3. Inserting titles and labels5.4. Sparkline Charts

Module 6: Data Management6.1. Data classification and filtering6.2. Creation of tables6.3. Data validation6.4. Subtotals and grouping

Module 7: Advanced Functions7.1. Text functions (CONCATENATE, LEFT, RIGHT)7.2. Logical functions (IF, AND, OR)7.3. Search functions (VLOOKUP, HLOOKUP)7.4. Date and time functions

Module 8: Tips and Tricks8.1. Advanced shortcuts8.2. Spreadsheet protection8.3. Formula audit8.4. Creating spreadsheet templates

Details about the Basic Excel Course

Have you ever stopped to think about how many times Excel could have made your life easier? Whether you want to organize your personal finances, manage projects at work, or simply track your data effectively, Excel is an indispensable tool. If you haven't yet mastered the basics of this incredible software, it's time to take a step forward.