All Programs
Accountants and economists
Learn to use functions and build reports, filter large volumes of data and streamline your work.
Excel + Google Sheets
from zero to Pro
A case-based programme for people who need something that actually works. We teach the software through real cases.
- 49+ lessons and hands-on masterclasses
- You put the tools to work from the very first lessons
- An OnStudy Certificate of Completion
3–6weeks of study
600+graduates
49+lessons and cases
Finished dashboardsby lesson three
🔥
Send a request and ask about the discount of up to 60% plus gifts from our partners
02d
04h
13min
26sec
Who the programme is for
Who this course suits
If you work with data and want to automate the routine, this programme covers what you need.
Marketers and analysts
Plan sales, compare campaign performance and build forecasts from your data.
Managers and business owners
Work out project margins and asset values, and forecast how the business will grow.
Where you end up
What you will be able to do
Six practical skills you can start using at work while still studying.
Complex calculations
Combined formulas and functions on real data.
Clear reports
Charts, pivot tables and visualisations for management.
Working with arrays
Handling large volumes of data, filters and forecasts.
01
Do complex calculations quickly
Combined formulas and functions plus keyboard shortcuts, so work gets done fast.
02
Present data clearly
A range of chart types (Gantt charts included), grouping, and reports management can read.
03
Build forecasts
Process arrays of data and model outcomes under different conditions.
04
Work with external sources
Analyse data without copying it again and again, and refresh workbooks automatically.
05
Write macros and scripts
Your own functions for unusual tasks, and pulling data across from Google services.
06
Apply filters of any complexity
Set up filtering so you see only the data you need right now.
Skills
Gain the skills that matter for a profession in demand
Working confidently with data takes more than knowing formulas: you need to understand how spreadsheets think, automate the routine and present results well.
Professional skills(Hard skills)
- Formulas and functions of any complexity, plus keyboard shortcuts
- Pivot tables, charts and clear reports
- Power Query, macros and automating the routine
- Working with external data sources
Transferable skills(Soft skills)
- Analytical thinking and working with large data sets
- Forecasting and evaluating results
- Speed and accuracy in everyday tasks
- The confidence to solve unusual problems on your own
Format
How the course works
Every lesson is hands-on. You follow the tutor step by step, working on real files.
STEP 01
Download the file
With data prepared specifically for that lesson.
STEP 02
Work through the topic
Work in the file as the video plays, following the tutor step by step.
STEP 03
Check your result
Against the tutor's finished file, and fix anything that went wrong.
STEP 04
Do the assignment and quiz
Complete the assignments and put what you learn to use every day.
Your tutor
Konstantin Zhizhilkin
A top-tier specialist with more than ten years of working in Excel and Google Sheets — and of teaching them.
10+years of Excel experience
2000+students taught
6applications covered
Specialism
- Building models in Excel
- Advice on any question
- Automating business tasks
Teaches
Programme
Course programme
A full programme of lectures, quizzes and practical assignments. A few of the 49-plus modules are shown below.
- Entering data, copying and pasting
- A basic table and what defines it, entering dates, the fill handle
- The status bar — a total without a formula
- Mouse and keyboard for editing, selecting and moving
- Context menus
- The conditional formatting tool and its quirks
- Built-in conditional formatting rules
- 20 different worked cases
- Formatting data attractively, based on its values
- How to pull data from a web page
- Importing from a text or CSV file
- An overview of the other import methods
- Useful functions Excel does not have: UNIQUE, SORT, FILTER, QUERY and others
- Building charts in Google Sheets
- Connected tools: Google Forms and feeding responses into a sheet
Certificate
Your training is confirmed by a certificate
On completing the programme you receive an OnStudy Certificate of Completion, issued by OS Strategy Ltd. (Alberta, Canada), which you can show an employer.
- Certificate for the programme “Excel and Google Sheets Specialist”
- Issued by OS Strategy Ltd., Alberta, Canada
- States the programme volume and your result
Life on the programme
A straightforward student area, and plenty of practice
The course runs on our own platform. From the first lesson you are automating spreadsheet work, with no surplus theory.
Study on our platform
Video lessons, quizzes and assignments in one place. Your progress syncs across devices, so you can study from a computer, tablet or phone.
Complete the assignments
Every lesson is followed by practice on real files. Your mentor checks the work and helps you fix mistakes.
Your mentor is always reachable in the chat
Ask questions, discuss assignments and get support from tutors and fellow students in the group chat.
This way of studying does not shut you off from other people — you can always share an idea, ask for advice, or talk through your progress with people on the same path and with your mentors.
Programme cost
$19 / mo*
Pay by card or bank transfer. Interest-free instalments.
VISAMCMIR
* Price shown is based on a 12-month instalment plan
- 49+ lessons and masterclasses, 250 hours of study
- A knowledge base answering the main Excel questions
- A strong community, support and motivation
Enrol, or book a free consultation
Careers
We help you find work
Every student gets our support: a session with an HR specialist on finding work and building a career.
- 1We explain how to write a CV that gets noticed
- 2We show you how to apply for roles and handle interviews
- 3We work through real HR questions and map out a career plan
Reviews
What students say
“An incredible find”
Excel opened up a whole world I had no idea existed. Building reports with formulas and variables no longer feels impossible. Thank you.
EB
Ekaterina BulaevaNizhny Novgorod
“I learned so much”
I work as an economist and often need complex calculations at short notice. After this programme I can write multi-level formulas, put pivot tables together quickly, and I picked up a pile of shortcuts.
EO
Evgeny OstapovUfa
“I could not do without it”
Clear, engaging and easy to follow. Konstantin went through every Excel tool, including everything new up to 2019. As an executive assistant I found it genuinely valuable. Thank you.
RM
Renat MamedovMoscow
Questions
Frequently asked questions
Of course. If you keep up with the assignments you will get there even with no prior knowledge. Experienced mentors guide you through the whole programme.
You work through the material whenever suits you, at your own pace. Every lesson stays available after the programme ends, permanently. It fits comfortably around work, study and family life.
That is entirely up to you. On average students spend three to five hours a week.
Pay by card, in interest-free instalments, or from a company account. Ask our support manager about instalment details — we will help you arrange it.
WhatsApp
Telegram
I have a question
