Udemy

Simple Technique for Using Excel to Analyze Process Maps

Sample Process Discussed in Course
Free tutorial
Rating: 4.5 out of 5 (8 ratings)
606 students
30min of on-demand video
English
English [Auto]

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)

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.

Instructor

Pragmatic IT Strategist | Digital Transformation Advisory
  • 4.5 Instructor Rating
  • 8 Reviews
  • 606 Students
  • 1 Course

Transforming Businesses through Strategic IT Leadership


In the dynamic realm of Information and Communication Technology (ICT), I bring over 27 years of unwavering dedication and a portfolio of 25+ Consultancy Engagements. I have steered strategic IT initiatives, led digital transformations, and re-engineered technical and operational processes to elevate organizational performance.

Navigating Challenges, Learning from Failures


Embarking on roles such as Advisor To The Chairman / Group IT Manager at IMCO Engineering & Construction, I've honed my expertise in ERP implementations and spearheaded change initiatives. Every challenge has been a stepping stone, offering invaluable experiences and lessons from failures—a testament to my commitment to continuous improvement.

Consultancy as a Catalyst for Transformation


Venturing into independent consultancy, I've evaluated and recommended ERP systems, conducted in-depth Requirements & Process reviews, and catalyzed the restructuring of core processes. My role extends beyond providing solutions; I recommend Digital Transformation Programs, infusing fresh ideas and innovative solutions to realize tangible benefits and add substantial value.

Agility in a Rapidly Changing Landscape


Contributing to the assessment of Software Houses, I've played a pivotal role in enhancing their agility for transformative competition in today's fast-paced environment. Investors seeking to finance IT projects find a strategic partner in me—I thrive on playing the Devil's Advocate to inspire robust discussions and informed decisions.

Analytical Excellence and Continuous Learning


Beyond professional pursuits, I find joy in Auditing Engagements, where I've uncovered and addressed five fraud cases through meticulous data analysis. My pursuit of excellence led me to earn the CISA designation in 2002. To further elevate my analytical skills, I recently completed the Google Data Analytics Certification in 2022.

Books that Resonate


Two books that have significantly influenced my perspective are "Good to Great" by Jim Collins and "Silo's Politics and Turf Wars" by Patrick Lencioni.


Top companies trust Udemy

Get your team access to Udemy's top 30,000+ courses