Master formulas and data analysis. Master excel & spreadsheets through bite-sized, swipeable learning tiles — designed for busy people who want to learn on the go.
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
1
Spreadsheet Power
Formulas, pivot tables, and VLOOKUP
SUM, AVERAGE, COUNTIF and nested IFVLOOKUP and INDEX/MATCHpivot tablesconditional formattingdata validationcharts and sparklines
2
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
3
Data Management
Organize and clean data
data validation rulesnamed rangestables vs rangesremoving duplicatestext to columnsdata consolidationimporting external data
4
Pivot Tables Mastery
Analyze data dynamically
creating pivot tablesgrouping and ungroupingcalculated fieldsslicers and timelinespivot chartsmultiple data sourcesrefreshing and updating
5
Charts & Visualization
Create impactful charts
choosing the right chart typeformatting and customizationcombination chartssparklinesdynamic chart rangesconditional formatting visualsdashboard charts
6
Automation & Macros
Automate repetitive tasks
recording macrosVBA basicsloops and conditionals in VBAuser formsGoogle Apps Script basicsscheduled taskscustom functions
7
Data Analysis Tools
Excel's built-in analysis features
Goal SeekSolver add-inWhat-If analysisregression in Exceldescriptive statisticshistogram creationcorrelation analysis
8
Collaboration & Sharing
Work with teams on spreadsheets
shared workbookstrack changesprotecting sheets and rangescomments and notescloud collaboration (OneDrive/Drive)version historysharing best practices
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
Start this excel & spreadsheets short course today. Swipe through AI-powered tiles, earn badges, and build a daily learning habit — no experience needed.