Excel BI Academy

13 hours of Excel course for free

[qode_elements_holder number_of_columns=”two_columns”][qode_elements_holder_item vertical_alignment=”bottom” horizontal_alignment=”center” advanced_animations=”no” item_padding=”2.5%”]
[/qode_elements_holder_item][qode_elements_holder_item vertical_alignment=”bottom” horizontal_alignment=”left” advanced_animations=”no” item_padding=”2.5%”]

Hello, I’m Bartosz Czapiewski, the founder of Excel BI Academy. I invite you to my Academy, where I share my knowledge from many years of work on reporting projects.

Thanks to the courses at the Academy, I have helped thousands of people change their reports and careers. You will find there as much as 13 hours of free video with the possibility of asking questions and obtaining a certificate:

[unordered_list style=’number’ number_type=’transparent_number’ animate=’yes’ font_weight=”]

  • Excel formulas and data operations (5 h)
  • Excel Pivot Tables (6h)
  • Reporting on maps in Excel & Power BI (2 h)

[/unordered_list]

[/qode_elements_holder_item][/qode_elements_holder]
[qode_elements_holder number_of_columns=”two_columns” columns_proportion=”66_33″][qode_elements_holder_item vertical_alignment=”middle” horizontal_alignment=”left” advanced_animations=”no”]

Is the course really free?

[icon_list_item icon=”fa-check” icon_type=”transparent” title=”the course is 100% free” icon_size=”24″ icon_color=”#604457″ title_color=”#604457″ title_size=”24″][icon_list_item icon=”fa-check” icon_type=”transparent” title=”the course materials are free to download” icon_size=”24″ icon_color=”#604457″ title_color=”#604457″ title_size=”24″][icon_list_item icon=”fa-check” icon_type=”transparent” title=”you can use the materials further, and even train others on their basis” icon_size=”24″ icon_color=”#604457″ title_color=”#604457″ title_size=”24″][/qode_elements_holder_item][qode_elements_holder_item vertical_alignment=”middle” horizontal_alignment=”left” advanced_animations=”no”][image_hover target=”_self” animation=”no” image=”1228″ hover_image=”1227″ link=”https://excelbiacademy.com/checkout/?add-to-cart=360″][/qode_elements_holder_item][/qode_elements_holder]

Learn Excel with me!

Over 20,000 people are learning online with me because:

[unordered_list style=’number’ number_type=’transparent_number’ animate=’yes’ font_weight=”]

  • I explain using the simple language (or as the graduates write: I translate from Excel to English)
  • I present only practical examples based on 15 years of work with Excel
  • I present many tricks, ways to save time and automate reporting

[/unordered_list]

What’s included in the course?

[qode_elements_holder number_of_columns=”three_columns”][qode_elements_holder_item vertical_alignment=”top” advanced_animations=”no” custom_class=”frame01″ item_padding=”10px”]

Formulas and data operations

ONLINE COURSE
[unordered_list style=”circle” animate=”no”]Lesson 1
Introduction to Excel formulas

  • mathematical formulas
  • address blocking
  • keyboard shortcuts

Lesson 2
Sprint across Excel formulas

  • logical, date and time, text

Lesson 3
VLOOKUP

  • introduction to the formula and common mistakes
  • XLOOKUP – new Excel 365 formula

Lesson 4
Key formulas in reports

  • COUNTIF and SUMIF
  • SUMPRODUCT
  • array formulas

Lesson 5
Data operations

  • sorting and filtering
  • finding and replacing
  • conditional formatting

[/unordered_list][/qode_elements_holder_item][qode_elements_holder_item vertical_alignment=”top” advanced_animations=”no” custom_class=”frame01″ item_padding=”10px”]

Excel Pivot Tables

ONLINE COURSE

Lesson 1
Introduction to a pivot table

Lesson 2
Basic calculations in a pivot table

Lesson 3
Layout, formatting, and sorting of a pivot table

Lesson 4
Grouping of a pivot table

Lesson 5
Filtering of a pivot table

Lesson 6
Pivot chart

Lesson 7
Show values as

Lesson 8
Calculated field

Lesson 9
Developing a dashboard on a pivot table

Lesson 10
Slicers and filtering

Lesson 11
Advanced calculations

Lesson 12
Advanced pivot charts

[/qode_elements_holder_item][qode_elements_holder_item vertical_alignment=”top” advanced_animations=”no” custom_class=”frame01″ item_padding=”10px”]

Map reports in Excel and Power BI

ONLINE COURSE

Lesson 1
Power Map 3D

Lesson 2
Work with addresses

Lesson 3
Other ways to make maps in Excel

Lesson 4
Standard maps in Power BI

Lesson 5
Examples of projects with maps in Excel and Power BI

[/qode_elements_holder_item][/qode_elements_holder]

Why is it worth taking advantage of the courses at the ExcelBIAcademy.com ?

Akademia icons 24h

24/7 access to video courses from any device.

Akademia icons cwiczenia

The practical nature of the courses – exercises only – based on the experiences of hundreds of participants of our training courses.

Akademia icons question

Opportunity to ask questions on a regular basis.

Akademia icons video

Access to video also after completing the course (who doesn’t dream about it?).

Akademia icons certyficat

The certification process confirming the acquired skills.

Akademia icons book

The scope of material constantly updated (with changes in tools).

[qode_elements_holder number_of_columns=”two_columns”][qode_elements_holder_item vertical_alignment=”middle” advanced_animations=”no” item_padding=”10px”]
[/qode_elements_holder_item][qode_elements_holder_item vertical_alignment=”middle” advanced_animations=”no” item_padding=”10px”][image_hover target=”_self” animation=”no” image=”1229″ hover_image=”1230″ link=”https://excelbiacademy.com/checkout/?add-to-cart=360″][/qode_elements_holder_item][/qode_elements_holder]

Sample lessons:

EXCEL FORMULAS

VLOOKUP

How to order?

cart icon

Add the package to your cart by clicking the GET FREE ACCESS button

next icon
mail icon

Enter your name and e-mail address and click ORDER

next icon
web page icon

Receive your login details by e-mail

[qode_elements_holder number_of_columns=”two_columns”][qode_elements_holder_item vertical_alignment=”middle” advanced_animations=”no” item_padding=”10px”]
[/qode_elements_holder_item][qode_elements_holder_item vertical_alignment=”middle” advanced_animations=”no” item_padding=”10px”][image_hover target=”_self” animation=”no” image=”1229″ hover_image=”1230″ link=”https://excelbiacademy.com/checkout/?add-to-cart=360″][/qode_elements_holder_item][/qode_elements_holder]

What do participants think about the course?

[testimonials_carousel category=”english” show_title=”no” show_rating=”no” author_image=”no” show_navigation=”yes” navigation_style=”dark” auto_rotate_slides=”5″ animation_speed=”1500″]
[qode_elements_holder number_of_columns=”two_columns” columns_proportion=”25_75″][qode_elements_holder_item vertical_alignment=”middle” advanced_animations=”no” item_padding=”5%”]

We have been a trusted partner in training for:

[/qode_elements_holder_item][qode_elements_holder_item vertical_alignment=”middle” advanced_animations=”no” item_padding=”5%”][qode_carousel carousel=”academy-logos” number_of_visible_items=”four_items” orderby=”title” order=”ASC”][/qode_elements_holder_item][/qode_elements_holder]

still have questions?

Write to me at bartosz@excelbiacademy.com or call +48 500 196 861