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

Excel Dashboards 101

SKU:WT-1001698
Format: Webinar
Description:

Microsoft® Excel® dashboards are a powerful way to pull together different information in a single place to give a high-level overview of a business. A meaningful "big picture” view of business activities can drive the allocation of scarce resources.

Decisions are easier.

And, the end-user doesn't have to spend valuable time swimming through seas of unimportant information to get to key information.

You could buy expensive software to create dashboards. But, before you do, see what you can do with tools you already possess in Excel.

Join Microsoft® Certified Trainer Melissa Esquibel for Excel Dashboards 101 to discover how to create useful dashboards with financial, production and customer data. Get tips on converting raw data into readable charts, diagrams and tables that are easy to consume.

We'll cover:

  • What should be included in your dashboard
  • Set-up tips to allow data to easily flow from source to dashboard
  • How to make your dashboards resilient to changing data
  • Using charts and pivot tables to get just the detail you need
The session will be presented from Excel 2010, but many of the techniques you'll learn will be applicable to Excel 2007 and 2013. Some material will also be usable in older versions. To get the most out of this program, attendees should have some experience with Excel charts, pivot tables and formulas.

Among the techniques you'll learn are:
  • Importing data from external sources
  • Transforming cell data into dynamic graphics
  • Creating interactive user interfaces
  • Connecting your dashboard to automatically refreshing data
With Excel Dashboards you can step back from the details and see the key trends and relationships that drive business. Join us for Excel Dashboards 101 and learn how to create effective dashboards easily.

About The Provider: The HR Specialist family of products helps HR professionals quickly resolve their daily challenges. From state-specific employment law to compensation and benefits, our experts give you the HR advice you need to know.

Whether you're new to HR or an experienced pro - a department of one or 10 - you can trust the practical, plain-English advice from HR Specialist. We'll save you time and headaches by focusing on what you need to know, when you need to know it. That makes you the HR expert your company can rely on and gets you the recognition you deserve.
Price: $197.00
More Info: Contact Us For More Information
Share This: Share on Facebook


Share on Twitter


Share on Google+


Keywords For This Course:

Excel, presentations, accounting, dashboards, financials, accounting, data

Currently Scheduled Dates For This Webcast
There currently are no scheduled dates for this webcast. Please click here to search for another course.

Call Report for Banks - Recent Changes, Highlights, and Pitfalls
Call Report for Banks - Recent Changes, Highlights, and Pitfalls

Flood Insurance: Compliance Issues And Enforcement Topics That Continue To Plague Lenders
Flood Insurance: Compliance Issues And Enforcement Topics That Continue To Plague Lenders

What To Do When A Customer Dies
What To Do When A Customer Dies

Sixty (60) Critical Steps For Handling Delinquent And Abandoned Safe Deposit Boxes
Sixty (60) Critical Steps For Handling Delinquent And Abandoned Safe Deposit Boxes

Right of Setoff
Right of Setoff

Federal Benefit Payments Garnishment Requirements
Federal Benefit Payments Garnishment Requirements

Certified Regulatory Vendor Program Manager
Certified Regulatory Vendor Program Manager

Cash Management: How Sales, Operations, and Technology Can Work Together to Generate More Fee Income
Cash Management: How Sales, Operations, and Technology Can Work Together to Generate More Fee Income

Underwriting Construction Loans
Underwriting Construction Loans

BSA Requirements
BSA Requirements

Bank and Financial Institution Fraud
Bank and Financial Institution Fraud

Qualified Financial Advisor (QFA)
Qualified Financial Advisor (QFA)

Loan Officer Boot Camp
Loan Officer Boot Camp

CSA Certified Senior Advisor
CSA Certified Senior Advisor

Loan Processing 101: The Basics
Loan Processing 101: The Basics

FHA Direct Endorsement - DE Underwriting
FHA Direct Endorsement - DE Underwriting

 BankTrainingCenter.com. 5755 North Point Parkway, Suite 228 | Alpharetta, GA 30022 | 770-410-9375 | support@BankTrainingCenter.com
Copyright BankTrainingCenter.com 2017 | Web Site Development by OTAU
Facebook