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
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
Creating graphs
Data protection
Keyboard shortcuts
3 lessons
6 lessons
2 lessons
8 lessons
7 lessons
5. How to make convenient planners, schedules and calendars in Excel
Ranking data
Lollipop chart
Combined histogram
Sparklines
Lifetime access to the course content and updates
After finishing the course, you will receive an official certificate of completion. To prove your Excel skills include the certificate in your resume.
Demonstrate your Excel skills with a certificate
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
– – – – – – –
–
–
Feeling stuck with an Excel assignment? Your coach is just one email away from helping you
Your coach will review your assignments and give you valuable feedback
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 curator?
Yes. We will send you a link to your personal chat with your curator, where you can ask him any questions and discuss your progress.