Start learning
My learning

The Complete Excel Course with AI Integration

Excel course for import and export coordinators

For import and export coordinators who track containers, chase documents and cost shipments in Excel. The Complete Excel Course with AI Integration has no trade data of its own, so this page picks out the lessons that carry over: arithmetic for landed cost, IF and COUNTIF for document checklists and demurrage, text functions for tariff codes, lookups against your own tariff list, PivotTables for the monthly report and the TaskFlow tracker for containers.

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:

  • Keep a shipment and container tracker with status drop-downs, late arrivals highlighted and the working days to each deadline counted with NETWORKDAYS.
  • Run a document checklist for each shipment with drop-down lists, COUNTIF and COUNTA, and mark a shipment ready only when its documents are complete.
  • Look up a tariff code's description and duty rate from your own tariff list with XLOOKUP, after cleaning the codes with TRIM and SUBSTITUTE and reading the leading digits with LEFT.
  • Work out landed cost per item: purchase cost, freight, insurance and duty added up with absolute references and percentages.
  • Count demurrage and detention days with date arithmetic and IF: the days a container stays beyond its free time.
  • Report shipments, duty and freight by supplier, port and month with PivotTables and slicers.

Projects

What you will build.

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

  • 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.

    Built for tasks, it works as a container tracker: each shipment's status from booking to clearance, late arrivals in colour, and working days left before a document or a delivery is due.

  • XLOOKUP formula in Excel (PeopleInsight): each employee row looks up its location from another sheet.

    Project 06

    PeopleInsight HR workbook

    Employee data joined across sheets with one formula.

    A tariff code typed once, and its description and duty rate fetched from your tariff list: the same lookups this workbook runs on employee IDs.

  • 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.

    Shipments, duty and freight by supplier, port of entry and month, with a slicer to switch between origins.

  • Project 03

    Sales Goal Tracker

    IF and COUNTIF on a checklist: a shipment marked ready only when its documents are all in, and the days past free time counted for demurrage.

Lessons

The lessons that matter, in course order.

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

Where to start

Lesson 8 Basic maths in Excel

Begin at Lesson 8 if you can enter data but formulas are new: landed cost starts with adding and multiplying. New to Excel altogether? Begin at Lesson 1. If IF and SUMIFS are familiar, go to Lesson 41 for tariff codes and drop-down lists, or to Lesson 67 for the lookups.

56 of 186 lessons · 4 h 27 min

01 Microsoft Excel fundamentals: building a foundation from scratch 5 of 13 lessons · 19 min Landed cost arithmetic: add freight, insurance and duty to the purchase cost, hold a duty rate in one cell with an absolute reference, work out percentages, and handle errors with IFERROR. The lessons use a personal budget; a costing sheet takes the same formulas.
  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
04 Essential formulas and functions (IF, SUMIF and more) 13 lessons · 1 h 17 min IF for a demurrage flag once the free days are used up, COUNTIF and COUNTA to check how many documents are in, SUMIF and SUMIFS to total duty by port or supplier, and date arithmetic with TODAY for days in port. The lessons use sales figures.
  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) 7 lessons · 35 min Codes and text kept consistent: TRIM, SUBSTITUTE and FIND to clean a tariff code typed with dots or spaces, CONCAT and TEXTJOIN to build a reference, Text to Columns to split a field, and drop-down lists so a document status or a port is entered one way.
  1. 41 CONCAT, the & operator and TEXTJOIN in Excel Combine text from multiple cells 6 min
  2. 42 TRIM, UPPER, LOWER and PROPER in Excel Clean messy text and fix capitalisation 6 min
  3. 43 FIND, SEARCH and SUBSTITUTE in Excel Locate and replace text with formulas 5 min
  4. 44 Text to Columns wizard in Excel Split a column by a comma delimiter 4 min
  5. 45 Data validation in Excel Create drop-down lists for consistent data entry 4 min
  6. 46 Ninja Challenge: problem Clean messy data with text functions and validation 4 min
  7. 47 Ninja Challenge: solution PROPER, Text to Columns and drop-down lists 7 min
07 PivotTables and PivotCharts: data analysis made easy 10 lessons · 33 min PivotTables for the monthly report: shipments, duty and freight by supplier, port and month, grouping by date, slicers and PivotCharts. The lessons use sales orders; a shipment register summarises the same way.
  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 12 lessons · 54 min Lookups against your own reference lists: XLOOKUP, VLOOKUP and INDEX and MATCH fetch a tariff description, a duty rate or a supplier's country by code, IFERROR marks a code missing from the list, LEFT, RIGHT and MID read part of a code, NETWORKDAYS counts working days, and FILTER lists shipments still waiting on a document.
  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
  6. 72 CONCAT and TEXTJOIN in Excel Combine employee names and text with a delimiter 3 min
  7. 73 LEFT, RIGHT and MID in Excel Extract parts of a text code like DAL-SAL-0001 7 min
  8. 74 TODAY, EOMONTH and NETWORKDAYS in Excel Date calculations for HR data 5 min
  9. 75 UNIQUE function in Excel Extract a distinct list with dynamic arrays 6 min
  10. 76 FILTER function in Excel Dynamic array filtering with AND and OR criteria 5 min
  11. 77 SORT and SORTBY in Excel Sort data dynamically with formulas 4 min
  12. 78 Excel Ninja Challenge XLOOKUP, totals and text concatenation lookup challenge 3 min
09 Project: task automation with data validation and forms 9 lessons · 49 min TaskFlow as a container tracker: status drop-downs from booking to clearance, conditional formatting for late arrivals, days remaining with NETWORKDAYS and TODAY, a protected sheet and a test with sample data. The project tracks tasks; a shipment with an ETA fits the same columns.
  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 is right for import and export coordinators?

The Complete Excel Course with AI Integration from Coding Liquids teaches the Excel that trade paperwork leans on, though it has no shipping data of its own: landed cost formulas, document checklists with drop-down lists and COUNTIF, tariff codes cleaned with text functions and looked up with XLOOKUP, demurrage days from dates, and a tracker for containers. This page lists 56 lessons, 4 hours 27 minutes of the course's 16 hours.

Can I look up tariff codes and duty rates in Excel?

Yes, against a tariff list you keep. The Complete Excel Course with AI Integration teaches XLOOKUP, VLOOKUP and INDEX and MATCH, with IFERROR to mark a code that is not on the list, and text functions such as TRIM, SUBSTITUTE and LEFT to bring codes typed in different ways into one form first. The course has no tariff data; keeping the rates current is up to you.

How do I work out landed cost per item?

With the arithmetic The Complete Excel Course with AI Integration teaches in its first formula lessons: add freight, insurance and duty to the purchase cost, keep each rate in one cell behind an absolute reference, and share a freight bill across items by their percentage of the order value. There is no landed cost template, and which charges count is for your company's rules to say.

Can it help me keep track of demurrage and detention?

With the days, yes. With what The Complete Excel Course with AI Integration teaches, date arithmetic gives the days since arrival, IF subtracts the free days and returns zero until they are used up, and conditional formatting colours a container that is running up charges. The free time and the charges come from your shipping line's terms, not from the course.

Does it cover customs procedures, Incoterms or letters of credit?

No. Customs law and procedures, Incoterms, letters of credit and freight forwarding systems are not taught; The Complete Excel Course with AI Integration teaches Excel only. It picks up where those leave a spreadsheet: the shipment register, the checklists, the costing sheet and the monthly report.

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