As we’re half-way through the decade (yes time does fly), David Benaim will go through a whistlestop tour of the most important functions, commands and tools to have hit Excel in the 2020’s so far.
So many Excel enthusiasts are highly familiar with classic Excel features, but many of the stalwarts have actually been superseded by better features, including Pivot Tables, VLOOKUP, commenting, SUMPRODUCT, LEFT/RIGHT. New cell-based data types including checkboxes, images, geography, currencies are useful, new formula audit techniques plus AI is also now nested to Excel in several ways, and Excel has made strides for simultaneous editing and collaboration, for example the ability to check, cell by cell, who edited what and when.
Many consider themselves Excel experts when they can use the classic Excel features very well, but are unfamiliar with some better features which have been released recently.
Excel releases new features monthly so it can be difficult to keep up with every feature, and so David breaks it down in a fast paced digestible format that users of all levels can benefit from.
This is best applicable to anyone using Excel for more than 30 minutes per day at work. Although any office worker could benefit, those who work in finance or analytics would probably benefit the most.
Many consider themselves Excel experts when they can use the classic Excel features very well, but are unfamiliar with some better features which have been released recently.
Excel releases new features monthly so it can be difficult to keep up with every feature, and so David breaks it down in a fast paced digestible format that users of all levels can benefit from.
This is best applicable to anyone using Excel for more than 30 minutes per day at work. Although any office worker could benefit, those who work in finance or analytics would probably benefit the most.
David Benaim is considered by Microsoft to be in the top 100 or so Excel users worldwide by holding the Microsoft MVP award, he has a YouTube channel with tech tutorials with over 18,000 subscribers under his name David benaim and does 50+ webinars/presentations per year on Excel/public speaking. David keeps up to date with new Excel features so much that he contributes to every official Microsoft Excel monthly blog post and he also runs Xlconsulting where he assists with process automation and analytics via Excel.
Empowering Conflict Resolution: Letting Go to Gain Control
Developing an Agile Workforce with Emotional Intelligence (…
FDA Regulation of Artificial Intelligence/ Machine Learning
Compliance Under Fire: Navigating I9 Immigration Raids & …
How to Give Corrective Feedback: The C.A.R.E. Model - Elimi…
Human Error Reduction Techniques for Floor Supervisors
How To Conduct An Internal Harassment And Bullying Investig…
Secrets Of Psychology - Why People Do The Things They Do
FDA Compliance And Laboratory Computer System Validation
Leadership: Strategic Planning and Decision Making
Polish your Presence on Linkedin - The Powerful Profile
Marketing to Medicare or Medicaid Beneficiaries - What You …
Human Factors Usability Studies Following ISO 62366 and FDA…
Leveraging Artificial Intelligence in HR
Bootcamp for New Managers and Supervisors: Develop These Es…
Utilizing A Proven Process When Conducting Sensitive, Inter…
Understand the Different Contexts in DAX, The Filter Contex…
Understanding and Analyzing Financial Statements
HR Metrics and Analytics 2025 - Update on Strategic Plannin…
The Importance of Storytelling in Project Management
Defensive Documentation: Protecting Your Organization from …
Topic Name/Course Title Leading a Project and Team in Stres…
Power Bi - Turn Bad Data Into Great Data In Minutes
OSHA Reporting: What are OSHA's Reporting Requirements?
Onboarding is NOT Orientation - How to Improve the New Empl…
Copilot and HR: An Introduction for HR Professionals
Establishing Appropriate Quality Metrics and Key Performanc…
How to Write Effective Audit Observations: The Principles f…
Basic Accounting and Finance for Human Resources Profession…
EBIT/EBITDA - Understanding Your Profit and Loss Statement-…
FDA Audit Best Practices - Do's and Don'ts
Handbook Overhaul 2026: Compliance, OBBB Act & Beyond
FDA Technology Modernization Action Plan (TMAP) and Impact …
Stress, Change And Team Resilience Through Humor: An Intera…
Controller Challenges in Changing Times: New Roles as Strat…
The Importance of the first 5 seconds when presenting
Excel Spreadsheets; Develop and Validate for 21 CFR Part 11…
Sunshine Act Reporting - Clarification for Clinical Research
How to Prepare For and Host a FDA Inspection and Respond to…
From Chaos To Calm: How to Eliminate Drama and Boost Workpl…
Managing Toxic Employees: Strategies For Leaders To Effecti…