Summary  
This chapter demonstrates automating data cleaning and transformation by programmatically hiding irrelevant columns, filtering out unwanted records, and normalizing date formats to create a consistent input layer for further processing.

General domain of usage  
Financial reporting

In this chapter, you prepare the foundation of your template.

You take a raw CSV export and turn it into a clean, structured input layer that works reliably every time new data is added.



Start with the raw Upwork CSV.

Instead of deleting unnecessary columns, hide them. This keeps the original structure intact, so future imports do not break your setup.

Then remove noise from the dataset. Filter out rows like withdrawals, but keep the data in place so the template continues to work automatically with new files.

Clean the Imported Data


Use Copilot to apply rules, not one-time fixes.

Once filters and structure are in place, they will apply automatically whenever new data is pasted into the table. This is what makes the template reusable.

Automate the Cleanup


Not all data comes from the CSV.

Create a separate sheet for recurring expenses such as subscriptions and tools. Structure it the same way as your main dataset so both sources can work together.

Make sure formats, especially dates, match across tables.

Add Manual Expenses

Discover how to use Excel with Copilot to solve real business problems. Explore practical workflows that turn messy data into structured, reliable systems. Learn how to build models, automate calculations, and generate insights without memorizing formulas. Understand how to guide Copilot, validate its output, and keep full control over your logic.

Explore the core setup and habits for working with Copilot in Excel. You configure your environment, learn how to write clear prompts, and apply safe workflows before using Copilot on real data. You focus on testing, verifying results, and protecting your files. These skills help you avoid mistakes and use Copilot with confidence further.

Focus on turning messy, inconsistent datasets into clean and usable data. You standardize headers, split combined fields, fix mixed formats, and remove duplicates using Copilot. Consider real-world scenarios and apply structured workflows to clean data safely.

Discover using Copilot to work with clean data and turn it into insights. You extract values, connect multiple datasets, handle errors, and build dynamic summaries. Learn to describe tasks in plain language while Copilot generates and applies the formulas.

Learn how to present data in a clear and interactive way. Create PivotTables, add slicers, build charts, and apply conditional formatting to highlight key insights. Combine all elements into a structured dashboard and use Copilot to support analysis, formatting, and presentation. 

Build a forecasting model using assumptions, pricing scenarios, and 12-month projections. Test different outcomes, guide Copilot through complex logic, and turn your analysis into a clear, decision-ready recommendation.

Turn your work into a reusable, product-like spreadsheet. Clean raw data, combine multiple sources into a single system, build automated reports, and package everything into a polished template with instructions that anyone can use.

Clean Data and Manual Expenses