USING MICROSOFT EXCEL TO CREATE DASHBOARDS

Instructor explaining student the course outline

Excel Dashboard Reporting & Database Analysis

The certificate introduces students to the tools needed to analyze large datasets in order to make more informed business decisions. Gather and organize data for more effective analysis. Learn to communicate analyses in a clear and concise manner.

Topics include:

• Importing data into an analytics software package

• Performing exploratory graphical and data analysis

• Building analytics models using tools such as multiple regression and decision trees

• Finding the best model to explain correlation among variables

• Learning how to control and assess data variability

Who should participate?

• Business, marketing, and operations managers

• Data analysts or professionals in any field who deal with large amounts of data

• Financial industry professionals

• Small business owners

Jul

13

Tue

Intermediate Excel Skills Training

Learn Functions & Formulas such as IF, SUMIF, COUNTIF and more....

Aug

8

Sat

Excel programming with VBA

Learn to create powerful Excel apps with VBA, Develop user-friendly dialog boxes

Jul

28

Tue

QuickBooks Training: For Beginners

Learn to use QuickBooks if you have no accounting experience - For Admin Assistant

Jul

18

Sat

Financial Accounting I - Basic Accounting

Learn Debits/Credits, Analyze Transactions, Create GL accounts, Prepare Fin. Statements, Reconciliation