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!
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
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.
-
Frequently Asked Questions
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