Learn Excel Now

Conquer the Fear of Excel

  • Home
  • Training
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
  • Resources
  • Login

Managing Lists & Databases with Excel: Instructor-Led Training for Success

Price: $
Share

Summary

Most people don't connect "database," and Excel, but most people are using Excel to manage their lists. Whether it's product pricing, human resources or transaction data, Excel users spend a great deal of time managing, tracking, and analyzing these "flat" databases. Many of these hours could turn to minutes if you knew the secrets the experts know. This 90-minute training will give you that edge by revealing:

  • How to build lists that take advantage of Excel's best tools
  • How to take what you get from data imports and turn it into what you need
  • Techniques for sorting and filtering that go beyond ascending/descending
  • Three different methods to "query" your data

Program Highlights

Excel Data Management: Keys to Making Sense of Large Lists

  • Tools for data import & clean-up that will save you time
  • How to work with Table Style formatting to manage data lists
  • Discover hidden tools to make managing data easier
  • Refining data imports to get what you need from them

Filter, Advanced Filter and Pivot Tables: Sort & Organize Your Data

  • Dynamic filtering: Going beyond ascending/descending for true insight
  • Query your data: Three effective methods to quickly find what you need
  • VLookUp, DSum and other Dfunctions: Conquer your challenging tasks
  • Pivot Tables techniques that make sense of your data

About The Speaker

Melissa Esquibel is a technology consultant, coach, trainer and speaker.

  • She is a consultant, frequent speaker and Microsoft Certified Trainer
  • Since 1991, Ms. Esquibel has assisted a variety of companies and industries with Microsoft Office (Excel, Word, PowerPoint, Access, Outlook) all versions through 2016.
  • Melissa has 25+ years experience in information technology with a background in training, technical writing and business risk analysis

Program Benefits

This 90-minute training gives you tools and techniques to add to your skill set and shave time off your large data tasks.

Credits

NASBA logo
Credit Hours:
Field of Study:
Program Level:
Basic Knowledge
Prerequisites:
None
Advance Prep:
Delivery Method:
Group Internet Based
Progressive Business Conferences is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

Purchase This On-Demand Webinar

Managing Lists & Databases with Excel: Instructor-Led Training for Success

Format: On-Demand Webinar
Price: $199 + applicable taxes Buy Now

Purchase This On-Demand Webinar

Managing Lists & Databases with Excel: Instructor-Led Training for Success

Format: On-Demand Webinar
Price: $199 + applicable taxes
Buy Now

Credits

NASBA logo
Credit Hours:
Field of Study:
Program Level:
Basic Knowledge
Prerequisites:
None
Advance Prep:
Delivery Method:
Group Internet Based
Progressive Business Conferences is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In