The online course where you will learn to manage spreadsheets like a pro. Start practicing right away using the interactive simulators: a complete copy of the Microsoft Excel and Google Sheets interface
This online course will quickly turn you into the spreadsheets PRO. How? The gamified approach is fun and hassle-free. You ‘play' the interactive simulators which imitate Microsoft Excel and Google Sheets interface. You practice until those skills become your second nature. Easy as that.
1. How to turn chaotic data into a convenient spreadsheet
Splitting and combining text
Finding and removing duplicates
Checking for errors
Text formatting
Pivot tables
Conditional formatting
Course content
44 interactive lessons and 25 practical exercises
Certificate of completion
After completing all the lessons and practical exercises, you will receive an official certificate of completion that you can include in your resume.
2. How to make quick calculations using functions and formulas
SUMPRODUCT
Average growth rate
Conditional sum (SUMIF)
VLOOKUP
3. How to build financial models and predict results
What-if analysis
Parameter selection and Scenario manager
Add-in Solver
4. How to automate tasks and speed up your work
Keyboard shortcuts
Auto-highlighting the active cell, row, or column
Using Auto Fill
Transliteration
Basics of working with macros
Updates in the latest version of Excel
Vacation calendar
Auto-highlighting of dates and deadlines
6. How to build diagrams
Control chart
Overlapping histogram
Normal distribution histogram
Scatter char
7. How to switch from Excel to Google Sheets
Getting to know Google Sheets
Essential functions of Google Sheets
Additional functions of Google Sheets
Pivot tables and conditional formatting
Transposing data
Hiding and unhiding rows and columns
Grouping data
Combining data into one table
MAX / MIN
Frequency analysis
Logical functions
Creating graphs
Data protection
Keyboard shortcuts
10 lessons
8 lessons
3 lessons
6 lessons
2 lessons
8 lessons
7 lessons
5. How to make convenient planners, schedules and calendars in Excel
/ СУММ и СУММПРОИЗВ
/ надстройка Power Query
/ СУММЕСЛИ
Ranking data
Lollipop chart
Combined histogram
Sparklines
Lifetime access to the course content and updates
FREE BONUS: 40 important templates and "cheat sheets"
You will get valuable handouts that will help you in your daily work. We recommend that you print them out and always keep them handy.
How to create pivot tables How to calculate the average and growth How to use the what-if analysis How to use the VLOOKUP function How to do frequency analysis How to use logical functions How to visualize data
– – – – – – –
Helping you to find your dream job
1
2
3
4
You get the necessary knowledge and skills
The right skill set will help you find the perfect job where you will feel confident and speak the same language with your colleagues.
We assist you in writing the resume
Our HR crew will help you write a effective resume that will make you stand out from other candidates.
We speed up your job search
You will get access to the employment course and learn how to get ready for a job interview, answer tricky questions and much more.
We send out your CV to our corporate clients, including top and international companies.
The step-by-step guide to go from newbie to expert
How much time do I need to complete the course?
It depends on you. Some students complete it within 10-14 days of intensive work. Others may need more time. You study at your own pace at any time of the day.
Frequently Asked Questions
Can I communicate with the coach?
Yes. We will send you a link to your personal chat with your coach, where you can ask him any questions and discuss your progress.