3-day Virtual Seminar

3-Hour Virtual Seminar on Excel Deep Dive: Advanced Tips & Techniques

The use of this seal confirms that this activity has met HR Certification Institutes (HRCI) criteria for recertification credit pre-approval.
This activity has been approved for 3 HR (General) recertification credit hours toward aPHR, PHR, PHRca, SPHR, GPHR, PHRi and SPHRi recertification through HR Certification Institute (HRCI). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at www.hrci.org." ...more

Overview

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.

Areas Covered in the Session

• 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