Cristiano Galvao

In this course, you will learn how to use Microsoft's Excel Power Pivot. Unlike Power Query, this is a lesser-known tool that simplifies creating complex reports. We start by understanding tables, then delve into Power Pivot through the Data Model. You'll merge tables, create formula fields, and make pivot tables from multiple tables! This course complements the Power Query course on LinkedIn Learning, and both can be taken in any order.

This is the "Excel 2021: Basic Training" course, designed to help you take your first steps in Excel 2021. You'll learn to use Excel correctly in a work environment, greatly enhancing your resume. The course starts with basic concepts like cell data entry and modification. Next, you'll learn to improve the visual presentation of your data. You'll cover essential tools such as filters and sorting, and get an introductory understanding of formulas, charts, and pivot tables.

If you're a frequent Excel user, you might have some repetitive tasks. Luckily, you can automate these tasks by creating macros. Many assume macros are complex and only for advanced users, but that's not the case! In this quick course, you’ll see the best situations to use a macro and how to record your clicks, typing, and operations in spreadsheets. This knowledge will help you understand the role and potential of VBA (Visual Basic for Applications) in solving various problems.

This course is for those who already use Microsoft Excel but need to speed up their work by using its features more efficiently. With a wide range of tips focused on daily spreadsheet tasks, by the end of the course, you'll save hours of repetitive or manual work without needing programming skills. From the first lessons, you'll notice that just a few tips will save you time in front of the computer.

With the introduction of Power add-ins, processes like data extraction, transformation, and loading can now be easily performed in Excel using Power Query. In this course, you will learn essential concepts and basic fundamentals such as loading options, ETL process steps, creating a perpetual calendar, data extraction, and more. Power Query will help you achieve higher productivity and enhance your Excel experience. This course complements the Power Pivot course from LinkedIn Learning.

The course "Excel: Advanced Formatting Techniques" is designed for users familiar with basic Excel formatting who want to enhance their skills. Through practical examples and support materials, you'll learn advanced formatting, including font adjustments and color use for professional displays. Learn tricks like customizing number scales and automatically updating colors to refine your work efficiently. This course will elevate your Excel formatting expertise to a new level.

The Excel VBA: Basic Training course is designed for professionals with intermediate to advanced Excel skills but no programming experience. You'll learn to automate repetitive tasks using macros and VBA programming. The course starts with the macro recorder, covering basic VBA syntax, and progresses to advanced commands only available through VBA programming, highlighting the limitations of recording and the advantages of using the programming language.

In this course, we will cover and learn the basics of one of the most comprehensive and versatile programs in the Microsoft Office suite: Excel 2016. This will enable us to handle a wide range of formulas, calculations, and analyses, from the simplest to the most complex, using commands in a user-friendly program available on most computers worldwide. We hope you learn and enjoy using this application to its fullest potential, in the way that best suits you and brings you the most benefits.

In our new economy, businesses are driven by data, which grows every day. In this Data Management and Analysis course, you will learn to apply simple concepts in realistic scenarios that reflect the daily challenges faced by many companies. Excel is the ideal tool for managing and analyzing this data in a simple, dynamic, and effective way.

In this course, we will cover and learn the basics of one of the most comprehensive and versatile programs in the Microsoft Office suite: Excel 2019. This way, we will be able to perform various formulas, calculations, and analyses, ranging from simple to complex, through commands in a user-friendly program available on most computers worldwide. We hope you enjoy, learn, and make the most of this application to its fullest potential, in a way that benefits you the most.