Excel course

Spreadsheets are a key element in many fields of work. Excel is a powerful tool that opens the door to new career opportunities. Whether you’re a beginner or already familiar with a few formulas, this free 15-hour Excel course is perfect for you.

The training is designed to help you easily master the basics of Excel and then advance to an intermediate level. By the end of the course, you’ll earn 4 certificates and gain the confidence to unlock new opportunities.

Free

Duration

15 h

Mode

24/7 video access

Language

Polish or English

Max group

n/a

What do you gain?

24/7 access to video courses from any device
Opportunity to ask questions on a regular basis
Access to video also after completing the course
The certification process confirming the acquired skills
The scope of material constantly updated (with changes in tools)
Practical Excel skills, including data entry, calculations, creating formulas, and tables
Confidence in solving real-world tasks like budgets, reports, and data analysis
Flexibility in learning with short lessons you can revisit anytime, anywhere

For whom?

Beginners looking to learn Excel from scratch and build a solid foundation.
Professionals who want to enhance their skills and apply Excel in their daily tasks.
Students who need practical Excel knowledge for academic projects and data analysis.
Anyone looking to gain confidence and proficiency in using Excel for both personal and professional purposes.

Training program

Introduction to Excel formulas
- mathematical formulas
- address blocking
- keyboard shortcuts
Sprint across Excel formulas
- logical, date and time, text
VLOOKUP
- introduction to the formula and common mistakes
- XLOOKUP – new Excel 365 formula
Key formulas in reports
- COUNTIF and SUMIF
- SUMPRODUCT
- array formulas
Data operations
- sorting and filtering
- finding and replacing
- conditional formatting

Introduction to a pivot table
Basic calculations in a pivot table
Layout, formatting, and sorting of a pivot table
Grouping of a pivot table
Filtering of a pivot table
Pivot chart
Show values as
Calculated field
Developing a dashboard on a pivot table
Slicers and filtering
Advanced calculations
Advanced pivot chart

Power Map 3D
Work with addresses
Other ways to make maps in Excel
Standard maps in Power BI
Examples of projects with maps in Excel and Power BI

Formulas and data operations

Introduction to Excel formulas
- mathematical formulas
- address blocking
- keyboard shortcuts
Sprint across Excel formulas
- logical, date and time, text
VLOOKUP
- introduction to the formula and common mistakes
- XLOOKUP – new Excel 365 formula
Key formulas in reports
- COUNTIF and SUMIF
- SUMPRODUCT
- array formulas
Data operations
- sorting and filtering
- finding and replacing
- conditional formatting

Excel Pivot Tables

Introduction to a pivot table
Basic calculations in a pivot table
Layout, formatting, and sorting of a pivot table
Grouping of a pivot table
Filtering of a pivot table
Pivot chart
Show values as
Calculated field
Developing a dashboard on a pivot table
Slicers and filtering
Advanced calculations
Advanced pivot chart

Map reports in Excel and Power BI

Power Map 3D
Work with addresses
Other ways to make maps in Excel
Standard maps in Power BI
Examples of projects with maps in Excel and Power BI

Who will train you?

Our Training Team is versatile and constantly evolving in the ever changing world of tech. We encourage you to Get to know our Trainers in a dedicated section of our website and to explore further at Meet Our Team.

We aim for high flexibility and providing you with the up-to-date knowledge and relevant skills, hence trainers can be assigned to a particular course dynamically. Selection criteria may involve factors like preferred dates, trainer’s latest achievements in a given field or your personal view of their competence and experience. Did we mention the Get to know our Trainers section?

Additional information

Training offered in collaboration with Bartek Czapiewski / excelbiacademy.com.

Excel course

the right choice?

Is Excel course the right choice?

Misaligned training isn’t just frustrating – it’s a waste of time. Fill in the form below and ensure we can deliver exactly what your skill set requires. We’ll get back to you within a day, offering our best value for your time.

Dive deeper with these related topics

4in1 Power courses bundle

#Microsoft #Beginner #Data analysts

Excel BI for Analysts

#Microsoft #Beginner #Data analysts

Power BI – prepare data, create data model, design dashboard

#Microsoft #Beginner #Data analysts

Intro to AI for enterprise

#Beginner #Everyone

UiPath Developers Foundation

#UiPath #Beginner #RPA Developers

UiPath Developers Advanced

#UiPath #Advanced #RPA Developers

RPA for Business Analysts

#Intermediate #Business Analysts #Project Managers #Automation Managers

MS Power Automate Flows + Desktop

#Microsoft #Beginner #Power Automate Developers

MS Power Apps Training

#Microsoft #Beginner #Power Automate Developers

4in1 Power courses bundle

#Microsoft #Beginner #Data analysts

Excel BI for Analysts

#Microsoft #Beginner #Data analysts

Power BI – prepare data, create data model, design dashboard

#Microsoft #Beginner #Data analysts