About The Event
Microsoft Excel has become the de facto spreadsheet application for business. But do you sometimes feel like you have rows and rows of data and it’s hard to make heads or tails of it? This class will help you learn how to manage databases in Excel, and get the most out of them.
For 75-minutes, Excel expert Tom Fragale will lead you through a full array of powerful and easy-to-use database commands and methods critical to effectively working with Excel databases. In this webinar, you will learn how to improve your Excel database skills so that you can better summarize info-making better, more-informed business decisions.
- Create and use Excel tables, as well as add, edit, search for, and delete records in a data list using a form
- Use VLOOKUP and HLOOKUP to aggregate data from multiple tables
- Sort records in a data list using a variety of methods
- Filter data in a list using a variety of methods, as well as work with filtered data
- Create and work with subtotalled lists
- Use various database functions to summarize data
- Create, modify, and work with PivotTables, PivotCharts, and Slicers
- Import external data from a variety of sources into Excel
Who Should Attend
- Experienced Excel users who work with large data sets
- Accountants and finance professionals
- CFO/Controllers Investment Analysts / Financial Analysts / Business Analysts Forecasting & Planning Personnel Mergers & Acquisitions Specialists Risk Managers Strategic Planners / Capital Expenditure Planners Cost Accountants / Managerial Accountants
- Any User of Excel who wants to learn how to create form-driven applications and spreadsheets
- Financial Professionals
- Office workers
Industries: Microsoft Office, Excel
Subjects: Microsoft Excel
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.
Compliance Prime 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: https://www.nasbaregistry.org.
Also, please check your junk mail or spam folder for firstname.lastname@example.org or email@example.com. If you are still unable to find it, contact our Customer Service at (888) 527-3477, 8:00am-4:30pm EST Monday-Friday, for a new one.
For that, login to your user account. Go to Orders > Webinar. You will see a “Attendees” button. Click on that, it will go to Add Attendee page. There you can add Attendee details. Once you have added the details, you will be taken to Attendee Listing page, where you can see “Certificate Download” button to download certificate.
After you have purchased a recording, login to user account. Go to Orders->Recording tab. There you will find a Download link. Click on that to download the video.
Once you have purchased a On-demand video, login to user account. Go to Orders->On-demand tab. You will find a Watch Now button. Click Watch Now button to watch the video.
Access Unlimited Webinars
Why You Should Subscribe?
Unlimited Live and On-Demand Courses
Attend any of our live webinars, more than 100 every year and all previously recorded webinars in On-Demand format related to HR, Payroll, Affordable Housing, Construction Law Management, Microsoft Office and Performance Management Office.
Unlimited SHRM and HRCI Credits
All our HR related programs are pre-approved for HRCI and SHRM credits, for which you don't have to pay anything.
Free Access to Course Materials
Each program comes with Additional Course Materials, which you can download and read anytime.
If you have a group, we offer good discounts on group membership.
Call Now At