BankTrainingCenter.com offers banking exams, banking degree training, and professional development for banking professionals
Course/Product Description
Title:

How To Use Excel Dashboards

SKU:WT-1001444
Format: Webcast/Audio Conference/Interview/Podcast
Description:

How To Use Excel Dashboards

Feel overwhelmed by the amount of information crossing your desk?

One way to stem the tide is by way of Excel-based dashboards, which can aggregate content from numerous sources into a compact resource that allows you to assimilate mass amounts of information at once, but also quickly drill down into the details when needed.

In this presentation, Excel expert David Ringstrom, CPA shares with you a number of techniques that you can use to construct dashboard applications in Excel. David teaches from Excel 2010 in this presentation, but his course materials include alternate instructions for Excel 2013, 2007, and 2003 when needed. He also provides an example workbook that includes copies of the related PowerPoint slides on each worksheet.

Who Should Attend:

Practitioners tasked with summarizing large amounts of data in Microsoft Excel spreadsheets

Topics Covered:

This webinar will help you to master a variety of Excel features and worksheet functions that will help you use Excel far more effectively. By attending, you will gain the ability to:

  • Create set-and-forget spreadsheets that others can use to monitor financial results

  • Use the From Text feature in Excel to establish persistent links to data files exported from your accounting software

  • Discover how Microsoft Query allows you to create self-updating links to databases, spreadsheets, text files and other data sources

  • Understand how to use the Slicers feature in Excel 2013 to streamline analyzing data within tables

  • Discover the Sparklines feature in Excel 2010 and 2013, and how to replicate it in Excel 2007 and earlier

  • Use Excel's Custom Views feature to show or hide multiple worksheets on demand

  • Use the Group and Ungroup feature to expand or collapse

  • Master the versatile SUMIF function

  • Use the SUMIFS to sum value based on multiple criteria

  • Compare the MIN, SMALL, MAX and LARGE functions

  • See why the MATCH and INDEX combination is often superior to VLOOKUP or HLOOKUP

  • Overcome annoyances in Excel 2013 by making simple adjustments to Excel's options

  • Discover the new Recommended Pivot Tables feature in Excel 2013

  • See the new Recommended Charts feature in Excel 2013, as well as user interface changes in Excel 2013 that make managing charts far easier

  • Capitalize on new features in Excel 2013 that empower anyone to quickly analyze data


Level:
Intermediate

Format:
Group: Internet-based

NASBA Field of Study:
Specialized Knowledge and Applications (2 Hours)

Program Prerequisites:
None

Advance Preparation:
None

About Your Speaker

David Ringstrom, CPA, is the Tech Editor-at-Large for AccountingWEB and Going Concern. David speaks at conferences nationally and presents dozens of webinars annually on Excel and other topics. He offers Excel training and consulting services nationwide, and has written numerous articles on spreadsheets.

About The Provider: The Industry Calendar creates and sells audio conferences, webcasts, seminars, and other training courses for busy business professionals.

We've done the work of listing the important, don't-miss events in one convenient location so you can quickly and easily view and register for upcoming events. Simply click on a course title or search by specific industry to get started!
Price: $239.00
More Info: Contact Us For More Information
Share This: Share on Facebook


Share on Twitter


Share on Google+


Currently Scheduled Dates For This Webcast
Course TitleDatePrice
How To Use Excel DashboardsCD/On-Demand$239.00

Do's and Don'ts of Signature Card Contracts
Do's and Don'ts of Signature Card Contracts

When Your Customer's Name and TIN Do Not Match
When Your Customer's Name and TIN Do Not Match

Right of Setoff
Right of Setoff

Marketing & Advertising Compliance - The First UDAAP Hotspot
Marketing & Advertising Compliance - The First UDAAP Hotspot

Handling Loan Applications - Required Training for Loan Originators
Handling Loan Applications - Required Training for Loan Originators

BSA Series: Revisiting CIP With New CDD Rules Pending

Dealing With Subpoenas, Summonses, Garnishments, Tax Levies, ETC.
Dealing With Subpoenas, Summonses, Garnishments, Tax Levies, ETC.

Basic Cash Flow Analysis
Basic Cash Flow Analysis

Alert! FFIEC BSA / Anti-Money Laundering Examination Manual

Securities License
Securities License

What To Do When Applicants Or Employees Have A Criminal History
What To Do When Applicants Or Employees Have A Criminal History

Certified Regulatory Vendor Program Manager
Certified Regulatory Vendor Program Manager

Best-Ever Compliance Checklists for Consumer Loans
Best-Ever Compliance Checklists for Consumer Loans

Opening Accounts for Nonresident Aliens: New W-8BEN, W-8BEN E and Due Diligence Rules
Opening Accounts for Nonresident Aliens: New W-8BEN, W-8BEN E and Due Diligence Rules

Call Report For Banks: Basel III & Other Recent Changes
Call Report For Banks: Basel III & Other Recent Changes

Bank Call Report Preparation for Beginners - Five Part Webinar
Bank Call Report Preparation for Beginners - Five Part Webinar

FacebookFacebook
Licensing
Insurance Licensing
Securities Licensing
Series 3 Exam Prep
Series 4 Exam Prep
Series 6 Exam Prep
Series 7 Exam Prep
Series 9 Exam Prep
Series 10 Exam Prep
Series 11 Exam Prep
Series 24 Exam Prep
Series 26 Exam Prep
Series 27 Exam Prep
Series 28 Exam Prep
Series 32 Exam Prep
Series 51 Exam Prep
Series 53 Exam Prep
Series 55 Exam Prep
Series 62 Exam Prep
Series 63 Exam Prep
Series 65 Exam Prep
Series 66 Exam Prep
Series 79 Training
Series 82 Training
Series 99 Training
Designations/Certifications
Accredited Investment Fiduciary (AIF®)
Certified Annuity Specialist (CAS)
Certified College Planning Specialist (CCPS)
Certified Divorce Specialist (CFDS)
Certified Estate and Trust Specialist (CES)
Certified Financial Planner (CFP)
Certified Funds Specialist (CFS)
Certified Income Specialist (CIS)
Certified Senior Advisor (CSA)
Certified Tax Specialist (CTS)
CFP Courses for Certification
CFP Review Course
Chartered Advisor for Senior Living (CASL)
Chartered Alternative Investment Analyst® (CAIA®)
Chartered Financial Analyst (CFA)
Chartered Financial Consultant (ChFC)
Financial Risk Manager (FRM)
Professional Plan Consultant (PPC)
Qualified Financial Advisor (QFA)
Steps to Achieve CFP® Certification
 
Professional Development
Account Management Training Courses For Bankers
Bank Compliance Training And Education
Bank Directories
Bank Fraud Prevention
Bank Management
Banking Certifications / Designations
BSA Training
Call Report Training
Estate Planning
Mortgage Lending Training Courses
Safe Deposit Box Training
Teller Training
Trusts and Estates Training
UDAAP Training Courses
Vendor Management Training Courses