Courses

Excel is in almost every office in the world, yet most people use only a small part of what it can do. In this practical course you will learn to find your way around the Microsoft 365 Excel interface in Portuguese, manage workbooks and sheets, enter data and apply professional number formats, build formulas with the SUM, AVERAGE, MAX, MIN and COUNT functions, use relative and absolute references and, finally, sort, filter and prepare lists for printing or PDF. You will follow Marta, an administrative assistant at Nova Rota Logística, and practise on a downloadable Excel file with orders, stock and sales. Aligned with the digital content creation area of the European Digital Competence Framework (DigComp), the course prepares you to work with spreadsheets quickly, neatly and without errors, in any country and any sector. The course is delivered in Portuguese.

What you will learn

• Navigate the Excel interface and create, save, open and organise workbooks and worksheets.
• Enter different types of data and apply professional formatting, including number formats, borders and AutoFill.
• Build formulas with operators and with the SUM, AVERAGE, MAX, MIN and COUNT functions, using relative and absolute references correctly.
• Sort and filter data lists and set up the page and print area to print or export to PDF.

Modules

1. Getting to know Excel47 min
2. Entering and formatting data49 min
3. Basic formulas52 min
4. Sorting, filtering and printing47 min

Who it is for

Office staff, administrative assistants and analysts who are starting to use Excel or want to consolidate the basics