Como fazer Planilha de Controle Financeiro para MEI no Excel

🟢LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: https://excelentejoao.com.br/sejaexce... 🔵SPREADSHEET: https://excelentejoao.com.br/planilha... ▶ Guys, the spreadsheet is free for you to do along with me during the class. But, if you don't want to do it, you can purchase it through the link above. Delivery is automatic and secure. 🙏👍 In this free Excel video lesson, we will learn how to create a financial control spreadsheet for MEI (Individual Microentrepreneur) in Excel. With this Excel spreadsheet, we can control the income and expenses of our company, manage business finances, track revenues and expenses, and manage accounts payable and accounts receivable. We will use several Excel tools such as important formulas and functions, drop-down lists, automatic color (conditional formatting), etc. We'll have a main tab for transactions, income and expense control, monitoring of the annual limit of R$ 81,000, a monthly summary with SUMIFS, and drop-down lists to better organize entries. The idea is to create a simple, practical, and easy-to-update spreadsheet, bringing together in a single table customer receipts, expenses, DAS (Simplified Tax Collection System), paid bills, outstanding bills, and accumulated revenue. MEI (Individual Microentrepreneur) Income, Business Expenses, DAS Payment, Customers and Receipts, Current Revenue, Remaining Revenue up to the MEI Limit, Monthly Summary with SUMIFS, Drop-down Lists in Excel This spreadsheet can help individual microentrepreneurs who want to better control their business finances without needing complex systems. #ExcellentJoão #Excel #Dashboard