Courses

Interactive BTS CG and Bachelor courses, taught in live sessions, and free AI and web courses.

22 courses

BTS CG year 1 5

BTS CG · Interactive course

B1-01 — Proportions and percentages

Compute a share and say which whole it refers to, multiply two shares, compute an overall rate, tell percentage points from percentages and markup from margin rate, then split a headcount in a spreadsheet. To follow in a guided session, with the code your teacher gives you.

Duration2 h 00 min
FormatSlides + guided session
BTS CG · Interactive course

B1-02 — Changes: rates, multipliers, indices

Move from a rate to a multiplier and from net to gross prices, chain changes, reverse a change, read an index and compute an average rate, then work through a BTS exam table in a spreadsheet. To follow in a guided session, with the code given by your trainer.

Duration2 h 00 min
FormatSlides + guided session
BTS CG · Interactive course

B1-03 — Working with a file: pivot tables and one-variable series

Group a sales file with a pivot table in Excel, compute the markup rate with a calculated field, summarise a series by its median, quartiles and standard deviation, then compare two series with their box plots. Each idea is first explained with an everyday picture. To follow in a guided session, with the code given by your trainer.

Duration2 h 00 min
FormatSlides + guided session
BTS CG · Interactive course

B1-04 — Two-variable series: fit and forecast

Link a website’s advertising and sales with a scatter plot, draw the least-squares line, read the correlation coefficient without mistaking a link for a cause, then forecast and find when a threshold is reached, in a spreadsheet. To follow in a guided session, with the code your teacher gives you.

Duration2 h 00 min
FormatSlides + guided session
BTS CG · Interactive course

B1-05 — Logic: conditions and checks

Write a company’s sales rules with and, or, not, if… then, negate them with De Morgan’s laws, say “for all” or “there exists” and find the counterexample that is enough, then check a rule in a spreadsheet. To follow in a guided session, with the code your teacher gives you.

Duration2 h 00 min
FormatSlides + guided session

BTS CG year 2 9

BTS CG · Interactive course

B2-01 — Reading and checking numerical information

Read, check and explain numerical information: proportions, percentages, changes over time. To follow in a guided session, with the code your teacher gives you.

Duration3 h 20 min
FormatSlides + guided session
BTS CG · Interactive course

B2-02 — Statistical series: summarise, relate, forecast

Summarise a series, relate two variables with a scatter plot and a linear fit, then forecast in a spreadsheet. To follow in a guided session, with the code your teacher gives you.

Duration2 h 45 min
FormatSlides + guided session
BTS CG · Interactive course

B2-03 — Logic: write and check a rule

Express a business rule with and, or, not, if… then, negate it with De Morgan’s laws, say “all” or “at least one”, then check it in a spreadsheet. To follow in a guided session, with the code your teacher gives you.

Duration2 h 15 min
FormatSlides + guided session
BTS CG · Interactive course

B2-04 — Sequences: model a steady change

Model a change with an arithmetic or geometric sequence, compare two growth assumptions, find the rank where a threshold is crossed and sum terms in a spreadsheet. To follow in a guided session, with the code your teacher gives you.

Duration2 h 45 min
FormatSlides + guided session
BTS CG · Interactive course

B2-05 — Financial mathematics: invest, borrow

Compute a future value and a present value, price a series of payments, build a loan amortisation schedule and its cost, with PMT in a spreadsheet. To follow in a guided session, with the code your teacher gives you.

Duration2 h 15 min
FormatSlides + guided session
BTS CG · Interactive course

B2-06 — Exponential and logarithm: grow, target, fit

Compute with an exponential model and its rate, find a threshold with the natural logarithm, fit a series with z = ln y and forecast with EXP and LN in a spreadsheet. To follow in a guided session, with the code your teacher gives you.

Duration2 h 15 min
FormatSlides + guided session
BTS CG · Interactive course

B2-07 — Derivative and optimisation: slope, direction, peak

First revisit the exponential, the logarithm and the while loop through everyday pictures, then differentiate a polynomial and a e^(kx), study the sign of the derivative, build a variation table and find an optimal price, even under a constraint. To follow in a guided session, with the code your teacher gives you.

Duration2 h 10 min
FormatSlides + guided session
BTS CG · Interactive course

B2-08 — Composite derivatives and economic functions

Differentiate a product, a quotient, e^u and ln u, read total, average and marginal cost, find the equilibrium price between supply and demand, then say how many solutions f(x) = k has and approximate them in a spreadsheet. To follow in a guided session, with the code your teacher gives you.

Duration2 h 15 min
FormatSlides + guided session
BTS CG · Interactive course

B2-09 — Conditional probability

Read a conditional probability in a weighted tree and in a cross table, compute a total probability along every path, go back up the tree to find P_B(A), then justify that two events are independent. To follow in a guided session, with the code your teacher gives you.

Duration2 h 15 min
FormatSlides + guided session

Bachelor year 3 4

Bachelor 3 · Interactive course

B3-01 — Data expert: from raw data to decision

Clean a sales export in Excel, join it with its reference tables, summarise it with a PivotTable, then build a dashboard and a recommendation for an executive committee. To follow in a guided session, with the code your teacher gives you.

Duration2 h 55 min
FormatSlides + guided session
Bachelor 3 · Interactive course

B3-02 — Every formula, then the AI analyst

Every Excel formula a manager needs, one page each: syntax, common trap, worked figures, and what each part of the infographic becomes in Excel; then clean, join, count working days, cross with a PivotTable and build a dashboard, step by step. Finally, hand the analysis to an AI, guide it with your rulebook and check its figures. To follow in a guided session, with the code your teacher gives you.

Duration2 h 35 min
FormatSlides + guided session
Bachelor 3 · Interactive course

B3-03 — Word processing: format and lay out

Import a raw note into Word, clean it with paragraph marks shown, apply styles and the theme, set paragraphs, lists, header, footer, sections and page numbers, then save it as a PDF; finally hand the writing to an AI and proofread before laying it out. To follow in a guided session, with the code your teacher gives you.

Duration3 h 00 min
FormatSlides + guided session
Bachelor 3 · Interactive course

B3-04 — Mail merge and e-mailing

Link a spreadsheet contact list to a form letter, insert merge fields, filter recipients, write an If…Then…Else rule, merge into documents and PDFs, then send by e-mailing or as an attached PDF; finally have an AI write the form letter. To follow in a guided session, with the code your teacher gives you.

Duration3 h 00 min
FormatSlides + guided session

AI & web 4

Free · 17 slides

AI for solopreneurs

16 curated AI tools and one live hands-on case: we sort the bullshit from what's genuinely useful. Enough to leave with a clear toolbox, not a hype list.

Duration30 min · 17 slides
FormatSlides + quiz
ToolkitDownloadable PDF
Free · 13 slides

Automate with AI — 5 workflows for non-tech

5 workflows tested without coding — quotes, emails, social media, invoices, monitoring — to win back about 2h a day. Concrete, repeatable, ready to apply right away.

Duration25 min · 13 slides
FormatSlides + polls
Free · 14 slides

DIY SEO Audit — 7 checks in 20 minutes

7 concrete SEO checks with 5 free tools, to know if Google finds your site — and fix what's stuck yourself.

Duration20 min · 14 slides
FormatSlides + checklist
Bonus

The toolkit to take away

The “AI for solopreneurs” training comes with a PDF toolkit: prompt templates, checklists, ready-to-use workflows. Your email is only used to send it to you.

ContentsPDF + templates
AccessEmail only