Call us at +1-661-336-9555

cart

Unlock the full potential of Excel with our deep-dive webinar into the newly introduced GROUPBY and PIVOTBY functions. These innovative features offer Excel users like you the ability to generate dynamic, pivot-table-like summaries without the hassle of manual refreshes. This webinar is designed to provide you with a thorough understanding of how to apply these functions effectively, enhancing your data analysis and reporting capabilities.


  • Introduction to GROUPBY and PIVOTBY: Understand the fundamentals and benefits of using these functions over traditional pivot tables.
  • Real-Time Data Updates: Learn how these functions update automatically as your data changes, ensuring your reports are always current without additional steps.
  • Advanced Techniques: Explore advanced applications, including multi-level grouping, custom aggregation, and dynamic sorting to streamline your data tasks.

Join our upcoming webinar to explore the powerful new GROUPBY and PIVOTBY functions in Excel, which revolutionize how you manage and analyze data without the need for constant manual refreshes. This session is perfect for Excel users seeking to enhance their data manipulation toolkit with real-time updating capabilities. We'll take a comprehensive look at these functions, demonstrating how they can simplify complex data operations and improve your workflow efficiency. Whether you're an analyst, a data enthusiast, or anyone in between, this webinar will equip you with cutting-edge techniques to handle large datasets more effectively and with greater flexibility. Don't miss out on mastering these essential new tools in Excel—sign up now to secure your spot!

  • Data Analysts
  • Financial Analysts
  • Business Intelligence Analysts
  • Quality Analysts
  • Any Role that involves Data Analysis

Abdelrahman Abdou is an experienced Excel and Power BI Trainer and Consultant with over 10 years of expertise in reporting, business intelligence, and data analytics, Abdelrahman has worked with some of the largest telecom companies in Egypt and Canada. Their extensive background in data analysis and visualization makes them a highly sought-after consultant and educator.

As a dedicated trainer and consultant, Abdelrahman specializes in helping clients master Excel and Power BI. They conduct live sessions, webinars, and in-class training, focusing on automating reporting processes, creating insightful dashboards, and leveraging advanced Excel functions for efficient data management.

View all trainings by this speaker
 
Live Webinar

Live Session for 1 Participant

$149

Live + Recorded Session

Get unlimited access to the link for six months for one participant, from the date of webinar completion.

$249

Live + Transcript

Get to attend the LIVE Session and also receive a PDF copy of the Transcript only after the completion of the LIVE webinar.

$229

Live + USB

Free shipment within 15 Working Days from the date of webinar completion.*

$399

On Demand

Transcript

PDF Transcript of the Training which are available once the webinar is completed.(Transcript for single user only)

$149

Downloadable Recorded Session

Get unlimited access to the link for six months.

$219

USB

Free shipment within 15 Working Days, from the date of webinar completion.*

$149

Group Session

Group Session Participants + Recorded

Live Session with unlimited participants. Invite any number of attendees to join.

$599

 

Feb. 21, 2025

Female to Female Hostility @Workplace: All you Need to Know

Dr. Susan Strauss

Upcoming Webinars

Image

By Dr. Susan Strauss
Female to Female Hostility @Workplace: All you Need to Know
Date: Feb. 21, 2025

Image

By Erica Chisolm & Vanessa Hardiman
Maximizing Productivity with ChatGPT: AI Solutions for HR, Management, and Beyond
Date: Feb. 21, 2025

Image

By Bob Oberstein
Labor Relations Crash Course
Date: Feb. 21, 2025

Image

By Jonnie Keith
Putting The Quality In Audit Reports
Date: Feb. 21, 2025

Image

By Ritu Arora
2-Hour Virtual Seminar on Empowering Presentations with PowerPoint Mastery
Date: Feb. 24, 2025

Image

By Abdelrahman Abdou
Pivot tables beginner to advanced + 20 advanced Pivot table techniques
Date: Feb. 24, 2025

Image

By Justin Muscolino
Understanding Artificial Intelligence (AI) & using Chat GPT
Date: Feb. 25, 2025

Image

By Pete Tosh
Creating Loyal Customers Through Excellent Customer Service
Date: Feb. 25, 2025

Image

By Wendy Sellers
Understanding and Communication New Immigration Policies (2025)
Date: Feb. 25, 2025

Image

By Catherine M. Rymsha
Navigating Talent Management and Retention Strategies.
Date: Feb. 25, 2025

Image

By Paul R Hales
HIPAA is Unsettled – Safe Compliance Strategies
Date: Feb. 25, 2025

Image

By Charles H. Paul
Project Management for Non-Project Managers - Scheduling your Project
Date: Feb. 25, 2025

Image

By Edwin Waldbusser
How to Prepare For and Host a FDA Inspection and Respond to 483's
Date: Feb. 26, 2025

Image

By Aimee Bernstein
Empowering Conflict Resolution: Letting Go to Gain Control
Date: Feb. 26, 2025

Image

By Marcia Zidle
Onboarding Best Practices for 2025: Proven Strategies to Power Up Your New Hires’ Experience & Retention.
Date: Feb. 26, 2025

Image

By Don Phin
Navigating 2025 Employment Laws: What Every Employer Needs to Know
Date: Feb. 26, 2025

Image

By Susan Fahey Desmond
HANDLING FMLA ABUSE
Date: Feb. 26, 2025

Image

By Beverly Beuermann-King
Managing Toxic Employees: Strategies For Leaders To Effectively Deal With Employee Attitude Issues
Date: Feb. 27, 2025

Image

By Bob Verchota
How to Conduct Exit Interviews - Implementing and Enhancing Your Exit Interview Program
Date: Feb. 27, 2025

Image

By Roxana Radulescu
Adapting to Change: Strategies for Personal & Team Resilience
Date: Feb. 27, 2025

Image

By Isaac Gottlieb
Introduction to Excels Built-In Solver – Advanced Decision-Making Tools
Date: Feb. 27, 2025

Image

By Margie Faulk
How to Manage the Legal Landmine of the FMLA, ADA and Workers Compensation in the Workplace!
Date: Feb. 27, 2025

Image

By Carolyn Troiano
FDA Technology Modernization Action Plan (TMAP) and Impact on Regulated Computer Systems and Data Integrity
Date: Feb. 27, 2025

Image

By Alan M Golden
Design Control for Medical Devices Including Verification/Validation
Date: Feb. 28, 2025

Image

By Mark Gorkin
Stress, Change And Team Resilience Through Humor: An Interactive Playshop
Date: Feb. 28, 2025

Image

By Gary Heppner
The Return to Work Program OSHA
Date: Feb. 28, 2025

Image

By Meredith Crabtree
Developing and Implementing Quality Culture in the Organization and Why it’s Important
Date: Feb. 28, 2025

Image

By Abdelrahman Abdou
GROUPBY and PIVOTBY functions. Pivot table killers?
Date: March 3, 2025

Image

By Bruce Lee
Negotiating Skills For Professional Results - Winning Strategies Before, During, and In Closing, to Get More and Pay Less
Date: March 4, 2025

Image

By Veronica L. Matthews
Trust in Leadership: Building and Maintaining Trust as a Leader
Date: March 4, 2025

Image

By Michael Healey
Conquer Toxic People - Learn To Protect Yourself And Get Your Sanity Back
Date: March 4, 2025

Image

By Don Phin
AI and Human Resources: The Great Opportunity!
Date: March 5, 2025

Image

By Mark Gorkin
Tools and Tactics for Grieving, Surviving, and Thriving in a Climate of Organizational RIFs, Uncertainty, and Agency Dissolution.
Date: March 5, 2025

Image

By Marcia Zidle
Bootcamp for New Managers and Supervisors: Develop These Essential Leadership Skills & Be a Better Boss!
Date: March 6, 2025

Image

By Dr. Susan Strauss
How To Conduct An Internal Harassment And Bullying Investigation To Determine Facts And Minimize Liability
Date: March 6, 2025

Image

By Justin Muscolino
How Generative AI can be used in Banking Risk and Compliance
Date: March 6, 2025

Image

By Don Phin
Creating Employee Handbooks that Protect You and Support the Companys Culture
Date: March 6, 2025

Image

By Dev Strischek
The Five Cs Of Commercial Credit: The Basic Elements Of Credit And Lending
Date: March 7, 2025

Image

By Meredith Crabtree
SOPs - How to Write Them to Satisfy those Inspectors
Date: March 10, 2025

Image

By Pete Tosh
Improving Employee Engagement & Retention Through Stay Interviews
Date: March 10, 2025

Image

By Richard E Cascarino
ChatGPT for Accountants
Date: March 10, 2025

Image

By Bruce Lee
How to Give Corrective Feedback: The CARE Model - Eliminating Negative Behaviour, By Focusing On Accountability
Date: March 11, 2025

Image

By Edlyn McGarity
Building Thriving Teams: Proactive Strategies for Managers to Prevent Burnout.
Recorded Session

Image

By Diane L. Dee
2025 EEOC & Employers: Investigating Claims of Harassment & Discrimination
Recorded Session

Image

By Dr. Susan Strauss
The Business Case for LGBTQIA+ Inclusion in the Workplace: Navigating Policies, Procedures, Practices.
Recorded Session

Image

By Deb Schaffer
ChatGPT and Project Management: Leveraging AI for Project Management Excellence
Recorded Session

Image

By David Nettleton
The 6 Most Common Problems in FDA Software Validation and Verification
Recorded Session

Image

By Justin Muscolino
Updated Metro 2®, e-OSCAR and the New Tougher FCRA/CFPB Compliance Requirements
Recorded Session

Image

By Charles H. Paul
Project Management for Non-Project Managers - How to communicate project actions and progress - conducting effective project review meetings
Recorded Session

Image

By Marcia Zidle
Reduce Stress in the Workplace: Effective Ways to Handle Conflicts, Difficult People & Tough Situations!
Recorded Session

Image

By Dr. B. Lynn Ware
Best Practices in Virtual Onboarding
Recorded Session

Image

By Richard E Cascarino
Accounting For Non Accountants : Debit, Credits And Financial Statements
Recorded Session

Image

By Dr. Susan Strauss
Tattoos, hijabs, piercings, and pink hair: The challenges of a dress & appearance code
Recorded Session

Image

By Edwin Waldbusser
21 CFR Part 11 - Compliance for Electronic Records and Signatures
Recorded Session

Image

By William J. Rothwell
Using High-Performance Coaching for Managers to Address Performance and Behavior Issues
Recorded Session

Image

By Ginette M. Collazo
Implementing an Effective Human Error Reduction Program
Recorded Session

Image

By Edwin Waldbusser
FDA Regulation of Artificial Intelligence/ Machine Learning
Recorded Session

Image

By Danielle DeLucy
Batch Record Review and Product Release
Recorded Session

Image

By Rebecca Farabaugh
Designing Employee Experiences to Build a Culture of Compliance
Recorded Session

Image

By Marcia Zidle
Unlock Employee Loyalty: Stay Interviews Will Keep Them Engaged Before They Start Looking Elsewhere!
Recorded Session

Image

By William J. Rothwell
Effective Succession Planning
Recorded Session

Image

By Charles H. Paul
FDA Audit Best Practices - Do's and Don'ts
Recorded Session

Image

By Dr. Susan Strauss
2-Hour Virtual Seminar on How to Conduct an Internal Harassment and Bullying Investigation to Determine Facts and Minimize Liability
Recorded Session

Image

By Bob Verchota
Onboarding Best Practices for Millennial and All Employees
Recorded Session

Image

By Bob McKenzie
Terminating Employees Safely
Recorded Session

Image

By Pete Tosh
Strategic Interviewing & Selection: Getting the Right Talent on Your Team
Recorded Session

Image

By Meredith Crabtree
Performance of Root Cause Analysis, CAPA, and Effectiveness Checks
Recorded Session

Image

By Jonnie Keith
How to Write Effective Audit Observations: The Principles for Bullet Proofing Your Audit Findings
Recorded Session

Image

By Beverly Beuermann-King
Terminating Toxicity: Strategies For Leaders To Confidently Deal With Toxic Behaviors
Recorded Session

Image

By Cathy Horwitz
Transform Data into Insights: A Beginners Guide to Excel PivotTables
Recorded Session

Image

By Kenneth M. Jones
How to Write Contracts for Procurement Professionals
Recorded Session

Image

By Rebecca Staton-Reinstein
Project Management for administrative professionals
Recorded Session

Image

By Danielle DeLucy
Sunshine Act Reporting - Clarification for Clinical Research
Recorded Session

Image

By David Nettleton
2-Hour Virtual Seminar on the 6 Most Common Problems in FDA Software Validation and Verification
Recorded Session

Image

By Edwin Waldbusser
Human Factors Usability Studies Following ISO 62366 and FDA Guidance
Recorded Session

Image

By Rachelle D Souza
FDA Recommendations for Artificial Intelligence/Machine Learning (AI/ML)-Enabled Device Software Functions
Recorded Session

Image

By Dev Strischek
Why EBITDA Doesn't Spell Cash Flow and What Does
Recorded Session

Image

By Melveen Stevenson
Mastering Job Descriptions: Legal and Practical Insights for HR Pros
Recorded Session

Image

By William A. Levinson
Zero Acceptance Sampling to Reduce Inspection Costs
Recorded Session

Image

By Susan Fahey Desmond
Writing Effective Job Descriptions
Recorded Session

Image

By Mark Gorkin
Transforming Anger And Conflict Into Collaborative Problem Solving: The Stress Doc’s Four Faces Of Anger – Model And Method
Recorded Session

Image

By Carolyn Troiano
FDA Compliance And Laboratory Computer System Validation
Recorded Session

Image

By William Mack Copeland
The Anti-Kickback Statute: Enforcement and Recent Updates
Recorded Session

Image

By Alan M Golden
Impact Assessments For Supplier Change Notices
Recorded Session

Image

By Bob McKenzie
Effective Onboarding: How to Welcome, Engage, and Retain New Employees with Your In-Person and Virtual On-boarding
Recorded Session

Image

By Carl Young
Understanding and Analyzing Financial Statements
Recorded Session

Image

By Diane L. Dee
Do's and Don'ts of Documenting Employee Behaviour, Performance, and Discipline
Recorded Session

Image

By Bob Verchota
Managing Toxic & Other Employees Who have Attitude Issues
Recorded Session

Image

By Marcia Zidle
Onboarding is Not Orientation: How to Improve Your New Hires’ Experience & Their Retention
Recorded Session

Unsubscribe

×

Subscribe Here

×