Home›Courses›Data & AI›Excel & Spreadsheets

✦ PremiumData & AIBeginner Friendly10 Milestones

Excel & Spreadsheets Short Course

Master Excel and Google Sheets to analyze data, automate calculations, and make better business decisions with spreadsheets. Spreadsheet skills are essential for virtually every office job, from finance and marketing to operations and project management. This course covers essential formulas like SUM, IF, VLOOKUP, and INDEX/MATCH, plus pivot tables, conditional formatting, data validation, and charts.. Master excel & spreadsheets through bite-sized, swipeable learning tiles — designed for busy people who want to learn on the go.

Start This Course →

About This Excel & Spreadsheets Course

This Excel & Spreadsheets short course on SkillTiles breaks down everything you need to know into 10 structured milestones, each packed with bite-sized learning tiles you can swipe through in under 15 seconds each.

Whether you're a complete beginner or looking to refresh your knowledge, this online excel & spreadsheets course uses AI-powered content to adapt to your learning pace. Each tile delivers a focused concept, example, or quiz — making it perfect for commutes, coffee breaks, or quick study sessions.

Covering 70 key topics across 10 milestones, this course takes you from foundations to practical application. Earn badges as you complete each milestone and track your progress on your learning dashboard.

Course Curriculum

Spreadsheet Power

Formulas, pivot tables, and VLOOKUP

SUM, AVERAGE, COUNTIF and nested IFVLOOKUP and INDEX/MATCHpivot tablesconditional formattingdata validationcharts and sparklines

Advanced Formulas

Go beyond SUM and AVERAGE

SUMIFS and COUNTIFSINDEX/MATCH vs VLOOKUPXLOOKUP (modern Excel)IF with AND/OR nestingTEXT and DATE functionsINDIRECT and OFFSETarray formulas and ARRAYFORMULA

Data Management

Organize and clean data

data validation rulesnamed rangestables vs rangesremoving duplicatestext to columnsdata consolidationimporting external data

Pivot Tables Mastery

Analyze data dynamically

creating pivot tablesgrouping and ungroupingcalculated fieldsslicers and timelinespivot chartsmultiple data sourcesrefreshing and updating

Charts & Visualization

Create impactful charts

choosing the right chart typeformatting and customizationcombination chartssparklinesdynamic chart rangesconditional formatting visualsdashboard charts

Automation & Macros

Automate repetitive tasks

recording macrosVBA basicsloops and conditionals in VBAuser formsGoogle Apps Script basicsscheduled taskscustom functions

Data Analysis Tools

Excel's built-in analysis features

Goal SeekSolver add-inWhat-If analysisregression in Exceldescriptive statisticshistogram creationcorrelation analysis

Collaboration & Sharing

Work with teams on spreadsheets

shared workbookstrack changesprotecting sheets and rangescomments and notescloud collaboration (OneDrive/Drive)version historysharing best practices

Business Templates

Build useful business spreadsheets

budget trackerinvoice templateproject timelineexpense reportinventory managementsales dashboardmeeting agenda template

Power Features

Excel power user skills

Power Query for ETLPower Pivot data modelsdynamic arrays (FILTER, SORT, UNIQUE)LAMBDA functionskeyboard shortcuts masteryperformance optimizationExcel vs Google Sheets comparison

What You'll Learn in This Excel & Spreadsheets Course

SUM, AVERAGE, COUNT

IF and nested IF

VLOOKUP and INDEX/MATCH

pivot tables

conditional formatting

data validation

charts and sparklines

SUMIFS and COUNTIFS

INDEX/MATCH vs VLOOKUP

XLOOKUP (modern Excel)

IF with AND/OR nesting

TEXT and DATE functions

INDIRECT and OFFSET

array formulas and ARRAYFORMULA

Related Data & AI Courses

AI Fundamentals Short Course

Artificial intelligence is transforming every industry, from healthcare to finance to creative arts. This course breaks down how AI and machine learning actually work in plain language, no coding required. Explore neural networks, LLMs like ChatGPT and Claude, and the real-world applications shaping our future.

Prompt Engineering Short Course

The quality of your AI output depends entirely on the quality of your prompts. Prompt engineering is the skill of communicating clearly with tools like ChatGPT, Claude, and Gemini to get accurate, useful results. Learn role-based prompting, chain-of-thought reasoning, and advanced techniques that supercharge your productivity.

Data Analysis Short Course

Data analysis is one of the fastest-growing career fields, with demand for skilled analysts across every industry. Learn to clean, explore, and visualise datasets to uncover patterns and make data-driven decisions. This course covers statistical thinking, Python with Pandas, and practical techniques you can apply immediately.

Ready to master Excel & Spreadsheets?

Start this excel & spreadsheets short course today. Swipe through AI-powered tiles, earn badges, and build a daily learning habit — no experience needed.

Start Learning Excel & Spreadsheets →