The Complete Excel Course with AI Integration
How to build a budget and expense tracker in Excel
A budget tracker you build yourself does what no downloaded template can: you know what every cell does, so you trust each total and can change the tracker the day your money changes. The Complete Excel Course with AI Integration opens with one, built from a blank workbook: the Personal Budget Tracker, an industry-standard project designed after talking with people from many different industries. It assumes no experience, needs nothing but Excel, and leaves every formula yours to read and change.
Taught by Sagnik Bhattacharya and Virginia Thorn
What you will be able to do
You will be able to:
- Set up a budget workbook with Dashboard, Transactions and Notes sheets, and log income and spending with AutoFill filling in the dates.
- Work out total income, total spending, savings and the average expense with formulas that update the moment an amount changes.
- Show every expense as a share of income, with the income cell locked by dollar signs so one formula copies down the whole column.
- Light up every expense over a limit you choose, then total each spending category on the dashboard, first by hand and then with SUMIF.
- Draw a pie chart of spending by category, with percentages on its slices, that follows your totals whenever they change.
- Project what a monthly investment could grow to with a SIP calculator built from a running total and from FV, and chart its growth.
Projects
What you will build.
The course has 14 industry-standard projects. These three matter most here.
-
Project 01
Personal Budget Tracker
Your first workbook: where the money goes each month.
The whole build on this page: transactions on one sheet, totals and a category summary on a dashboard, overspending lit up, a pie chart and a SIP calculator, every piece yours to extend.
-
Project 09
FinanceGuard
The budget vs actual report finance teams send every month.
Where a plan meets real spending: budget against actual for each line, a variance and a percent variance in colour-coded formats, and a dashboard that shows where the money went.
-
Project 10
WealthFlow
A retirement plan that shows how long the money lasts.
Where the SIP calculator leads: a full simulator with a SIP that steps up each year, withdrawals in retirement, inflation and charts. Its finished workbook is free by email from the course page.
Lessons
The lessons that matter, in course order.
The Complete Excel Course with AI Integration has 186 lessons. This page picks out 21 of them, 2 h of video. Each lesson keeps its number in the course.
Where to start
Lesson 3 The Excel interface
Start at Lesson 3, a free preview lesson on the course page, where the tracker's workbook is created and saved; its sheets then grow lesson by lesson up to the pie chart of Lesson 17, and the SIP calculator follows in Lesson 18. Know your way around Excel already? Begin at Lesson 5, where the transactions go in, or at Lesson 14 to finish a tracker of your own.
21 of 186 lessons · 2 h
01 Microsoft Excel fundamentals: building a foundation from scratch The tracker from a blank workbook: the Excel window and a saved file, Dashboard, Transactions and Notes sheets, a month of income and spending typed in with AutoFill, amounts and dates formatted, totals for income, spending and savings, a tax column locked with dollar signs, each expense as a share of income, and errors handled with IFERROR.
- 3 Start here The Excel interface Ribbon, tabs, name box, formula bar and navigation Free preview 13 min
- 4 Workbooks and worksheets in Excel Add, rename, move and navigate sheets Free preview 6 min
- 5 Your first Excel spreadsheet Cells, rows, columns and data types in a budget 8 min
- 6 Number formatting in Excel Currency, date and percentage formats for a budget 5 min
- 7 Cell formatting in Excel AutoFit column width, the #### error and cell styles 6 min
- 8 Basic maths in Excel Add, subtract, multiply and divide with formulas 3 min
- 9 SUM and AutoSum in Excel Total income, expenses and savings with MAX 6 min
- 10 Relative vs absolute references in Excel Dollar signs and mixed references 3 min
- 11 Calculating percentages in Excel Each expense as a percentage of income 2 min
- 12 Common Excel errors and how to fix them DIV0, NAME, VALUE errors and IFERROR 4 min
- 13 Organising an Excel workbook Dashboard, transactions and notes sheets 2 min
02 Project: personal budget tracker The tracker finished: an average expense, a rule that turns every expense above your limit red, spending summed by category on the dashboard, a pie chart with percentages on its slices, and a SIP calculator grown year by year and then with FV, drawn as a line chart.
- 14 SUM and AVERAGE in Excel Personal budget tracker totals and average expense 4 min
- 15 Conditional formatting in Excel Highlight rules, data bars and icon sets 3 min
- 16 Monthly expense summary in Excel Category totals for a personal budget tracker 7 min
- 17 Excel charts for beginners Pie chart of budget expenses by category 8 min
- 18 SIP growth calculator in Excel FV function for mutual fund investment growth 7 min
03 Managing data in Excel: sort, filter and tables (Dunder Michael Paper employee database) Excel Tables, practised on a staff list: rows added at the foot join the table and its total row counts them, the way to let a transactions sheet grow all month with no total left behind.
- 19 Excel tables Create and format a table, structured references and total row 8 min
04 Essential formulas and functions (IF, SUMIF and more) SUMIF, COUNTIF, SUMIFS and COUNTIFS, practised on sales records: one formula per spending category instead of pointing at each amount, then sums and counts with several conditions at once, a date range among them.
- 36 SUMIF and COUNTIF in Excel Conditional sum and count with one criterion 8 min
- 37 SUMIFS and COUNTIFS in Excel Sum and count with multiple criteria 7 min
04 Essential formulas and functions (IF, SUMIF and more) Date functions, practised on sales dates: MONTH gives each transaction its month number, TODAY counts the days since it happened, and a date moves forward by simple addition.
- 39 Date and time functions in Excel TODAY, NOW, MONTH and date arithmetic 6 min
05 Text functions and data validation (enhancing data quality) Drop-down lists with data validation, practised on departments: your categories kept in one list, so every expense is filed under a name the totals recognise.
- 45 Data validation in Excel Create drop-down lists for consistent data entry 4 min
Instructors
Who teaches it.
Instructor, Excel with AI
Virginia Thorn
Emmy Award winner. Teaches Excel with AI at Coding Liquids.
Questions
Asked before starting.
How do I build a budget tracker in Excel from scratch?
Start from a blank workbook and add one piece at a time, the way The Complete Excel Course with AI Integration from Coding Liquids builds its opening project, the Personal Budget Tracker, an industry-standard workbook. You set up Dashboard, Transactions and Notes sheets, log a month of income and spending, total it, light up every expense over your limit, sum each category and draw a pie chart of where the money goes, then add a SIP calculator. This page is that build plus the formulas that extend it: 21 lessons, 2 hours of video, each formula yours to read and change.
Should I download a free budget template or build my own in Excel?
Build your own, and the tracker never keeps a secret from you. A downloaded template hands you someone else's formulas; in The Complete Excel Course with AI Integration you write each one, so when a total looks wrong you know which cell to check, and when your money changes (a new income, a new category, a savings goal) you change the tracker yourself. The finished tracker comes with the lessons to hold yours against, it runs in Excel alone with no app or account elsewhere, and lifetime access keeps the lessons open whenever you rebuild it.
What should a personal budget spreadsheet include?
A sheet for every transaction, a dashboard of totals, a rule that flags overspending and a chart of where the money goes: that is the tracker you build in The Complete Excel Course with AI Integration. The Transactions sheet holds the date, description, category and amount of every entry, plus each expense as a percentage of income; the Dashboard shows total income, total spending, savings and the average expense, with a summary by category and a pie chart; a rule turns any expense above your limit red; and a Notes sheet keeps your worked examples and what each error means. The lessons start with rent, food, transport, subscriptions, eating out, healthcare, clothes and pets; add the categories your own month needs.
Can a complete beginner make a budget in Excel?
Yes: the budget is where The Complete Excel Course with AI Integration begins, so it assumes no Excel at all. You open a blank workbook in Lesson 3, type your first transactions in Lesson 5 and write your first formula, a plain addition, in Lesson 8; each lesson is short and teaches one skill, and the first lessons of this path are free preview lessons. Stuck on your own version? The plan with instructor support adds two months of questions answered by the instructor under each lesson, plus Ask AI, starting the day you switch it on.
How do I track expenses by category in Excel?
Give every expense a category and let formulas do the adding. The Complete Excel Course with AI Integration first totals each category on the dashboard by pointing at its amounts (Lesson 16), so you see exactly what a category total is made of; SUMIF then does the same in one formula however many entries a category gathers (Lesson 36). A drop-down list keeps each category spelt one way, so none slips out of its total (Lesson 45), and the pie chart of Lesson 17 shows each category's share of the month.
How do I make a monthly budget in Excel?
Get one month right, then let dates carry it forward. The tracker in The Complete Excel Course with AI Integration is a month of salary in and rent, food, transport, subscriptions and the rest out, with savings worked out as income minus spending (Lesson 9) and a summary by category on the dashboard. For the months after, keep every transaction in one growing list, give each its month number with MONTH (Lesson 39), and total any category in any month with SUMIFS, the multi-condition sum of Lesson 37.
Can my budget tracker update itself when I add new expenses?
Put your transactions in an Excel Table and it does. The Complete Excel Course with AI Integration shows it on a staff list in Lesson 19: a row added to a table becomes part of it, and its total row counts the new entry without a formula being touched. A SUM written on a whole table column stays connected as rows arrive (Lesson 34), so your totals, category sums and the pie chart that follows them keep pace with the month, and no total quietly misses the latest spending.
Can my budget show how my savings could grow if I invest them?
Yes, and the tracker closes with exactly that. The Complete Excel Course with AI Integration builds a SIP calculator (Lesson 18), a SIP being a fixed amount invested every month: you set the monthly amount, an assumed yearly return and the number of years, grow it year by year in a column you build yourself and then with Excel's FV function, and draw the growth as a line chart. WealthFlow later takes the idea to a full retirement simulator, and its finished workbook is free by email from the course page.
Excel with AI
See the whole course.
The Complete Excel Course with AI Integration: 16 hours of video in 186 lessons, built around 14 industry-standard projects, with lifetime access, a Certificate of Completion and a 14-day money-back guarantee.
The same course
For another job, goal, level, topic or comparison.
By job
Finance and accounting
- Accountants and finance teams
- Bookkeepers and accounts assistants
- FP&A and budget analysts
- Auditors and fraud examiners
- Payroll administrators
- Tax accountants and advisers
- Banking professionals
- Cost and management accountants
- Financial controllers
- Credit control and receivables teams
- Accounts payable teams
- Financial planners and advisers
- Credit analysts and loan officers
- Insurance underwriters
- Insurance claims handlers
- Reconciliation analysts
- Treasury analysts
- Medical billing and coding specialists
- Fund accountants
- Billing administrators
- AML and KYC analysts
- Actuarial analysts
- Insurance agents and brokers
- Retirement planners
HR and office administration
Operations and supply chain
- Operations and project managers
- Procurement and purchasing officers
- Logistics coordinators
- Inventory controllers and storekeepers
- Supply chain analysts
- Warehouse managers and supervisors
- PMO analysts
- Import and export coordinators
- Production planners
- Demand planners
- Fleet and transport managers
- Apparel merchandisers
Data and reporting
Sales, marketing and customer service
Business and management
Engineering, construction and manufacturing
- Quantity surveyors and estimators
- Civil and site engineers
- Quality managers and engineers
- Construction project managers
- Health and safety officers
- Document controllers
- Production managers and supervisors
- Mechanical and electrical engineers
- Industrial engineers
- Planning engineers
- Sustainability and ESG analysts
- Maintenance planners
Retail, property and hospitality
Healthcare and life sciences
Education and careers
Public sector, non-profit and legal
By goal
- Instructor support
- Certificates
- How long it takes
- Is Excel worth learning
- A retirement calculator
- A task tracker
- A KPI dashboard
- A budget vs actual report
- A sales goal tracker
- An employee database
- A chart dashboard
- An employee lookup
- A self-refreshing sales report
- A checking macro
- A Power Automate flow
- A compound interest calculator
- A SIP calculator
- An Excel test for a job
- A step-up SIP calculator
- Practice exercises
- Excel skills for a CV