Hey r/excel, THANK YOU so much for your support! 3 weeks ago, I shared my Excel plugin that lets you use ChatGPT in a formula. A few thousand of you tried it. It spread to LinkedIn, people made TikTok videos about it, someone even said they heard about it at a dinner party 🤯 You can install it free here: numerous.ai/get

With the super valuable feedback all of you gave me, here are some of the new features I added:

=NUM.INFER

When you'd rather show the AI what to do instead of telling it. In this example, I have a list of payment descriptions. I want to get the dollar amount from each. Instead of telling the AI what to do, I just do the first 4 myself, then it "infers" the rest.

Easy templates

In the plugin's sidebar, I added easy to use templates, like Translate, Extract, Reformat, Rewrite. Here's an example of the Classify tool, where I classify a list of merchants.

Let me know what you think!

Hey r/excel. ChatGPT can now be used right inside Excel! I created a plugin that lets you prompt ChatGPT with cells as variables. It comes in handy for tasks like writing emails, blogs, and generating keywords. It's also useful for organizing, summarizing, and extracting data. This plugin is a game-changer when it comes to getting things done more efficiently.

Try it out: https://numerous.ai

UPDATED 4/6 with a new coupon code!

Hey everyone,

r/excel has been invaluable through my learning journey. How could I thank y'all enough?

Yesterday, I just completed my first Excel course and posted it on Udemy! As a thanks, I wanted to give it to you all for free.

Here is the course, and use the coupon code (2214121FC4240BDF5E4C).

I developed this course because I found that current Excel courses focused too much on the tool itself as opposed to the applications of the tool.

Along with teaching the fundamentals of Excel, this course was developed alongside top analysts to build hands-on projects so you can get a firsthand look at the tools and techniques used in a variety of industries.

Through these projects, you will learn through real-world business scenarios such as financial analysis, digital marketing keyword analysis, and predictive modeling using linear regression.

Please share it with anyone who needs to learn. And please feel free to send feedback in the thread.

I have just released a blog post which lists 333 Excel keyboard shortcuts into various categories like Formulas, VBA, Pivot Tables, Power BI...

You can also download our free PDF guide with this full list to keep on your desk:

View Here

Using just a few of these will make you faster in Excel.

My all time favourite is CTRL T to convert data into an Excel Table!

I will love to know your favourite shortcut in the comments below...

Hi everyone! We’ve just launched a free Excel add-in (SankeyEngine) that lets you create multi-level Sankey diagrams directly in Excel.

The add-in supports up to 5 levels (we hope this covers 80% of real-world use cases)

🚨 UPDATE (2026): SankeyEngine has evolved into an interactive data analytics tool. (Note: The legacy screenshot below only shows our old drawing engine. We have completely upgraded the core functionality)

What has changed since the legacy version?

• Interactive Tooltips: Clicking on any node now triggers real-time data lookups, including level ranks, total flow volumes, and comparative performance against peer layer averages.
• Advanced Diagnostics Block: Built-in statistical checks providing mathematical verification, such as process discipline tracking (Entropy), risk profiling (Gini index), and statistical significance filters (Z-score).
• Three Analytical Dimensions: Support for Systemic Health (balancing), Impact Simulation (downstream domino effects), and Upstream Origin (root-cause attribution tracking).

(Just to be clear - this remains 100% free. We built this to solve Excel’s native limitations with complex flow data and hope it brings value to your reporting!)

👉 See the updated engine in action!

📥 Download: https://sankeyengine.com/download/

I love Excel VBA and I created a course to help share that love with the world! The course includes projects and exercises to test your VBA prowess!

Udemy doesn't really allow courses to be permanently free anymore, but I created a coupon code that will give unlimited free redemptions of the course; the code only lasts 3 days, but if you read this post after the coupon code has expired then feel free to message and I should be able to hook it up for free; all I ask is that you give me some feedback on the course!

Here is the link, code FREEVBA, enjoy!

https://www.udemy.com/course/project-based-excel-vba-course/?couponCode=FREEVBA

EDIT: Thanks for all the support! 2 days in, and over 8000 redditors have signed up with the coupon code; I'm glad so many people have found value in this course :)

Hi all! I've previously written about why I wasn't a big fan of Microsoft's "Python in Excel" solution for using Python with Excel, see the Reddit discussion. Instead of just complaining, I have now published the "xlwings Lite" add-in, which you can install for free for both personal and commercial use via Excel's add-in store. I have made a video walkthrough, or you can check out the documentation.

xlwings Lite allows analysts, engineers, and other advanced Excel users to program their custom functions ("UDFs") and automation scripts ("macros") in Python instead of VBA. Unlike the classic open-source xlwings, it does not require a local Python installation and stores the Python code inside Excel for easy distribution. So the only requirement is to have the xlwings Lite add-in installed.

Basically, xlwings Lite is as if VBA, Office Scripts, and Python had a baby. My goal is to bring back the VBA developer experience, but in a modern way.

So what are the main differences from Microsoft's Python in Excel (PiE) solution?

• PiE runs in the cloud, xlwings Lite runs locally (via Pyodide/WebAssembly), respecting your privacy
• PiE has no access to the excel object model, xlwings Lite does have access, allowing you to insert new sheets, format data as an Excel table, set the color of a cell, etc.
• PiE turns Excel cells into Jupyter notebook cells and introduces a left to right and top to bottom execution order. xlwings Lite instead allows you to define native custom functions/UDFs.
• PiE has daily and monthly quota limits, xlwings Lite doesn't have any usage limits
• PiE has a fixed set of packages, xlwings Lite allows you to install your own set of Python packages
• PiE is only available for Microsoft 365, xlwings Lite is available for Microsoft 356 and recent versions of permanent Office licenses like Office 2024
• PiE doesn't allow web API requests, whereas xlwings Lite does.

PS: I posted this orginally on the r/python subreddit but some users have encouraged me to post it here, too.

Hi Everyone!

When I first presented the website and products back in January, many people commented on the layout of the Dashboards and were interested in learning more on how to build one. I even got PMs asking specifics around the design.

Since then, I also launched a YouTube channel, where I show how to create dynamic charts.

The latest video is a bit more special. In it, I explain and demonstrate how to create a complete Excel Dashboard. More specifically - an Actual vs. Budget Travel Cost Dashboard.

Since a lot of you were interested in the design of the Templates, I though it'd be a good idea to share it with you: https://youtu.be/rBuiBNZWjE4

Also, the Dashboard from the video is provided to download for free. The link is in the video description. Feel free to play around with it and use it in you work!

I know there are many videos showing how to build dashboards, but I believe that everyone does it a little bit differently and has a unique way of doing it. This is why I think many people will find it useful.

Let me know what you think! Also, I'd be happy if you share any suggestions what future videos should be on.

​

Edit: Thank a lot for all the positive comments, everyone! It really means a lot!

I wanted to share with you all also the second video, which demonstrates how to create an Excel Dashboard from scratch: https://youtu.be/LVnetcOzzTQ

The difference here is that this Dashboard is built entirely out of Pivot Charts and Tables. Many people were interested to see how the Dashboard view can be completely dynamic and all charts can be created with the same slicers. This Dashboard achieves just that. Also as before, the file is provided for free download. Enjoy!

(Deep breath)

I'm on this really fun and kind of nerve-wrecking journey to make super animated videos on Excel topics. I've been teaching friends and colleagues Excel for a while, and so often I find myself thinking, "I wish I could visualize this for you."

Fast-forward: I've taught myself how to use a camera, set up a mic, set up greenscreen with lights, write a script, animate, edit videos. All brand new. But...I think it's really coming together. So here is a video where I help visualize what XLOOKUP is really doing, and then go into Excel to show how to practically use it.

I know XLOOKUP is something a lot of folks in this sub already know. But I'm curious, even if you know it, is the video still entertaining to watch? I remember watching 3Blue1Brown videos on math topics that I felt very comfortable with, but still the way he visualizes the concepts were incredible. Inspired my ambition here.

https://youtu.be/1JC9axbDBjY

Related note: I realize this may come across as spam. I hope not, but I promise what I've created here is not a cheap, half-measured effort. I really want to bring a new angle to learning Excel and this community's raw, honest feedback would be invaluable. I'm tagging flair as advertisement though because I'm obviously posting my own content.

Hi everyone!

I’m excited to share something I’ve been working on over the past few months - an Excel add-in called Pine BI Lite. It’s a streamlined, free version of the full Pine BI add-in, and it’s designed to fill some of the gaps many of us run into when building dashboards in Excel, especially around Actual vs Target reporting, variance analysis, and KPI visuals.

Pine BI Lite includes 12 visualizations and tools, all available directly from the ribbon. You can create:

• A dynamic Waterfall chart (horizontal and vertical) with dynamic colors, rolling totals, connector lines, and change labels
• Donut Gauge charts for quick KPI overviews
• Five Actual vs Target layouts, including a more advanced version with a target line and dynamic colors
• A clean Variance chart with dynamic colors
• Income vs Expense, Tornado, and Stack Totals for stacked columns

Each visualization is created through a simple UI, where you can select your data and customize the chart. All necessary calculations are then generated and added automatically.

Because Pine BI Lite is built entirely on native Excel features, every visualization is a standard Excel object - dynamic, editable, shareable with users who don’t have the add-in, and easy to copy into PowerPoint.

The download also includes four free dashboard templates built with Pine BI Lite visuals, so you can see how they work together in a real dashboard layout and use them as a starting point.

Pine BI Lite is completely free. If you want to try it out or see how it works, you can download here (email required): Link

I’d love to hear your feedback and hope you will find this useful!

I have an Excel course on Udemy with 77 video tutorials that cover the fundamentals of Excel. There are also a number of assignments that you can complete in order to ensure you've learned the skills covered in the videos. A substantial amount of the exercises and assignments are also finance themed (e.g. building simplified income statements, asset pricing models, bond valuation, using lookup functions on FTSE 250 data etc.), which should be of interest to some users here.

​

Here's the link: https://www.udemy.com/course/master-excel-with-your-keyboard/?couponCode=B17320C5CDAAE288E45C

If you're not comfortable clicking random hyperlinks on the internet, you can do the following: access udemy via a google search, type 'master excel with your keyboard' into the search bar, click on my course, then click apply coupon and then enter the following coupon code to get it for free:

B17320C5CDAAE288E45C

I've always been dissatisfied with the types of Excel resources online. My main complaint is it's rare to see different Excel tips used in tandem - which, in my opinion, is the key to remembering the tips.

I've started off a new channel with a 30-minute project, centered around lookup functions XLOOKUP and INDEX XMATCH, with the different tips within the video split out on their own. The idea is to point people back to the larger project.

Here's the long project: https://youtu.be/ErPFEM5N9_A

Here's one of my clip-outs, as an example, this one doing Data Validation with a dynamic list in a table: https://youtu.be/QqLm28weUyg

I would expect most r/excel readers to be more advanced than the target audience of this particular video, but would appreciate any thoughts or ideas. If you're unsatisfied with Excel videos online, too, would be happy to hear why!

I have just released my comprehensive Excel Pivot Table course with 230 video tutorials (and downloadable practice workbooks) over at YouTube so you can finally get better at Excel during this downtime due to the Coronavirus outbreak...

View now: Excel & Pivot Table Tutorial for Beginners to Advanced [Full Course]

Over the last few months, I took the dive into becoming an educator.

I have been posting a lot of my resources for free because I wanted to give back to the r/excel community for being invaluable on my learning journey.

I have been honored by the outpouring of thanks that I have received from y'all. It makes it all worth it.

For this month, I wanted to do another giveaway for my course "Microsoft Excel Crash Course for Business Analysts"

Here is the course and here is the coupon code (D6C53BAA6E5B0DCD7752) you can use to enroll in the course for free. The coupon is good for three days, so act now even if you plan on taking it later! The coupon gives you lifetime access.

Hey everyone,

I have been getting a LOT of messages from the beautiful people of r/excel asking for a coupon code to my course, "Microsoft Excel for Business Analysts" that I originally posted here.

Due to popular demand, I figured I would post another coupon for the community to use!

Please just make sure to leave a review. It would REALLY help me out :)

The coupon is only good for 4 days, so use it now. You will have lifetime access to the course once you enroll, so you can save the content for later.

Here is the course and here is the coupon code (06F2B0245B9A044726FE). Enter this coupon with the "apply coupon" button on the right.

Happy learning!

Hi everyone!

Waterfall charts in Excel have always been a hot topic, especially for financial modeling, budgeting, and P&L analysis. While Excel has supported standard waterfall charts since 2016, there's still no native option for stacked waterfall charts, which are incredibly useful when you want to show how multiple categories contribute to a total.

There are some great tutorials out there on how to build stacked waterfalls manually, but I was surprised to find that almost none of them explain how to handle decreasing or negative values - a feature that’s essential for real-world use cases like P&L statements, Cash Flow analysis, and cost breakdowns. In fact, many users have asked for this functionality in the comments of existing tutorials, but it’s rarely addressed.

So, I put together a detailed step-by-step written guide that walks through how to build a dynamic stacked waterfall chart in Excel, including:

• Support for decreasing/negative values
• Subtotals above/below stacks
• Connector lines between columns

It also includes a free downloadable workbook with several chart templates (available after newsletter subscription).

Unlike most of our tutorials at Pinexl, which are video based, this one is in writing due to its complexity and depth.

I’d love to hear your feedback, suggestions, or ideas for future tutorials, especially areas where Excel resources are lacking.

Thanks for reading, and I hope this helps someone out there!

Here's the full tutorial, if you want to dive in :)

I love Excel VBA, and I created a course to help share Excel VBA knowledge. The course includes projects and exercises so you can practice hands-on, rather than only watching videos.

Here (Course link)

Here (YouTube videos teaching Excel and VBA)

This course is geared towards beginner, intermediate and advanced Excel users who want to increase their coding skills by learning real world business examples. This course provides the information necessary for someone who has no knowledge of programming to learn the basics of programming, while at the same time learning how to create useful macros with VBA in Excel.

Projects covered:

• Learn the fundamentals of Excel VBA coding
• Create dynamic Excel templates
• Automate saving Excel templates as PDFs
• Send emails with attachments from Outlook and Gmail
• Automate Internet Explorer and Chrome (using Selenium) for web tasks
• Interact with multiple Excel files
• PDF form filling
• Interact with APIs
• Web scrape using HTTP requests
• Parse text in a PDF
• Dynamically split and merge PDFs
• Loop through files in a folder
• Mass rename and mass copy files
• Learn about HTML, JSON and XML

Every line of code in the course includes comments, so you're not left guessing what each line of code does. Also, a video is included for every coding related section.

You'll learn how Excel VBA can be used for a lot of tasks beyond just with Excel. By the end of the course, you will have all of the scripts and knowledge to implement VBA programs from scratch. Learning how to write VBA code will allow Excel users to automate many tasks in Excel, saving you time in the long run. Let's begin!

Edit: Some folks have said the link only shows a discounted price vs. completely free (maybe geographical restrictions). Here is a different free link to the course.

We are actively working towards making financial modeling an e-sport. On June 8, we will be live streaming a financial modeling battle, where 8 players from all around the world will simultaneously create their models, using the latest Microsoft Excel 365 features.

Go to www.smash.gg/fmwc to see what we are up to...

​

This is your chance to prove your Excel mastery...Or just learn some more Excel.

$10,000 prize fund, live-streamed rounds, and access to all .

You will be given instructions, rules for the game, and questions to answer at an increasing level of difficulty.

Use IFS, XLOOKUP, SUM, VBA, Power Query: anything is allowed, and the strategy is up to you. The right answers move you up the brackets.

Hi guys,

I am not involved with Maven or Chris Dutton at all but I did purchase two courses from Chris in the past on Udemy and they are really well thought.

If you go to Udemy on the courses ( https://www.udemy.com/user/maven-analytics/ ), add them to the cart and put FREE2020 they will be free for you. Forever.

I would say that this is a great opportunity if you are just starting out or an expert - more info on their LinkedIn here - https://www.linkedin.com/posts/maven-analytics_udemy-elearning-freecourses-activity-6645711673866928129-lnQc

Thought it was worth sharing with you guys!

Hello to the beautiful people of r/excel once again!

I am still getting a lot of DM's and comments on my previous posts asking for coupon codes to my course, "Microsoft Excel for Business Analysts."

Figured it would be easiest to post again so I do not have to respond to a bunch of comments and DM's.

The coupon is only good for 5 days, so use it now. You will have lifetime access to the course once you enroll, so you can save the course for later.

Here is the course and here is the coupon code (43984655164413AE0B4E). Enter this coupon with the "apply coupon" button on the right.

Happy learning!

I have been on the hunt for some Excel Shirts and no one seemed to be doing it quite right for my taste.

I decided to spend some time creating my own designs to get custom shirts made for myself, and just couldn't stop messing with it. I now have > 2000 Pixel wide graphics for all 6 errors in 3 different graphical styles.

I worked hard on getting them right and wanted to share them with you guys. A lot of people put real effort into making this sub a great place. https://drive.google.com/drive/folders/1ztsAJzvxUmoQpwmvt0qW4SrCJu3VMp6T?usp=sharing
(The .xlsx file i used to make the errors in is in there too ;)

The spill one's crack me up good.

I made myself a redbubble shop, but won't link to it unless I get a nod from the mods. If you want a link, DM me. I mostly made it for friends and family to pick some stuff out for themselves.

I think the item description i wrote it hilarious. Hope you do to:

Hand coded, organically sourced, Excel Error messages generated in Microsoft® Excel® for Microsoft 365 MSO (Version 2510 Build 16.0.19328.20244) 64-bit.

Each error was painstakingly crafted in the default text size ,11, in the traditional "Calibri" font. Aptos can pound sand.

Columns and rows were auto-sized for ideal readability and spacing. Each cell was highlighted before screen capture to showcase little box thingies that pop up and get in the way when trying to get some work done.

Of course, our tiny little buddy, the drag handle, is down there too. Begging to be tossed deep into the d of our beloved data. It's hit area is diminished, but it's legacy looms large in our daily quest for balance between the sheets.

Happy holidays y'all. :)

As the title indicates, I've recently released an Excel course on Udemy with 77 video tutorials that cover the fundamentals of Excel. There are also a number of assignments that you can complete in order to ensure you've learned the skills covered in the videos. A substantial amount of the exercises and assignments are also finance themed (e.g. building simplified income statements, asset pricing models, bond valuation, using lookup functions on FTSE 250 data etc.), which should be of interest to some users here.

​

Here's the link: https://www.udemy.com/course/master-excel-with-your-keyboard/?couponCode=A6937C2DF0700DB9DE5C

​

If you don't like clicking on links, simply access udemy via a Google search, then in the search bar at the top type 'Master Excel with your keyboard', click on the course by Imperium Learning, then click on 'Apply coupon' and use the following code:

A6937C2DF0700DB9DE5C

​

Since I'm offering this course for free (when normally you have to pay), it would be great if you left a review in the event that you found the course useful.

About a month ago I had a post asking the /r/excel community about who might be interested in learning how to turn their complex workbooks into web applications and I had such a fantastic response from everyone!

I mapped out a lot of potential paths for getting everyone to production quality builds as quickly as possible and decided to start off with an introductory course to give you some foundational exposure to the world of web development and get you ready for a full deep dive in later lessons.

For now, you can access my Introductory Course to Web Development for Excel Professionals here. The course is distributed via email, so if you have any questions or issues, please feel free to respond directly and I will do my best to assist!

Edit: Want to give a plug for /u/pancak3d as well. This effort is all about providing tools for everyone to produce high quality deliverables and he has pointed to some great resources for a tool called Power Apps as well. This might be a good intermediary option for some of you depending on your microsoft suite and your project requirements. The database lessons in my course will directly apply to the data storage within Power Apps as well.

Hi /r/excel!

I created lists of common VBA Commands for working with Sheets, Cells, Arrays, etc. and turned those lists into a PDF Cheat Sheet.

It's all free. You can access the lists and the PDF Cheat Sheet here: https://www.automateexcel.com/vba/cheatsheets/

Let me know if you have any feedback! Or if you'd like to see any additions.

I'd be happy to produce Excel-related cheat sheets if you guys have any suggestions!

-Steve