Duration: Scheduled for 90 minutes including question and answer session.
Presenter(s): Tom Fragale, Microsoft Certified Trainer; Microsoft Certified Office Master
Price: $299.00, On-Demand includes full audio presentation, question and answer session, and presentation slides.
Credits: Live webinar approved for 1.5 NASBA credit hours (Management Services).
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 and planning personnel, mergers and acquisitions specialists, risk managers, strategic planners, capital expenditure planners, cost accountants, and managerial accountants
Microsoft Excel has become the de facto spreadsheet application for bankers and finance professionals. 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.
Learn how to manage databases in Excel with this webinar. Learn the tools that will help large amounts of data seem more manageable, and easier to sort through and analyze. Understand what functions work best with large tables, and how you can automate repetitive steps with simple macros. Become a master of working with databases in Excel.
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 your data to make more informed business decisions.
WHAT YOU'LL LEARN
A sampling of what this webinar will cover:
- How can you build and manage large databases in Excel?
- What specialized Excel financial functions will simplify your job?
- How can you sort and filter data to identify business trends?
- What are the best ways to validate data and guarantee accuracy?
- How can you format data to create compelling charts and presentations?
- How can you use macros to save time by automating repetitive steps?
YOUR CONFERENCE LEADER
Your conference leader for “Advanced Excel for Bankers” 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 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.
BankersWEB.com QUALITY COMMITMENT
BankersWEB, a division of DKG Media, LP, wants you to be satisfied with your webinar. If this webinar does not meet your expectations, email us at [email protected].
CERTIFICATES OF PARTICIPATION
BankersWEB certificates of participation are available to everyone completing this webinar.