Using Excel for Everyday Administrative Tasks

Recorded Webinar | Tom Fragale | From: Feb 16, 2021 - To: Dec 31, 2021

Training Options & Pricing

Error Conference Exists In Wish-list.

Congrats Conference Added In Wish-list.

Recording
⊖   ⊕$229  
DVD
⊖   ⊕$249  
Recording + DVD
⊖   ⊕$389  
Transcript (Pdf)
⊖   ⊕$229  
Recording & Transcript (Pdf)
⊖   ⊕$379  
DVD & Transcript (Pdf)
⊖   ⊕$389  


Order Form

Understand how to sort, filter, format, subtotal, and manage the data with the various built-in formulas within Excel

As a modern-day administrative professional, you have many responsibilities. On top of the normal tasks that come with the admin job, you may also be presented with huge amounts of data, and then asked to make some kind of sense of it all. This can all be very overwhelming. The information in this topic will help you deal with a large amount of data by showing you how to sort, filter, conditionally format, subtotal, and manage the data with various built-in formulas within Excel.

Agenda:-

Sorting Data

  • Sorting by One Field
  • Sorting by More Than One Field

Filtering Data

  • Filtering Text Fields
  • Filtering Number Fields
  • Filtering Date Fields

Conditional Formatting

  • Number Fields
  • Text Fields
  • Visually Appealing Conditional Formatting

Subtotal With the Data

  • Subtotals Using Formulas
  • Subtotals Using the Subtotal Feature

Important Formulas

  • IF
  • VLOOKUP
  • Text Formulas

Who should Attend?

This live webinar is designed for:

  • Administrative assistants
  • Executive assistants
  • Office administrators
  • Secretaries
  • Office managers
  • Other Administrative professionals

Tom Fragale

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.