Data Analytics & Visualization with EXCEL

Master the Excel basics, intermediary, advanced, Power Pivot, Power Query & Intermediate Power query in Excel, and learn to use excel analytics and visualization tool to conduct impactful analysis for professional decision making process.

Get Advice

Data Analytics & Visualization With Excel

Who this course is for:

Beginners curious about data visualization and analytics, looking to get started with Excel.
PowerBI users who want to take their data analysis skills to the next level with Excel.

Data professionals aiming to broaden their skill set with proficiency in Excel.
Business leaders and managers seeking to leverage data for informed decision-making.
Students studying business, economics, statistics, or related fields, looking to bolster their resume with data analysis skills.
IT professionals who want to understand and utilize Excel in their workflow.
Freelancers offering data analysis services, looking to expand their toolkit with Excel proficiency.

What you will Learn:

Master the use of Excel as a powerful analytical tool to transform raw data into valuable insights.
Automate your data analysis and reporting, saving significant time and increasing efficiency.

Apply Excel and DAX to decipher complex data, finding the insights that drive decision making.
Create compelling visualizations that effectively communicate your data analysis results.

Learn and implement the framework for mastering Excel for data analytics.
Enhance your DAX and Power Query skills, gaining a deeper understanding of data manipulation.
Build practical solutions for real-world scenarios, using advanced data analytics techniques.

Implement best practices in Excel model development, report writing, and publishing.

Course Benefits & Key Features

Master Data Analytics With PowerBI’s benefits and key features.

Modules

30+ Modules.

Lessons

80+ Lessons

Practical

40+ Hands-On Labs

Life Projects

5+ Projects

Resume

CV Preparations

Job

Jobs Reference

Recording

Session Recording

Interviews

Mock Interviews

Support

On Job Supports

Membership

Membership Access

Networks

Networking

Certification

Certificate of Completion

INSTRUCTOR-LED LIVE ONLINE CLASSES

Our learn-by-building-project method enables you to build

practical or coding experience that sticks. 95% of our

learners say they have confidence and remember more

when they learn by building real world projects which is

required to work in your real life.

Get step-by-step guidance to practice your skills without getting stuck
Validate your technical problem-solving skills in a real environment
Troubleshoot complex scenarios to practice what you learned
Develop production experience that translates into real-world

.

Why Data Analytics & Visualization With EXCEL?

Learn In-demand Skills

Those with careers in data analysis learn relevant in-demand skills that span industries and add value to every digital-enabled organization.

Earn a Higher Salary

Experienced data analysts can earn up to $112,000 per year and transition into higher-paying jobs as Senior Data Analysts, Data Scientists, or Analytics Managers.

Positive Job Outlook

The data analytics market is predicted to hit $132.90 Billion USD by 2026. COVID-19 pandemic accelerated the adoption of data analytics solutions and services.

Shape the Future

Data analysts transform organizations by capitalizing on data to improve their business decisions and solve critical real-world problems.

Become a Leader

Being a central part of an organization’s decision-making processes, analytics experts often pick up strong leadership skills as well.

Data Analysis are Constantly Evolving

Data analysis moves quickly, and data analysts are constantly learning and advancing in their careers.

GreaterHeight Certificates holders are prepared to work at companies like these.

Some Alumni Testimonies

Investing in the course "Become a Data Analyst" with GreaterHeight Academy is great value for the money and I highly recommend. The trainer is very knowledgeable, very engaging, provided us with quality training sessions on all courses and was easily acessible for queries. We also had access to the course materials and also the timely availability of the recorded videos made it easy and aided the learning process..

QUEEN OBIWULU

Team Lead, Customer Success

The training was fantastic, the instructor is an awesome lecturer, relentless and not tired in his delivery. He obviously enjoys teaching, it comes natural to him. We got more than we expected. He extended my knowledge of Excel beyond what I knew, and the courses were brilliantly delivered. They reach out, follow up, ask questions, and in fact the support has been great. They are highly recommended and I would definitely subscribe to other training programs from them.

BISOLA OGUNRO

Fraud Analytics Risk Oversight Manager

It's one thing to look for just a Data Analysis training, and it's another to get the knowledge transferred through certified professional trainers. No matter your initial level of proficiency in any of the Data Analysis tools, GreaterHeight Academy would meet you there and take you up to a highly proficienct and confident level in a short time at a reasonable pace. I learnt a lot of Data Analysis tools and skills at GreaterHeight from patient and resourceful teachers.

TUNDE MEREDITH

Operation Director - Abbfem Technology

The Data Analysis training program was one of the best I have attended. The way GreaterHeight took off with Excel and concluded the four courses with Excel was a mind blowing - it was WOW!! I concluded that I'm on the right path with the right mentor to take me from a novice to professional. GreaterHeight is the best as far as impacting Data Analysis knowledge is concern. I would shout it at the rooftop to recommend GreaterHeight to any trainee that really wants to learn.

JOHN OSI PETER

Greaterheight

I wanted to take a moment to express my deepest gratitude for the opportunity to study data analytics at GreaterHeight Academy. I am truly impressed by the level of dedication and support that the sponsor and CEO have put into this program. GreaterHeight Academy is without a doubt the best tech institution out there, providing top-notch education and resources for its students. One of the advantages of studying at GreaterHeight Academy is the access to the best tools and technologies in the field.

AYODELE PAYNE

Sales/Data Analyst

It is an unforgettable experience that will surely stand the test of time learning to become a Data Analyst with GreaterHeights Academy. The Lecture delivery was so impactful and the Trainer is vast and well knowledgeable in using the applicable tools for the Sessions. Always ready to go extra mile with you. The supports you get during and after the lectures are top notch with materials and resources available to build your confidence on and off the job.

ADEBAYO OLADEJO

Customer Service Advisor (Special Operations)

Data Analytics & Visualization With Excel

Introduction to Excel

Getting started with Excel

In this Excel course, you’ll learn the fundamentals needed to have you analyzing data in spreadsheets before you know it. This course focuses on helping you navigate Excel and prepare your data for basic analysis. You’ll learn how to manage tables and apply calculations to your data to provide new insights

Learn Functions

You’ll learn about the many available functions in Excel that can help you to perform calculations, analyze data and, in some cases, automate tasks. We’ll start your journey into understanding the full potential of Excel’s functions and leverage built-ins such as SUM, AVERAGE, COUNT, UPPER, LEFT, and more.

Visualizing data

We’ll finish this course by explaining the basics of using Excel to effectively communicate data through compelling visuals. You’ll explore the versatility of area, column, and pie charts to help tell a story to bring your analysis to life.

3 Modules | 4+ Hours | 3+ Skills

Course Modules

In this module, you’ll learn how to navigate Excel and understand how best to work with tables. You will cover topics such as navigating the grid layout, importing data, manipulating data with tables, and creating basic formulas.

Introduction to Excel
The possibilities of Excel
Navigating Excel
Loading workbooks
Working with data
Creating first formula
Working with tables
Referencing cells
Managing data with tables
Working with structured cell references
Filtering data
LAST STEP INSTRUCTIONS Formatting tables

In this module, you’ll learn how to work with data in a tabular layout. You will cover topics such as creating named ranges, using subtotals to summarize groups of data, and applying data validation rules. Additionally, you’ll learn how to use aggregate functions in Excel to help summarize your data.

Managing and formatting data
Manage vs. Format
Managing data
Naming ranges
Sub-totals
Custom formats and validation
Aggregate and Arithmetic operations
Order of operations
Understanding house prices
Summarizing sales
Calculating sales and profit

Finally, in this module, we’ll finish by looking at the various functions available within Excel and learn how to start visualizing basic data. You will cover text, date and time, statistical functions, and learning to use built-in Excel features to visualize your data.

Other functions in Excel
To the left, to the left
Applying formatting functions
Product profiles
Profit performance
Formatting with functions
Visualizing data in Excel
Do you know the meaning of data viz?
How to visualize data
Visualizing categories
Capturing parts of a whole
Capturing a trend
Wrap-up!

Data Preparation in Excel

Starting data preparation in Excel

In this course, you’ll learn how to prepare and clean raw data in Excel worksheets. This course focuses on helping you utilize the numerous features in Excel that allow you to bring in data from different sources and prepare the data by filtering, deduping, and organizing your columns and rows to ensure subsequent analysis tasks are done as efficiently as possible.

Useful functions to prepare data

As well as the built-in features Excel offers, you will learn to use different functions to handle and manipulate dates and text strings.

Nesting logical functions

You will be introduced to logical functions that will allow you to create new flags and categories within your raw data while understanding how different logical functions can be combined in nested formulas.

Lookups and new table types

You will also understand how to use lookup functions in Excel to bring in data from different sheets and identify specific results within large datasets. Finally, you will get your first glimpse of PivotTables - a powerful Excel feature that allows you to summarize and analyze large volumes of data using dynamic tables.

4 Modules | 5+ Hours | 4+ Skills

Course Modules

In this module, you’ll learn different ways to source and import your raw data into Excel. You will then start your preparation of raw data by removing duplicates added in error and filling in the missing parts of your data that will help you prepare the best dataset for analytical use.

The data preparation journey
Data preparation steps
Load and clean data
Importing files
Deduping
Flashy filling
Series filling

In this module, you’ll learn how to use text category functions to combine text strings with useful variables for better analysis. You will also utilize some of Excel's date and time functions, taking simple date columns to a new level.

Text and date functions
Which function category?
More functions, better preparation
Equal length
Joining together
Dates and more

In this module, you’ll learn how to use logical functions to create conditional formulas for new flags and filters for your data. You will combine the logical operators to create nested formulas, specifically using the IF function to create new category data. Additionally, you will understand how to differentiate between notes and comments in Excel and use them effectively to share information with others.

Using logical functions in formulas
Which conditional formula is right?
Logical data preparation
To be, or NOT to be
Functions two by two
Well nested IF functions
Notes and comments

In this module, you’ll finish by looking at some important lookup and reference functions available within Excel, specifically the VLOOKUP and HLOOKUP functions. Additionally, you’ll be introduced to the powerful world of PivotTables, which helps you summarize and analyze large volumes of data through dynamic tables.

Lookups and PivotTables
Good arguments
Referencing and summarization
Look up, not down
Pivot. Pivot!
A category of products
Grand total percentages
Wrap-up!

Introduction to Power Query in Excel

Navigating Data with Excel Power Query

Embark on a transformative journey through Excel Power Query, where data manipulation becomes an art. Designed for novices and experts alike, this course unlocks new efficiencies in data handling, leaving behind time-consuming manual processes. Discover the power to connect with varied data sources, streamline your datasets, and ready them for insightful analysis. Excel Power Query's suite of tools awaits to elevate your reporting and decision-making prowess, saving time and revealing valuable insights from your data.

Discovering Power Query in Excel

Begin with a comprehensive overview of Power Query, transforming Excel into a potent data analysis tool. Learn to import and systematically organize data with intuitive commands, tracking each step with precision. This foundational knowledge sets the stage for sophisticated data manipulation within the familiar Excel workspace.

Cleansing Data for Clarity

Dive into Power Query's cleaning features to produce immaculate datasets. Tackle errors, fill gaps in data, and eradicate duplicates. This module hones your skills in data refinement, ensuring your dataset's integrity and priming it for complex analysis.

The Art of Data Transformation

Conclude with a deep dive into data transformation techniques. Master the essentials of column transformations, including numerical, date/time, and text adjustments, leveraging Power Query's built-in functions. Experience advanced structuring methods like transposing, pivoting, and grouping, and learn to interlink queries for a comprehensive analytical narrative.

This condensed course promises a hands-on approach to mastering data efficiency and insight extraction with Excel Power Query, empowering you to become a savvy data analyst.

4 Modules | 5+ Hours | 4 Skills

Course Modules

Imagine Excel as you've never seen it before – Power Query opens a window to a whole new world of data possibilities! In this module, you’ll explore the layout and features of Power Query and its interplay with traditional Excel workbooks. You’ll load data from multiple sources and learn to structure them through column and row manipulations while maintaining an applied steps log of all your actions.

Introduction to Power Query
Excel Workbooks vs Excel Power Query
Navigating the Power Query Editor
Getting Started and Loading Data
Managing Columns
Extracting PDF Data

In this module, you’ll harness Power Query’s digital cleaning features to prepare a squeaky-clean dataset! Column profiling features will be covered, allowing you to handle errors and missing data effectively. You’ll also master eliminating duplicate data and correcting for data entry issues and outliers.

Data Cleaning and Preparation
Importance of Clean Data
Data Cleaning Techniques in Excel Power Query
Handling errors
Assessing column quality and missing data
Removing duplicate data
Outlier detection

It’s time to transform! This module covers many basic column transformations - a vital step in the journey from raw data to meaningful insights. You will learn how and when to apply numeric, date/time, and text transformations to both transform and derive column contents with Excel Power Query’s many built-in features.

Column Transformations
Impact of column transformations
Transformation types in Excel Power Query
Text transformations
Calculating age between two dates
Numeric transformations
Multiple column transformations

It’s all about shaping and grouping in this final module! You will get hands-on experience with powerful transformation options to bring your analysis prep to the next level. You’ll learn how and when to apply transpose, pivot, and group-by transformations - all within the Power Query editor. You’ll also learn how to leverage existing queries to build new ones and track their connection in the Query Dependencies tree.

Introduction to Data Shaping and Grouping
Which transformation to use?
Shaping and Grouping Data in Excel Power Query
Transposing data
Pivoting in Excel Power Query
Group by transformation
Wrap-up!

Intermediate Power Query in Excel

Building on your foundational Power Query in Excel knowledge, this intermediate course takes you to the next level of data transformation mastery. Discover advanced data integration techniques, including appending and merging datasets with various join types. Delve into M language syntax for creating custom conditional columns and harness advanced table transformations. Unlock the Power Query Advanced Editor, exploring M's built-in functions, mastering best practices like query grouping, and dynamically adjusting filter criteria with parameters. Elevate your skills by crafting custom M formula language functions, unleashing advanced query design capabilities that will empower you to extract deeper insights from your data.

3 Modules | 4+ Hours | 3 Skills

Course Modules

In this module, you’ll delve into Power Query's data integration capabilities. You’ll master the art of appending queries to combine datasets seamlessly. You’ll also learn to merge datasets together, harnessing various join types to render datasets in multiple ways.

Appending and merging queries
Using Append vs. Merge
Combining queries with Power Query
Appending queries
Merging queries with left outer join
Merging queries with inner join

It’s all about customization in this module. You’ll learn the fundamentals of M language syntax, and how it underpins every transformation step in query development. You’ll leverage M to create custom conditional columns using logical operators to suit numerous scenarios. You’ll also delve into M table transformation expressions to create custom grouped index columns, enhancing your proficiency in advanced query design.

Custom columns
Conditional logic with M
Custom columns in Power Query with M
Custom conditional columns
Advanced conditional columns
Calculating early warning system scores
Grouped index columns

In this final module, you’ll delve into the Power Query Advanced Editor, unraveling M-Language syntax for code modification and debugging. You’ll explore M's built-in functions, and master best practices such as query grouping and dynamic filtering with parameters. Lastly, you’ll elevate your skills by crafting custom M formula language functions, unlocking advanced query design capabilities.

M Formula Language
Power Query Advanced Editor
M for Power Query in Excel
Built-in M functions
Query parameters
Debugging the advanced editor
Custom functions
Wrap-up!

Power Pivot in Excel

Starting with Power Pivot in Excel

Getting started on this insightful journey through Excel Power Pivot, transforming your data analysis skills. Begin by learning how to enable the Power Pivot add-in and import data from various sources. You will be guided through the initial steps of preparing your data for analysis, setting the stage for more advanced techniques.

Exploring Data Modeling Concepts

Dive into the fundamental aspects of Power Pivot with data modeling. Learn to create relationships and hierarchies within your data, enabling a more structured and interconnected data model.

Unveiling the Power of DAX in Excel

Unlock the potential of Data Analysis Expressions (DAX). Master the basics of DAX calculations, creating measures and calculated columns to perform advanced data manipulations, allowing you to level up your analytical capabilities.

Crafting Interactive Reports

Utilize Power Pivot's strengths to help introduce interactivity and storytelling in your reports. Learn to add slicers and organize your visuals to create compelling data narratives. You will be able to create informative and engaging reports even within Excel.

This course promises a hands-on approach to mastering Power Pivot in Excel, empowering you to become a proficient data analyst capable of easily extracting actionable insights.

4 Modules | 5+ Hours | 4 Skills

Course Modules

You will take your first steps in setting up Power Pivot by enabling the add-in. Then, you will import data from various source types and practice preparing your data for analysis.

Introduction to Power Pivot
What's the pivot?
Getting started in Power Pivot
Turn it on
Preparing data with Power Query
Manage data in Power Pivot

In this module, you will begin exploring data modeling concepts in Power Pivot, including creating relationships and hierarchies.

Data modeling
Face the facts with dimensions
Data modeling in Power Pivot
Connection builds a relationship
Hierarchies
Mark your calendars

In this module, you will explore DAX (Data Analysis Expressions) in Power Pivot. You will learn to write DAX formulas to create calculated columns and measures. You will also understand the importance of row and filter context when using DAX.

Introduction to DAX
Keep it in context
DAX in Power Pivot
It's math, not magic
We're related
Aggregate measures

In the final module, you will make your Excel reports interactive with Power Pivot by adding slicers and organizing your visuals in a way that tells a data story.

Data stories with dashboards
Story time
Dashboards in Power Pivot
Visualizing data with PivotTables
Key performance indicators
Visualizing data with PivotCharts
Slice and dice
Wrap-up!

Advanced Excel Functions

Elevate Your Excel Skills

Expand your Excel expertise with this intermediate course, designed to introduce you to a range of new referencing, lookup, and database functions.

Reference Like a Pro!

The first two modules will build on your existing knowledge of lookup and referencing methods while introducing you to the advanced/updated functionalities of XLOOKUP, INDEX/MATCH, and OFFSET. Through practical exercises, you'll master these seemingly complicated functions and will start to wonder where they have been all your life! Whether it's navigating large datasets or automating repetitive actions, you'll gain efficiency and confidence.

Enter the World of Database Functions

Have you worked with Excel’s database functions before? This very useful but somewhat underused family of functions, introduced in the final module, can change the way you analyze large datasets when aggregations are necessary. You'll explore DSUM, DAVERAGE, and more, uncovering the mysteries of data analysis and manipulation. By the end of this course, these functions will become second nature, empowering you to extract valuable insights effortlessly.

Achieve Excel Mastery

As you progress through each module, you'll not only expand your technical skills but also develop a deeper understanding of Excel's vast capabilities. From enhancing your lookup abilities to mastering dynamic ranges and database functions, this course equips you with the tools and knowledge needed to excel in the world of spreadsheet excellence.

3 Modules | 4+ Hours | 3 Skills

Course Modules

Already a pro with VLOOKUP? Take your skills to the next level with advanced functions like XLOOKUP, INDEX, and MATCH. We'll explore practical applications, mastering these tools and gaining a solid understanding of arrays. Enhance your referencing and lookup capabilities with these powerful techniques.

Elevating your lookup game!
Lookups galore!
XLOOKUP and INDEX MATCH in action
Both way lookups
The Matching Game
Transposing and ranking

Discover the power of offsetting and dynamic name ranges as we master the OFFSET function and its practical uses. Set up and utilize dynamic ranges to enhance data management, applying OFFSET with functions like INDEX, MATCH, or even SUM and with data visualization. Transform your approach to complex datasets and elevate your Excel proficiency.

Navigating calculations with OFFSET and ranges
Let’s play a little game!
OFFSET( ) in practice
Moving on up!
Dynamic period
Preparing a comparison tool
Visualizing comparison

Discover the power of database functions with DSUM, DCOUNT, and DAVERAGE. Master how to sum, count, and average data according to specific criteria. The module also includes troubleshooting advice for common errors, helping you confidently tackle complex data aggregation tasks.

Database functions for large datasets
To DSUM or not to DSUM?
Summarizing data with database functions
Simple AND condition
Write your own criteria
Simple OR
Wildcards
Wrap up!

Financial Modeling in Excel

Are you ready to dive deep into the world of financial modeling and hone your Excel skills? In this comprehensive course, you'll embark on a journey that will empower you with the knowledge and tools to excel in financial analysis.

Discover the Power of Cash Flows

Begin your journey by unraveling the intricacies of cash flows. You'll construct a financial model, calculate net income, and gain a solid understanding of what makes up an income statement. These skills will form the foundation of your financial modeling prowess.

Master Scenario Analysis Techniques

Take your modeling skills to the next level by diving into scenario analysis. You'll learn how to forecast multiple outcomes, conduct sensitivity analysis, and effortlessly manipulate growth rates using Excel's versatile tools.

Unlock the Secrets of Time Value of Money

Understand the critical concept of the time value of money and its pivotal role in decision-making. You'll calculate present and future values and apply these skills with precision.

Becoming a Capital Budgeting Pro

Empower yourself with the ability to make data-driven decisions using metrics like net present value, internal rate of return. You'll compare results against benchmarks and provide actionable recommendations that drive success in financial scenarios.

Upon completing this course, you'll be equipped with the expertise to excel in financial modeling using Excel. You'll have a deep understanding of financial concepts and the practical skills to apply them effectively. Join us on this journey and unlock your potential as a modeling master!

4 Modules | 5+ Hours | 4 Skills

Course Modules

Use financial data from an income statement to create a financial model to forecast income, expenses, and net income and evaluate the purchase and sale price of the property using dynamic modeling features.

Introduction to financial modeling
Revenue or expense?
Financial modeling in Excel
Reviewing the financials
That's Cap
As the years go by
Exit now!

Use Excel’s What-If toolkit to enhance the power of financial modeling. Analyze and compare different hypothetical scenarios with the Scenario Manager, Goal Seek, and Data Table tools.

What-if analysis
What is what-if?
What-if analysis in financial models
Talk to my manager
Seek and you shall find
Data tables with one input variable
Two is better than one

Time is money! Use the time value of money to analyze cash flows through the lens of an investor with return on investment, future value, and present value.

The time value of money
Sorting out the future from the present
Time value of money calculations in Excel
Return on investment
Future value
Present value

Prioritize projects and make actionable investment recommendations using capital budgeting techniques. Calculate the net present value and the internal rate of return for the acquisition of West Ridge North.

Introduction to Capital Budgeting
Discounting NPV
Capital budgeting in Excel
Net present value
XNPV with time series
Internal rate of return
Your final recommendation
Wrap-up!

Case Study: Net Revenue Management in Excel

Fast Moving Consumer Goods

The world of Fast Moving Consumer Goods (FMCG) is a dynamic world that plays a significant role in our daily lives. Have you ever wondered how well-known brands like Coca-Cola, Nivea, and Lays are being managed? This case study will help you get a better understanding of this industry. You will start by analyzing a big dataset and by performing your own market analysis. You will go from calculating market share to creating clear visuals to reveal actionable insights.

Net Revenue Management

Next, you will use the principles of Net Revenue Management (NRM), which will help you to identify new growth opportunities for your company. You will have to use a variety of Excel tools and functions to calculate the true potential of these growth buckets. You will not only master everything which relates to PivotTables, VLOOKUP, and forecasting but also have a better understanding of what is happening behind the scenes of your favorite FMCG brands. Are you ready to use your Excel skills to build a complete business case?

3 Modules | 4+ Hours | 3 Skills

Course Modules

In the first module, you will be working as a category manager for Healthmax, a FMCG company active in the shampoo business. You will calculate Key Performance Indicators (KPIs) such as market share and value growth on various time dimensions such as year-to-date (YTD) and moving annual total (MAT).

Introduction to the case study
FMCG products
How do FMCG companies measure their performance?
Investigating the dataset
Year-over-year growth
Calculating Year-to-Date
Year-to-Date
Moving Annual Total
Market Share
New strategy implementation

In this module, you will learn about the concept of Net Revenue Management (NRM) and will focus on two of its pillars: Brand Portfolio Pricing and Mix Management. You’ll calculate important KPIs such as net sales contribution and gross margin. You’ll also use brand Portfolio Pricing to identify the correct price for your consumers. Consecutively you’ll use Mix Management techniques to help Healthmax launch a new product and expand into a new subcategory.

Net Revenue Management
Profit growth
Net sales
Gross margin
Profitability matrix
New category opportunity
New product launch

In the last module, you will focus on the three remaining pillars of Net Revenue Management (NRM). Trade Terms Management will help you to decide in which customers and products you should be investing to grow your business. You’ll combine that information with Pack Price Architecture to develop a new pricing strategy for a small shampoo bottle and use a Promotion Management technique to identify the most successful promotion. Finally, you’ll wrap it up by forecasting next year's growth by combining organic growth with the additional revenue of your NRM activities.

Net Revenue Management - Pillars
Trade Terms Management
Price Pack Architecture
Promotion Management
Forecasting
Waterfall
Wrap-up

Data Visualization in Excel

Building basic Charts

You will embark on an immersive exploration of basic Excel charts, equipping yourself with the skills to create impactful visualizations and customize chart types. Through a comprehensive understanding of Series and Categories, you will gain the expertise to transform data into compelling narratives that resonate with your audience.

Advancing to more complex charts

Ready to further enhance your charting skills with Excel? You will explore how to work with dual series and prepare more advanced charts, such as Bullet charts, Waterfall charts, or Scatter plots. Additionally, we will investigate various chart editing options.

Data Visualization best practices

Like any discipline, data visualization has its best practices, and it's time to take a closer look at the dos and don'ts. We will improve our skills in selecting chart elements, applying colors, legends, and labels, while also learning how to troubleshoot and customize poorly designed visuals for the benefit of end users.

Visualizing disaggregated data with PivotCharts

Get ready for an exciting journey into the world of visualizing disaggregated data! We'll explore PivotTables, PivotCharts, and how to combine them into a dynamic mini-dashboard. Are you ready to unlock the true power of your data?

4 Modules | 5+ Hours | 4 Skills

Course Modules

In this module, you will embark on an immersive exploration of basic Excel charts, equipping yourself with the skills to create impactful visualizations and customize chart types. Through a comprehensive understanding of Series and Categories, you will gain the expertise to transform data into compelling narratives that resonate with your audience.

Getting started with data visualization in Excel
Truth or a myth?
Building the first charts
Comparing Contributions
Visualizing Contribution Differently
How are we doing on Sales?
Visualizing Sales per Segment
Quarterly Sales per Region

Ready to further enhance your charting skills with Excel? This module will explore how to work with dual series and prepare more advanced charts, such as Bullet charts, Waterfall charts, or Scatter plots. Additionally, we will investigate various chart editing options. There's a lot to learn, so let's get started!

Exploring more complex charts
Pick the right chart!
Bullet, waterfall charts, and scatter plots
Tracking several measures
Comparing versus the average
Quarterly profit walkthrough
Regional performance quadrant

Like any discipline, data visualization has its best practices, and it's time to take a closer look at the dos and don'ts. In this module, we will improve our skills in selecting chart elements, applying colors, legends, and labels, while also learning how to troubleshoot and customize poorly designed visuals for the benefit of end users.

The art of data visualization
Misleading news?
Chart Clinic 1 on 1
Visualizing evolution
Accenting lines
Fixing a 3D chart
Colorful charts

Get ready for an exciting journey into the world of visualizing disaggregated data in this final module! We'll explore PivotTables, PivotCharts, and how to combine them into a dynamic mini-dashboard. Are you ready to unlock the true power of your data? Let's dive in!

Visualizing disaggregated data with PivotCharts
Aggregate or disaggregate - that is the question!
Pivot Charts in action
Basic PivotCharts
Exploring data with PivotCharts
Building a dashboard
Printing our results
Wrap-up!

Data Analysis in Excel

Exploring PivotTables

You will learn how to extract valuable insights and uncover secrets hidden within your data using the power of PivotTables. Additionally, you’ll learn how to use keyboard shortcuts to speed up your workflow.

Intermediate Logical Functions

You’ll identify your ideal customer profile using logical functions and create targeted marketing strategies. You’ll explore the concept of customer segmentation and gain the skills to maximize customer success, increase revenue and boost business growth.

What-if Analysis

You’ll master the art of scenario analysis using Excel’s built-in What-If Analysis tool. You’ll understand how different variables can impact your sales, perform sensitivity analysis and use it to make informed predictions to stay ahead in dynamic business environments.

Forecasting

You will unlock the power of forecasting to anticipate future trends and visualize this data for your stakeholders. You’ll leverage moving averages and trendlines to communicate your findings.

4 Modules | 5+ Hours | 4+ Skills

Course Modules

You will learn how to extract valuable insights and uncover secrets hidden within your data using the power of PivotTables. Additionally, you’ll learn how to use keyboard shortcuts to speed up your workflow.

Introduction to data analysis
Which steps should I take?
Exploratory data analysis in PivotTables
Getting started with PivotTables
Calculated fields in PivotTables
Custom grouping in PivotTables
Slicing data in PivotTables

You’ll identify your ideal customer profile using logical functions and create targeted marketing strategies. You’ll explore the concept of customer segmentation and gain the skills to maximize customer success, increase revenue and boost business growth. You’ll utilize functions such as Nested IFs, SWITCH, and COUNTIFS.

Diving deeper with logical functions
IF versus SWITCH
Intermediate logical functions in Excel
Swapping values with SWITCH
Nesting logical functions
Using COUNTIF and SUMIF
COUNTIFS and SUMIFS

You’ll master the art of scenario analysis using Excel’s built-in What-If Analysis tool. You’ll understand how different variables can impact your sales, perform sensitivity analysis and use it to make informed predictions to stay ahead in dynamic business environments.

What if...
What if this or that?
What-if analysis in Excel
Manual scenario creation
Using Goal Seek
What-if analysis with Scenario Manager
Sensitivity analysis with Data Tables

You will unlock the power of forecasting to anticipate future trends and visualize this data for your stakeholders. You’ll leverage moving averages and trendlines to communicate your findings.

Forecasting
The truth about forecasting
Forecasting techniques in Excel
Moving averages
Trendline forecasts
Forecast Sheet
Wrap-up!

Case Study: Analyzing Customer Churn in Excel

Apply your Excel Skills with a Case Study

For subscription-based businesses, reducing customer churn is a top priority. In this Excel case study, you'll investigate a dataset from an example telecom company, Databel, and analyze their churn rates.

Understand why customers churn

Analyzing churn doesn’t just mean knowing the churn rate: it’s also about figuring out why customers are churning at the rate they are and how to reduce churn. You'll answer these questions by creating calculated columns and fields, building PivotTables, and creating an eye-catching dashboard.

3 Modules | 4+ Hours | 3 Skills

Course Modules

In this first module, you’ll start by exploring your new dataset in Excel and gain an initial understanding of why customers are churning.

Analyzing customer churn in Excel
Analysis process
Data preparation
Understanding churn and it's applications
Calculating churn
Investigating churn reasons
Digging deeper into churn categories

You’ll continue leveraging the Excel knowledge you gained from the prerequisite courses to investigate further why customers are leaving Databel.

Zooming out
Analyzing demographics
Age groups
Unlimited plan
International calls
Retaining senior citizens
Contract type

In the last module, you’ll create a dashboard-style sheet and arrange your visuals to present your results to stakeholders in a cohesive story.

Creating a cohesive story
Dashboarding best practices
Overview - Adding KPIs
Overview - Adding churn reasons
Overview - Adding demographics
Overview - Adding consumption
Wrap-up

DATA ANALYTICS & VISUALIZATION WITH EXCEL COST

United States

$349.99

United Kingdom

£299.99

Career and Certifications

GreaterHeight Academy's Certificate Holders also prepared work at companies like:

Our Advisor is just a CALL away

+1 5169831065 +447474275645

Available 24x7 for your queries

Talk to our advisors

Our advisors will get in touch with you in the next 24 hours.

Get Advice

FAQs

Data Analytics & Visualization with Excel

Basic Excel for Data Analysis;
Intermediate & Advanced Excel for Data Analysis;
Excel PivotTable, PowerPivot, Power-Query & DAX;
Excel Interactive Dashboard;
Excel for Data Analysis & Visualization;
Excel for Business Analysis.

All our mentors are highly qualified and experience professionals. All have at least 15-20 yrs. of development experience in various technologies and are trained by GreaterHeight Academy to deliver interactive training to the participants.

Yes, we do. As the technology upgrades, we do update our content and provide your training on latest version of that technology.

All online training classes are recorded. You will get the recorded sessions so that you can watch the online classes when you want. Also, you can join other class to do your missing classes.

Yes. But you can also raise a ticket with the dedicated support team at any time. If your query does not get resolved through email, we can also arrange one-on-one sessions with our support team. However, our support is provided for a period of Twelve Weeks from the start date of your course.

Creating effective spreadsheets
Managing large sets of data
Mastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)
Create dynamic report with Excel PivotTables
Unlock the power and versatility of Microsoft Excel's Add-In, PowerPivot
Audit Excel Worksheet formulas to ensure clean formulas
Automate your day to day Excel tasks by mastering the power of Macros and VBA

No. Any abuse of copyright is taken seriously. Thanks for your understanding on this one.

Yes, we would be providing you with the certificate of completion of the program once you have successfully submitted all the assessment and it has been verified by our subject matter experts.

GreaterHeight is offering you the most updated, relevant, and high-value real-world projects as part of the training program. This way, you can implement the learning that you have acquired in real-world industry setup. All training comes with multiple projects that thoroughly test your skills, learning, and practical knowledge, making you completely industry ready.
You will work on highly exciting projects in the domains of high technology, ecommerce, marketing, sales, networking, banking, insurance, etc. After completing the projects successfully, your skills will be equal to 6 months of rigorous industry experience.

OUR POPULAR COURSES

Data Analytics and Visualization With Python

Advanced developments of expertise in cleaning, transforming, and modelling data to obtain insight into corporate decision making as a Senior Data Analyst - Using Python.

View Details

Data Science Training Masters Program

Learn Python, Statistics, Data Preparation, Data Analysis, Querying Data, Machine Learning, Clustering, Text Processing, Collaborative Filtering, Image Processing, etc..

View Details

Microsoft Azure DP-100 Data Science

You will Optimize & Manage Models, Perform Administration by using T-SQL, Run Experiment & Train Models, Deploy & Consume Models, and Automate Tasks.

View Details

Machine Learning using Python

Learn Data Science and Machine Learning from scratch, get hired, and have fun along the way with the most modern, up-to-date Data Science course on.

View Details

Microsoft Azure PL-300 Data Analysis

You will learn how to Design a Data Model in Power BI, Optimize Model Performance, Manage Datasets in Power BI and Create Paginated Reports.

View Details

Microsoft Azure DP-203 Data Engineer

You will learn Batch & Real Time Analytics, Azure Synapse Analytics, Azure Databricks, Implementing Security and ETL & ELT Pipelines.

View Details

The GreaterHeight Advantage

0+

Accredited Courseware

Most of our training courses are accredited by the respective governing bodies.

0+

Assured Classes

All our training courses are assured & scheduled dates are confirmed to run by SME.

0+

Expert Instructor Led Programs

We have well equipped and highly experienced instructors to train the professionals.

OUR CLIENTS

We Have Worked With Some Amazing Companies Around The World

Our awesome clients we've had the pleasure to work with!

Data Analytics & Visualization with EXCEL

Course Benefits & Key Features

Master Data Analytics With PowerBI’s benefits and key features.

Modules

Lessons

Practical

Life Projects

Resume

Job

Recording

Interviews

Support

Membership

Networks

Certification

INSTRUCTOR-LED LIVE ONLINE CLASSES

Why Data Analytics & Visualization With EXCEL?

Learn In-demand Skills

Earn a Higher Salary

Positive Job Outlook

Shape the Future

Become a Leader

Data Analysis are Constantly Evolving

GreaterHeight Certificates holders are prepared to work at companies like these.

Some Alumni Testimonies

QUEEN OBIWULU

BISOLA OGUNRO

TUNDE MEREDITH

JOHN OSI PETER

AYODELE PAYNE

ADEBAYO OLADEJO

Data Analytics & Visualization With Excel

Module 1: Getting started with Excel

Module 2: Managing Data and Applying Aggregate Functions

Module 3: Other Functions and Visualizing Data

Module 1: Starting Data Preparation in Excel

Module 2: Functions for Data Preparation

Module 3: Conditional Formulas

Module 4: Lookups and Data Transformation

Module 1: Getting Started with Power Query in Excel

Module 2: Data Cleaning and Preparation

Module 3: Column Transformations

Module 4: Shaping and Grouping Data

Module 1: Combining Queries in Power Query

Module 2: Custom Columns

Module 3: M Formula Language

Module 1: Starting with Power Pivot

Module 2: Data Modeling in Power Pivot

Module 3: DAX in Power Pivot

Module 4: Dashboards with Power Pivot

Module 1: Lookup and Reference Functions

Module 2: Offsetting and Dynamic Name Ranges

Module 3: Do more with Database Functions

Module 1: Financial Modeling

Module 2: What-if Analysis in Financial Models

Module 3: Time Value of Money

Module 4: Capital Budgeting

Module 1: Fast Moving Consumer Goods

Module 2: Net Revenue Management

Module 3: Optimizing Net Revenue

Module 1: Building Basic Charts

Module 2: Advancing to More Complex Charts

Module 3: Data Visualization Best Practices

Module 4: Visualizing Disaggregated Data with PivotCharts

Module 1: Exploring data with PivotTables

Module 2: Intermediate Logical Functions

Module 3: What-if Analysis

Module 4: Forecasting

Module 1: Exploratory Analysis

Module 2: Investigating Churn Patterns

Module 3: Creating a Cohesive Story

DATA ANALYTICS & VISUALIZATION WITH EXCEL COST

United States

United Kingdom

Career and Certifications

Our Advisor is just a CALL away

+1 5169831065 +447474275645

Available 24x7 for your queries

Talk to our advisors

Data Analytics & Visualization with Excel