Excel table for business management

Good day. I have experience working with Excel. I have an understanding of sales, expenses, and profitability. I am ready to discuss in more detail.

Show original

Translate

Hello! Ready to get started. I have over 15 years of experience in financial reporting for international business! Let's talk in private messages!

Show original

Translate

Hello! I work with Excel and Google Sheets. I am ready to help using formulas or macros (scripts). Communication via Telegram bot and e-mail with Google Sheets. I would be happy to collaborate.

Show original

Translate

Good day! I am interested in your project for creating an Excel spreadsheet for business management. I have experience working with Excel, including creating automated spreadsheets, formulas, reports, and analytics. I can assist with implementing sales tracking, expenses, profit calculation, inventory control, financial decomposition, break-even point, and other metrics for effective business management. I am ready to discuss the project details, the structure of the spreadsheet, necessary reports, and metrics to create the most convenient and useful tool for your business. I look forward to collaborating!

Show original

Translate

Hello! I looked at your file, and I understand the specifics of your business. I am ready to completely rebuild the architecture to a professional level. I will add a full warehouse module, automatic margin calculation by product categories, and an interactive dashboard with a breakeven point and goal decomposition tailored to your business. We will create a catalog with cost price fixation. Stock levels will be calculated automatically in real-time based on sales. Sales journal. You will only need to enter the date, article, and quantity. The name, cost price, revenue, and net margin of each transaction will be automatically populated through formulas. A main panel for you as the owner. Here, there will be an automatic calculation of the breakeven point and a financial decomposition tool (where you can specify the target net profit, and the system will calculate the sales plan). Protection. All formula areas will be strictly locked, and the entry of categories and items will only be through dropdown lists to prevent "breaking" the model during daily use. Also, in Excel, you can connect APIs using Power Query (without programming) or through VBA scripts, allowing you to automatically pull bank statements, exchange rates, or orders from CRM systems into the table with one click.

Show original

Translate

Hello, Mykyta.

I have been working with formulas since 2008, and with VBA-Excel (macros) since 2011.
My priorities are optimizing calculations and user convenience.

Among the completed projects: annual financial and material planning for a sewing company; financial model for a credit company (over 70 input parameters); credit calculators...

The combination of your experience in management and finance and my knowledge of Excel will yield a good result in the form of an accurate, user-friendly, and fast program.)

Show original

Translate

Good day. I can do everything, but not for that budget. I would suggest Google Sheets; in the future, we can connect various automations through the API.

Show original

Translate

Good day! I will set up financial accounting in spreadsheets. I have over 13 years of experience in implementing financial accounting. I will provide examples of my work.

Show original

Translate