Start learning
My learning

The Complete Excel Course with AI Integration

Excel course for fleet and transport managers

For fleet and transport managers using Excel for fuel, servicing, drivers and costs, this page selects relevant lessons from The Complete Excel Course with AI Integration. The course contains no vehicle data. Apply its budget tracker to running costs, division to consumption and cost per kilometre, conditional totals to vehicles, date functions to services and licence expiry, TaskFlow to schedules and PivotTables to monthly reports.

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:

  • Calculate each vehicle's kilometres per litre or litres per hundred kilometres from a fuel log, using SUMIFS and division.
  • Use SUMIFS to total each vehicle's costs and distance, divide costs by kilometres, then compare the results in a PivotTable.
  • Organise services and inspections with status drop-downs, red highlighting for overdue entries and TODAY to calculate days until each deadline.
  • Make expired entries and those due to expire this month stand out in driving licence and vehicle inspection records, using conditional formatting with EOMONTH and TODAY.
  • Record accidents and fines in an Excel Table, then use COUNTIFS to count entries for each driver, vehicle and month.
  • Summarise monthly vehicle use and running costs in PivotTables, with a breakdown by cost type and a pie chart showing the proportions.

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.

    Adapt the household spending log to fuel, tyres and repairs. Calculate totals and averages, group monthly costs by type, add colour warnings and show the proportions in a pie chart.

  • Task tracker in Excel (TaskFlow): start and due dates, status, priority and a progress bar for each task, with working days left, days past due and unfinished high-priority tasks highlighted.

    Project 07

    TaskFlow

    One sheet that shows what is done, what is late and what is urgent.

    Give services, inspections and renewals a due date and status, show overdue entries in red and calculate the days until the next deadline.

  • Excel PivotTables and a PivotChart of sales data (SalesPlusPerformance): net sales by product category as a column chart, with State, Region and City filters.

    Project 05

    SalesPlusPerformance

    A sales question answered in seconds, straight from the order data.

    Summarise logged vehicle use and costs by depot, vehicle and month, then use slicers to filter the figures for a monthly review.

  • Project 03

    Sales Goal Tracker

    Apply SUMIFS and COUNTIFS to totals and counts for each vehicle, driver and month. Use IF to identify a vehicle that needs a service.

Lessons

The lessons that matter, in course order.

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

Where to start

Lesson 8 Basic maths in Excel

If you can enter data and are starting with formulas, begin at Lesson 8: division is the basis of consumption and cost per kilometre. Start at Lesson 1 if Excel itself is new to you. If you already use SUMIFS, move to PivotTables at Lesson 57 or the beginning of TaskFlow at Lesson 79.

50 of 186 lessons · 4 h 10 min

01 Microsoft Excel fundamentals: building a foundation from scratch 5 of 13 lessons · 19 min Personal budget examples teach the calculations behind running costs. Divide fuel by distance for consumption and costs by kilometres for cost per kilometre, keep a rate in a cell with an absolute reference, and handle division by zero with IFERROR.
  1. 8 Start here Basic maths in Excel Add, subtract, multiply and divide with formulas 3 min
  2. 9 SUM and AutoSum in Excel Total income, expenses and savings with MAX 6 min
  3. 10 Relative vs absolute references in Excel Dollar signs and mixed references 3 min
  4. 11 Calculating percentages in Excel Each expense as a percentage of income 2 min
  5. 12 Common Excel errors and how to fix them DIV0, NAME, VALUE errors and IFERROR 4 min
02 Project: personal budget tracker 4 of 5 lessons · 22 min Build a running-cost log on the budget tracker's pattern: calculate totals and averages, highlight warnings with conditional formatting, summarise each month's categories and chart their share of costs 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) 3 of 9 lessons · 24 min The employee database lessons show how to organise a list as an Excel Table, the way to keep vehicle and driver registers. Apply sorting at several levels and filter entries by vehicle type, status or depot.
  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
04 Essential formulas and functions (IF, SUMIF and more) 13 lessons · 1 h 17 min Sales examples supply formulas for fleet records: SUMIF and SUMIFS total costs and distance by vehicle and month, while COUNTIFS counts fines and incidents. Flag service needs with IF, combine two conditions with AND and OR, and calculate days since a service using TODAY and date arithmetic.
  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
07 PivotTables and PivotCharts: data analysis made easy 10 lessons · 33 min Turn a fuel and cost log into totals for each depot, vehicle and month using the PivotTable methods taught with sales orders. Group dates, filter with slicers and display the results in PivotCharts to report vehicle use and costs.
  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
08 Advanced Excel functions: lookups, text and arrays 5 of 12 lessons · 21 min Match a registration number to the vehicle register with VLOOKUP, XLOOKUP or INDEX and MATCH, bringing the depot, vehicle type or driver into the fuel log. Handle registrations missing from the register with IFERROR.
  1. 67 Lookup functions in Excel The PeopleInsight HR dataset and why lookups matter 2 min
  2. 68 VLOOKUP in Excel Find employee data across sheets with exact match 4 min
  3. 69 XLOOKUP in Excel Exact match, if not found and two-way lookup 6 min
  4. 70 IFERROR in Excel Handle lookup errors in VLOOKUP and XLOOKUP formulas 3 min
  5. 71 INDEX and MATCH in Excel A flexible alternative to VLOOKUP 6 min
08 Advanced Excel functions: lookups, text and arrays 1 of 12 lessons · 5 min Apply the HR date lesson's TODAY, EOMONTH and NETWORKDAYS functions to licence and inspection expiry and the next service date.
  1. 74 TODAY, EOMONTH and NETWORKDAYS in Excel Date calculations for HR data 5 min
09 Project: task automation with data validation and forms 9 lessons · 49 min Adapt TaskFlow's dated task columns to services and inspections. Build a planner with status drop-downs and overdue highlighting, calculate remaining days with TODAY and NETWORKDAYS, protect the sheet and test it with sample data.
  1. 79 TaskFlow project tracker in Excel Overview of the task tracker dashboard 4 min
  2. 80 Designing a task tracker in Excel TaskFlow layout, columns and headers 5 min
  3. 81 Data validation in Excel Status and priority drop-down lists in TaskFlow 8 min
  4. 82 Conditional formatting in Excel Highlight overdue and completed tasks 8 min
  5. 83 Gantt chart in Excel Build a project timeline with conditional formatting 6 min
  6. 84 Data bars and icon sets in Excel Visual priority and progress in TaskFlow 6 min
  7. 85 NETWORKDAYS and TODAY in Excel Days remaining and task deadlines in TaskFlow 5 min
  8. 86 Protect a sheet and lock cells in Excel Secure the TaskFlow tracker workbook 4 min
  9. 87 Testing an Excel task tracker Stress test TaskFlow with sample data 3 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 can fleet and transport managers use?

The Complete Excel Course with AI Integration from Coding Liquids teaches the skills behind a fleet log, schedule and monthly report. Division and SUMIFS support fuel calculations and cost per kilometre; TaskFlow and EOMONTH support service schedules and licence renewals; PivotTables summarise vehicle use. Its examples use budgets, sales and staff records rather than vehicle data. This page selects 50 lessons, taking 4 hours 10 minutes.

Can a fleet manager use Excel to calculate fuel consumption and cost per kilometre?

Yes. Start with your own vehicle log, as The Complete Excel Course with AI Integration does not include a fleet template. Its opening formula lessons teach division, absolute references and IFERROR. SUMIFS gives fuel, cost and distance totals for a chosen vehicle and month; divide the relevant totals to calculate consumption or cost per kilometre, then compare vehicles side by side in a PivotTable.

How can fleet and transport managers monitor services, inspections and licence renewals?

Use the TaskFlow project and date lessons in The Complete Excel Course with AI Integration to give each item in the schedule a status and use dates and colour to show what needs attention. Conditional formatting marks overdue services red, TODAY calculates days remaining, and EOMONTH identifies licences expiring this month. You enter the service intervals and legal deadlines.

Does the course teach fleet and transport managers about telematics, fleet software or route planning?

No. The Complete Excel Course with AI Integration teaches Excel and does not cover telematics, fleet management software, transport law or route planning. Once telematics, fuel card or workshop data has been exported to a spreadsheet, its lessons help you log the records, calculate totals and produce reports.

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