If you’ve got the basics down and are ready to do more, this course is your next step. In Intermediate Google Sheets you helps you move beyond simple spreadsheets and into more powerful tools that can save time, clean up your data, and make your work look more polished. You’ll still get clear, easy-to-follow explanations—just with a bit more muscle behind each skill. This course focuses on practical ways to improve how you work in Sheets, from building smarter formulas to using conditional formatting and advanced sorting. Whether you’re handling a larger dataset, collaborating with others, or just want to get more done in less time, these lessons will help you feel more confident and capable. It’s the perfect bridge between beginner and advanced spreadsheet skills.
Overview
COURSE DIFFICULTY
COURSE DURATION
18m
Skills Learned
After completing this online training course, students will be able to:
Create DAX measures for business calculations
Build calculated columns for data enrichment
BI Developers, Data Analysts
None
01. Introduction
02. Why Use DAX?
03. COMBINEVALUES
04. CONCATENATE
05. CONCATENATEX
06. EXACT
07. FIND
08. FIXED
09. FORMAT
10. LEFT, RIGHT
11. LEN
12. LOWER, UPPER
13. MID
14. REPLACE
15. REPT
16. SEARCH
17. SUBSTITUTE
18. TRIM
19. UNICHAR
20. UNICODE
21. VALUE
22. Class Wrap Up
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Create DAX measures for business calculations
Build calculated columns for data enrichment
WHO SHOULD ATTEND
BI Developers, Data Analysts
PREREQUISITES
None
COURSE OUTLINE
01. Introduction
02. Why Use DAX?
03. COMBINEVALUES
04. CONCATENATE
05. CONCATENATEX
06. EXACT
07. FIND
08. FIXED
09. FORMAT
10. LEFT, RIGHT
11. LEN
12. LOWER, UPPER
13. MID
14. REPLACE
15. REPT
16. SEARCH
17. SUBSTITUTE
18. TRIM
19. UNICHAR
20. UNICODE
21. VALUE
22. Class Wrap Up
