Microsoft Office "TIPS AND TIME-SAVERS FOR HR PROFESSIONAL"

Unlock the full potential of Microsoft Excel, PowerPoint, and Outlook in this fast-paced, hands-on workshop designed to transform the way you work! Learn how to navigate spreadsheets with ease using flash shortcuts, automate data entry with Autofill, and create stunning charts in seconds. Discover power Excel functions, from VLookUp to advanced date calculations, to streamline data management and analysis.

Take your PowerPoint presentations to the next level with expert quick tips for delivering impactful slides with confidence. Then, supercharge your Outlook workflow by mastering email organization, automating responses, and scheduling messages for maximum efficiency. Packed with time-saving techniques and insider shortcuts, this workshop will help you work smarter, not harder - giving you back valuable time in your day!

LEARNING OBJECTIVE:

Enhance Data Management & Analysis - Apply advanced Excel® functions, including VLookUp, date calculations, and data consolidation across worksheets, to improve HR reporting and workforce analytics.

Improve Efficiency & Productivity - Utilize time-saving features such as Autofill, Flash Replication, and shortcut commands to accelerate spreadsheet navigation and data entry, targeting improved HR reporting and workforce analytics.

Streamline Email & Communication Processes - Automate Microsoft® Outlook® workflows, including email scheduling, automatic replies, and message organization, to enhance HR productivity and employee responsiveness to communications.

Increase Organizational Effectiveness - Implement sorting, filtering, and grouping techniques in Outlook® and Excel® to better manage HR tasks, track important HR data, and optimize HR workflow efficiency.

This workshop has been submitted for 3 HRCI and SHRM certification credits.

All attendees will receive

Microsoft® Excel®

• Faster Navigating, Selecting, & Naming Cells
• Understand & Use Relative & Absolute References

Use Autofill & Flash Replication

• Use Numeric, Time, Day, Date, Month, Quarterly, Yearly, Formula, & Custom List Autofill Features

Instant Chart Features

• Chart Creation in 30-Seconds or Less

Calculate Data Across Worksheets

• Flash Replication of Spreadsheet Content
• Calculate Data Across Worksheets
• Calculate Data Across Worksheets with Identical
• Cell Locations

Popular Advanced Functions

• Date Functions
• Combine Cell Information
• Separate Cell Information
• Lookup Table Data (VLookUp)

Microsoft® PowerPoint®

• Presentation Success Using Presentation Quick Tips

Microsoft® Outlook®

Fast & Easy Message Organization

• Better Management of Emails Next To One Another & When They Are Not Right Next To One Another
• Control Email Message Delivery Dates & Times
• Target Faster Email Responses
• Automatically Send Email Responses to Key People
• Increase Organization Using Group, Sort, & Filter Features

Automating Message Management

• Use Automatic Replies
• Craft & Trigger an Out-of-Office Automated Response

Time-Saving Shortcuts Using Key Commands

Host or Publisher Baldwin County SHRM