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
![ins_img](/Speaker_Pics/cathy.png)
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
![](/static/images/default-webinar-info.jpg)
The Importance of the first 5 seconds when presenting
![](/static/images/default-webinar-info.jpg)
Pivot tables beginner to advanced + 20 advanced Pivot table…
![](/static/images/default-webinar-info.jpg)
GAAP—Update on new Accounting Principles and How They Impac…
![](/static/images/default-webinar-info.jpg)
Proactive Retention: Harnessing the Benefits of Stay Interv…
![](/static/images/default-webinar-info.jpg)
ChatGPT and Project Management: Leveraging AI for Project M…
![](/static/images/default-webinar-info.jpg)
The 6 Most Common Problems in FDA Software Validation and V…
![](/static/images/default-webinar-info.jpg)
Creating Employee Handbooks that Protect You and Support th…
![](https://247compliance.com/static/images/organized-work.jpg)
![](/static/images/default-webinar-info.jpg)
![](/static/images/default-webinar-info.jpg)
Maximizing Productivity with ChatGPT: AI Solutions for HR, …
![](https://247compliance.com/static/images/hr-employee.jpg)
Female to Female Hostility @Workplace: All you Need to Know
![](/static/images/default-webinar-info.jpg)
2-Hour Virtual Seminar on Empowering Presentations with Pow…
![](/static/images/default-webinar-info.jpg)
HIPAA is Unsettled – Safe Compliance Strategies
![](/static/images/default-webinar-info.jpg)
Project Management for Non-Project Managers - Scheduling yo…
![](/static/images/default-webinar-info.jpg)
Navigating Talent Management and Retention Strategies.
![](/static/images/default-webinar-info.jpg)
Understanding and Communication New Immigration Policies (2…
![](/static/images/default-webinar-info.jpg)
Creating Loyal Customers Through Excellent Customer Service
![](/static/images/default-webinar-info.jpg)
Understanding Artificial Intelligence (AI) & using Chat GPT
![](https://247compliance.com/Speaker_Pics/hiring.jpg )
Onboarding Best Practices for 2025: Proven Strategies to Po…
![](/static/images/default-webinar-info.jpg)
Empowering Conflict Resolution: Letting Go to Gain Control
![](/static/images/default-webinar-info.jpg)
Navigating 2025 Employment Laws: What Every Employer Needs …
![](/static/images/default-webinar-info.jpg)
How to Prepare For and Host a FDA Inspection and Respond to…
![](/static/images/default-webinar-info.jpg)
![](/static/images/default-webinar-info.jpg)
How to Manage the Legal Landmine of the FMLA, ADA and Worke…
![](/static/images/default-webinar-info.jpg)
How to Conduct Exit Interviews - Implementing and Enhancing…
![](/static/images/default-webinar-info.jpg)
Adapting to Change: Strategies for Personal & Team Resilien…
![](/static/images/default-webinar-info.jpg)
Introduction to Excels Built-In Solver – Advanced Decision-…
![](https://247compliance.com/static/images/hr-employee.jpg)
Managing Toxic Employees: Strategies For Leaders To Effecti…
![](/static/images/default-webinar-info.jpg)
FDA Technology Modernization Action Plan (TMAP) and Impact …
![](/static/images/default-webinar-info.jpg)
Design Control for Medical Devices Including Verification/V…
![](/static/images/default-webinar-info.jpg)
Stress, Change And Team Resilience Through Humor: An Intera…
![](/static/images/default-webinar-info.jpg)
![](/static/images/default-webinar-info.jpg)
Developing and Implementing Quality Culture in the Organiza…
![](https://247compliance.com/Speaker_Pics/student-849821__340.jpg)
![](/static/images/default-webinar-info.jpg)
Negotiating Skills For Professional Results - Winning Strat…
![](/static/images/default-webinar-info.jpg)
Use the power of AI to turbocharge your MS Excel
![](/static/images/default-webinar-info.jpg)
![](/static/images/default-webinar-info.jpg)
Excel - Pivot Tables - The Key To Modern Data Analysis and …
![](https://247compliance.com/static/images/excel-data.jpg)
Excel Power Skills: Master Functions, Formulas, and Macros …
![](https://247compliance.com/static/images/emotional-intelligence.jpg)
Emotional Intelligence: Mastering the Emotions of Great Lea…
![](https://247compliance.com/static/images/peer-to-boss.jpg)
![](https://247compliance.com/static/images/hr-employee.jpg)
Managing Toxic & Other Employees Who Have Attitude Issues
![](/static/images/default-webinar-info.jpg)
6-Hour Virtual Seminar on Learning the Highlights of Excel …