Logo VietRica
EN English VI Tiếng Việt ES Español
Sign up

Excel and Google Sheets Basics for Small Traders

12 chapters · 6 hours · From your first cell to a full sales, inventory and cash tracker — with AI writing the formulas while you read the numbers and decide.

12 modules · EN / ES / VI
Sign up to enroll — 0.00 VND Already have an account? Sign in 0.00 VND
Excel and Google Sheets Basics for Small Traders
A free, hands-on course that turns spreadsheets into a decision tool for small traders, shop owners and market sellers. Across twelve thirty-minute micro-lessons you learn to enter and format data cleanly, do basic calculations, use SUM, AVERAGE and IF, build a sales and inventory tracker, filter and sort, draw simple trend charts, work in Google Sheets on your phone, let AI write formulas for you, read numbers to make decisions, catch common errors, and assemble your shop's own spreadsheet kit. Anchored in ten classic Excel and data books, from Walkenbach's Excel Bible to Knaflic's Storytelling with Data and Mollick's Co-Intelligence. Built on three pillars: humans at the center — you make the final call on every decision; mastering AI — AI writes formulas, you verify and decide; and no one left behind — plain language, ready-made templates and offline Hub support so even first-time computer users finish with a working toolkit.

Curriculum

What you will learn

  1. 01

    Getting to Know the Spreadsheet: Cells, Rows, Columns

    Beat the first-day jitters — understand the grid and enter your first sales data.

    Public (anyone, no login)
  2. 02

    Entering and Formatting Data Cleanly

    Format numbers, dates and money so your table reads fast with fewer mistakes.

    Public (anyone, no login)
  3. 03

    Basic Calculations

    Add, subtract, multiply and divide in the grid — let the sheet do the math, fast and error-free.

    Public (anyone, no login)
  4. 04

    Useful Functions: SUM, AVERAGE, IF

    A handful of functions covers most of a trader's needs — automate your daily totals.

    Public (anyone, no login)
  5. 05

    Sales and Inventory Tracker

    One tracker tells you what sells well and what is left in stock — always.

    Public (anyone, no login)
  6. 06

    Filtering and Sorting Data

    Find any order or product in seconds — filter by condition, sort to see what matters.

    Public (anyone, no login)
  7. 07

    Simple Charts to See Trends

    A chart reveals the trend a table of numbers hides — build column and line charts that speak.

    Public (anyone, no login)
  8. 08

    Google Sheets and Working on Your Phone

    Free, saved online, open anywhere — your shop's numbers in your pocket.

    Public (anyone, no login)
  9. 09

    Let AI Write Formulas for You

    No need to memorize complex formulas — describe what you need, let AI draft, then verify.

    Public (anyone, no login)
  10. 10

    Reading Numbers to Make Decisions

    The point of a spreadsheet is better decisions, not just record-keeping — turn data into action.

    Public (anyone, no login)
  11. 11

    Avoiding Common Errors and Checking Data

    One wrong cell can skew a whole report — learn the checks that make your numbers trustworthy.

    Public (anyone, no login)
  12. 12

    Your Shop's Own Spreadsheet Kit

    Bundle your sales, inventory and cash sheets into one kit — and build the weekly update habit.

    Public (anyone, no login)

VietRica

Ready to dive in?

Open the course player to start the first module right away.

Sign up to enroll — 0.00 VND