Overview
This structured virtual seminar takes attendees from the fundamentals of Excel to advanced, professional-grade practice across three 2-hour sessions.
Built around a single business dataset that grows throughout the seminar, each session adds a layer of skill, from understanding data and formulas, through lookups and PivotTables, to automated data cleaning with Power Query and modern dynamic array formulas. Along the way, the instructor demonstrates how an AI assistant can build the same formulas, as an alternative, and how to check what it produces.
The seminar culminates in a capstone demonstration: a raw, messy set of data exports is transformed into a self-refreshing reporting workbook and dashboard, then updated with a new month of data in a single click. Attendees receive practice workbooks and session checkpoint files so they can follow along, rejoin at any point, and rebuild the capstone on their own.
Demonstrations use Microsoft 365 Excel for Windows. Some features shown (including XLOOKUP, dynamic array formulas, and Power Query's folder import) differ or are unavailable in older versions, Excel for Mac, or Excel for the web; attendees should confirm their version before the seminar.
Why you should Attend
Every month, someone in your organization rebuilds the same report by hand: copying, pasting, fixing dates, re-sorting, and hoping nothing was missed. Each manual step is a chance for an error that reaches a decision-maker unseen. Professionals who never move past basic Excel spend hours on work the software can do in seconds, and they are increasingly measured against colleagues who already work the modern way.
Areas Covered in the Session
- Session 1 - Foundations and Structure
- How Excel stores data: numbers, text, and dates, and why "numbers stored as text" cause silent errors
- Formula anatomy, relative and absolute references, and copying formulas correctly
- Shaping data for analysis: one row per record, one column per attribute
- Excel Tables and structured references
- Answering first business questions with IF, SUMIFS, and COUNTIFS
- Session 2 - Answer and Summarize
- Lookups with XLOOKUP; decision logic with IFS, AND, and OR
- Handling errors cleanly with IFERROR
- PivotTables: building, grouping, filtering, and summarizing data
- Pivot Charts and slicers for interactive analysis
- AI as an alternative: asking an AI assistant to write the same formulas, and checking its work
- Session 3 - Automate and Prove It
- Power Query: importing, cleaning, and combining multiple files from a folder
- Dynamic array formulas: FILTER, UNIQUE, SORT, and TAKE
- Designing a one-screen dashboard
- Capstone demonstration: the Monthly Refresh, from raw exports to a self-updating report
Includes practice workbooks, session checkpoint files, and a completed capstone answer file.
Who Will Benefit
- Administrative and Office Professionals
- Business, Financial, and Operations Analysts
- Project and Program Managers
- HR, Sales, and Marketing Professionals
- Team Leaders and Managers who build or review reports
- Anyone who uses Excel and wants to move from basic to advanced work
Speaker Profile
Allen Evitts is a seasoned project management professional with extensive experience in the field. With a career span of over two decades, Allen has successfully led numerous projects across various industries, including technology, healthcare, and construction. Allen's expertise lies in both traditional and Agile project management methodologies, making them a versatile and knowledgeable instructor.
Allen has a proven track record of delivering projects on time, within budget, and to the satisfaction of stakeholders. Their ability to organize, communicate, and lead teams has earned them recognition as a top project management consultant. Allen's approach to project management is rooted in practical, real-world experience, ensuring that participants in their webinars gain valuable insights and actionable skills.
In addition to their professional experience, Allen is a certified Project Management Professional (PMP) and holds certifications in Agile methodologies, including Scrum Master, and in Cybersecurity. Allen is also an active member of the Project Management Institute (PMI).
Allen's passion for teaching and mentoring has led them to develop and deliver comprehensive training programs that empower project professionals to excel in their roles. Their engaging and interactive teaching style ensures that participants not only learn the essential skills but also feel confident in applying them to their projects.
Join Allen Evitts in the webinar "Organize, Communicate, Lead: Essential Skills for Project Professionals" to enhance your project management skills and lead your projects to success!