Microsoft Excel Dashboard Development and Reports Generation Training (BASIC - AVERAGE - ADVANCED) Widus Hotel, Clark Freeport Zone, Angeles City, Pampanga or Unit E, JVFL Building Pandan 12-7 Magalang Road, Angeles City Pampanga 2009 ( Attendees below 10 ) ABOUT THE TRAINING/WORKSHOP OBJECTIVES This course is designed for people who are working with spreadsheets and would like to improve and automate current templates so they can focus more in value added work. Every organization would need a Report Dashboard to track KPI Metrics and Performance critical for decision making. DESCRIPTION To understand new methods in Database Management using MS Excel latest Features To eliminate old methods of using MS Excel and learn how to utilize the new features to make life easier To be able to perform Excel Power Functions and Features to start developing a Report ready Calculators To produce a Dashboard Report project at the end of the workshop To perform basic Report Analysis and learn how to help an organization when it comes to Decision Making Anatomy of MS Excel 365 Window Worst MS Excel Practices MS Excel Terminologies Entering Data in MS Excel Environment Database Management Basic Calculations in MS Excel Introduction to Reporting WHO SHOULD JOIN: - Participants with zero knowledge in Excel - Beginner users of MS Excel - Participants who use old Excel versions Anatomy of MS Excel 365 Window Database Management using MS Excel Preparing a Pivot Ready Raw Data Commonly used Features and Functions Report Dashboard Creation Process Basic Charting Report Designing and Visualization WHO SHOULD JOIN: - Participants who completed the Basic Level Training Review on Dashboard Creation Process Complex Formulas and Features Advance Pivot and Charting Features Building a Calculator Report Analytics Tools WHO SHOULD JOIN: - Participants who completed the Average Level Training REQUIREMENTS THINGS TO BRING: Laptop with Microsoft Office 2013/2016/365/2019 Notes: QUALIFICATIONS: Basic Level - Should have used basic MS Excel Average and Advance Level - should have completed the Basic Level Sample Output: DOWNLOAD THE RESERVATION FORM KINDLY CLICK YOUR PREFERRED FORMAT FROM THE BUTTONS BELOW DATE: July 17-18-19,2019 TIME: 9:00 AM - 4:00 PM VENUE: Widus Hotel, Clark Freeport Zone, Angeles City, Pampanga or Unit E, JVFL Building Pandan 12-7 Magalang Road, Angeles City Pampanga 2009 (Attendees below 10) Contact Numbers: (045) 923.1751 or text/call 09778393827 Your learning investment includes AM Snack, Lunch, PM Snack, Manual Kit, materials, and Certificate. LIMITED SEATS ONLY! For inquiries, you may also leave a message in our CONTACT FORM . REGISTER ONLINE MANUAL REGISTRATION WE WILL SEND A BILLING STATEMENT WITHIN 48 HOURS AFTER YOU REGISTERED. WE ALSO OFFER IN-HOUSE TRAINING . INQUIRE FOR DETAILS. WE'LL SEE YOU THERE SPREAD THE NEWS |
Microsoft Excel Dashboard Development and Reports Generation Training
(BASIC - AVERAGE - ADVANCED)
| |
ABOUT THE TRAINING/WORKSHOP
| |
OBJECTIVES
This course is designed for people who are working with spreadsheets and would like to improve and automate current templates so they can focus more in value added work. Every organization would need a Report Dashboard to track KPI Metrics and Performance critical for decision making.
DESCRIPTION
- To understand new methods in Database Management using MS
Excel latest Features
- To eliminate old methods of using MS Excel and learn how to
utilize the new features to make life easier
- To be able to perform Excel Power Functions and Features to
start developing a Report ready Calculators
- To produce a Dashboard Report project at the end of the
workshop
- To perform basic Report Analysis and learn how to help an
organization when it comes to Decision Making
| |
- Anatomy of MS Excel 365 Window
- Worst MS Excel Practices
- MS Excel Terminologies
- Entering Data in MS Excel Environment
- Database Management
- Basic Calculations in MS Excel
- Introduction to Reporting
WHO SHOULD JOIN:
-Participants with zero knowledge in Excel
-Beginner users of MS Excel
-Participants who use old Excel versions
| |
-
Anatomy of MS Excel 365 Window
- Database Management using MS Excel
- Preparing a Pivot Ready Raw Data
- Commonly used Features and Functions
- Report Dashboard Creation Process
- Basic Charting
- Report Designing and Visualization
WHO SHOULD JOIN:
-Participants who completed the Basic Level Training
| |
- Review on Dashboard Creation Process
- Complex Formulas and Features
- Advance Pivot and Charting Features
- Building a Calculator
- Report Analytics Tools
WHO SHOULD JOIN:
-Participants who completed the Average Level Training
| |
REQUIREMENTS
THINGS TO BRING: Laptop with Microsoft Office 2013/2016/365/2019
Notes:
QUALIFICATIONS:
Basic Level - Should have used basic MS Excel Average and Advance Level - should have completed the Basic Level
| |
DOWNLOAD THE RESERVATION FORM
KINDLY CLICK YOUR PREFERRED FORMAT FROM THE BUTTONS BELOW
|
| |
Contact Numbers: (045) 923.1751 or text/call 09778393827 | |
Your learning investment includes AM Snack, Lunch, PM Snack, Manual Kit, materials, and Certificate. LIMITED SEATS ONLY!
For inquiries, you may also leave a message in our CONTACT FORM.
| |
WE WILL SEND A BILLING STATEMENT WITHIN 48 HOURS AFTER YOU REGISTERED. |
|
| |
|
|
| |