Advanced Excel 2021 Training in Perth, Australia

Master using Microsoft Excel and leverage this multifaceted tool to create efficient worksheets

  • Learn expert-level features and functions available in Microsoft Excel
  • Understand how Pivot Tables and Charts work and how to use them
  • Learn to use mathematical commands and IF functionality efficiently
  • 350,000 + Professionals trained
  • 250 + Workshops every month 
  • 100 + Countries and Counting 

Microsoft Excel 2021 FAQs

Microsoft Excel 2021 Training

During this eight-hour course, a variety of topics will be covered with the aim of making you an expert in Microsoft Excel 2021. The following are the practical skills you’ll gain on course completion:

  • Developing a proficiency in basic as well as advanced concepts of Excel 2021
  • Understanding the various features and functions that are a part of the Excel Suite.
  • Applying the learning to analyze and expose trends that will help organizations.
  • Learning to leverage Excel 2021 as a tool to help you in Big Data Analytics.

These skills will help you get the most out of your worksheets using lesser time.

An advanced knowledge of MS Excel 2021 can benefit both students and professionals who are into data analysis or projecting statistics.

There are no prerequisites for attending this course. Any student or professional with a keen interest in honing their Microsoft Excel skills can attend this course.

Workshop Experience

Currently, all our courses are offered online as live, interactive, trainer-led sessions where you will get to learn directly from the trainer with opportunities to discuss and clear doubts.

Our instructors are experts in Microsoft Excel with several years of industry experience. They also have hands-on experience and will be able to tell you the practical aspects of what you are learning.

Our courses are delivered through live interactive virtual classrooms. Our training focuses on interactive learning, split across hands-on exercises, discussions, and team collaboration, all facilitated by the trainer who is a Microsoft Excel expert. The focus is on finding practical solutions to real-world scenarios in various Excel environments, both big and small.

No, you do not need to record the sessions, the sessions will be auto recorded on our LMS, you will be able to refer to them.

Become an Expert in Excel 2021

The potential of Excel in the world of Data analysis is now being realized and organizations are on the lookout for professionals who have mastered this tool. Our virtual class, with its comprehensive course structure, real-world examples and plenty of hands-on examples will help you master Excel and use it to achieve professional and academic success.

..... Read more
Read less

Highlights

  • Intensive training on applications of Excel 2021

  • Live, instructor-led online classes

  • Real-life projects to help you Master Excel 2021

  • Hands-on exercises to supplement classroom learning

  • Work with advanced formulas to create statistical analysis

  • Go from basic to advanced concepts in Excel 2021

Accredited by

The KnowledgeHut Edge

Brilliant Track Record

KnowledgeHut has empowered over 350,000 professionals with skills and certifications in various domains

Learn from Industry Experts

Interact and engage with certified instructors with a wealth of industry experience and a mastery of the subject

Advanced Curriculum

Learn from the latest, most up-to-date curriculum, designed with industry needs in focus

Hands-On Training

Learn with the help of practical individual and group exercises, quizzes, and activities

Strengthen Foundations

Learn concepts from scratch by learning through step-by-step guidance and detailed feedback

Continual Learning Support

Choose from monthly webinars, e-books, tutorials and more to strengthen your learning

Prerequisites

Prerequisites

There are no prerequisites to attend this course.

Basic knowledge of MS Excel will be helpful.

Who Should Attend This Course

Students

Graduates

Freshers

Professionals

Business Analysts

Data Analysts

Statistics Specialists

Schedules

Can't find the batch you're looking for?

Request a Batch

What You Will Learn

Microsoft Excel 2021 Basics

Get an overview of basic Excel functions like MIN, MAX, and SUM

Mathematical Functions

Understand functions like MEAN, MEDIAN and MODE

IF Functionality

Understand how to use the AND and OR operators within the IF function

Performing Data Lookups

Learn how to work with the VLOOKUP and HLOOKUP functions

Sparklines

Understand how to create and design a Sparkline

Advanced Mathematical Functions

Learn advanced functions including the Time and Date functions

Transform Your Workforce

Build Excel Proficiency Across Teams

Ramp up your organization's Excel skills! Help your team members maximize efficiency and derive crucial insights from data. This training program will help you build a team that is highly proficient in Excel 2021 and drive profitability.

  • Custom Training Solutions
  • Experiential Learning
  • Learn by Doing Approach
  • Immediately Applicable Skills

500+ Clients

Curriculum

Topics

  • What are Rows, Cells, and Column
  • Customizing Excel Quick Access Toolbar
  • Common Excel Shortcuts
  • Different Types of Data Types
  • Moving the Cells to Different Position
  • Understand the Menu and Toolbars
  • Use of Function Box
  • Use of Cell Reference and Cell Edits
  • Use of Name Box and Range

Topics

  • Understand the Formatting Techniques
  • Data Type Formatting
  • Formatting Techniques on Rows and Columns
  • Conditional Formatting

Topics

  • Text Functions
  • Date Functions
  • Basic Excel Formulas

Topics

  • Understanding Lists as a Table and Database
  • Sorting Lists
  • Filters
  • Grouping and Outlining Data

Topics

  • Inserting Images in Excel
  • Inserting Shapes in Excel
  • Working with SmartArt

Topics

  • SUM Function
  • AVERAGE Function
  • PRODUCT Function
  • MIN Function
  • MAX Function
  • COUNT Function
  • COUNTA Function
  • COUNTBLANK Function
  • COUNTIF Function
  • SUMIF(): Adding Only the Cells You Specify
  • COUNTIFS() and SUMIFS(): Counting and Summing
  • IF Function
  • AND Function
  • OR Function

Topics

  • VLOOKUP With Exact Match
  • INDEX and MATCH vs VLOOKUP
  • VLOOKUP With Approximate Match
  • Format as Table
  • Data Model Tool
  • Slicer in Pivot Table

Topics

  • Using Predefined Templates
  • Creating Custom Templates
  • Creating Macros
  • VBA Modules
  • Visual Basic Editor
  • VBA Coding and Scripting

Topics

  • Text to Columns
  • Remove Duplicates
  • Data Validation
  • Find and Replace
  • Data Entry Form

Topics

  • Calculated Fields in Pivot Table
  • Grouping Data with Pivot Table
  • GetPivotData
  • Group and Ungroup 

Topics

  • What-If Analysis: Goal Seek
  • What-If Analysis: Data Table
  • What-If Analysis: Scenario Manager
  • Auditing Formulas

Topics

  • Format as Table
  • Data Model Tool
  • Formatting Pivot
  • Value Fields Setting

Topics

  • Sparklines as Mini Charts
  • Column Chart and Bar Chart
  • Line Chart
  • Pie Chart
  • Area Chart
  • Combo Charts
  • Speedometer Chart
  • PivotChart
  • Creation of Interactive Dashboard
  • Presentation of Final Results

Topics

  • Activation of Data Analysis ToolPak Add-in
  • Descriptive Statistics
  • Histogram
  • Correlation
  • Linear Regression
  • Explanation of Regression Output
  • Muliple Linear Regression
  • Probability
  • Z-scores
  • Download the Results of Statistical Analysis
  • Time Series Analysis in Excel