Mastering Microsoft Office Tools & Tricks For HR/Payroll Executives & Managers
Webinar Agenda :
Two of the most widely used Microsoft Office applications are Excel and Outlook. MS Excel is frequently used for managing employee data by HR/Payroll departments and by managers/supervisors who need to maintain detailed excel spreadsheets with up-to-date records for their team members and their respective KPIs. HR and Payroll departments need to maintain so many variables of an employee’s record in MS Excel. If not done properly, these important records are often at the risk of getting lost or edited wrongly. On the other hand, MS Outlook is widely used for managing emails, tasks, calendars involving multiple employees. It is very easy to lose an important email or miss a calendar event if your outlook is not organized properly. With time, everyone’s inbox and calendar gets overwhelmed and disorganized. There are so many features and best practices for efficiently using MS Outlook. Most users are not aware of these easy to use and time saving features.
This program is specially designed for HR/Payroll departments and Managers/Supervisors to ensure their daily tasks on these two widely used applications run as efficiently as possible.
The following areas will be covered in detail :
Microsoft Excel
- Detailed assessment of the most productive Excel formulas and functions
- Using Conditional Formatting for Real-Time Feedback
- Automatic Date-and-Time Deadline Calculation
- Managing Sloppy Data with Sorts & Filters
- Using Key formulas and functions – IF, SUMIF, COUNTIF, AVERAGEIF, Subtotals
- Arranging data with VLOOKUP & HLOOKUP
Microsoft Outlook
- Managing Incoming Emails with Categories and Rules
- Sort and Filter the Results with Search and Search Folders
- Quick tips for managing your calendar
- Organizing the To-Do List/To-Do Bar
- Customizing Folder Views by Filtering & using Categories
Ask your questions & get expert advice directly from the speaker during the informative Q/A session at the end of the webinar session.
About The Trainer: Tom Fragale is a computer professional with over 30 years of professional experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word and Excel., and a Microsoft Certified Specialist in Access, Outlook, and PowerPoint. He has trained over 30,000 business people in on-line webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including insurance, manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant and project manager on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is training people and helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.
