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

https://i.redd.it/3unkp1wpfwua1.gif

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

https://i.redd.it/8dewl0frfwua1.gif

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!

My life changed a month and a half ago and it started on this subreddit.

I made a post asking people to try out my website - excelformulabot.com

I was just looking for some testers. That post led to a couple more, which turned into the site blowing up on TikTok from a big productivity influencer, who had over 4.5M followers.

That TikTok video led to 25+ more TikTok videos, among Twitter posts from productively influencers.

My life hasn’t been the same since.

With my site unexpectedly going viral, I was ecstatic but also shitting my pants. The cost of the AI that powers the site cost money.

I quickly racked up several thousand dollars is API costs.

I added a donation link, where I fortunately was able to recoup roughly half of the cost.

I purposely decided not to add a pay wall at the time. I felt that there was a reason as to why the site took off - some random dude make a badass website to help 750M Excel users around the world and he’s offering it for free.

It was one of the best decisions I made. Nearly all of the publications and social posts about my site contained the word “free.” People love free. I strongly believe that had I immediately put up a payday, it would not have gotten the traction it did.

Fast forward a month and a half later, today is my official launch day. I’ve had a whopping 350K users to the site since. I did a soft launch a couple days ago and have already generated $700 in subscriptions - monthly and yearly.

I hope you enjoyed my journey and I’d be kicking myself if I didn’t shoot my shot - so here’s my Product Hunt webpage if you’d like to support my website and receive a 40% promo code.

https://www.producthunt.com/posts/excelformulabot-com

Enjoy!

David

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

https://i.redd.it/cuwbd1rs84sa1.gif

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.

(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.

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 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 to the people of 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. If it already says "free", go ahead and check out.

However, if it does not say free, here is the coupon code (A59644E31042842D6FD7). Enter this coupon with the "apply coupon" button on the right.

Hi,
One thing I haven't seen a lot of are games made using Excel - obviously there are graphical limitations, but I have been having a whole bunch of fun makign excel games (mix of formala and VBA).
Would love feedback on some of the games I have made.

1) Adventure game in style of Oregan Trail : https://youtu.be/sdi73Pr7-jI?si=bmkLYTWX18I94VMd
2) Wordle in Excel : https://youtu.be/5Ier4ttf-5M?si=Iiiodzrbt-5fKVx3

3) DnD style/ Baldur's Gate style game : https://youtu.be/jhsi9EnbzkY?si=gkP-ZmIRhbEeM2q5
4) Pokemon battle style game : https://youtu.be/L0Jbef84p00?si=Ivbu7BW1Jzd9K9Mv

Warning I am not an excel expert - but really enjoying using my skills doing somethign slightly different. Please provide feedback/ thoughts.

​

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!

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.

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 :)

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 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

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!

I'm building a mobile app to help users learn spreadsheets (excel and google sheets) through gamified experience. It's free. Available for both Android & iOS. Do you think it might be useful for you?

https://apps.apple.com/us/app/nuum-learn-spreadsheets/id6502941256
https://play.google.com/store/apps/details?id=nuum.tech.app&pli=1

I am looking for users feedback: what you'd like to learn, what you like in the app, what you don't like, any feedback is much appreciated! Thank you!

​

https://preview.redd.it/7o7l2hnb11p91.png?width=1920&format=png&auto=webp&s=c0f32b1b921e33f0d4944b7d097dafbf9963fdde

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.

Hello everyone,

Tabula, a free tool to extract table data inside PDFs

Very simple guide this time, I just want to present you a totally free tool that I often need myself using when i'm in the rush and need a specific table data in a oneshot kind of task.

Tabula is an excellent tool which I often find myself using when I do not have enough time to make a PowerQuery or for some reason PowerQuery is not interpreting well a document that Tabula does a better job of reading.

How to use it ?

https://www.youtube.com/watch?v=DH2Tuz3SZmg

The process of using it is extremely simple, all you have to do is indicate where the table are located on the PDF, and tabula does the rest. It will extract the tables and output it in a CSV.

There are very usefull features, like being able to save your "Template". The "Template" is the location of all the Red Rectangle you made, that way if you encounter a new file, but with the same format, you can reuse this "Template" on it.

It can also automatically detect tables***,*** and to make it more user-friendly, let's say you have a 125 page report which consists of a big table. You can just draw the first rectangle, and then use the "Repeat to All page" button to repeat this same rectangle on the next 124 pages in one click.

It's entirely free and can be used online :
http://tabula.ondata.it/

PDF Sample : https://lvmh-com.cdn.prismic.io/lvmh-com/ZnBAeJm069VX1zyr_Communique%CC%81-LVMHRe%CC%81sultatsannuels2023.pdf

Example

How to install it locally on your machine :

http://tabula.ondata.it/ is the online version but you can also install it on your computer :

Go to : https://tabula.technology/ and on the left menu, click on one of the buttons based on your OS. Unzip it somewhere on your computer, and launch it.

It might ask you to download Java, go ahead and do so. Once Java installation is done, relaunch tabula and it should open a terminal turn for 15-30 seconds then open a window on your web browser.

If your terminal get stuck on : INFO: using a shared (threadsafe!) runtime press Ctrl+C once and it should execute itself normally.

At some point I used it because I wanted to build an invoice parser tool, but while it was very usefull for ponctual task, it wasn't a 100% reliable enough to fulfill my goal. In the end I chose to do this using LLM.

I am a software engineer building a comprehensive platform called sheetsinterview.com to streamline the process of evaluating Excel skills for job applicants. Similar to how LeetCode or HackerRank offer coding assessments, my platform focuses on Excel proficiency.

The problem I am trying to solve is quite obvious: Most jobs these days require Excel knowledge, otherwise, this subreddit would not exist. But most often I would not test those Excel skills in the interview process. If I do, I will send over an Excel file with a specific task to solve.

The platform is solving that by giving you, as interviewer, a variety of tasks that you can send to the candidate, testing their Excel skills. Once you have emailed the candidate, they can open a link and enter a passcode to start the task. You can set a time or give them unlimited time. All works in the browser with our own "Excel IDE" where most formulas are supported. It's not perfect but I am looking for feedback and some alternatives - I currently use FortuneSheet but might use univer soon which has better support for pivot tables for example which the platform currently does not support.

Looking for feedback overall here from the sub. If you want to sign up and use the platform for free, you can use the link: https://sheetsinterview.com/login/reddit-excel

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.

Hey guys, I (24M) built this powerful Excel tool over this weekend. Just explain the formula and AI will write it for you. I shared it with friends who work at companies like Deloitte and they rave about it!

Best thing is you can use it inside Excel or Google Sheets on Chrome browser. It can do complex SUMIFS, VLOOKUP and much more with the help of LLM AI models that I have fine tuned on a dataset of over 40K formula combinations.

You can get it here: Excel AI

https://i.redd.it/ejgxywdm8d0a1.gif

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]

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...

https://preview.redd.it/fsphaupkr2371.png?width=1641&format=png&auto=webp&s=e1c4a10aa66041a1c5e3eeb50cef3b3476a4a2ac

https://sheetmule.com/

SheetMule takes a description/prompt and outputs an Excel formula.

EDIT: NO LONGER REQUIRES EMAIL SIGN UP

Hey, I've been developing this product for a few months now.

It can be buggy and inaccurate sometimes but we are working hard to fix it.

Hope you find this useful!

following this thread Homegrown Excel solutions at Enterprise scale? : r/excel (reddit.com)

Intention of this thread

Here—presumably—we all love Excel. We all probably know its shortcomings. And its strengths.

My intention of this thread is to discuss navigating its shortcomings while leaning into its strengths.

But, why??

When you start outgrowing your Excel workbooks,

one option is to treat them as a "phase 1" proof of concept. And to re-engineer them into a more mature (web?) app with database, etc.

Re-engineering obviously costs something and the risk of not perfectly re-engineering all the logic and exceptions can also be great (sometimes 9,000+ formula relationships!! — see screenshot below). Not to mention user learning curves, migration, and other hosting/services license costs.

Another option is to become an expert in various technologies to build the connections/automations to level up your Excel sheet into a more reliable solution for more than 1-2 users. This is basically what I'm presenting for discussion here.

But, what??

Real-life example of what I'm talking about here (pardon my country accent. Y'all ain't never seen nothing like this! 🤠):

https://youtu.be/tScRf40eXYo 🎥▶️🎦🍿

Basically...

1. Put an Excel file on a server (a Windows PC).
   
2. It awaits activity in another app (like a custom web form submission, or a new object in Salesforce).
3. The Excel file receives data from the other app. The formulas inside do their magic.
4. The other app receives the result (calculated values, etc — in the video above, a produced quote.)

Screenshot of 9,000+ formula connections in one workbook 😵‍💫

bottom right.

9000+ formula connections in one workbook. recursive map of all dependencies