Loading
  • Main Menu
GreaterHeight Technologies LLC ~ GreaterHeight Academy
  • All Courses
    • BI and Visualization
      • Mastering Data and Business Analytics
        • Basic Excel for Data Analysis
        • Intermediate and Advanced Excel for Data Analysis
        • Excel for Business Analysis & Analyst
        • PivotTable, PowerPivot, PowerQuery & DAX for Data Analysi
        • Data Analytics and Visualization with Tableau
        • Data Analytics with Power-BI
        • Data Analytics and Visualisation with SQL
      • Mastering Python for Data Analytics and Visualization
        • Python Foundation for Data Analytics
        • Data Analysis Using Python With Numpy and Pandas
        • Data Visualization Using Python with Matplotlib and Seaborn
        • Data Science with SQL Server and Azure SQL Database
        • Data Analytics and Visualisation with PowerBI
      • Complete Microsoft Excel Master Program
        • Basic Excel for Data Analysis
        • Excel Interactive Dashboard for Data Analysis
        • Intermediate and Advanced Excel for Data Analysis
        • PivotTable PowerPivot, PowerQuery & DAX for Data Analysis
        • Excel for Data Analysis and Visualization
        • Excel for Business Analysis & Analyst
      • Data Analytics With SQL Master Program
      • Master Data Analytics With PowerBI
      • Financial Reporting with PowerBI
      • Data Analysts with Power-BI
      • Data Analytics and Visualization with Excel
    • Mastering Python
      • Python Developer Masters Program
        • Python Programming Certification Course
        • Data Science With Python Certification
        • Artificial Intelligence Certification Course
        • PySpark Certification Training Course
        • Python Statistics for Data Science
      • The Complete Python Developer
      • Data Analysis and Visualization with Python
      • Complete Data Scientist with Python
      • Data Engineer with SQL and Python
      • Machine Learning Engineer with Python
    • Azure Cloud Computing
      • DevOps Engineer and Solutions Architect Master Program
      • Greaterheight Azure GH-602 Cloud Solution Architect Master
      • Greaterheight Azure GH-601 Cloud DevOps Master
      • Microsoft Azure az-900 Fundamentals
      • Microsoft Azure az-104 Administrator
      • Microsoft Azure az-204 Developer
      • Microsoft Azure az-305 Solutions Architect
      • Microsoft Azure az-400 DevOps Engineer
      • Microsoft Azure AI-900 Fundamentals
      • Microsoft Azure DP-100 Data Science
    • SQL and SQL-Server Database
      • Mastering SQL Server Development
      • Data Analytics With SQL Master Program
      • Data Engineer Course Online Masters Program
      • Data Science with SQL Server and Azure SQL Database
    • DevOps Development Program
      • DevOps Engineer & Solution Architect Expert Program
    • Data Science
      • Data Science With Python Certification
      • Pythom Statistics for Data Science
      • Data Science with SQL Server and Azure SQL Database
      • Complete Data Scientist with Python
  • Who We Serve
    • Individuals
    • Business
    • Universities
  • Partners
    • Employer Networks
    • Community Partnership
    • Opportunity Funds
    • Future Finance
    • Scholarships
  • Resources
    • Webinars
    • Blog
    • Tutorials
    • White Papers
    • Podcast
    • Events
  • Get Advice
GreaterHeight Technologies LLC ~ GreaterHeight Academy
  • All Courses
    • BI and Visualization
      • Mastering Data and Business Analytics
        • Basic Excel for Data Analysis
        • Intermediate and Advanced Excel for Data Analysis
        • Excel for Business Analysis & Analyst
        • PivotTable, PowerPivot, PowerQuery & DAX for Data Analysi
        • Data Analytics and Visualization with Tableau
        • Data Analytics with Power-BI
        • Data Analytics and Visualisation with SQL
      • Mastering Python for Data Analytics and Visualization
        • Python Foundation for Data Analytics
        • Data Analysis Using Python With Numpy and Pandas
        • Data Visualization Using Python with Matplotlib and Seaborn
        • Data Science with SQL Server and Azure SQL Database
        • Data Analytics and Visualisation with PowerBI
      • Complete Microsoft Excel Master Program
        • Basic Excel for Data Analysis
        • Excel Interactive Dashboard for Data Analysis
        • Intermediate and Advanced Excel for Data Analysis
        • PivotTable PowerPivot, PowerQuery & DAX for Data Analysis
        • Excel for Data Analysis and Visualization
        • Excel for Business Analysis & Analyst
      • Data Analytics With SQL Master Program
      • Master Data Analytics With PowerBI
      • Financial Reporting with PowerBI
      • Data Analysts with Power-BI
      • Data Analytics and Visualization with Excel
    • Mastering Python
      • Python Developer Masters Program
        • Python Programming Certification Course
        • Data Science With Python Certification
        • Artificial Intelligence Certification Course
        • PySpark Certification Training Course
        • Python Statistics for Data Science
      • The Complete Python Developer
      • Data Analysis and Visualization with Python
      • Complete Data Scientist with Python
      • Data Engineer with SQL and Python
      • Machine Learning Engineer with Python
    • Azure Cloud Computing
      • DevOps Engineer and Solutions Architect Master Program
      • Greaterheight Azure GH-602 Cloud Solution Architect Master
      • Greaterheight Azure GH-601 Cloud DevOps Master
      • Microsoft Azure az-900 Fundamentals
      • Microsoft Azure az-104 Administrator
      • Microsoft Azure az-204 Developer
      • Microsoft Azure az-305 Solutions Architect
      • Microsoft Azure az-400 DevOps Engineer
      • Microsoft Azure AI-900 Fundamentals
      • Microsoft Azure DP-100 Data Science
    • SQL and SQL-Server Database
      • Mastering SQL Server Development
      • Data Analytics With SQL Master Program
      • Data Engineer Course Online Masters Program
      • Data Science with SQL Server and Azure SQL Database
    • DevOps Development Program
      • DevOps Engineer & Solution Architect Expert Program
    • Data Science
      • Data Science With Python Certification
      • Pythom Statistics for Data Science
      • Data Science with SQL Server and Azure SQL Database
      • Complete Data Scientist with Python
  • Who We Serve
    • Individuals
    • Business
    • Universities
  • Partners
    • Employer Networks
    • Community Partnership
    • Opportunity Funds
    • Future Finance
    • Scholarships
  • Resources
    • Webinars
    • Blog
    • Tutorials
    • White Papers
    • Podcast
    • Events
  • Get Advice

Intermediary & Advanced Excel For Data & Business Analytics


Greaterheight Academy will teach you the intermediate and advanced topics needed to have you analyzing and visualizing dataset. You will learn with how to use pivot tables, VLookup, and date functions among other more as an intermediate.


Get Advice

Intermediary & Advanced Excel For Data & Business Analytics


Who this course is for:

  • This course is for anyone who wants to kickstart their career in Mastering Data & Business Analytics with Excel
  • This course is for anyone who wants to learn more about Excel.


What you will Learn:

  • Designing Better Spreadsheets
  • Formula Auditing
  • Data Validation Formulas and Functions
  • Making Decisions with Logical Functions
  • Looking Up Information
  • Advanced Sorting and Filtering
  • Working with Date and Time
  • Preparing Data for Analysis
  • Dynamic Arrays
  • Advanced Lookup and Reference Functions
  • Statistical Functions
  • Math Functions
  • New Functions - LET and LAMBDA
  • Practical Excel – Advanced Formulas
  • Macros and VBA.

Course Benefits & Key Features

Intermediate and Advanced Excel for Data Analysis' 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 Intermediary & Advanced Excel For Data & Business Analytics?

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)

Intermediary & Advanced Excel For Data & 

Business Analytics Course

Intermediate and Advanced. You will learn the Microsoft Exel intermediate and advanced concepts for professionals for data analysis & visualization for both data and business analysis. Let’s dive into it.

Intermediate and Advanced. You’ll learn the intermediate and advanced topics needed to have you analyzing and visualizing dataset. You will learn with how to use pivot tables, VLookup, and date functions among other more as an intermediate.


For advanced excel learners, you will learn how to manage and organize large amounts of data. You learn to comprehensive graphs, tables, and record a macro to automate common tasks and more.

WEEK 3-6 | 15 Modules | 10+ Hours | 10+ Skills

Course Modules


  1. The Golden Rules of Spreadsheet Design
  2. Improving Readability with Cell Styles
  3. Controlling Data Input
  4. Adding Navigation Buttons

  1. Troubleshooting Common Errors
  2. Formula Auditing: Tracing Precedents
  3. Formula Auditing: Tracing Dependents

  1. Creating Dynamic Drop-down Lists
  2. Other Types of Data Validation
  3. Custom Data Validation

  1. Logical Functions (AND, OR, IF)
  2. The IF Function
  3. Nested IFs
  4. The IFS Function
  5. Conditional IFs (SUMIF, COUNTIF, AVERAGEIF)
  6. Multiple Criteria (SUMIFS, COUNTIFS, AVERAGEIFS)
  7. Error Handling with IFERROR and IFNA

  1. Looking Up Information using VLOOKUP (Exact Match)
  2. Looking Up Information using VLOOKUP (Approx Match)
  3. Looking Up Information Horizontally using HLOOKUP
  4. Performing Flexible Lookups with INDEX and MATCH
  5. Using XLOOKUP and XMATCH
  6. The OFFSET Function
  7. The INDIRECT Function

  1. Performing Sorts on Multiple Columns
  2. Sorting Using a Custom List
  3. The SORT and SORTBY Functions
  4. Using the Advanced Filter
  5. Extracting Unique Values - The UNIQUE Function
  6. The FILTER Function

  1. Understanding How Dates are Stored in Excel
  2. Applying Custom Date Formats
  3. Using Date and Time Functions
  4. Using the WORKDAY and WORKDAY.INT Functions
  5. Using the NETWORKDAYS and NETWORKDAYS.INT Function
  6. Tabulate Date Differences with the DATEDIF Function
  7. Calculate Dates with EDATE and EOMONTH

  1. Why Clean Data?
  2. Remove Blanks and Duplicates
  3. Importing Data into Excel
  4. Removing Blank Rows, Cells and Duplicates
  5. Changing Case and Removing Spaces
  6. Splitting Data using Text to Columns
  7. Splitting Data using Text Functions
  8. Splitting or Combining Cell Data Using Flashfill
  9. Use Text Functions to Clean Data
  10. Find and Replace
  11. Concatenating Data
  12. Standardizing Data
  13. Convert Numbers Stored as Text to Numbers
  14. Spell Check
  15. Joining Data using CONCAT
  16. Format Data
  17. Formatting Data as a Table

  1. What are Dynamic Arrays?
  2. Introduction to Spills and Arrays
  3. Extract and Count Unique Entries
  4. Unique vs Distinct
  5. Extract Unique Values with Multiple Criteria
  6. Extract Unique Values by Column
  7. The SORT Function
  8. The SORT Function - Horizontal SORT
  9. SORTBY Function
  10. The SORTBY Function - Horizontal SORT
  11. Simple SEQUENCE and Unstacking Records
  12. The FILTER Function
  13. FILTER with Logic: + Operator (OR)
  14. FILTER with Logic: * Operator (AND)
  15. FILTER with Logic: = Operator (Both or Neither)
  16. FILTER with Logic: - Operator (One or the Other)
  17. Using RANDARRAY and RANDBETWEEN to Randomize Data
  18. Using XLOOKUP to Perform Complex Lookups
  19. Using XMATCH

  1. Performing 2-Way Lookups
  2. Using the CHOOSE Function
  3. Using the SWITCH Function

  1. Using MEDIAN, MODE.SNGL and MODE.MULT
  2. Using LARGE and SMALL
  3. Ranking Data with Sorting using RANK.EQ and RANK.AVG
  4. The COUNTBLANK function

  1. Rounding Values using ROUND, ROUNDUP and ROUNDDOWN
  2. Specialized Rounding (MROUND, CEILING.MATH and FLOOR.MATH)
  3. Using the AGGREGATE Function

  1. The LET Function
  2. The LAMBDA Function

  1. Finding the Last Occurrence of a Value
  2. Finding the Closest Value
  3. Extract Data from the Middle of a String

  1. Using Macros to Automate Tasks
  2. Recording, Saving and Running Macros
  3. Recording a Macro with Relative Referencing
  4. Multi-step Macros
  5. The VBA Editor
  6. Assigning Macros to Buttons
  7. Creating a Custom Macro Ribbon

Intermediary & Advanced Excel For Data &

Business Analytics 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


OUR POPULAR COURSES

Microsoft Azure Az-900 Fundamentals

Microsoft Azure Az-900 Fundamentals

Learn Cloud Computing concepts, Cloud models, Azure services, Compute, VMs and Containers, Azure CDN, Azure Storage, IoT and Machine Learning, Azure Policy, etc.

View Details
Data Analytics and Visualization With Python

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
Microsoft Azure Az-104 Administrator

Microsoft Azure Az-104 Administrator

Master and become expert in optimizing workloads, managing, and implementing virtual networks in Azure and explore IaaS architecture, services, tools, and creating and more.

View Details
Microsoft Azure Az-204 Azure Developer

Microsoft Azure Az-204 Azure Developer

Master in developing, planning, and scaling your web applications on Microsoft Azure. It includes training on Azure App Services, Azure Storage, Azure Virtual Machines, Azure SQL Database, etc.

View Details
Microsoft Azure AZ-305 Solutions Architect

Microsoft Azure AZ-305 Solutions Architect

You will learn Microsoft Azure Offering IaaS, PaaS, SaaS, migrate your project to Azure cloud, and build .NET applications with Azure, and much more.

View Details
Microsoft Azure Az-400 DevOps Engineer

Microsoft Azure Az-400 DevOps Engineer

You will learn Sprint Planning and Tracking, Manage code using Azure Repos, build CI/CD Pipeline, Integrate Azure Test plans and Artifacts, much more.

View Details
Data Science Training Masters Program

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 AI-900 AI Fundamentals

Microsoft Azure AI-900 AI Fundamentals

You will learn AI Workloads & Considerations, Monitoring & Optimization, Principles of Machine Learning on Azure, and Computer Vision Workload.

View Details
Microsoft Azure DP-900 Data Fundamentals

Microsoft Azure DP-900 Data Fundamentals

You will learn Relational Data Offerings in Azure, Data Ingestion,  Data Storage & Processing, Building with Power BI, and Query Relational Database in Azure.

View Details
Microsoft Azure DP-100 Data Science

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

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 DP-300 Database Administrator

Microsoft Azure DP-300 Database Administrator

Master Planning Deployment & Configure Azure SQL Offerings,   Security, Monitoring & Optimization ,   Automation of Tasks , and Perform Administration by using T-SQL.

View Details
Microsoft Azure PL-300 Data Analysis

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

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
Azure Cloud DevOps Engineer Master Program

Azure Cloud DevOps Engineer Master Program

GreaterHeight's Azure Cloud DevOps Engineer Master’s Program will prepare and take you from the beginner's level to the master's level as you master the four certification exams on Azure Cloud DevOps Engineer Master's paths.

View Details
Azure Cloud Solutions Architect Expert Master Program

Azure Cloud Solutions Architect Expert Master Program

GreaterHeight's Azure Cloud Solutions Architect Master’s Program will prepare and take you from the beginner's level to the master's level as you master the four certification exams on Azure Cloud Solutions Architect Master's paths.

View Details
Azure Cloud DevOps Engineer & Solutions Architect Expert Programs

Azure Cloud DevOps Engineer & Solutions Architect Expert Programs

Greaterheight Academy's Azure Cloud DevOps Solution Expert’s Program will prepare and take you from the beginner's level to the master's level as you master the five certification exams on Expert/Master's paths.

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!


Client 01
Client 02
Client 03
Client 04
Client 05
Client 06
Client 07
  • Contact info
  • Facebook
  • WhatsApp
  • (+86)1234567809
  • creative@gmail.com
  • Back to top