Excel Deep Dive: Advanced Tips & Techniques – A 3-hour Workshop.
180 Minutes
Join this engaging and hands-on webinar designed to enhance your Excel skills through interactive learning. You will explore key auditing techniques, such as locating cells containing formulas, precedent cells, and dependent cells, allowing you to trace and troubleshoot workbook data with ease. Learn how dates and times are represented as numbers in Excel, allowing you to calculate durations accurately. We will also cover how to name cells for easy workbook navigation, making formulas easier to understand, and ensuring your cell references remain absolute in complex formulas.
In addition, you will discover how to apply conditional formatting to highlight key data points based on their values, creating visually appealing spreadsheets that provide better understanding of data trends and insights. The session will introduce you to PivotTables, helping you summarize and analyze data with ease. Finally, you will learn to create charts with just one keystroke, creating visual representations of the data. This interactive webinar combines practical demonstrations with real-world examples to ensure you can apply these techniques immediately.
AREA COVERED
- Auditing Workbooks
- Locate Cells Containing Formulas
- Locate Precedent Cells
- Locate Dependent Cells
- Calculating with Dates and Times
- Why Dates are Actually Numbers
- Calculating Duration
- Naming Cells
- Create a GoTo Cell
- Use in Formulas
- Make Cell References Absolute
- Applying Conditional
- Format Cells Based on Their Values
- Quick Start to PivotTables
- Summarize and Analyze Data
- Charting Data
- Visualizing Data
- Create a Chart with One Keystroke
WHO WILL BENEFIT?
- Business Owners
- CEO's / CFO's / CTO's
- Managers
- Accountants
- CPA's
- Financial Consultants
- IT Professionals
- Auditors
- Human Resource Personnel
- Bookkeepers
- Marketers
- Anybody with large amounts of Data
- Anybody who uses Microsoft Excel on a regular basis, and wants to be more efficient and productive
- Auditing Workbooks
- Locate Cells Containing Formulas
- Locate Precedent Cells
- Locate Dependent Cells
- Calculating with Dates and Times
- Why Dates are Actually Numbers
- Calculating Duration
- Naming Cells
- Create a GoTo Cell
- Use in Formulas
- Make Cell References Absolute
- Applying Conditional
- Format Cells Based on Their Values
- Quick Start to PivotTables
- Summarize and Analyze Data
- Charting Data
- Visualizing Data
- Create a Chart with One Keystroke
- Business Owners
- CEO's / CFO's / CTO's
- Managers
- Accountants
- CPA's
- Financial Consultants
- IT Professionals
- Auditors
- Human Resource Personnel
- Bookkeepers
- Marketers
- Anybody with large amounts of Data
- Anybody who uses Microsoft Excel on a regular basis, and wants to be more efficient and productive
Speaker Profile
Cathy Horwitz
Cathy Horwitz is a highly experienced Microsoft Office instructor, specializing in Excel, Word, PowerPoint, Outlook, and Access. With over 30 years of expertise in both in-person and online training, she has helped thousands of professionals boost productivity, streamline workflows, and master essential Microsoft Office skills.Cathy has been teaching Microsoft Office since its inception, offering tailored training programs that meet the unique needs of individuals and businesses. Her courses cover everything from Excel formulas, PivotTables, and automation with macros to Word document formatting, PowerPoint presentation design, and Outlook email management. Workshops from beginning level through advanced are available.Known for her engaging, …
Upcoming Webinars
The Importance of the first 5 seconds when presenting
By:Terry Winship
Feb. 18, 2025
10:00 AM PDT | 01:00 PM EDT
Pivot tables beginner to advanced + 20 advanced Pivot table…
By:Abdelrahman Abdou
Feb. 19, 2025
10:00 AM PDT | 01:00 PM EDT
GAAP—Update on new Accounting Principles and How They Impac…
By:Dev Strischek
Feb. 19, 2025
10:00 AM PDT | 01:00 PM EDT
Proactive Retention: Harnessing the Benefits of Stay Interv…
By:Melveen Stevenson
Feb. 19, 2025
12:00 PM PDT | 03:00 PM EDT
ChatGPT and Project Management: Leveraging AI for Project M…
By:Deb Schaffer
Feb. 20, 2025
12:00 PM PDT | 03:00 PM EDT
The 6 Most Common Problems in FDA Software Validation and V…
By:David Nettleton
Feb. 20, 2025
12:00 PM PDT | 03:00 PM EDT
Creating Employee Handbooks that Protect You and Support th…
By:Don Phin
Feb. 20, 2025
12:00 PM PDT | 03:00 PM EDT
Maximizing Productivity with ChatGPT: AI Solutions for HR, …
By:Erica Chisolm & Vanessa Hardiman
Feb. 21, 2025
10:00 AM PDT | 01:00 PM EDT
Female to Female Hostility @Workplace: All you Need to Know
By:Dr. Susan Strauss
Feb. 21, 2025
10:00 AM PDT | 01:00 PM EDT
2-Hour Virtual Seminar on Empowering Presentations with Pow…
By:Ritu Arora
Feb. 24, 2025
10:00 AM PDT | 01:00 PM EDT
HIPAA is Unsettled – Safe Compliance Strategies
By:Paul R Hales
Feb. 25, 2025
10:00 AM PDT | 01:00 PM EDT
Project Management for Non-Project Managers - Scheduling yo…
By: Charles H. Paul
Feb. 25, 2025
10:00 AM PDT | 01:00 PM EDT
Navigating Talent Management and Retention Strategies.
By:Catherine M. Rymsha
Feb. 25, 2025
10:00 AM PDT | 01:00 PM EDT
Understanding and Communication New Immigration Policies (2…
By:Wendy Sellers
Feb. 25, 2025
10:00 AM PDT | 01:00 PM EDT
Creating Loyal Customers Through Excellent Customer Service
By:Pete Tosh
Feb. 25, 2025
12:00 PM PDT | 03:00 PM EDT
Understanding Artificial Intelligence (AI) & using Chat GPT
By:Justin Muscolino
Feb. 25, 2025
12:00 PM PDT | 03:00 PM EDT
Onboarding Best Practices for 2025: Proven Strategies to Po…
By:Marcia Zidle
Feb. 26, 2025
12:00 PM PDT | 03:00 PM EDT
Empowering Conflict Resolution: Letting Go to Gain Control
By:Aimee Bernstein
Feb. 26, 2025
12:00 PM PDT | 03:00 PM EDT
Navigating 2025 Employment Laws: What Every Employer Needs …
By:Don Phin
Feb. 26, 2025
10:00 AM PDT | 01:00 PM EDT
How to Prepare For and Host a FDA Inspection and Respond to…
By:Edwin Waldbusser
Feb. 26, 2025
10:00 AM PDT | 01:00 PM EDT
How to Manage the Legal Landmine of the FMLA, ADA and Worke…
By:Margie Faulk
Feb. 27, 2025
12:00 PM PDT | 03:00 PM EDT
How to Conduct Exit Interviews - Implementing and Enhancing…
By:Bob Verchota
Feb. 27, 2025
12:00 PM PDT | 03:00 PM EDT
Adapting to Change: Strategies for Personal & Team Resilien…
By:Roxana Radulescu
Feb. 27, 2025
10:00 AM PDT | 01:00 PM EDT
Introduction to Excels Built-In Solver – Advanced Decision-…
By:Isaac Gottlieb
Feb. 27, 2025
10:00 AM PDT | 01:00 PM EDT
Managing Toxic Employees: Strategies For Leaders To Effecti…
By:Beverly Beuermann-King
Feb. 27, 2025
10:00 AM PDT | 01:00 PM EDT
FDA Technology Modernization Action Plan (TMAP) and Impact …
By: Carolyn Troiano
Feb. 27, 2025
12:00 PM PDT | 03:00 PM EDT
Design Control for Medical Devices Including Verification/V…
By:Alan M Golden
Feb. 28, 2025
10:00 AM PDT | 01:00 PM EDT
Stress, Change And Team Resilience Through Humor: An Intera…
By:Mark Gorkin
Feb. 28, 2025
10:00 AM PDT | 01:00 PM EDT
Developing and Implementing Quality Culture in the Organiza…
By:Meredith Crabtree
Feb. 28, 2025
12:00 PM PDT | 03:00 PM EDT
Negotiating Skills For Professional Results - Winning Strat…
By:Bruce Lee
March 4, 2025
10:00 AM PDT | 01:00 PM EDT
Use the power of AI to turbocharge your MS Excel
By:Terry Winship
March 4, 2025
12:00 PM PDT | 03:00 PM EDT
Excel - Pivot Tables - The Key To Modern Data Analysis and …
By:Mike Thomas
March 5, 2025
10:00 AM PDT | 01:00 PM EDT
Excel Power Skills: Master Functions, Formulas, and Macros …
By:Cathy Horwitz
March 6, 2025
12:00 PM PDT | 03:00 PM EDT
Emotional Intelligence: Mastering the Emotions of Great Lea…
By:Don Phin
March 7, 2025
10:00 AM PDT | 01:00 PM EDT
Managing Toxic & Other Employees Who Have Attitude Issues
By:Pete Tosh
March 7, 2025
12:00 PM PDT | 03:00 PM EDT
6-Hour Virtual Seminar on Learning the Highlights of Excel …
By:Cathy Horwitz
March 31, 2025
10:00 AM PDT | 01:00 PM EDT