Everyone's talking about AI, and it's time for you to join the conversation!

Discover how real-world Excel problems can be solved using AI, saving you hours of work. This course will ensure you stay ahead of your colleagues with the power of AI.


Tired of repetitive clicks and keystrokes in Excel?

Macros are code that perform thousands of clicks and keystrokes in seconds. With AI, you can create these time-saving codes in seconds. Less time on data cleaning and more time for analyzing and utilizing your data!


10+ years of Excel experience packed into one course...

...with structured videos to take you to the next level. Learn how to pull data from 100 files with one click, create stunning Power BI dashboards, and ensure every chart and table matches your company's colors within seconds.

Examples from real life

Scenario 1

A colleague had 347 sheets with intercompany balances to reconcile every month, one sheet for each company in the group. She copied and pasted data into a new sheet and, after a couple of hours, began the reconciliation by manually adding and subtracting cells.

Solution You Will Learn

A macro that completes this task in a heartbeat with ZERO human errors. Who writes the code? AI!

Scenario 2

The annual budget involved 57 cost centers, each with its own Excel file that needed to be consolidated. I used to open a file, copy its contents into the summary file, close it, and then open the next one. A new version? Start all over again.

Solution You Will Learn

With Power Query, connect to ALL files and load the data into Excel. For new versions, simply replace the file and press "Refresh All."


Scenario 3

I used to reformat the PivotTable to my preference every single time. I used the same commands in different tabs and often struggled to find them. Additionally, it took me a lot of time to color the cells to match the company's branding guidelines.

Solution You Will Learn

Tips and tricks to work smarter in Excel: How to change the default settings of a PivotTable, add commands to the Quick Access Toolbar, and instantly apply your company's colors to all cells and objects.

Meet Your Instructor

Rickard Bäck

Founder & Chief Excel Officer

🔍 Former Auditor at Big Four - KPMG

🚀 Reached Millions on Social media

💼 A Decade of Excel Experience

Learn Excel with me — Fun and engaging guaranteed!

✉️ [email protected]
👨‍💼 LinkedIn Profile


You are now close to automate painful 3-hour tasks with a simple click of a button!


Course Description

PivotTables and PivotCharts - Calculate, summarize, analyze, and visualize data effectively.

Various ways to work faster - Shortcuts, quick access commands, apply your company's color profile to everything in seconds, and much more.

AI  integration - Learn what AI is and how to use it effectively. Focus on ChatGPT and built-in AI capabilities like Copilot and Data Types.

Macros - Automate clicks and keystrokes without knowing how to write the code yourself. Discover the capabilities of macros and learn how AI can handle the heavy lifting for you.

Power Query - Automate repetitive tasks and load data from thousands of files with a single click. Often more useful than Macros!

Power Pivot - Combine multiple datasets into a single PivotTable!

Power BI - Create stunning dashboards with ease.


Designed in 2024 for 2024. Courses older than two years (pre-AI) are a waste of your time.

Course curriculum

    1. Excel Automation with AI - Practice Workbook

    2. Download Bonus material

    1. 101 - Welcome

      GRATIS DEMO

    2. 102 - Excel Automation

      GRATIS DEMO

    3. 103 - Types of Automation

      GRATIS DEMO

    4. 104 - Use cases

      GRATIS DEMO

    1. 201 - PivotTable and PivotChart

    2. 202 - Create and customize

    3. 203 - Change basic settings

    4. 204 - PivotChart

    5. Quiz Module 2

    6. Task Module 2

    1. 301 - Quick access toolbar

      GRATIS DEMO

    2. 302 - Shortcuts

    3. 303 - Create your own tab

    4. 304 - Templates

    5. 305 - Change default settings

    6. 306 - Themes, colors and fonts

    7. Quiz Module 3

    8. Task Module 3

    1. 401 - AI

    2. 402 - AI tools inside Excel

    3. 403 - AI-tools outside Excel

    4. Quiz Module 4

    5. Task Module 4

    1. 501 - Introduction to Macros

    2. 502 - Recording and editing

    3. 503 - VBA Editor

    4. 504 - Variables

    5. 505 - Loops

    6. 506 - Conditional statements

    7. Quiz Module 5

    8. Task Module 5

About this course

  • 129,00 kr
  • 49 lektioner
  • 2 timmar videoinnehåll

Who is this course for?

Working Professionals

Working professionals who feels familiar in Excel and now feels like:

Efficiency Enthusiasts: Love the idea of making Excel do the heavy lifting for you.

Data heroes: Want to take their Excel game to a wizardry level.

Career Climbers: Aim to add a sparkle to their resume and stand out in the job market.


"... the course breaks down complex concepts without the usual daunting 10-hour commitment!"

"...  It's about working smarter, not harder!"

"...  The instructor made learning not just educational, but enjoyable."


More reviews


Excel Automation with AI

Get ready to dive in!
This is what the course is all about:

  • 8 Excel Training modules

    Dive into the newest AI capabilities within Excel, along with other tools that turbocharge your work. Round off each module with a quiz and a task to assess your skills.

  • 50+ Training Videos and Worksheets

    Follow along, watch again and learn at your own pace!

  • Bonus material

    $122-value vault of ready-to-use templates & guides! Curious? More details.

ExcelBerry Guarantee

We are so confident that this course will meet your learning and growth objectives that we offer a full refund if you are not satisfied within the first 30 days.

Send us an email ([email protected]) letting us know and we'll send your money back. No hassles, headaches or hoops to jump through.

Bonus Material

In addition to the course material, you'll also gain exclusive access to valuable bonus documents that can further refine your Excel skills and improve your productivity. Valued at $122!

Here's a sneak peek:

Price: $129

INCLUDES:


✓   Lifetime Access to Full Excel Curriculum

✓   Excel Course Completion Certificate

✓   $122-Value of Bonus Material

✓   Money back within the first 30 days if you are not satisfied

Get Access Now - $129

Testimonials

“Very good course with a complete overview of the tools available in Excel and other software that can facilitate work. I got many practical tips and inspiration for continued exploration. Rickard was excellent! He gave very engaging presentations, was knowledgeable, and managed to cover everything in this course.”

Lotta W

“ I think that your explanations are clear and comprehensive, videos are visually appealing, content is interesting. Well done. Just consider warning to the users to watch after eating something. Those berries look so delicious and distracting 😄😄😄”

Kolyu M

“Overall, i think you did a great job. Hope lots of people will buy this course. I think it is pretty useful.”

Martin B

“The course breaks down complex concepts without the usual daunting 10-hour commitment!! The lessons are concise yet comprehensive. The interactive elements keep learners engaged, well done.”

Erik S

“Thank you for the great information. I have worked in Excel for several years, but I am not very familiar with these functions. The data types function was very insightful, as well as data analysis. Many thanks. I think you go through it at a good pace without it taking too long. Very intuitive and good tips on shortcuts. This will make one's job easier in the future. Here too, you have a good pace to go through it.”

Magnus L

“When I read that we were going to use ChatGPT, I was a bit skeptical. I thought that I wanted to be able to do this myself, on my own. But it was great, and I have used ChatGPT frequently after the course, for example, to write macros.”

Anna S

“I have seen colleagues write macros before and thought that I would never be able to do that. This course changed my perspective. It’s about working smarter, not harder!”

Sophia S


FAQ

  • What Excel-level do I need?

    This course is designed for intermediate Excel users, but it does not require previous experience with VBA, AI, or other tools covered in the course.

  • How is this course different from other VBA courses?

    This course goes beyond VBA, providing comprehensive strategies to boost your efficiency in Excel. You'll learn how to leverage AI to elevate your Excel skills to new heights. Through real-life tasks and targeted questions, you'll master the most critical aspects effectively.

  • Can I add a course certificate to my LinkedIn or resume?

    Yes! Upon finishing this course, you'll be awarded a Completion Certificate, which you can proudly add to your LinkedIn profile or resume.

  • How long time can I expect this course to take?

    How long time does it take to binge watch a Netflix-series? If you really take the time to go through all material provided, it takes up to 5-10 hours.

  • Is there a deadline when I have to finish the course?

    No. You can complete the course at your own pace, as it will remain accessible to you at any time that suits your schedule.

  • Can I buy the course for my team?

    Yes, a discount is available! Please email [email protected] to learn more.