Available for Projects
Dashboards, automation, and no spreadsheet stress.
I simplify data and automate the boring stuff — so you can focus on what matters.
+
years of experience
+
Projects Completed
+
Questions Answered
min
Free Intro Call
Creative Expertise
What I doExcel & Power BI Dashboards
Interactive dashboards in Excel or Power BI, tailored to each business need and easy to keep up to date.
Automation with VBA & Power Query
Smart workflows that reduce repetition and human error.
Template & Toolkit Design
Reusable, scalable Excel solutions that save time.
Data Storytelling
Clear visualisations that turn raw data into decisions.
Problem-Solving with Excel
Breaking down complex tasks into clean, functional solutions.
Client-Ready Reports
Clean, polished deliverables that impress teams and stakeholders.
My Templates
Templates- All
- Business Dashboards
- Finance & Accounting Tools
- Productivity & Tracking
- Automation & Macros
KPI Dashboard
£19 · Track sales, revenue, margins, conversion rates with charts & traffic lights.Budget vs Actual Tracker
£15 · Monthly and annual budget monitoring with variance analysis.Project Tracker
£12 · Task statuses, deadlines, assigned users, progress % with filters.
To-Do List with Priorities
£7 · Daily and weekly views with auto-sorting based on urgency.
PDF Invoice Generator
£19 · Enter data once and auto-generate PDF invoices.
Bulk Email Tool
£24 · Send emails via Outlook using Excel list and a macro.
Executive Overview
£24 · Snapshot view of all business areas: finance, operations, and people.
Meeting Notes & Action Log
£9 · Track agendas, attendees, notes, and follow-ups.
Cash Flow Forecast
£19 · Forward-looking 12-month cash planning with inflow/outflow tracking.
Sales Dashboard
£24 · Dynamic monthly and quarterly sales trends with filters and slicers.
Project Portfolio Dashboard
£24 · Gantt view, project status, resource usage, deadlines overview.
Invoice Generator
£9 · Branded, automated invoice template with auto-numbering.
Profit & Loss Statement
£12 · Small business P&L template with quarterly summaries.
Timesheet Log
£12 · Weekly/monthly employee hours with overtime and summary charts.
One-Click Report Builder
£29 · Import and format raw data into a styled report with a button.
Macro Task Runner
£19 · Run multiple automated actions from a dropdown menu.KPI Dashboard
See your key numbers at a glance — sales, revenue, margin and conversion rate on one page, with traffic-light indicators that flag what needs attention.
-
Project : KPI Dashboard
-
Client : Small businesses & sales teams
-
Languages : Excel formulas, Charts, Conditional Formatting
-
Project Duration : £19 – instant download
Every template can be adapted to your own data, branding and way of working.
What's included
- Monthly and year-to-date KPI tiles
- Traffic-light thresholds you can set yourself
- Trend charts for each measure
- Simple data-entry sheet — no formulas to touch
File details
- Format: Excel workbook (.xlsx) — no macros
- Sheets: How to use, Dashboard, Data, Targets
- Works with: Excel 2016 or later, Microsoft 365, Excel for Mac and Excel online.
- Included: sample data to explore, plus a 'How to use' sheet with step-by-step instructions
£19 · instant download. Click the button above to buy, or get in touch if you'd like it tailored to your business.
Budget vs Actual Tracker
Track spending against budget month by month and for the full year, with variances calculated automatically so overspends stand out straight away.
-
Project : Budget vs Actual Tracker
-
Client : Finance teams & business owners
-
Languages : Excel formulas, PivotTables, Charts
-
Project Duration : £15 – instant download
Every template can be adapted to your own data, branding and way of working.
What's included
- Monthly and annual budget columns
- Variance in £ and % with highlighting
- Category and cost-centre summaries
- Chart of budget vs actual by month
File details
- Format: Excel workbook (.xlsx) — no macros
- Sheets: How to use, Summary, Budget, Actual
- Works with: Excel 2016 or later, Microsoft 365, Excel for Mac and Excel online.
- Included: sample data to explore, plus a 'How to use' sheet with step-by-step instructions
£15 · instant download. Click the button above to buy, or get in touch if you'd like it tailored to your business.
Project Tracker
Keep every task in one place — status, owner, deadline and progress — and filter to see exactly what is late, due soon or done.
-
Project : Project Tracker
-
Client : Project managers & small teams
-
Languages : Excel Tables, Filters, Conditional Formatting
-
Project Duration : £12 – instant download
Every template can be adapted to your own data, branding and way of working.
What's included
- Status and priority drop-downs
- Progress % bars and overdue highlighting
- Filter by owner, status or deadline
- Summary of open vs completed tasks
File details
- Format: Excel workbook (.xlsx) — no macros
- Sheets: How to use, Tracker, Lists
- Works with: Excel 2016 or later, Microsoft 365, Excel for Mac and Excel online.
- Included: sample data to explore, plus a 'How to use' sheet with step-by-step instructions
£12 · instant download. Click the button above to buy, or get in touch if you'd like it tailored to your business.
To-Do List with Priorities
A daily and weekly to-do list that sorts itself by urgency, so the most important jobs are always at the top.
-
Project : To-Do List with Priorities
-
Client : Anyone managing a busy workload
-
Languages : Excel formulas, Conditional Formatting
-
Project Duration : £7 – instant download
Every template can be adapted to your own data, branding and way of working.
What's included
- Daily and weekly views
- Automatic sorting by priority and due date
- Done / not done tick-off
- Colour-coded urgency
File details
- Format: Excel workbook (.xlsx) — no macros
- Sheets: How to use, My Priorities, Tasks
- Works with: Excel 2016 or later, Microsoft 365, Excel for Mac and Excel online.
- Included: sample data to explore, plus a 'How to use' sheet with step-by-step instructions
£7 · instant download. Click the button above to buy, or get in touch if you'd like it tailored to your business.
PDF Invoice Generator
Enter the invoice details once and create a finished PDF invoice with one click — numbered, dated and saved where you want it.
-
Project : PDF Invoice Generator
-
Client : Freelancers & small businesses
-
Languages : Excel, VBA
-
Project Duration : £19 – instant download
Every template can be adapted to your own data, branding and way of working.
What's included
- One-click PDF export
- Automatic invoice numbering
- Customer and product lists
- Saved invoice log
File details
- Format: Macro-enabled Excel workbook (.xlsm)
- Sheets: How to use, Invoice, Customers, Products, Settings, Log
- Works with: Excel 2016 or later / Microsoft 365 for Windows (desktop). Enable macros when the file opens.
- Included: sample data to explore, plus a 'How to use' sheet with step-by-step instructions
£19 · instant download. Click the button above to buy, or get in touch if you'd like it tailored to your business.
Bulk Email Tool
Send personalised emails to a whole list from Excel through Outlook, with names and details merged in for each recipient.
-
Project : Bulk Email Tool
-
Client : Teams sending regular updates
-
Languages : Excel, VBA, Outlook
-
Project Duration : £24 – instant download
Every template can be adapted to your own data, branding and way of working.
What's included
- Personalised subject and body fields
- Optional attachments per recipient
- Preview before sending
- Sent log with date and time
File details
- Format: Macro-enabled Excel workbook (.xlsm)
- Sheets: How to use, Email Sender
- Works with: Excel 2016 or later / Microsoft 365 for Windows (desktop). Enable macros when the file opens. Needs Outlook desktop.
- Included: sample data to explore, plus a 'How to use' sheet with step-by-step instructions
£24 · instant download. Click the button above to buy, or get in touch if you'd like it tailored to your business.
Executive Overview
A one-page snapshot of the whole business — finance, operations and people — built for board packs and monthly reviews.
-
Project : Executive Overview
-
Client : Directors & management teams
-
Languages : Excel formulas, Charts, Slicers
-
Project Duration : £24 – instant download
Every template can be adapted to your own data, branding and way of working.
What's included
- Headline KPIs across all areas
- Month vs prior month and prior year
- Clean, print-ready layout
- Easy to refresh with new data
File details
- Format: Excel workbook (.xlsx) — no macros
- Sheets: How to use, Overview, Data
- Works with: Excel 2016 or later, Microsoft 365, Excel for Mac and Excel online.
- Included: sample data to explore, plus a 'How to use' sheet with step-by-step instructions
£24 · instant download. Click the button above to buy, or get in touch if you'd like it tailored to your business.
Meeting Notes & Action Log
Record agendas, attendees and notes for each meeting, and track every action through to completion.
-
Project : Meeting Notes & Action Log
-
Client : Teams & project groups
-
Languages : Excel Tables, Filters
-
Project Duration : £9 – instant download
Every template can be adapted to your own data, branding and way of working.
What's included
- Meeting record with agenda and attendees
- Action log with owner and due date
- Open action filter
- Status tracking across meetings
File details
- Format: Excel workbook (.xlsx) — no macros
- Sheets: How to use, Dashboard, Meetings, Actions
- Works with: Excel 2016 or later, Microsoft 365, Excel for Mac and Excel online.
- Included: sample data to explore, plus a 'How to use' sheet with step-by-step instructions
£9 · instant download. Click the button above to buy, or get in touch if you'd like it tailored to your business.
Cash Flow Forecast
Plan cash 12 months ahead with expected inflows and outflows, and see the closing balance each month before it becomes a problem.
-
Project : Cash Flow Forecast
-
Client : Business owners & finance teams
-
Languages : Excel formulas, Charts
-
Project Duration : £19 – instant download
Every template can be adapted to your own data, branding and way of working.
What's included
- Rolling 12-month forecast
- Receipts and payments by category
- Closing balance chart with low-cash warning
- Actual vs forecast comparison
File details
- Format: Excel workbook (.xlsx) — no macros
- Sheets: How to use, Forecast, Actual vs Forecast
- Works with: Excel 2016 or later, Microsoft 365, Excel for Mac and Excel online.
- Included: sample data to explore, plus a 'How to use' sheet with step-by-step instructions
£19 · instant download. Click the button above to buy, or get in touch if you'd like it tailored to your business.
Sales Dashboard
Explore sales by month, quarter, product and customer with slicers, so trends and top performers are easy to spot.
-
Project : Sales Dashboard
-
Client : Sales managers & business owners
-
Languages : Excel, PivotTables, Slicers, Charts
-
Project Duration : £24 – instant download
Every template can be adapted to your own data, branding and way of working.
What's included
- Monthly and quarterly trends
- Slicers for product, region and customer
- Top 10 customers and products
- Refreshes from your raw sales data
File details
- Format: Excel workbook (.xlsx) — no macros
- Sheets: How to use, Dashboard, Sales Data, Lists
- Works with: Excel 2016 or later, Microsoft 365, Excel for Mac and Excel online.
- Included: sample data to explore, plus a 'How to use' sheet with step-by-step instructions
£24 · instant download. Click the button above to buy, or get in touch if you'd like it tailored to your business.
Project Portfolio Dashboard
See every project in one view — Gantt timeline, status, resources and deadlines — to spot clashes and risks early.
-
Project : Project Portfolio Dashboard
-
Client : PMOs & multi-project teams
-
Languages : Excel formulas, Conditional Formatting, Charts
-
Project Duration : £24 – instant download
Every template can be adapted to your own data, branding and way of working.
What's included
- Gantt-style timeline
- RAG status per project
- Resource usage summary
- Upcoming deadlines list
File details
- Format: Excel workbook (.xlsx) — no macros
- Sheets: How to use, Portfolio
- Works with: Excel 2016 or later, Microsoft 365, Excel for Mac and Excel online.
- Included: sample data to explore, plus a 'How to use' sheet with step-by-step instructions
£24 · instant download. Click the button above to buy, or get in touch if you'd like it tailored to your business.
Invoice Generator
A branded invoice template with automatic numbering, VAT and totals — just pick the customer and items.
-
Project : Invoice Generator
-
Client : Small businesses & sole traders
-
Languages : Excel formulas, Data Validation
-
Project Duration : £9 – instant download
Every template can be adapted to your own data, branding and way of working.
What's included
- Your logo and branding
- Automatic numbering and dates
- VAT and totals calculated for you
- Customer and product drop-downs
File details
- Format: Excel workbook (.xlsx) — no macros
- Sheets: How to use, Invoice, Customers, Products, Settings
- Works with: Excel 2016 or later, Microsoft 365, Excel for Mac and Excel online.
- Included: sample data to explore, plus a 'How to use' sheet with step-by-step instructions
£9 · instant download. Click the button above to buy, or get in touch if you'd like it tailored to your business.
Profit & Loss Statement
A clear small-business P&L with monthly figures and quarterly summaries, ready for reviews with your accountant or bank.
-
Project : Profit & Loss Statement
-
Client : Small businesses
-
Languages : Excel formulas
-
Project Duration : £12 – instant download
Every template can be adapted to your own data, branding and way of working.
What's included
- Income and expense categories
- Monthly columns with quarterly totals
- Gross and net margin %
- Year-on-year comparison
File details
- Format: Excel workbook (.xlsx) — no macros
- Sheets: How to use, P&L Summary, Monthly
- Works with: Excel 2016 or later, Microsoft 365, Excel for Mac and Excel online.
- Included: sample data to explore, plus a 'How to use' sheet with step-by-step instructions
£12 · instant download. Click the button above to buy, or get in touch if you'd like it tailored to your business.
Timesheet Log
Log weekly and monthly hours per employee, with overtime calculated automatically and summary charts for payroll.
-
Project : Timesheet Log
-
Client : Employers & team leaders
-
Languages : Excel formulas, Charts
-
Project Duration : £12 – instant download
Every template can be adapted to your own data, branding and way of working.
What's included
- Weekly and monthly views
- Automatic overtime calculation
- Hours by employee and project
- Summary charts for payroll
File details
- Format: Excel workbook (.xlsx) — no macros
- Sheets: How to use, Weekly Summary, Time Entries, Settings
- Works with: Excel 2016 or later, Microsoft 365, Excel for Mac and Excel online.
- Included: sample data to explore, plus a 'How to use' sheet with step-by-step instructions
£12 · instant download. Click the button above to buy, or get in touch if you'd like it tailored to your business.
One-Click Report Builder
Import raw data and turn it into a formatted, ready-to-send report with a single button.
-
Project : One-Click Report Builder
-
Client : Anyone producing regular reports
-
Languages : Excel, VBA, Power Query
-
Project Duration : £29 – instant download
Every template can be adapted to your own data, branding and way of working.
What's included
- Import from CSV or another workbook
- Automatic cleaning and formatting
- Consistent styled output every time
- One button to run the whole process
File details
- Format: Macro-enabled Excel workbook (.xlsm)
- Sheets: How to use, Control, Raw Data, Clean Data, Report
- Works with: Excel 2016 or later / Microsoft 365 for Windows (desktop). Enable macros when the file opens.
- Included: sample data to explore, plus a 'How to use' sheet with step-by-step instructions
£29 · instant download. Click the button above to buy, or get in touch if you'd like it tailored to your business.
Macro Task Runner
Pick a task from a drop-down and run it — a simple control panel for all your everyday automations.
-
Project : Macro Task Runner
-
Client : Power users & finance teams
-
Languages : Excel, VBA
-
Project Duration : £19 – instant download
Every template can be adapted to your own data, branding and way of working.
What's included
- Drop-down menu of tasks
- Run one task or a chain of tasks
- Status messages as each step runs
- Easy to add new macros
File details
- Format: Macro-enabled Excel workbook (.xlsm)
- Sheets: How to use, Control Panel, Data
- Works with: Excel 2016 or later / Microsoft 365 for Windows (desktop). Enable macros when the file opens.
- Included: sample data to explore, plus a 'How to use' sheet with step-by-step instructions
£19 · instant download. Click the button above to buy, or get in touch if you'd like it tailored to your business.
Clean spreadsheets. Automated workflows. Better data decisions.
Mark transformed our reporting process — everything’s faster, clearer, and way easier to manage. Highly recommended for any Excel work.
Personal Info
- Role: Excel & Power BI Consultant / Data Automation Expert
- Experience: 18+ Years With Excel
- Location: United Kingdom
- Tools: Excel, Power BI, Power Query, DAX, VBA, SQL
- Languages: English
My Core Skills
- Excel AutomationVBA macros and Power Query that take the repetitive work out of your week.
- Dashboards & Data VisualisationClear, interactive dashboards in Excel and Power BI.
- Power BI & DAXData models, measures and reports that refresh themselves.
- Financial Reporting & ModellingManagement accounts, budgets, forecasts and cash flow.
- Advanced Formulas & FunctionsXLOOKUP, dynamic arrays, LET, LAMBDA and the rest.
My Services
What I do12+ Project Dashboard Design
Create sleek, dynamic dashboards to make data easier to understand and act on.
8+ Project Automation & Macros
Eliminate repetitive tasks with powerful automation using VBA and Power Query.
15+ Project Data Cleanup & Importing
From messy spreadsheets to clean data — import, reshape, and tidy with ease.
10+ Project Custom Templates
Bespoke Excel templates tailored for businesses, from budgets to trackers.
5+ Project Financial Modelling
Build reliable, easy-to-update models for forecasting, analysis, and reporting.
20+ Sessions Delivered 1:1 Excel Training
Personalised sessions to level up your Excel skills, fast.
Fun Facts
Fun FactsRows in Excel
Excel Was Born
+
Excel Functions
+
Excel Versions Released
Power BI
DashboardsWhen Excel reports get too big or too hard to share, I build Power BI dashboards that refresh themselves: sales, month-end management packs and operations KPIs your whole team can use.
How I Can Help
How I Can HelpOne-Off Projects
Custom templates, Excel or Power BI dashboards, and reporting tools built to spec. Power BI dashboards from £495, and every project gets a fixed quote first.
- Tell me what you need
- Free 15-min call to understand the scope
- You receive a custom quote
- Project begins — updates every step of the way
£ 150 +
Ongoing Support
Need regular updates or monthly reporting help? Let's set up a retainer, from £195 a month for around 4 hours of support.
- Tell me what you need
- Free 15-min call to understand the scope
- You receive a custom quote
- Project begins - updated every step of the way
£ 195 /mo
Training & Coaching
1:1 or team training in Excel and Power BI, from the basics to advanced formulas and dashboards. £45 an hour for 1:1 online sessions; team rates on request.
- Tell me what you need
- Free 15-min call to understand the scope
- You receive a custom quote
- Project begins - updated every step of the way
£ 45 /hr
Free Excel Tips
VideosShort, step-by-step Excel tutorials, each in about 90 seconds. XLOOKUP, SUMIFS, COUNTIFS, IF with AND/OR, FILTER and UNIQUE so far, with new videos added regularly.
Excel Tips & Tricks
From The Blog
How to Add a Drop-Down List in Excel (Data Validation)
Typing the same five department names into a sheet over
INDEX MATCH in Excel: The Lookup That Works in Every Version
If you've ever been stuck because VLOOKUP can't look to
How to Build a Simple Cash Flow Forecast in Excel (Step by Step)
Profit and cash are not the same thing. A business
Excel or Power BI: Which Does Your Business Need?
Almost every business I work with runs on Excel, and
10 Essential Excel Tips Every Beginner Should Know
Whether you're new to Excel or looking to sharpen your
Why You Should Learn Excel Automation
Excel is powerful — but Excel with automation is a
Got a project, question, or idea? I’d love to hear from you. Whether it’s Excel templates, dashboards, or automating the boring stuff — I’m here to help.
© 2026 Excel With Mark · Website by Willows Digital