laura

Spreadsheet and Data Analyst

Jan 2025 - Present • 1 yr 8 mos

Designed and maintained custom Excel and Google Sheets systems for small businesses, online sellers, and startups across multiple industries. Built automated sales trackers, budget planners, inventory logs, expense trackers, and monthly performance reports tailored to each client's specific workflow. Developed advanced formulas, pivot tables, and interactive dashboards to help business owners monitor revenue, profit margins, and key performance indicators without manual calculations. Cleaned and organized messy, unstructured data into clear, reliable spreadsheets that improved accuracy and reduced reporting time. Created dynamic charts and visual summaries to make complex data easy to understand at a glance. Automated recurring calculations using formulas and conditional formatting to eliminate repetitive manual work. Built dropdown menus, data validation rules, and structured input sheets to reduce errors during daily data entry. Set up automated monthly and yearly summary reports that update instantly as new data is entered, saving clients hours of manual reporting. Collaborated directly with clients to understand their business goals and translate them into practical, easy to use spreadsheet solutions. Delivered fully editable files compatible with both Excel and Google Sheets to fit different client preferences. Provided ongoing support and revisions to ensure each spreadsheet continued to meet evolving business needs. Consistently focused on clean layout design, data accuracy, and long term usability, helping clients make faster, more confident business decisions every month.

Inventory and Operations Spreadsheet Specialist

May 2024 - Present • 2 yrs 4 mos

Built custom inventory and operations tracking spreadsheets for small retailers, online sellers, and service based businesses. Designed stock trackers with automatic reorder alerts, low stock warnings, and real time quantity updates linked to sales data. Created order management sheets that tracked incoming and outgoing stock, supplier details, and cost per unit to help clients monitor profitability. Developed workflow trackers for daily operations, including task lists, job status boards, and staff scheduling sheets tailored to each business. Automated stock level calculations and reorder points using formulas and conditional formatting, reducing the risk of running out of key products. Organized supplier and product databases into clean, searchable spreadsheets with filters and dropdown menus for faster daily use. Helped clients transition from paper based or scattered tracking methods into a single, centralized spreadsheet system. Built summary dashboards showing top selling products, slow moving stock, and overall inventory value at a glance. Delivered practical, easy to maintain systems that improved accuracy, saved time, and supported smoother day to day business operations.

Financial Reporting and Excel Specialist

May 2024 - Present • 2 yrs 4 mos

Provided financial reporting and spreadsheet consulting services to small business owners, freelancers, and startups looking to better understand their sales and expenses. Built monthly and quarterly financial summary reports in Excel and Google Sheets, including profit and loss breakdowns, expense categorization, and revenue trend analysis. Designed automated dashboards that calculated key financial ratios, growth percentages, and profit margins in real time as new data was entered. Converted raw bank statements, invoices, and sales logs into structured spreadsheets that were easy to review and audit. Created reusable report templates so clients could generate consistent monthly summaries without starting from scratch each time. Used conditional formatting and visual indicators to highlight overspending, low performing periods, and areas of opportunity. Worked closely with clients to align each spreadsheet with their specific financial goals and reporting style. Simplified complex financial data into clear charts and summaries suitable for presentations and business decision making. Ensured every file remained fully editable, well organized, and easy to maintain long after delivery, allowing clients to manage their own numbers with confidence going forward.