THE SPREADSHEETS TRAINING
Yakir Havin
The Google Sheets/Excel Course:
Beginner to Advanced
- 6 hours 30 minutes (58 video lessons)
- Language: English
WHAT YOU WILL LEARN
In this spreadsheet crash course, you will learn:
- Fundamentals as well as advanced functions of Google Sheets/Microsoft Excel.
- Formatting tricks to create beautiful and functional spreadsheets.
- Skills to analyze data sets and automate business processes using functions and formulas.
- Expert hacks to organize and present data professionally.
- Hidden features as well as shortcuts to improve your workflow.
About this course
6 Hours 30 Minutes (58 Video Lessons)
MODULE 1:FRAMEWORK
- Getting started with spreadsheets
- User interface
- Spreadsheet management
MODULE 2:FOUNDATIONS
- Spreadsheets best practice and skills- Structure, Normalization, Cell format, Freeze panes, Sorting, Filtering
- Introduction to functions and formulas - Function syntax, Cell referencing
MODULE 3:FUNCTIONS I
- Introduction
- Logical functions: AND, OR, IF, Nested IF
- Mathematical functions: COUNT, COUNTA, COUNTIF, COUNTIFS, SUM, SUMIF, SUMIFS, AVERAGE, AVERAGEIF, AVERAGEIFS, MIN, MAX, MEDIAN, MODE
MODULE 4:FUNCTIONS II
- Lookup functions: VLOOKUP, VLOOKUP- approximate match, SEARCH, INDEX, MATCH
- Text manipulation functions: LEN, TEXT, LEFT, RIGHT, MID, SPLIT
MODULE 5:FORMULAS
- Introduction
- Container functions: IFERROR, ARRAYFORMULA
- Combining functions into formulas: IF / AND, IF / Blank, VLOOKUP / MATCH, INDEX / MATCH, MID / SEARCH
MODULE 6:FEATURES
- Introduction
- IMPORTRANGE
- Data validation
- Dynamic labeling
- Pivot Tables
- Honorable mentions
- Takeaway lessons
Academy instructors
Learn from the best in Google Sheet/Excel Course.
YAKIR HAVIN
Academy instructor
Born and raised in Melbourne, Australia, Yakir has been involved in computers in some form since second grade. Throughout high school and then while studying Commerce and Computer Science at university, this interest blossomed into something more substantial. Yakir began to understand the power of spreadsheets, and they have since helped him in many corners of his life: from keeping track of income and expenses, to winning a Victorian state award in Information Technology, to getting a job as a Data Analyst at Charidy.com. Yakir has a passion for educating people about the many personal and work-related benefits of spreadsheets.
How it works
Sign up
ENTER YOUR DETAILS
Login
YOU'LL RECEIVE AN EMAIL WITH YOUR LOGIN INFORMATION
Start learning
LOG IN AND START LEARNING AT YOUR OWN PACE
How to reach us.
