STEP IT Academy | We have been teaching since 1999. High-quality IT-education for adults and children. We prepare programmers, designers and system engineers who cannot be replaced by artificial intelligence. In order to achieve this, we teach how to understand tasks, run projects and work in a team, in addition to core knowledge.

Your browser Internet Explorer is out of date!

Please, use Google Chrome, Safari, Mozilla Firefox, Opera

Advanced Excel and Google Sheets

This advanced course is not just about mastering formulas and functions; it's about investing in your personal and professional growth. It equips you with valuable skills for data analysis, problem-solving, and efficiency.
Analyze Data Like a Pro!

Become a Data Analysis Powerhouse

Build interactive dashboards with real-time data updates, providing clear insights and facilitating informed decision-making.

Advanced Excel and Google Sheets

Dive into the world of advanced Excel can unlock a whole new level of productivity and problem-solving.

Course Curriculum

Introduction to Advanced Excel/Google Sheets Features

Lookup and Reference Functions

Date & Time Functions

Text Functions

Logical Operators and Conditional Formatting

Data Validation and Collaboration

Pivot Tables

Pivot Charts

Power Query

Power Pivot

Advanced Graphs

What-If Analysis and Solver

Advanced Charting Techniques

Macros

Conditional Functions

Regression Analysis and Forecasting

Review and Assessment

Download detailed curriculum

Forms of Education and Tuition Fees

About the Course
Duration
16 hours
Schedule
1 day a week
Age
15-55 yo
Time:
Sundays from 8:30 am to 11:20 am

Tuition Fee

$99
start_study

Telegram

Follow the news, get access to the useful content and learn about special offers on our Telegram channel!

Read

This site uses cookies

Privacy policy