top of page

437-370-1210

365-341-3115

Business Analysis

with excel (BA-ex)

Amplify your Business Analysis Skills with our 15-hour High-Intensity Learning Program®️ focused on the role of Microsoft Excel in Business Analysis. Learn Data Manipulation, Data Cleansing, Data Analysis, Lookup functions, Pivot Tables and to use Excel to create data-backed BA Artefacts!

Overview   |  FAQ

15-Hour Program  |  2-Days

Home > Courses > BA with Excel

Business Analyst Training Bootcamp

Kick-start your career switch story with this Complete Business Analyst Training and Placement Program. Learn how to tackle complex business problems using in-demand BA tools. Make the most of this business analyst course with four projects as business analyst case studies and core training focused on business analyst certifications.

ITCity is an endorsed education provider of IIBA®️ and an authorized training partner of SCRUMstudy®️.

Overview  |  Curriculum  |  FAQ

12-Week Bootcamp  |  46 Lectures

Home > Courses > Business Analyst Training

Introduction to Business Analysis & Overview of the Business Analyst Job Market

Mastering Product Ownership & Business Cases + Product Owner Certification Training

Crafting Business Case Documents & Product Vision Documents

Performing Market Research & Cost-Benefit Analysis on Business Cases

Experiencing Pre-Project Activities and Project Kick-off through Live Project #1

Understanding Stakeholder Management: Identification, Organization, and Analysis

Conducting GAP Analysis: Current State vs Future State & Creating UML Diagrams

Executing Requirements Elicitation Techniques and Requirements Workshops

Constructing a Comprehensive Business Requirements Document

Comparing Waterfall & Agile SDLC Frameworks: Concepts and Differences

Writing Agile Requirements: Eliciting Epics & User Story Documentation

Developing User Stories for In-flight Projects through Live Projects #2 and #3

Understanding Core SCRUM & Agile Components + Scrum Master Certification Training

Grasping Structured Query Language (SQL) Concepts & CRUD Operations

Exploring API Concepts, Creation, and Testing using Postman Software

Domain Knowledge: Finance, Telecom, Healthcare, E-Commerce & Public Sector

Kick-start your Business Analysis journey with our comprehensive curriculum, designed to equip you with sought-after skills and real-world knowledge. Begin with an introduction to Business Analysis and an overview of the Business Analyst job market, setting the stage for your successful career. Dive into the nuances of Product Ownership, Business Cases, and gain hands-on experience in creating Business Case Documents and Product Vision Documents. This course offers exclusive training for sought-after certifications like Product Owner Certification, Scrum Master Certification and Agile Analysis Certification, enhancing your marketability in the job market. Our meticulously structured program takes you through crucial pre-project activities, project intake, and project kick-off, facilitated through live projects for experiential learning. Master Stakeholder Management, GAP Analysis, and UML Diagrams preparation, all key components to understanding current and future states of a business. Delve into effective Requirements Elicitation techniques and workshop execution, culminating in creating a robust Business Requirements Document. Explore the core differences between Waterfall and Agile SDLC frameworks and understand the art of writing requirements in Agile through Epics and User Story Documentation. You'll also learn the following tools:

JIRA

CONFL

ONE NOTE

EXCEL

POWER BI

GLIFFY

LUCID CHART

VISIO

 SQL

FIGMA

SMC

SPOC

AAC

ECBA

Kick-start your Business Analysis journey with our comprehensive curriculum, designed to equip you with sought-after skills and real-world knowledge. Begin with an introduction to Business Analysis and an overview of the Business Analyst job market, setting the stage for your successful career. Dive into the nuances of Product Ownership, Business Cases, and gain hands-on experience in creating Business Case Documents and Product Vision Documents. This course offers exclusive training for sought-after certifications like Product Owner Certification, Scrum Master Certification and Agile Analysis Certification, enhancing your marketability in the job market. Our meticulously structured program takes you through crucial pre-project activities, project intake, and project kick-off, facilitated through live projects for experiential learning. Master Stakeholder Management, GAP Analysis, and UML Diagrams preparation, all key components to understanding current and future states of a business. Delve into effective Requirements Elicitation techniques and workshop execution, culminating in creating a robust Business Requirements Document. Explore the core differences between Waterfall and Agile SDLC frameworks and understand the art of writing requirements in Agile through Epics and User Story Documentation. You'll also learn the following tools:

Business Analyst Course Curriculum

NOVEMBER

11 & 18

💻 Online, Instructor Led

📅 2-Day Crashcourse

​🚸 4 Lectures, 15 Hours

🏢 Hands-On Live Project

​📆 Two Saturdays

🕒 10:00 AM - 05:00 PM EST

​👨‍🏫 Trainer: Rishi Poptani

🔠 Language: English

C$ 1499.00

C$ 1099.00

TAXES INCLUDED

DECEMBER

02 & 09

💻 Online, Instructor Led

📅 2-Day Crashcourse

​🚸 4 Lectures, 15 Hours

🏢 Hands-On Live Project

​📆 Two Saturdays

🕒 10:00 AM - 05:00 PM EST

​👨‍🏫 Trainer: Rishi Poptani

🔠 Language: English

C$ 1499.00

C$ 1099.00

TAXES INCLUDED

JANUARY '24

13 & 20

💻 Online, Instructor Led

📅 2-Day Crashcourse

​🚸 4 Lectures, 15 Hours

🏢 Hands-On Live Project

​📆 Two Saturdays

🕒 10:00 AM - 05:00 PM EST

​👨‍🏫 Trainer: Rishi Poptani

🔠 Language: English

C$ 1499.00

C$ 1099.00

TAXES INCLUDED

Schedule for BA with Excel

Build skills with experts anytime anywhere. We offer course training on weekdays and weekends. Explore upcoming BA Training in Canada.

  • This program will cater to enhance your Business Analysis Skills by making extensive use of  Microsoft Excel in your day-to-day BA work. You will learn how to perform Data Manipulation, Data Cleansing, Data Analysis, Lookup functions, Pivot Tables and to use Excel to create data-backed BA Artefacts!

  • This program will take 3 days to complete with 12 hours of training every day of the program.

  • Oh Absolutely! Its is even more imperative to master excel if you are planning to start your career in Business Analysis. Showing this cohort on your resume will surely give you an edge!

  • This is a live training that will be conducted online via Zoom by none other than Rishi Poptani! a CBAP®️ certified and seasoned BA with 11 years of experience in Capital Markets.

    • Fees: The fees for this program are payable in two installments.

    • Refunds: Full refund if enrollment is withdrawn within 15 days of course commencement. No refunds after that time frame for any installments paid.

    • Pricing: All our prices are in Canadian Dollars (CAD). If you are an international client, your bank/payments processor will take care of the currency conversion. You will be charged in your local currency equivalent to the current date's conversion rate.

    • Payments: We currently accept payments through all Credit Cards, Debit Cards and Paypal. Canadian clients can Interac us too.

F.A.Q

BA with Excel Program Overview

Microsoft Excel is a cornerstone in business analysis, offering versatile tools for data storage, visualization, and in-depth analysis. Its user-friendly interface, integration capabilities, and robust financial modeling functions make it indispensable in the corporate landscape. BA with Excel Program is designed to build excel skills that will add a layer of expertise to your Business Analysis Profession. 

Key Highlights:

    • Eliminating blank rows from a sample dataset

    • Remediating duplicate data

    • Formatting Excel data using text functions

    • Effective use of find and replace to model data

    • Using flash fill functions

    • Introduction to Exploratory Data Analysis

    • Executing summary statistics and conditional formatting

    • Working with tables  in Excel

    • Using Conditional formulae - SUMIF, COUNTIF, AVERAGE IF to find target data

    • Operational Data vs Reference Data

    • Index Matching

    • Using Pivot Tables for Data Analysis

    • Using Slicers

    • Evaluation of Business Rules

    • Data Dictionary using Data Validation

    • Requirements Prioritization using Excel

    • Requirements Analysis and Documentation using Excel

61% of Jobs

An independent survey shows that 61% BA job postings deem Excel as a must-have skill

#6 in Top 25

Excel is ranked at #6  among top 25 must have BA Skills

Productivity

Your BA productivity will be boosted by 43% when dealing with datasets.

Deal Maker

Possessing excellent Excel skills have proven to be deal makers for BAs in the job market.

Live, Online Lectures

Hands-On Workshop

2-Day Training Program

15+ Hours of Coaching

You earn 12 IIBA PDUs

Free Career Consulting

bottom of page