Join the 1% of Excel users who know how to use
"the best new feature to happen to Excel in 20 years"
and improve your time to creating reports, developing advanced analysis and gaining new insights by at least 80%, guaranteed
Solving the Excel Pro daily challenges
As an Excel Pro, you are probably doing the following on daily basis:
If my guess is correct (or close enough), then I know exactly what you’re going through. I, too, am one of those Excel Pros who had to go through the above process over and over again. Although I really enjoyed working with data and I was well trained on the most flexible data analysis tool in the world, there were few things that were still holding me back (and I’m sure they are holding you back as well):
- You are grabing data from one or more sources.
- You prepare this data, usually using VLOOKUP.
- You create Pivot Tables over this prepared data.
- Sometimes you index into the resulting pivots, using formulas, to produce polished reports. Other times, the pivots themselves serve as the reports.
- You spend half of your time re-creating the same reports, updated with the latest data on a recurring basis.
If my guess is correct (or close enough), then I know exactly what you’re going through. I, too, am one of those Excel Pros who had to go through the above process over and over again. Although I really enjoyed working with data and I was well trained on the most flexible data analysis tool in the world, there were few things that were still holding me back (and I’m sure they are holding you back as well):
- I was very busy. A modestly complex report may require tens of hours of individual actions, and most of those actions need to be repeated when I receive new data or a slightly different request from my consumers.
- Integrating data from multiple resources is tedious. Excel is flexible, but this doesn’t mean it’s effortless. Making multiple sources play nicely together in Excel could be very daunting.
- Big Data doesn’t fit well in Excel. Sometimes data sets of thousands of rows can become really slow in Excel, especially when integrated with other data sets using formulas.
If any of this sounds familiar to you, then hang on tight because the world is about to change to your favor.
Superpowers that are built right within Excel
Back in 2010, Microsoft has introduced Power Query and Power Pivot to Excel. These 2 revolutionary technologies have enabled many Excel professionals worldwide transform the way they managed their data forever.
Power Query helps transform data from multiple sources much faster than doing the same with VLOOKUP, INDEX, MATCH, OFFSET, INDIRECT and other functions. When transforming and manipulating data, you’ll also be able to develop solutions faster and return results quicker via Power Query than compared to trying to do the same with VBA. You do the transformations once, and they will be automatically replicated every time the data changes.
Power Pivot is known to be the best new feature to happen to Excel in 20 years. It introduces the Data Analysis Expressions (DAX) which is a native formula and query language that was developed by the SQL Server Analysis Services team at Microsoft. This means it’s bringing SQL power right into Excel. It allows Excel to act as a Self-Service BI platform, where the user implement professional expression languages to query the data, calculate advanced measures and create complex data models that can be explored later on with regular pivot tables.
Now when both technologies are used together, can you imagine what do you get?
That’s right. MAGIC is what you get. Your Excel workbooks will seem as if they are on steroids.
Everyone around you will be easily impressed even with the simplest models you build. You will suddenly feel that you’ve become a Data Super Hero.
That’s not all…
Both technologies are completely learn-able to the ordinary Excel user. You don’t have to learn any new programming languages or complex data modeling techniques. You just extend the powers of “normal Excel” that you already know with new additional superpowers that snap right into Excel:
That’s right. MAGIC is what you get. Your Excel workbooks will seem as if they are on steroids.
Everyone around you will be easily impressed even with the simplest models you build. You will suddenly feel that you’ve become a Data Super Hero.
That’s not all…
Both technologies are completely learn-able to the ordinary Excel user. You don’t have to learn any new programming languages or complex data modeling techniques. You just extend the powers of “normal Excel” that you already know with new additional superpowers that snap right into Excel:
How Power Query and Power Pivot Transformed My Life (and Career)?
I have always regarded myself as an Excel Pro. I was able to create some of the most beautiful and complex spreadsheets that worked together in the same way that a highly trained unit of Navy Seals would work together. I was the go-to-guy in the office for any Excel challenge, and it made me feel invincible in some sort of way.
It was all fine and dandy, until I got assigned to a new job where I had to work on projects that required a level of analysis that I was not accustomed to before. Just to give you a flavor, the first project I worked on was a workforce planning analysis for our field engineers in Algeria (I worked for a company that sold healthcare equipment and services). The management needed to know how many field engineers do we need per product per city and how can we optimize their travel hours and make sure they are fully utilized; taking into account our current supply of engineers, the upcoming demand based on future equipment installations, and the current training level for each and every engineer.
So with so much data, relationships and parameters, I realized that it was much more than what a normal Excel pivot table could handle. To be honest I got a bit frustrated. It was the first time to come across a problem that I couldn't analytically solve with Excel. It felt like Excel has failed me for the first time after all these years (yes, it was that dramatic).
It didn’t take long until I discovered that my long time friend hasn't failed me after all; I was just not well informed. The day I discovered Power Query and Power Pivot was like the day man discovered fire.
What happened next? My job was literally transformed. I was able to build that complex workforce planning model in Algeria that impressed the team there. I then helped the team in Kenya cutting down the preparation time of a complex operational report from 2 days to just a couple of hours. I also enabled the team in Egypt to view a single scorecard with all the engineers’ KPIs instead of having to look at them from different files in different formats.
I just kept building one data model after another and enjoying the looks of astonishment on the faces of my bosses and colleagues.
The benefits?
Well, the functional benefits for me were that the analyses that took days in traditional Excel now take less than an hour, and most importantly, adjustments to those analyses are reduced to “seconds”. And it’s not just about “time saving”, but the “possibility of doing” as well. No level of analysis became impossible to do. I was generating reports that no one ever imagined was possible in Excel.
However the emotional benefits were the ones that really mattered to me the most. I felt smarter, faster, capable, better respected, more successful and happier. In less than a year in my role, I have been awarded for the benefits that my Excel models have brought to the business. And even better, my models were being shared across the “Global” teams in my company as best practices to be copied across different regions (including Europe and the US). If this is not fulfilling to an Excel Pro (or any employee for that matter), then I don’t know what is!!
So now that I have all this "power", I didn't want to just keep it for myself. You know, with great power comes great responsibility. And I do believe that my responsibility is to empower everyone working with data to be more efficient, productive, profitable, successful and happier, and this is exactly what you will get with the Excel Power Surge course.
It was all fine and dandy, until I got assigned to a new job where I had to work on projects that required a level of analysis that I was not accustomed to before. Just to give you a flavor, the first project I worked on was a workforce planning analysis for our field engineers in Algeria (I worked for a company that sold healthcare equipment and services). The management needed to know how many field engineers do we need per product per city and how can we optimize their travel hours and make sure they are fully utilized; taking into account our current supply of engineers, the upcoming demand based on future equipment installations, and the current training level for each and every engineer.
So with so much data, relationships and parameters, I realized that it was much more than what a normal Excel pivot table could handle. To be honest I got a bit frustrated. It was the first time to come across a problem that I couldn't analytically solve with Excel. It felt like Excel has failed me for the first time after all these years (yes, it was that dramatic).
It didn’t take long until I discovered that my long time friend hasn't failed me after all; I was just not well informed. The day I discovered Power Query and Power Pivot was like the day man discovered fire.
What happened next? My job was literally transformed. I was able to build that complex workforce planning model in Algeria that impressed the team there. I then helped the team in Kenya cutting down the preparation time of a complex operational report from 2 days to just a couple of hours. I also enabled the team in Egypt to view a single scorecard with all the engineers’ KPIs instead of having to look at them from different files in different formats.
I just kept building one data model after another and enjoying the looks of astonishment on the faces of my bosses and colleagues.
The benefits?
Well, the functional benefits for me were that the analyses that took days in traditional Excel now take less than an hour, and most importantly, adjustments to those analyses are reduced to “seconds”. And it’s not just about “time saving”, but the “possibility of doing” as well. No level of analysis became impossible to do. I was generating reports that no one ever imagined was possible in Excel.
However the emotional benefits were the ones that really mattered to me the most. I felt smarter, faster, capable, better respected, more successful and happier. In less than a year in my role, I have been awarded for the benefits that my Excel models have brought to the business. And even better, my models were being shared across the “Global” teams in my company as best practices to be copied across different regions (including Europe and the US). If this is not fulfilling to an Excel Pro (or any employee for that matter), then I don’t know what is!!
So now that I have all this "power", I didn't want to just keep it for myself. You know, with great power comes great responsibility. And I do believe that my responsibility is to empower everyone working with data to be more efficient, productive, profitable, successful and happier, and this is exactly what you will get with the Excel Power Surge course.
What you will get in Excel Power Surge is a “compendium” of what I have learned and applied over the years. There will be no technical jargon or heavy theories. Just the “practical” information that you need to hit the ground running in the shortest time possible.
Remember, I was in your shoes one day, and I wanted to make the quickest and biggest impact in my career. That’s why I know how to cut directly to the chase with the skills and techniques that you can apply right away with your own data and reap the multiple benefits of those power tools as quickly as possible.
How does it work?
After learning Power Query and Power Pivot, you will still create pivot tables and formulas (like you have always done in normal Excel), while adding a number of game-changing capabilities that will turbocharge your analysis and reporting skills.
1. Linking your reports directly to the data sources
Whether your data is in an SQL database, Access database or raw CSV or XLSX files, you can link your reports directly to where the data is sitting.
2. No more manual update
Once the data is changed or updated, your reports gets updated automatically. Do the data transformation once, and click a button to refresh it.
3. Connecting several tables from different sources together
No more VLOOKUPs, HLOOKUPs, or INDEX/MATCH
Produce integrated views of your business that were not feasible before
Produce integrated views of your business that were not feasible before
4. New “Smart” Formulas that are fast, powerful and portable
Tons of new functions that will help you in any situation (ex. DISTINCTCOUNT(), COUNTROWS(), TOTALYTD(), SAMEPERIODLASTYEAR(), CALCULATE(), …)
All functions work in pivots and auto-adjusts as pivots change in size and shape
Write the formula once and re-use it everywhere (no more re-writes)
All functions work in pivots and auto-adjusts as pivots change in size and shape
Write the formula once and re-use it everywhere (no more re-writes)
5. Limitless Data Capacity
Small, medium and Big Data are welcome.
Work with hundreds of rows or hundreds of MILLIONS of rows without the fear of having a slow, unresponsive or unreasonably huge Excel file.
Work with hundreds of rows or hundreds of MILLIONS of rows without the fear of having a slow, unresponsive or unreasonably huge Excel file.
6. Dynamic Dashboards
Build beautiful dynamic dashboards and reports that refreshes automatically when your data changes, and slice and dice through your data to extract actionable insights
Who can benefit from this course?
This course is typically for anyone who works with data. No matter where you are or what you do, you can apply these techniques in your job and Excel your data right away.
Sales
|
Operations
|
Finance
|
Marketing
|
Customer Service
|
Human Resources
|
Logistics
|
Startup Owners
|
Are you ready to be a Data Super Hero?
My promise to you is this: the skills and techniques that you will learn in this course will drastically transform the way you analyze and report data FOREVER. I’m so confident of this, that if within 30 days you found the skills you learned were not “transformational” enough, I will refund 100% of your money, no questions asked.
I will be available to answer directly any questions you have during the course, so that your online learning experience is as beneficial as possible. That’s why there is a limited number of seats available for each run, to ensure that I give the right focus and support needed for each participant.
In addition, after you complete the course, you will be invited to join our private Facebook Group where I, and a group of other data experts, will be personally answering any questions you may have later on in your data analysis and reporting journey.
In addition, after you complete the course, you will be invited to join our private Facebook Group where I, and a group of other data experts, will be personally answering any questions you may have later on in your data analysis and reporting journey.
What is included?
Course Contents
|
1. Introduction
1.1 What is Self Service Business Intelligence? 1.2 The Excel Data Model 1.3 Enabling Power Pivot in Excel 1.4 Introducing DAX: Data Analysis Expressions 2. Importing data to Power Pivot 2.1 Importing data from an existing file 2.2 Importing data from a database 2.3 Importing data from an Excel table 3. Shaping and Transforming Data in Power Query 3.1 Extracting and loading data using Get and Transform 3.2 Shaping data in the query editor 3.3 Extracting and loading data from multiple files 3.4 Extracting and loading data from a formatted Excel file 4. Creating Relationships 4.1 Create relationship across different data tables 4.2 Creating a Date table and connecting it to your model 5. DAX in depth 5.1 Creating Measures and Calculated Columns in the data model 5.2 DAX Basic Functions
|
6. Advanced DAX functions
6.1 FILTER() 6.2 Time & Date Functions
7. Visualizing Data in Excel 7.1 Adding Pivot Charts 7.2 Changing a Chart Type 7.3 Creating Hierarchies in the tables 7.4 Adding and Connecting Slicers 7.5 Cube Formulas 7.6 Conditional Formatting 7.7 Combo Charts 7.8 Polishing your Dashboard |
Course Duration: 10 Hours
Language: Arabic
Price: TBD
Language: Arabic
Price: TBD
|
All participants of the course will get:
|
|
