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:
- Excel formulas and data operations (5 h)
- Excel Pivot Tables (6h)
- Reporting on maps in Excel & Power BI (2 h)
How can any Excel user automate their work with data and create attractive, interactive dashboards?
In my opinion, each analyst should then follow the new Excel learning curve, learning in turn: Power Query, Power Pivot (including data modeling and DAX), dashboards in Excel and Power BI. The next stages are available at the Academy for a fee, but it is worth investing in them, as shown by the stories of participants whom the courses allowed:
- make better business decisions,
- gain recognition and self-confidence,
- get promoted or get a better paid job,
- plan and better implement their professional career.
Begin a new stage in your life
Learning the POWER add-ins in Excel will allow you to make significant changes in the reporting processes:
- you will save working hours by automating reporting (Power Query),
- you will improve the quality of data by catching errors (Power Query),
- you will build transparent data models with KPIs (Power Pivot / Power BI),
- you will develop intuitive and interactive dashboards (Excel / Power BI).
9 out of 10 Excel users have not heard of them at all, so after the courses you have a great chance to become the king of reporting and an agent of changes in your organization.
4 courses 60% cheaper.
Click here to see the composition of the package
The package includes the following courses:
- Power Query for Excel and Power BI analysts
- Data model and DAX for Excel Power Pivot and Power BI users
- Data visualization and designing Excel dashboards
- Power BI Desktop
Only 299 €
instead of 796 €
9 out of 10 students choose a bundled purchase.
The package cannot be combined with other discounts and promotions.
What are the courses included?
Power Query course
Lesson 1. Append
- Append workbooks
- DYI: Append two sheets of the same workbook
- Get data from folder of Excel files
- DYI: Get data from folder of CSV files
- Get data from sheets with different names
- Appending problems
Lesson 2. Merge queries
- Merge Excel sheets
- Merge scenarios
- DYI: Merge
Lesson 3. Loading queries to Excel
- Create a pivot table on a query
- New columns for pivot tables
- DYI: Operating on columns
- Column from examples
Lesson 4. Group
- Group by = Pivot table
Lesson 5. Pivot & Unpivot
- Unpivot
- Pivoted column
- DIY: Unpivot dates
Lesson 6. Get data from Web
- Get data from Web
- Get data from Web 2
- Example of function
Lesson 7. Repetition
Data model & DAX language course
Lesson 1. Building a data model
- Where to find data model in Power Pivot and Power BI?
- How not to build a data model in Excel?
- Creating queries in Power Query
- Creating relations in Power Pivot
Lesson 2. Inserting a pivot table
- Designing a pivot table
- Product with no sales and basics of data model
- Distinct count
- Drill down
Lesson 3. Hierarchy
- Creating a hierarchy
- Hierarchy in a Pivot table
- Hierarchy on a slicer
Lesson 4. Date table
- Creating a date table
- Hiding fields in Power Pivot
- Sorting by column
Lesson 5. Basic DAX formulas
- My first measure: SUM
- DIY: SUM
- DIVIDE
- COUNT
- DIY: COUNT
- COUNT vs COUNTROWS
- DIY: basic formulas
Lesson 6. CALCULATE
- SUMIF vs SUM in a pivot table
- CALCULATE
- Pivot table not working – filter context
- Basic measures with columns
- Limitations
- DIY: CALCULATE
Lesson 7. Functions with X
- SUMPRODUCT in Excel
- SUMX
- AVERAGEX
- DIY: formulas with X
- Context transition
Lesson 8. Other formulas
- SEARCH, FIND, IF, BLANK, SWITCH
- VALUES
- HASONEVALUE
- Other formulas – DIY
Lesson 9. ALL functions
- ALL on a table
- ALL on column and ALLEXCEPT
- ALLSELECTED
- DYI: ALL functions
Lesson 10. FILTER
- How does the FILTER work?
- FILTER with CALCULATE
- Row and filter context
- CALCULATE and CALCULATE with FILTER
- DIY: FILTER
Lesson 11. Time Intelligence
- SAMEPERIODLASTYEAR
- Year-To-Date
- Last Month
- Time formulas without Time Intelligence
- DIY: Time Intelligence
Lesson 12. Sales vs Targets
- Target realization
Data visualization and dashboard design course
Lesson 1. Introduction to Data Visualization
- Human senses and memory
- Tables vs. charts – basic applications
- History of data visualization
- What does the effective chart mean?
- Graphicacy and its impact on number communication
Lesson 2. Tables and charts
- 7 principles of effective number communication
- Basic types of tables and charts
- Which Excel chart to choose?
- Application of color
- Relationships and chart selection matrix
- Other types of charts
- Presentation of geographical data
Lesson 3. Reports
- What is a dashboard?
- Dashboard examples
- Management dashboard vs. analytical dashboard
- Is my report effective?
Power BI course
Lesson 1. Quick Start
- Introduction to Power BI
- Interface & Getting data
- My first column chart
- Hierarchy on a chart
- Hierarchy in the data model
- Grouping data
- DIY: Column chart
- Matrix = Pivot table
- DIY: Matrix
- Table = Pivot table
- Line chart & Analytics
- Explain the increase / decrease
- DIY: Line chart
- Waterfall, Funnel chart, Treemap
- Q&A
- DIY: Q&A
- Scatter chart & Zoom slider
- Maps
- DIY: Maps
- Chart interactions
- Slicers
- Slicers options
- Publishing the report to Power BI Online
- DYI: Repetition
Lesson 2. Data Visualization Basics
- DIY: Test your skills
- Data viz rules
- DIY: Exercise 1
- DIY: Exercise 2
- DIY: Exercise 3
- DIY: Exercise 4
- DIY: Exercise 5
- DIY: Exercise 6
- DIY: Exercise 7
Lesson 3. Data model
- Creating a data model
- Defining measures
- Gauge
- Conditional formatting
- KPI chart
- Sorting by column
- URL image
- Quick measures: YTD
- Quick measures: YoY % change
- Quick measures: Average per category
- Quick measures: Filtered value
- DIY: Quick measures
Lesson 4. Advanced & AI charts
- Hans Rosling’s chart
- Animated charts
- Small multiples
- Histogram
- Ribbon chart
- Clusters
- Dot plot
- Explain distribution
- Decomposition tree
Why is it worth buying 4in1 POWER courses bundle?
24/7 access to video courses from any device.
The practical nature of the courses – exercises only – based on the experiences of hundreds of participants of our training courses.
Opportunity to ask questions on a regular basis.
Access to video also after completing the course (who doesn’t dream about it?).
The certification process confirming the acquired skills.
The scope of material constantly updated (with changes in tools).
Sample lessons:
EXCEL FORMULAS
VLOOKUP
How to order?
1. Purchase for 1 person with immediate payment
2. Placing an order and payment by bank transfer
send the name and e-mail of each participant and the invoice details by e-mail
access to the courses will be provided within 24 hours
You will receive an invoice payable within 14 days, by ordinary bank transfer
3. Group purchase
It is possible to buy a package of courses for a larger group of people for a specified period of time. If you are interested in this option, please send an inquiry to bartosz@excelbiacademy.com
The Power series add-ins are fairly new and unknown to most Excel users. By learning Excel, the analyst first learns about formulas and pivot tables. What comes next?
Watch the video about the Excel revolution
I recommend for an intermediate Excel user the following path:
Knowing about the Power components allows Excel and Power BI users to:
- Automate your work
- Save time
- Improve data quality
- Improve the appearance of reports and their interactivity
- Raise the quality of your decisions
We have been a trusted partner in training for:
By purchasing the course, you support the Judo Lemur Sports Club, helping young athletes to make their dreams come true. 5% of every sold course is donated to the club.
I support “Lemurs” because:
- The club has a clear goal: to educate and train the Olympic champion in judo,
- Trainers place great emphasis on the personal culture of children and adolescents and their education,
- Lemurs shape values that are important to me: diligence, honor, passion, courage, respect,
- The coronavirus pandemic has limited the club’s development opportunities.
Get ready to work with POWER add-ins by getting to know (or repeating) Excel with me in free online courses:
- Excel formulas and data operation (5 h)
- Excel Pivot Tables (6 h)
- Reporting on maps in Excel & Power BI (2 h)
Here is the new Excel learning curve you will follow:
The most important information about the promotion of the 4in1 POWER courses bundle
What courses are included in the package?
The package includes 4 courses:
- Power Query for Excel and Power BI analysts
- Data model and DAX for Excel Power Pivot and Power BI users
- Data visualization and designing Excel dashboards
- Power BI Desktop
What is the cost?
The cost of more than 22 hours of courses is now only 299 EUR for unlimited access for 1 person
How much am I saving?
Thanks to the bundled purchase, you save as much as 60% compared to the regular price of single courses.
Did you purchase 1 course?
If you have 1 course, you can access the others for an extra payment of the difference. In this case, also write to bartosz@excelbiacademy.com
Are there group purchases?
It is possible to buy a package of courses for a larger group of people for a specified period of time. If you are interested in this option, please send an inquiry to bartosz@excelbiacademy.com.
How to sign up for a package?
Add the bundle to the cart and pay immediately by credit card or PayPal. Access to the course will be granted automatically within a few minutes, and you will receive a VAT invoice by e-mail.
It is possible to pay by bank transfer based on the invoice payable within 14 days or longer (the option preferred by companies). In this case, send to me at bartosz@excelbiacademy.com:
1. First name and e-mail address of the participant.
2. Invoice data (including the EU VAT ID for EU countries)
I will give you access to the course within 24 hours and send an invoice to your e-mail address. You then have 14 days to pay.
How much time do I have to complete the package?
Access to the courses is unlimited, which will allow you to come back to any course in the package whenever you want.
How are the courses held?
The courses are a series of videos in English that are watched after logging in to the website, combined with exercises to do by yourself.
Can I ask questions?
Of course. In each section, you can add comments that allow you to ask a question and get an answer. Moreover, there are also available questions from other participants and my answers to them. And if that wasn’t enough, you can write or call me.
Can I repeat the lessons?
The course is designed so that you can take it at your own pace and watch it whenever you want. You can come back to the items you’ve watched, pause, rewind, and skip.
Can I share my login details with my friends?
No, the course is purchased individually. If you like the course, just recommend the site to your friends.
What if I don't like the package?
You have a 30-day full refund guarantee if this package does not meet your expectations. All you need to do is send a justification and the account number for the refund to the address bartosz@excelbiacademy.com.
How to contact in case of problems?
Write to me at bartosz@excelbiacademy.com or call +48 500 196 861
Will I get a certificate after completing the course?
The condition for obtaining the certificate is completing the course and completing the post-training task (individually after each course). The content of the assignment is included in the course itself. After meeting these conditions, you will receive a certificate and a bonus.
