Microsoft Excel Courses

Online Instructor-led (1 days)

Online Self-paced (8 hours)

Microsoft Excel VBA and Macro Training 

Module 1: Recorded Macros

  • Understanding Excel Macros 
  • Enable the Developer Tab
  • Record a Macro
  • Run a Macro
  • Edit a Macro
  • Macro Security
  • Saving a Document as Macro Enabled
  • Relative Cell References
  • Assigning a Macro to the Toolbar
  • Assigning a Keyboard Shortcut to a Macro 

Module 2: Understanding Excel VBA

  • Programming in Microsoft Excel
  • VBA Terminology 
  • VBA Editor Screen
  • Closing the Editor 
  • Viewing the Excel Object Model 
  • Using the Immediate Window 
  • Setting Property Values 
  • Working with Worksheets
  • Accessing Help 

Module 3: Starting with Excel VBA

  • Using the Project Explorer 
  • Working with the Properties Window
  • Working with a Code Module
  • Setting Breakpoints in Code

Module 4: Using Excel Objects

  • Application Object 
  • Workbook Object
  • Range Object 
  • Using Range Objects 
  • Using Objects in a Procedure

Module 5: Programming Techniques

  • MsgBox Function
  • InputBox Function
  • InputBox Method
  • Simple If Statement
  • If...Then…else Statement
  • Select Case Statement
  • Do Loop
  • Do Until Loop
  • Do While Loop
  • For Next Loop
  • For Each…Next Loop

Module 6: Creating Custom Forms

  • Creating Custom Forms
  • Adding Text Boxes to a Form
  • Changing Text Box Control Properties
  • Adding Label Controls to a Form 
  • Adding a Combo Box Control
  • Adding Option Buttons
  • Adding Command Buttons

Module 7: Procedures

  • Understanding Procedures
  • Creating a New Sub Routine 
  • IntelliSense 
  • Using the Edit Toolbar 
  • Commenting Statements 
  • Indenting Code 
  • Bookmarking in Procedures

Module 8: Using Variables

  • Understanding Variables 
  • Creating and Using Variables 
  • Explicit Declarations
  • Scope of Variables 
  • Understanding Passing Variables 
  • Declaring Data Types
  • Using Arrays

Module 9: Functions in VBA

  • Understanding Functions 
  • Creating User-Defined Functions
  • VARTYPE Function
  • Creating a Function Library 
  • Importing a VBA Module

Module 10: Error Handling

  • Understanding Error Types
  • Excel Objects
  • Handling Errors
  • Error-Handling Routine
  • On Error Statements
  • Error Statement
  • Untrapped Errors
  • Working with Err Object 

Show moredown

Who should attend this Microsoft Excel VBA and Macro Training Course?

This Microsoft Excel VBA and Macro Training Course is designed for individuals seeking to enhance their proficiency in Excel and automate tasks using VBA (Visual Basic for Applications) programming. This Microsoft Excel Training can benefit a wide range of professionals, including:

  • Excel Users
  • Analysts and Data Professionals
  • Business Professionals
  • Financial Experts
  • IT Professionals
  • Educators
  • Administrative Staff
  • Entrepreneurs and Small Business Owners

Prerequisites of the Microsoft Excel VBA and Macro Training Course

There are no formal prerequisites for this Microsoft Excel VBA and Macro Course. However, a basic understanding of Microsoft Excel would be beneficial.

Microsoft Excel VBA and Macro Training Course Overview

Microsoft Excel VBA (Visual Basic for Applications) and Macro Training equip individuals with the skills to automate routine tasks and develop custom Excel solutions. This proficiency is increasingly crucial as it enables efficient data analysis and management, which is essential in today's data-driven environment.

Mastery in Excel Courses are vital for professionals seeking to enhance their productivity and data manipulation capabilities. It is particularly beneficial for Data Analysts, Financial Professionals, Administrative Staff, and anyone involved in repetitive data or reporting tasks aiming to streamline workflows and enhance accuracy.

The Knowledge Academy’s 1-day Microsoft Excel Training is designed to provide delegates with a comprehensive understanding of Excel VBA and Macros, empowering them to automate tasks, enhance data analysis, and create efficient, custom Excel applications. The hands-on approach ensures practical skills that can be applied immediately in the workplace.

Course Objectives

  • To introduce the fundamentals of Excel VBA and Macro creation
  • To demonstrate the application of VBA in automating Excel tasks
  • To teach the construction of custom functions and procedures
  • To equip delegates with the skills to manage and deploy Macros effectively
  • To enhance error-handling and debugging techniques in VBA

After completing this Microsoft Excel Course, delegates will receive a certification affirming their proficiency in Excel VBA and Macros. This certification recognises their skill set and significantly boosts their professional credibility and marketability, empowering them to tackle complex data tasks with efficiency and confidence.

Show moredown

What’s included in this Microsoft Excel VBA and Macro Training Course?

  • World-Class Training Sessions from Experienced Instructors  
  • Microsoft Excel VBA and Macro Training Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (1 days)

Online Self-paced (8 hours)

Microsoft Excel Masterclass Outline

Module 1: Navigation of the Excel Interface

  • Understanding the Excel Start Screen
  • Excel Tab Interface
  • Introduction to Microsoft Excel
  • Excel Workbook Screen
  • Ribbon
  • Name Box
  • Formula Bar
  • Worksheet Tab
  • Understanding the Backstage View
  • Accessing the Backstage View
  • Understanding Dialog Boxes
  • Launching Dialog Boxes
  • Understanding the Quick Access Toolbar
  • Changing the Location of the Bar
  • Understanding the Status Bar

Module 2: Use of Lists and Tables

  • Understanding Lists
  • Applying and Clearing a Filter
  • Performing an Alphabetical Sort
  • Performing a Numerical Sort
  • Creating a Table
  • Inserting or Deleting Table Records
  • Removing Duplicates
  • Modifying a Table
  • Sorting Data in a Table
  • Naming and Resizing Tables
  • Converting a Table to a Range
  • Deleting a Table

Module 3: Conditional Formatting

  • Understanding Conditional Formatting
  • Highlighting Cells Containing Values
  • Highlighting Cells Containing Text
  • Highlighting Duplicate Values
  • Using Top and Bottom Rules
  • Using Data Bars
  • Using Colour Scales
  • Using Icon Sets
  • Creating Custom Rules
  • Conditional Formatting Rules Manager
  • Clearing Rules

Module 4: Using Formulas and Creating Pivot Tables

  • Using Sparklines
  • Using Formulas in Excel
  • Exploring Excel Functions
  • Using Functions in Excel
  • Insert Function Button
  • Working with Names and Ranges
  • IF Formulas
  • AVERAGE Function and COUNT Function
  • Common Logical Functions
  • Create a PivotTable from an Excel Data List
  • Refresh Data/Change Data Source
  • Changing the PivotTable Design
  • Creating and Modifying a Pivot Chart
  • VLOOKUP
  • Undo, Redo, and Repeat with Keystrokes

Show moredown

Who should attend this Microsoft Excel Masterclass?

This Microsoft Excel Training is designed for individuals of varying skill levels who want to enhance their proficiency in using Microsoft Excel. This Microsoft Excel Training Course can benefit a wide range of professionals, including:

  • Beginners
  • Intermediate Users
  • Advanced Users
  • Business Professionals
  • Entrepreneurs and Small Business Owners
  • Data Analysts
  • Administrative Professionals
  • Project Managers

Prerequisites of the Microsoft Excel Course

There are no formal prerequisites for this Microsoft Excel Masterclass..

Microsoft Excel Masterclass Overview

Microsoft Excel is an indispensable tool across various industries, known for its versatility in data analysis, financial modelling, and information management. Its relevance stretches from simple spreadsheet management to complex data analytics, making it a critical skill set for professionals aiming to enhance their productivity and analytical capabilities.

Proficiency in Microsoft Excel Courses are crucial for professionals who deal with data, financial reports, and analytical tasks daily. This includes Accountants, Financial Analysts, Data Analysts, Project Managers, and Marketing Professionals. Mastering Excel streamlines their workflow and opens up opportunities for data-driven decision-making and insights, setting a solid foundation for career advancement.

The Knowledge Academy’s 1-day Microsoft Excel Training is designed to transform participants from casual users to Excel power users. Delegates will learn through practical examples, hands-on exercises, and real-world case studies, enabling them to unlock Excel's full potential. By the end of the day, participants will be proficient in advanced functions, data visualisation techniques, and automation processes, significantly enhancing their efficiency and analytical skills.

Course Objectives

  • To introduce the comprehensive capabilities of Microsoft Excel, from basic functionalities to advanced features
  • To develop skills in using formulas, functions, and Excel operations to solve complex problems
  • To enhance proficiency in data analysis and visualisation tools for insightful reporting
  • To teach efficient data management techniques, including sorting, filtering, and conditional formatting
  • To explore the power of PivotTables and PivotCharts for dynamic data summarisation and exploration

After completing this Microsoft Excel Course, delegates will receive a Microsoft Excel Course completion certificate, recognising their proficiency in Excel. This Microsoft Excel Certification validates their skills and enhances their professional credibility, opening doors to new career opportunities and advancements.

Show moredown

What’s included in this Microsoft Excel Masterclass?

  • World-Class Training Sessions from Experienced Instructors  
  • Microsoft Excel Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (1 days)

Online Self-paced (8 hours)

Excel for Accounting Course Outline

Module 1: Using Lists in Excel

  • Defining a List
  • Sorting Lists
  • Filtering Lists
  • Managing a List
  • Using the Data Form

Module 2: Pivot Tables

  • Purpose of Pivot Tables
  • Getting Data Summaries
  • Building Pivot Tables
  • Data Cache
  • Using Named Ranges as Data Sources

Module 3: Common Sizing Using Worksheets

  • Rationale for Common Sizing
  • Other Uses of Common Sizing

Module 4: Charting

  • Why Charts?
  • Charts that Show Time Series
  • Pivot Charts Vs Standard Charts
  • Budget Variances Over Time

Module 5: Tools for Accountants

  • What Tools do Accountants Need?
  • Built-In Lists
  • Building Custom Lists
  • Using the Macro Recorder
  • Using Keyboard Shortcuts

Module 6: Scenarios in Excel

  • Scenarios and Multiple Inputs
  • Scenarios and Worksheets
  • Creating Scenarios
  • Defining an Implicit Intersection
  • More Help from the Scenario Manager
  • Grinding it Out with Goal Seek and Solver

Module 7: Payment Functions

  • Payment Functions
  • Using a Function
  • Using the Function Wizard

Module 8: Excel's Depreciation Functions

  • Family of Depreciation Functions
  • SLN Function
  • Accelerated Depreciation

Module 9: Excel and QuickBooks

  • IIF Import Files
  • Format of an IIF File
  • Exporting Data into an IIF File
  • Creating Multiple Lists in One IIF File
  • Importing an IIF File
  • IIF File Keywords for Lists
  • Profile Lists Import Files
  • Standard Lists Import Files
  • Updating Lists with Excel Import Files
  • Importing Adjusting Entries

Show moredown

Who should attend this Excel for Accounting Course?

The Excel for Accounting Training is tailored for professionals in the field of accounting who want to enhance their proficiency in using Microsoft Excel for financial analysis, reporting, and data management. This Microsoft Excel Training is well-suited for a variety of professionals, including:

  • Accountants
  • Financial Analysts
  • Auditors
  • Bookkeepers
  • Finance Managers
  • Cost Accountants
  • Forensic Accountants
  • Budget Analysts

Prerequisites of the Excel for Accounting Course

There are no formal prerequisites for the Excel for Accounting Training. However, delegates should have a basic understanding of accounting principles and Microsoft Excel functionality.

Excel for Accounting Course Overview

The Excel for Accounting Course is a specialised Microsoft Excel Training Course tailored for accounting professionals. As Microsoft Excel remains an indispensable tool in the finance and accounting sectors, this course delves deep into its functionalities. It bridges the gap between general Excel knowledge and specific accounting applications, making it highly relevant in today's data-driven business environment.

Understanding and mastering Microsoft Excel is crucial for Accountants and Financial Analysts. These professionals rely heavily on Excel for data analysis, financial modelling, and reporting. The Excel for Accounting Course is designed specifically for those who seek to enhance their analytical skills and efficiency in financial tasks using Microsoft Excel Courses.

This 1-day training offered by The Knowledge Academy is a comprehensive course that enables delegates to gain hands-on experience. Delegates will learn advanced Excel features relevant to accounting, such as complex formulas, data visualisation techniques, and automation of repetitive tasks. The course is structured to provide immediate practical benefits, improving workflow and decision-making capabilities.

Course Objectives

  • To equip delegates with advanced Excel skills tailored for accounting and financial tasks
  • To enable understanding of complex formulas and functions relevant to financial analysis
  • To enhance data visualisation techniques for creating impactful financial reports
  • To teach automation methods for streamlining repetitive accounting processes
  • To improve accuracy and efficiency in financial modeling and forecasting
  • To foster the ability to integrate Excel with other accounting software and tools

Upon completing this course, delegates will not only be proficient in utilising Excel for accounting purposes but also be able to apply these skills effectively in their professional roles. This proficiency will lead to increased efficiency and accuracy in financial reporting and analysis, greatly benefiting their organisations.

Show moredown

What’s included in this Excel for Accounting Course?

  • World-Class Training Sessions from Experienced Instructors
  • Excel for Accountants Certificate
  • Digital Delegate Pack

Show moredown

Online Instructor-led (1 days)

Online Self-paced (8 hours)

Business Analytics with Excel Course Outline

Module 1: Introduction to MS Excel

  • What is Business Analytics?
  • What is MS Excel?
  • Features of MS Excel
  • Basic Worksheet Modelling
  • Range Names

Module 2: Functions

  • Lookup Functions
  • INDEX Function
  • MATCH Function
  • Text Functions
  • NPV and XNPV Functions
  • IRR, XIRR, and MIRR Functions
  • More Excel Financial Functions
  • IF, IFERROR, IFS, CHOOSE, and SWITCH Functions
  • COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions
  • SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS, and MINIFS Functions
  • OFFSET Function
  • INDIRECT Function

Module 3: Using Solver

  • Using Solver to Determine the Optimal Product Mix
  • Using Solver to Schedule Your Workforce
  • Using Solver to Solve Transportation or Distribution Problems
  • Using Solver for Capital Budgeting
  • Using Solver for Financial Planning
  • Using Solver to Rate Sports Teams

Module 4: Data in Excel

  • Importing Data from a Text File or Document
  • Geography and Stock Data Types
  • Validating Data
  • Summarising Data by Using Histograms and Pareto Charts
  • Summarising Data by Using Descriptive Statistics
  • Using Pivot Tables and Slicers to Describe Data
  • Data Model
  • Summarising Data with Database Statistical Functions
  • Consolidating Data

Module 5: Introduction to Variables

  • An Introduction to Random Variables
  • Binomial, Hypergeometric, and Binomial Random Variables
  • Poisson and Exponential Random Variable
  • Normal Random Variable and Z-Scores
  • Using the Lognormal Random Variable to Model Stock Prices

Show moredown

Who should attend this Business Analytics with Excel Course?

The Business Analytics with Excel Training is designed for individuals who want to gain practical skills in Microsoft Excel for data analysis and business decision-making. This Microsoft Excel Training Course will benefit the following professionals:

  • Business Analysts
  • Data Analysts
  • Financial Analysts
  • Operations Managers
  • Marketing Researchers
  • Supply Chain Professionals
  • Consultants

Prerequisites of the Business Analytics with Excel Course

There are no formal prerequisites for this Business Analytics with Excel Training.

Business Analytics with Excel Course Overview

Business Analytics with Excel is an essential skill in today's data-driven environment. Excel, being one of the most versatile tools, enables professionals to interpret and analyse data efficiently. This masterclass is designed to bridge the gap between theoretical knowledge and practical application, making it indispensable in the modern business landscape.

Proficiency in Excel Courses are crucial for making informed decisions and strategic business planning. It is particularly vital for professionals in roles such as Business Analysts, Project Managers, and Data Analysts. Mastering Excel for analytics allows these individuals to leverage data effectively, enhancing productivity and driving business success.

The Knowledge Academy’s 1-day training is structured to impart comprehensive knowledge and hands-on experience with Excel's advanced analytics functions. Delegates will learn to navigate complex datasets, perform statistical analysis, and present data visually. The focused approach ensures that participants can immediately apply their skills to real-world scenarios, significantly boosting their analytical capabilities.

Course Objectives

  • To introduce delegates to the fundamentals of Business Analytics with Excel
  • To enhance proficiency in using Excel's advanced analytical tools and functions
  • To demonstrate how to manage and analyse large datasets effectively
  • To teach effective data visualisation techniques for business reporting
  • To develop skills in predictive analysis and forecasting using Excel

After completing this course, delegates will receive a certification in Business Analytics with Excel, affirming their proficiency in utilising Excel for advanced business analytics. This certification boosts employability and advancement in data analysis and business intelligence.

Show moredown

What’s included in this Business Analytics with Excel Course?

  • World-Class Training Sessions from Experienced Instructors
  • Business Analytics with Excel Masterclass Certificate                
  • Digital Delegate Pack

Show moredown

Online Instructor-led (1 days)

Online Self-paced (8 hours)

Excel Training with Gantt Charts Course Outline

Module 1: MS Excel Basics

  • Getting Started
  • Explore Window
  • Backstage
  • Entering Values
  • Move Around
  • Save Workbook
  • Worksheet
    • Create Worksheet
    • Copy Worksheet
    • Hiding Worksheet
    • Delete Worksheet

Module 2: Editing Worksheet

  • Data
    • Insert Data
    • Select Data
    • Delete Data
    • Move Data
  • Rows and Columns
  • Copy and Paste
  • Find and Replace
  • Spell Check
  • Zoom In-Out
  • Special Symbols
  • Insert Comments
  • Add Text Box

Module 3: Working with Formula

  • Creating Formulas
  • Copying Formulas
  • Formula Reference
  • Using Functions

Module 4: Excel Charts

  • Types of Advanced Charts
  • Advanced Charts in Brief
    • Waterfall Chart
    • Band Chart
    • Gantt Chart
    • Thermometer Chart
    • Bullet Chart
    • Funnel Chart
    • Waffle Chart
    • Step Chart
    • Box and Whisker Chart
    • Histogram
    • Pareto Chart
    • Organisation Chart
  • Methodology for Creating Advanced Excel Charts

Module 5: Advanced Excel - Gantt Chart

  • What is a Gantt Chart?
  • Advantages of Gantt Charts
  • Preparation of Data
  • Creating a Gantt Chart

Module 6: Make a Gantt Chart

  • Add Duration Data to the Chart
  • Add Task Description to the Gantt Chart in Excel
  • Transform the Bar Chart into an Excel Gantt Chart in Excel
  • Adjust the Number of Dates on Your Gantt Chart in Excel

Show moredown

Who should attend this Excel Training with Gantt Charts Course?

The Excel Training with Gantt Charts Course is designed for professionals aiming to master the use of Microsoft Excel for Project Management, specifically focusing on creating and managing Gantt charts. This course will benefit the following professionals:

  • Project Managers
  • Team Leaders
  • Planners and Schedulers
  • Operations Managers
  • Business Analysts
  • Engineers
  • Entrepreneurs
  • Operations Coordinators

Prerequisites of the Excel Training with Gantt Charts Course

There are no formal prerequisites to attend the Excel Training with Gantt Charts Course. However, a basic knowledge of Microsoft Excel would be beneficial.

Excel Training with Gantt Charts Course Overview

Excel is an indispensable tool for managing projects, and Gantt charts are pivotal for tracking project schedules and progress. This course introduces participants to the advanced functionalities of Excel for creating and managing Gantt charts, highlighting its significance in inefficient project management.

Proficiency in Excel Courses are crucial for Project Managers, Planners, and anyone involved in project execution. Mastering these tools enables professionals to visualise project timelines, allocate resources effectively, and anticipate potential schedule conflicts, ensuring project success.

The Knowledge Academy’s 1-day Microsoft Excel Training is designed to equip delegates with practical skills in using Excel for Gantt chart creation, enabling effective project timeline visualisation. Delegates will learn shortcuts, tips, and techniques to streamline their project management tasks, improving their ability to meet deadlines and manage resources more effectively.

Course Objectives

  • To introduce the basics of Gantt chart creation in Excel
  • To demonstrate how to customise Gantt charts to match project requirements
  • To teach effective techniques for updating and maintaining Gantt charts
  • To enable understanding of resource allocation and timeline adjustments using Excel
  • To provide insights into tracking project progress and identifying potential delays

After completing the Microsoft Excel Training Course, delegates will receive a certification, affirming their proficiency in using Excel to manage Gantt charts. This certification will test their ability to apply advanced Excel features for effective project management, enhancing their professional credibility and career advancement opportunities.

Show moredown

What’s included in this Excel Training with Gantt Charts Course?

  • World-Class Training Sessions from Experienced Instructors
  • Excel Training with Gantt Charts Certificate
  • Digital Delegate Pack

Show moredown

Not sure which course to choose?

Speak to a training expert for advice if you are unsure of what course is right for you. Give us a call on + 1-866 272 8822 or Enquire.

Package deals for Microsoft Excel Courses

Our training experts have compiled a range of course packages on a variety of categories in Microsoft Excel Courses, to boost your career. The packages consist of the best possible qualifications with Microsoft Excel Courses, and allows you to purchase multiple courses at a discounted rate.

Swipe for more. Don’t miss out!

Microsoft Excel Courses FAQs

Microsoft Excel is a powerful spreadsheet application developed by Microsoft, used for data analysis, visualisation, and complex calculations, featuring pivot tables, graphing tools, and a macro programming language.
Register for The Knowledge Academy’s comprehensive Excel Courses to kickstart your journey in learning Excel.
This Excel Online Course comes with a comprehensive Excel tutorial from experienced trainers, a digital delegate pack, and a certificate upon completion of the course.
There are no formal prerequisites for attending our Microsoft Excel Certification Training, but it is beneficial for delegates to have prior knowledge of how to use a computer and Windows.
These Excel Online Courses offer flexibility, a personalised learning pace, access to a wide range of resources, the ability to enhance employability, and opportunities for certification from anywhere.
Common career paths for someone with Microsoft Excel Certification include Data Analyst, Financial Analyst, Administrative Assistant, Project Manager, Business Analyst, Accountant, and Marketing Analyst.
This Excel Training covers advanced features, including complex formulas, PivotTables, macro automation, data analysis techniques like statistical functions, and visualisation tools to manage and interpret large datasets effectively.
Our Excel Training Courses uniquely combine practical assignments, real-world case studies, and personalised feedback, ensuring learners not only understand but can apply Excel skills in diverse professional scenarios.
Exclusive features of our Excel Training Courses include personalised feedback, real-world case studies, advanced simulation exercises, and access to a community of Excel experts for ongoing support.
Practical applications of Excel Spreadsheet skills in real-world business scenarios include financial modelling, budgeting, data analysis, reporting, inventory management, and performance tracking.
Limitations or restrictions associated with these courses may include course fees, prerequisite knowledge for advanced classes, and the need for a compatible version of Microsoft Excel software.
The Knowledge Academy is the Leading global training provider for Microsoft Excel Courses.
The training fees for Microsoft Excel Courses in Puerto Rico starts from $1295.
Show more down

Why we're the go to training provider for you

icon

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

icon

Trusted & Approved

We are accredited by PeopleCert on behalf of AXELOS

icon

Many delivery methods

Flexible delivery methods are available depending on your learning style.

icon

High quality resources

Resources are included for a comprehensive learning experience.

barclays Logo
deloitte Logo
Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

santander logo
bmw Logo
Google Logo
cross

OUR BIGGEST SPRING SALE!

Special Discounts

red-starWHO WILL BE FUNDING THE COURSE?

close

close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

close

close

Press esc to close

close close

Back to course information

Thank you for your enquiry!

One of our training experts will be in touch shortly to go overy your training requirements.

close close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.