Simple Technique for Using Excel to Analyze Process Maps

Name: Simple Technique for Using Excel to Analyze Process Maps
Rating: 4.5 (13 reviews)

Sample Process Discussed in Course

Created byGhassan Kabbara

Last updated 8/2024

English

English [Auto],

What you'll learn

Brief Intro of Swimlane Processes using Visio
How to Review the As-Is Mapped Processes using Gap Analysis
Generating key Attributes of the Mapped To-Be Processes into Excel for Analysis
Using Pivot Tables to understand the Overall Attributes of your Processes.(Approvals, Decisions, Manual Input, etc)
Bonus Video (My Bloopers during an Interview)

Course content

1 section • 6 lectures • 30m total length

Introduction to Listing Processes & Swimlane Processes Using Visio6:43
Learn a simple technique to analyze mapped processes using a spreadsheet, extracting key attributes from swimlane diagrams in visio and leveraging excel to reveal process owners, decision points, and gaps.
Introduction to a Swinlane As-Is Mapped Process2:25
Explore the as-is contract review process, map its steps in a spreadsheet, and identify bottlenecks to inform revamping and an RFP for ERP.
Gap Analysis Overview & Best Practice to map To-Be Processes3:10
Explore gap analysis after process mapping to identify gaps, risks, and recommendations for to-be processes. Learn in-house mapping using Visio, whiteboard sessions, or outsourcing considerations.
Process Attributes defined in Excel with a look at a To-Be Process5:34
Input process data in Excel, then use pivot tables to reveal owners, divisions, steps, approvals, and gaps between as-is and to-be processes, including Excel usage and bottlenecks.
Understanding Process Attributes with Pivot Tables12:25
learn how to use pivot tables in excel to analyze process maps, capture attributes like divisions, owners, approvals, and durations, and uncover bottlenecks.
Benefits of SwimLane Process
Bonus for Watching My Course (Bloopers During an Interview)

Requirements

Having prior experinece of using Visio is recommended
Having a keen eye for detail & Curiosity
Able to create Pivot Tables from your data set.

Description

Welcome to my crash course on converting process maps into meaningful data using Pivot Tables. Whether you're a beginner or looking to refine your skills, this course is designed to give you a solid foundation in just 30 minutes.

In today’s fast-paced business environment, understanding your process attributes from every angle is crucial. This course will guide you through the steps to transform complex process maps into actionable insights. By utilizing Pivot Tables, you'll gain a holistic, 360-degree view of your processes, enabling you to make data-driven decisions that can improve efficiency and effectiveness.

Throughout the course, I’ll share some practical tips and tricks to help you get the most out of your data. These insights are sprinkled throughout, so be sure to listen carefully. The goal is not just to teach you the technical skills but also to help you see the bigger picture and apply these techniques in real-world scenarios.

As a fun bonus, at the end of the course, you’ll find a QR code. Scan it to enjoy a short clip of my 10 minutes bloopers during an interview —it’s a lighthearted way to wrap up your learning experience!

Join me, and let’s turn data into your competitive advantage!

Who this course is for:

Anyone those wishing to create processes & analyse then simply using Excel.