Kontakt oss
Get a consultation
4-month course

Excel PRO

Grow Companies and Careers with Microsoft Excel Proficiency

  • Requires a laptop/PC only
  • Beginner Friendly

Get a consultation on the course

Understanding and becoming an expert in using Microsoft Excel can enhance careers as well as assist company owners in faster and comprehensive data-driven decision making. The more proficient in using Microsoft Excel, the more profit will be gained by professionals and business owners like you!

‍

97% firms
Investing in Big Data
$2500
average salary for data-driven specialists
5 Reasons You Should Take Excel Classes
  • Skills needed for various jobs. From marketing, financial to digital
  • A new opportunity for those interested in the digital world. By mastering Microsoft Excel there are many careers you can achieve
  • Minimize the risk of decision making because every decision is based on data management
  • Better decision-making for companies by leveraging the management of customer data held
  • Grow your business with a data-driven approach that offers valuable insights into customer behavior and preferences

In this course you will

Master all the tips and tricks

Taught by professionals who are ready to share tips and tricks using Microsoft Excel to maximize data

Work 1:1 with your mentor

That will answer all your questions and guide you in the learning process

Better career prospects

With expertise using Excel, you will improve your career prospects and get a promotion or job in a dream company because you will stand out from other professionals

How you will learn

Learn Topics
This course is organized on the GROWIA learning management system consisting of specific and easy-to-understand video lessons that you can learn at any time.
1/4
Join live sessions
Our mentors will support you in your education at GROWIA. Come to the Live session to be part of a friendly community and get feedback/feedback from mentors.
4.2
Create Portfolio
You will perform many practical tasks to turn your knowledge into skills. At the end of the course, you will have a portfolio with completed projects to show to your prospective company in the future.
3/4
Build a career or become a freelancer
Meet our career consultants to craft a great resume, prepare for interviews, and apply for first positions.
4.4

Course Curriculum

It’s your
future
certificate
1/ Introduction to Microsoft Excel
  • Introduction to interface and basic navigation
  • Get to know worksheets, workbooks, and cells
  • Security of workbooks and worksheets
  • Basic settings for rows, columns, cell formatting
2/ Basic Operations in Microsoft Excel
  • The use of simple formulas (summation, subtraction)
  • Use of data aggregation (count, average, min, max, count)
  • Absolute and relative reference in the formula
  • Using autofill and fill series functions
3/ Data Formatting and Visualization
  • Formatting cells and cell ranges
  • Basic chart creation: bar, pie, line chart
  • Graphic formatting and modification
  • Create a mini chart
  • Filter usage, data sorting, conditional formatting, duplicate removal
4/ Introduction to Power Query
  • Introduction to power queries: basic concepts and benefits in data processing
  • Importing and using power queries
  • Use of basic transformations: data type, filter, sort, remove duplicates, delete
  • Refresh data settings and data source management
5/ Using Advanced Functions
  • Intermediate Math Functions (Rounding, Rank, Root, Trigonometry, Statistics, Random numbers)
  • Use of logic functions (If, and, or, if nested, iferror)
  • Search function (vlookup, hlookup, index, match)
  • Use of text functions (merge, left, right, center)
6/ Complex Data Management
  • Use of data validation features and drop down lists
  • Use of dynamic tables (pivot tables) and pivot charts for data analysis
  • Use of structured tables (excel tables)
7/ Advanced Data Transformation Using Power Query
  • Combine data using power query: merge, add, merge
  • Manipulating columns and values
  • Pivot and unpivot
  • Use of custom steps in Power Query
  • Structured data management with Power Query
8/ Understanding Data Analytics
  • Use of “What-If” data analysis tools with Goal Seek and Solver
  • Data modeling with scenario manager
  • Use of add-ins for statistical analysis
  • Use of Power Pivot
  • Automated workflow creation with Power Query
  • Creating a Reporting Dashboard
9/ Macro Automation and Development
  • Introduction to VBA (Visual Basic for Applications) basics
  • Simple macro programming for task automation
Take an Excel course and make the most of the data you have
Sign up for the course
It’s your
future
certificate

Our Mentors

Vinson Ciawandy
Senior Data Scientist at one of Indonesia's largest e-commerce companies
Data Scientist with experience in 5 different industries: e-Commece, consulting, education, telecommunications, finance. Winner of 4 data analysis competitions. Trains more than 200 students in data analytics and data science.
Tantut Revelation Setyoko
Data Scientist
Has extensive experience as a Data Analyst and Data Scientist and 5+ years of experience in teaching. Expert in telling data stories through data processing with SQL and Python, then visualizing and relaying all the hidden information using multiple BI Tools.
Grow Companies and Careers with Microsoft Excel Proficiency
Sign up now and get the best deals!
Bids end in:
00
:
00
:
00
PT GROWIA ONLINE EDUCATION
Address: Cohive 101 Mega Kuningan, Lt 8 No. 19, Jl.
Mega Kuningan West South Jakarta 12950
Course
Software TesterData AnalystUX/UI designer
Contact Information
Student support:
hello@growia.education
More information about the course please contact:
(+62) 813 8931 3845