Excel For Freelancers

In this week’s Feature, Fix, or Focus, we take last week’s ROI Investment Tracker training. Here’s the list of updates I made for this training: ⭐️Create Recurring Transactions ⭐️Userform Date Picker Added ⭐️Drill Down Quick Look Added ⭐️VBA Code Optimized For Speed Please don’t forget to add your r

Hello, my friends, great to have you here as a Silver Member. This week's training is on the ROI Investment Tracker. In this training, we’ll build a complete ROI Investment Tracker in Excel from scratch so you can track multiple investments, record costs and returns, calculate ROI and payback period

In this week’s Feature, Fix, or Focus, we take last week’s Drag & Drop BOM training. Here’s the list of updates I made for this training: ⭐️ New Component Item Userform - Mbobo ⭐️ Add, Edit, Delete Items ⭐️ Added Qty On Hand Column & Formula - Mbobo ⭐️ Added Purchase Qty ⭐️Added Edit Item Floating B

Hello, my friends, great to have you here as a Silver Member. This week's training is on the Drag & Drop BOM. In this week’s training, I’ll show you how to build a fully functional Drag & Drop Bill of Materials (BOM) application entirely in Excel—from designing the interface to writing formulas and

In this week’s Feature, Fix, or Focus, we take last week’s AI Scheduler training. Here’s the list of updates I made for this training: ⭐️ Delete Recurring Schedule Items - Robert ⭐️ Pop-up Date Picker Added (sheet & Forms) ⭐️ Fixed Recurring Conflict ⭐️ Updated Calendar Borders – Robert ⭐️ New colum

In this week’s Feature, Fix, or Focus, we take last week’s 1-Click Flowchart training. Here’s the list of updates I made for this training: ⭐️ Added Idea Generator Feature & Userform ⭐️ 1-Click Model & Temperature Change ⭐️ Export To Power Point Feature Added ⭐️ Fixed Misc. Bugs & Optimized Code Ple

Hello, my friends, great to have you here as a Silver Member. This week's training is on the AI Scheduler. In this training, you’ll learn how to build an AI Scheduler in Excel that automatically converts natural language or voice commands into calendar events. Using the Groq API, you’ll create a sma

In this week’s Feature, Fix, or Focus, we take last week’s General Ledger training. Here’s the list of updates I made for this training: ⭐️Added Userform Date Picker w/ Holidays ⭐️Added Reports Date Filters ⭐️New Gen. Ledger & Date Picker Toolbar added ⭐️New custom ribbon toolbar added ⭐️Added Profi

Hello, my friends, great to have you here as a Silver Member. This week's training is on the 1-Click Flowchart. In this week’s training, we’ll create a 1-Click AI Flowchart Generator inside Excel that transforms any short idea—like “A CRM system to track clients and meetings”—into a complete, connec

Hello, my friends, great to have you here as a Silver Member. This week's training is on the General Ledger. In this training, you’ll learn how to build a complete General Ledger in Excel using VBA that automatically saves transactions, validates debit and credit entries, and updates all related tab

Hello Members, The training we have for this week that I have shared with you was about the Incredible EFF AI Function. If you have not seen it yet, you can view it right here on YouTube. Now that the training has been released, I am looking for your feedback to make this even better, just for you,

In this week’s Feature, Fix, or Focus, we take last week’s Inventory Kanban training. Here’s the list of updates I made for this training: ⭐️Edit Product from Kanban ⭐️Generate PO's for needed items ⭐️Updated Qty On Hand formulas ⭐️Updated Product Userform w/ new fields & picture Please don’t forget

Hello, my friends, great to have you here as a Silver Member. This week's training is the EFF AI Function. In this training, you will learn to take Excel to the next level with EFF AI, a no-cost solution that replaces many Copilot functions. You’ll discover how to design a dynamic Kanban board, deve

Hello Members, The training we have for this week that I have shared with you was about Incredible AutoSave Add-In. If you have not seen it yet, you can view it right here on YouTube. Now that the training has been released, I am looking for your feedback to make this even better, just for you, our

In this week’s Feature, Fix, or Focus, we take last week’s AI Contract Generator training. Here’s the list of updates I made for this training: ⭐️Added default & contract language for output ⭐️Delete Template feature added ⭐️Delete Contract feature added ⭐️Added send email details ⭐️Fixed minor bugs

Hello, my friends, great to have you here as a Silver Member. This week's training is on the Inventory Kanban. In this training, you’ll learn how to build a complete Inventory Kanban system in Excel from scratch—no add-ins required. With dynamic lanes that update in real-time, a vendor filter for fa

In this week’s Feature, Fix, or Focus, we take last week’s AutoSave Add-In training. Here’s the list of updates I made for this training: ⭐️1-Click Snapshot Save Added ⭐️Added Version Notes ⭐️Modify & Save Versions ⭐️Added Version Search Filter Please don’t forget to add your requests for your own F

Hello Members, The training we have for this week that I have shared with you was about Incredible AutoSave Add-In. If you have not seen it yet, you can view it right here on YouTube. Now that the training has been released, I am looking for your feedback to make this even better, just for you, our

In this week’s Feature, Fix, or Focus, we take last week’s Inventory Management Hacks training. Here’s the list of updates I made for this training: ⭐️Stock By Status (In Transit) - Mbobo ⭐️Returns Table - Mbobo ⭐️Damaged/Stolen Stock Table - Mbobo ⭐️Added Location Feature - Vintage Watches ⭐️Added

Hello, my friends, great to have you here as a Silver Member. This week's training is on the AutoSave Add-In. In this step-by-step VBA training, you’ll learn how to build a powerful Auto-Save and Versioning Add-in that saves your files automatically and keeps a complete version history you can resto

In this week’s Feature, Fix, or Focus, we take last week’s Multi-User Point of Sale training. Here’s the list of updates I made for this training: ⭐️Added - Dynamic Addins & Prices ⭐️Added - Add/Edit Products ⭐️Added - Add/Edit Users ⭐️Void Order Feature Added Please don’t forget to add your request

Hello Members, The training we have for this week that I have shared with you was about Amazing Multi-User Point of Sale. If you have not seen it yet, you can view it right here on YouTube. Now that the training has been released, I am looking for your feedback to make this even better, just for you

Hello, my friends, great to have you here as a Silver Member. This week's training is on the Multi-User Point of Sale. In this in-depth 3-hour training, you'll learn how to build a fully functional Juice Bar POS system entirely in Excel—no third-party tools required. From scratch, we design a custom

Hello Members, The training we have for this week that I have shared with you was about Amazing Annual Financial Statements. If you have not seen it yet, you can view it right here on YouTube. Now that the training has been released, I am looking for your feedback to make this even better, just for

Hello, my friends, great to have you here as a Silver Member. This week's training is on the Annual Financial Statements. In this training, you'll learn how to create a complete set of Annual Financial Statements in Excel — including the Income Statement, Balance Sheet, Cash Flow Statement, and Stat

Hello Members, The training we have for this week that I have shared with you was about Amazing New Outlook Email Automation. If you have not seen it yet, you can view it right here on YouTube. Now that the training has been released, I am looking for your feedback to make this even better, just for

Hello, my friends, great to have you here as a Silver Member. This week's training is on the New Outlook Email Automation. In this VBA tutorial, discover how to send emails from Excel that work with both the New Outlook and Legacy Outlook — even when automation seems blocked. Learn how to detect the