Profession
Excel and Google spreadsheets:
A practical online course where you will learn all the functions of Excel and Google Spreadsheets. Classes are held on interactive simulators - a full copy of the Microsoft Excel interface.
Sign up for a course
Interactive exercises
in the Excel and Google spreadsheet interface
Official diploma
course completion
Сourse completion
2 weeks
answer any question
on average to pass
beginner to expert
What this course will give you
Time saving
You will automate routine tasks and speed up your work with tables by at least 2 times.
Independence from colleagues
You won't have to ask your colleagues to help you with a spreadsheet anymore. Excel will become a clear tool for you
Income growth
Becoming an Excel expert can easily increase your salary or help you find a better paying job.
For home and school
Learn how to turn chaotic data into convenient tables, use formulas, and draw graphs. You will be able to calculate your family's budget or speed up your coursework.
To work
Learn how to use features, create summary tables, and automate routine tasks. Speed up your work, make reporting and sales planning easier.
For business
Learn how to filter large amounts of data, create interactive dashboards and protect tables. You will be able to create plans and calendars and calculate the profitability of projects.
For investment
Learn to use macros, create charts, and work with add-ins to calculate data. You will be able to make forecasts, import and analyze data
The programme is fully compliant with the requirements for Business Analysts
Turn chaotic data into a table that is easy to work with
Work with Power Query and Power Pivot add-ins
Make forecasts and analyze different scenarios
Create dashboards to visualize data and quickly analyze metrics
Quickly make complex calculations using summary tables, formulas and hotkeys
Construct informative graphs and charts for presentation to management and clients
Create your own macros to solve non-standard tasks
1
6
4
5
2
3
7
Training programme
8 lessons
10 lessons
  1. How to turn chaotic data into a table that is easy to work with
2.How to make quick calculations with functions and formulas
4.How to automate tasks and speed up your work
5. How to make easy-to-use plans, charts and calendars in Excel
6. How to build visual diagrams
8. Macros in Excel and Google Sheets
3. How to build financial models and forecast results
  • Splitting and merging text
  • Find duplicates in a list
  • Error checking
  • Text formatting
  • Summary tables
  • Conditional formatting
  • Sum and product
  • Average and increment
  • Sum with condition
  • CPR function
  • Inserting a character on the keyboard
  • Automatic highlighting of the active line
  • Instant fill function
  • Transliteration
  • Basics of working with macros
  • Updates in the latest version of Excel
  • Vacation Calendar
  • Automatic highlighting of dates and deadlines
  • Reference lines
  • Histogram with overlap
  • Normalized centered histogram
  • Dot chart
  • Ranked data
  • When and for what purposes macros are used, how they help to and automate work
  • The basis and basic principles Writing macros for beginners
  • What-if analysis
  • Parameter selection and Scenario Manager
  • Solution Finder add-in
6 lessons
Access to course materials and updates forever
10 lessons
3 lessons
2 lessons
8 lessons
  • Transpose data
  • Hiding and displaying rows and columns
  • Grouping data
  • Assembling data into one table
  • Sum and product
  • Average and increment
  • Sum with condition
  • CPR function
  • Docked histogram
  • Sparklines
7. How to move from Excel to Google Tables
  • Getting to know Google Tables
  • Basic Google Tables functions: CPR, UNIQUE, SUMPRODUCT, Filter and others
  • Additional functions of Google tables: inserting pictures and text
7 lessons
  • Summary tables and conditional formatting
  • Creating charts
  • Data protection
  • Hotkeys
  • VBA syntax and logic, control constructs, operators and loops
  • Common mistakes when writing macros
3 lessons
9. Creating interactive dashboards in Google Sheets and Excel
  • When and for what purposes dashboards are used
  • How does a dashboard help to simplify or automate work with analytics and charts
  • Algorithm for building a dashboard
  • How to add new data and update the dashboard
  • How to work with such a dashboard and use all its features
10 lessons
10. Power Query and Power Pivot add-ons
  • When and for what purposes Power Query and Power Pivot are used
  • How Power Query and Power Pivot differ
  • How the Power Query add-in works with data, what is included in the concept "external data"
  • Power Query editor interface and working in it
  • Power Query M language, its basic functions and syntax
  • How to import and load external data and convert into an understandable table
  • How the PowerPivot add-in relates to Power BI
  • Basic principles in working with Power Pivot: data models, data relationships and calculations

Helping you find your dream job

1
We provide the necessary knowledge and skills
They make it easy for you to find the perfect job for you, where you'll feel confident and speak the same language as your colleagues.
2
Help you
write your CV
Core business skills Academy HR specialists will help you create a competent CV that will make you stand out from other candidates.
3
We tell you all about
the job search
You'll have access to a course
on employment and learn
how to prepare for interviews,
answer tough questions.
and much more.
4
Send your CV
to our partner companies
We have been training employees of major companies since 2013. Your CV will go directly to our partners, allowing you to quickly find a job in one of the leading companies.
$299
Course fee
Make an application today and receive a personal consultation with a course expert as a gift
An advanced training certificate will validate your skills
Access to the course forever. Updates are free!
Start learning right now!
BUY NOW

Frequently Asked Questions