Start learning
My learning

The Complete Excel Course with AI Integration

Excel course for farm managers

For farm managers keeping records and accounts in Excel, this guide selects lessons from The Complete Excel Course with AI Integration, which uses no farm data. Apply its budget tracker to simple farm accounts, Excel Tables to tidy registers, SUMIFS and PivotTables to yields and costs by field and season, charts to seasonal comparisons, and FinanceGuard to enterprise budgets versus actuals.

See the plans Watch free lessons

Taught by Sagnik Bhattacharya and Virginia Thorn

The Complete Excel Course with AI Integration: Sagnik Bhattacharya and Virginia Thorn

What you will be able to do

At work, you will be able to:

  • Organise income and expenses by farm enterprise and month, using SUMIFS to calculate totals.
  • Build a slicer dashboard comparing each crop or livestock enterprise's budget with actuals, calculating variance and percent variance and highlighting overspends in colour.
  • Summarise recorded field yields by season in a PivotTable and choose the season through a slicer.
  • Maintain livestock records in an Excel Table: select breeds and statuses from drop-down lists, calculate ages from birth dates with TODAY, and remove repeated tag numbers.
  • Use SUMIFS to total incoming and outgoing seed, feed and fertiliser, with IF and conditional formatting to highlight low stock.
  • Compare seasonal yields and costs using line and combo charts, with an in-cell sparkline showing the trend for each field.

Projects

What you will build.

The course has 14 projects. These four matter most here.

  • Personal budget tracker in Excel: spending by category with income, expense and saving totals beside a pie chart of expenses.

    Project 01

    Personal Budget Tracker

    Your first workbook: where the money goes each month.

    Apply the budget's layout to farm income and costs, calculating totals and averages, highlighting warnings in colour, summarising categories and showing their shares in a pie chart.

  • Budget vs actual dashboard in Excel (FinanceGuard): total budget, actuals and variance cards above a monthly line chart and a column chart by department.

    Project 09

    FinanceGuard

    The budget vs actual report finance teams send every month.

    Find the month and amount of overspending in each crop or livestock enterprise by comparing its planned spending with actual costs.

  • Nine Excel chart types from the Marketing Engagement Dashboard: combo, bar, funnel, Pareto, waterfall, histogram, box and whisker, sunburst and treemap.

    Project 04

    Marketing Engagement Dashboard

    Nine charts, each picked for the question it answers.

    Choose charts for seasonal comparisons: yield trends as lines, field comparisons as columns, and rainfall alongside yield in a combo chart.

  • Project 02

    Dunder Michael Paper Company employee database

    Prepare animal or field registers for use: sort and filter entries, delete repeated tag numbers, freeze headings and print a list for a vet visit or inspection.

Lessons

The lessons that matter, in course order.

The Complete Excel Course with AI Integration has 186 lessons. This page picks out 63 of them, 5 h 22 min of video. Each lesson keeps its number in the course.

Where to start

Lesson 5 Your first Excel spreadsheet

If opening Excel and navigating a sheet are familiar, start with Lesson 5, where the budget building begins. For a first introduction to Excel, choose Lesson 1. If you already use formulas, start at Lesson 19: this begins Managing data in Excel, included in full among this page's lessons and available free by email with practice files. Request it on the course page. Confident users can start FinanceGuard at Lesson 115.

Get the free section by email

63 of 186 lessons · 5 h 22 min

01 Microsoft Excel fundamentals: building a foundation from scratch 9 of 13 lessons · 40 min Build a personal budget with skills you can apply to farm income and costs. Begin with cells, rows and columns, then cover number and date formats, addition, multiplication, SUM, absolute references, percentages and common errors, before organising a workbook into sheets.
  1. 5 Start here Your first Excel spreadsheet Cells, rows, columns and data types in a budget 8 min
  2. 6 Number formatting in Excel Currency, date and percentage formats for a budget 5 min
  3. 7 Cell formatting in Excel AutoFit column width, the #### error and cell styles 6 min
  4. 8 Basic maths in Excel Add, subtract, multiply and divide with formulas 3 min
  5. 9 SUM and AutoSum in Excel Total income, expenses and savings with MAX 6 min
  6. 10 Relative vs absolute references in Excel Dollar signs and mixed references 3 min
  7. 11 Calculating percentages in Excel Each expense as a percentage of income 2 min
  8. 12 Common Excel errors and how to fix them DIV0, NAME, VALUE errors and IFERROR 4 min
  9. 13 Organising an Excel workbook Dashboard, transactions and notes sheets 2 min
02 Project: personal budget tracker 4 of 5 lessons · 22 min Household spending provides the example for a tracker you can adapt into a simple farm account. Calculate totals and averages, add conditional formatting alerts, summarise each month's spending by category and display the split in a pie chart.
  1. 14 SUM and AVERAGE in Excel Personal budget tracker totals and average expense 4 min
  2. 15 Conditional formatting in Excel Highlight rules, data bars and icon sets 3 min
  3. 16 Monthly expense summary in Excel Category totals for a personal budget tracker 7 min
  4. 17 Excel charts for beginners Pie chart of budget expenses by category 8 min
03 Managing data in Excel: sort, filter and tables (Dunder Michael Paper employee database) 9 lessons · 1 h 1 min Practise on an employee database to learn how to organise livestock or field registers. Work with Excel Tables, sorts and filters; clean entries with TRIM and Find and Replace; use Remove Duplicates for repeated tag numbers; and split text with Flash Fill and Text to Columns. Freeze the headers and fit the printed register to the page.
  1. 19 Excel tables Create and format a table, structured references and total row 8 min
  2. 20 Sorting data in Excel Single and multi-level sort on an employee database 6 min
  3. 21 Filtering data in Excel AutoFilter, text and number filters on employee data 10 min
  4. 22 Cleaning data in Excel TRIM, Paste Special values and Find and Replace 13 min
  5. 23 Remove duplicates in Excel Find and delete duplicate rows in an employee list 6 min
  6. 24 Flash Fill in Excel Split first and last names automatically 3 min
  7. 25 Text to Columns in Excel Split data by delimiter into separate columns 6 min
  8. 26 Freeze panes in Excel Lock header rows and columns while scrolling 3 min
  9. 27 Printing in Excel Print area, page orientation, scaling and page layout 6 min
04 Essential formulas and functions (IF, SUMIF and more) 13 lessons · 1 h 17 min The sales examples teach formulas you can apply to farm records: SUMIF and SUMIFS for field and seasonal yields or enterprise costs, and COUNTIFS for group head counts. Use IF to flag low stock or animals due for checks, AND and OR to test two conditions, and TODAY with date arithmetic to calculate ages or days elapsed since an event.
  1. 28 Logical functions in Excel TRUE and FALSE comparisons for beginners 5 min
  2. 29 The IF function in Excel Pass or fail results with a single condition 3 min
  3. 30 IF function practice in Excel Categorise sales data with IF formulas 6 min
  4. 31 Nested IF and IFS in Excel Customer value tiers with nested IF 6 min
  5. 32 Nested IF and IFS in Excel Sales performance labels with the IFS function 5 min
  6. 33 AND and OR with IF in Excel Flag high-value deals with multiple conditions 8 min
  7. 34 SUM, COUNT and COUNTA in Excel SUM with FILTER and counting numbers with COUNT 7 min
  8. 35 SUM, COUNT and COUNTA in Excel COUNTA, unique counts and completeness checks 4 min
  9. 36 SUMIF and COUNTIF in Excel Conditional sum and count with one criterion 8 min
  10. 37 SUMIFS and COUNTIFS in Excel Sum and count with multiple criteria 7 min
  11. 38 The Excel function library Insert Function dialog and Formula AutoComplete 5 min
  12. 39 Date and time functions in Excel TODAY, NOW, MONTH and date arithmetic 6 min
  13. 40 Excel Ninja Challenge COUNTIF, SUMIF, IF, COUNTIFS, SUMIFS and IFS practice 8 min
05 Text functions and data validation (enhancing data quality) 1 of 7 lessons · 4 min Keep totals consistent by using drop-down lists to enter breed, field name and status in a standard form.
  1. 45 Data validation in Excel Create drop-down lists for consistent data entry 4 min
06 Data visualisation: charts and graphs 7 of 9 lessons · 34 min Select and format charts for seasonal comparisons. Show yields over time with columns or lines, divide costs in a pie chart, combine measures on a combo chart with a secondary axis, and place each field's trend inside a cell using sparklines.
  1. 48 Choosing the right Excel chart Column, line, pie, combo and modern chart types 4 min
  2. 49 Column charts in Excel Insert, format and label a column chart 5 min
  3. 50 Line charts in Excel Show trends over time with a line chart 4 min
  4. 51 Pie charts in Excel Show proportions and parts of a whole 4 min
  5. 52 Combo charts in Excel Column and line chart with a secondary axis 4 min
  6. 53 Formatting charts in Excel Titles, data labels, colours and chart styles 7 min
  7. 54 Sparklines in Excel Line, column and win-loss mini charts in cells 5 min
07 PivotTables and PivotCharts: data analysis made easy 10 lessons · 33 min Learn PivotTables through sales orders, then apply the approach to yields, costs and head counts grouped by field, enterprise and season. Add slicers and PivotCharts, and refresh the summaries after adding records for a new season.
  1. 57 PivotTables 101 in Excel What a PivotTable does and the sales dataset 5 min
  2. 58 Preparing data for PivotTables Clean data with TRIM, PROPER, find and replace 5 min
  3. 59 Create your first PivotTable in Excel Insert a PivotTable from a sales table 1 min
  4. 60 PivotTable fields in Excel Rows, values, columns and Value Field Settings 2 min
  5. 61 PivotTable summaries in Excel Sales by product category and grouping by date 4 min
  6. 62 Slicers in Excel Filter PivotTables with clickable buttons 3 min
  7. 63 PivotCharts in Excel Create interactive charts from a PivotTable 5 min
  8. 64 PivotTable design Tab Report layouts, PivotTable styles and number formats 5 min
  9. 65 Refresh a PivotTable in Excel Update pivots when source data changes 2 min
  10. 66 Excel Ninja Challenge PivotTable sales by region, category and monthly trend 1 min
12 Project: FinanceGuard budget variance analyser (budget vs actual Excel dashboard) 10 lessons · 52 min Adapt FinanceGuard's budget and spending tables to an enterprise budget. The project builds a model with SUMIFS and dynamic arrays, calculates variance and percent variance, applies colour-coded number formats, and presents the results through KPI cards, a combo chart and slicers.
  1. 115 FinanceGuard budget vs actual dashboard Excel project overview 3 min
  2. 116 Excel tables for budget and actual data Organise the FinanceGuard datasets 4 min
  3. 117 Budget vs actual model in Excel SORT, UNIQUE, VSTACK, LET, TEXTSPLIT, SUMIFS 8 min
  4. 118 Budget variance in Excel Calculate variance and percent variance 4 min
  5. 119 Custom number formats in Excel Show budget variances with colours and signs 2 min
  6. 120 PivotTables for budget vs actual The FinanceGuard pivot workspace 8 min
  7. 121 KPI cards in Excel Summary cards for a budget variance dashboard 4 min
  8. 122 Budget vs actual charts in Excel Combo chart with secondary axis for variance 5 min
  9. 123 Slicers and PivotCharts in Excel Interactive FinanceGuard budget dashboard 4 min
  10. 124 Finish the FinanceGuard dashboard in Excel Final polish and variance insights 10 min

Instructors

Who teaches it.

Virginia Thorn smiling at the camera, dark hair tied back, wearing a navy top.

Instructor, Excel with AI

Virginia Thorn

Emmy Award winner. Teaches Excel with AI at Coding Liquids.

Questions

Asked before starting.

Which Excel course would suit me as a farm manager?

The Complete Excel Course with AI Integration from Coding Liquids covers Excel skills that apply to farm records, although its examples contain no farms. Use the budget tracker as a simple farm account, Excel Tables to keep registers tidy, SUMIFS and PivotTables to summarise yields and costs by field and season, charts to compare seasons, and FinanceGuard to compare budgets with actuals. This page selects 63 lessons, with a combined duration of 5 hours 22 minutes.

Can a farm manager check each crop or enterprise's actual spending against its budget?

Yes. In The Complete Excel Course with AI Integration, FinanceGuard combines a budget table and an actuals table using SUMIFS totals, calculates variance and percent variance, applies colours through custom number formats, and presents a dashboard with slicers. Label each line with an enterprise, such as wheat, dairy or poultry, to let a slicer display that enterprise's figures.

Will this course help me maintain my farm's livestock and field registers in Excel?

Yes. The register skills in The Complete Excel Course with AI Integration include Excel Tables that expand with added rows, drop-down lists for consistent breed or status entries, Remove Duplicates for repeated tag numbers, age calculations using TODAY and date arithmetic, and filters for finding a group. The course supplies no farm template: you arrange the columns to suit your farm.

Does the course cover farm accounting, agronomy or farm management software?

No. The Complete Excel Course with AI Integration does not cover farm accounting or tax, agronomy, or farm management software. Its subject is Excel, with skills you can use on records already held in spreadsheets or exported from farm software, and on the budgets and charts you build from those records.

Excel with AI

See the whole course.

The Complete Excel Course with AI Integration: 16 hours of video in 186 lessons, built around 14 projects, with lifetime access, a Certificate of Completion and a 14-day money-back guarantee.

See the plans Watch free lessons

The same course

For another job, level or topic.

By job

Finance and accounting
HR and office administration
Operations and supply chain
Data and reporting
Sales, marketing and customer service
Business and management
Engineering, construction and manufacturing
Retail, property and hospitality
Healthcare and life sciences
Education and careers
Public sector, non-profit and legal
Technology

By level and topic