SMS-112 Microsoft® Excel Data Analysis and Interactive Dashboard Reporting - Basic to Intermediate
Training by
Ampro Solutions Sdn Bhd
Inquire Now
On-Site
/ Training
Details
Microsoft Excel is one of the most powerful and popular data analysis desktop application on the market today. By participating in this Microsoft Excel Data Analysis and Dashboard Reporting course you'll gain the widely
sought after skills necessary to effectively analyze large sets of data. Once the data has been analyzed, clean and prepared for presentation, you will learn how to present the data in an interactive dashboard report.
Outline
- Managing Raw Data
- Lab Assessment – Handing Massive Raw Data
- Working with a Single Dataset
- Working with Data Analysis
- Lab Assessment : Formula VS PivotTable
- Working with Multiple Datasets
- Lab Assessment : Generating Invoices / Purchase Order in Excel
- Working with Data Reporting
- Lab Assessment : 10 Questions – 10 Quick Analysis
- Preparing Dashboard and Visualization
- Lab assessment : Design Dashboard for each department
- Creating Interactive Dashboard
- Lab Assignment : compiling multiple chart and prepare linked pivot table for future designs
- Prepare and Distribute Reports
- Lab Assessment : Dynamic Dashboard with extra macro inside
Reviews
Be the first to write a review about this course.
Write a Review
Ampro believes that the key to a successful and rewarding career is continuous professional development. We have a flexible approach to your training needs with regardless of whatever your requirements, we promise you a high level of service with packages that meet the needs of your business.
As a forward thinking company we deliver training at all levels, thereby supporting your company at every stage of its development. Courses can be delivered onsite at a location of your choice, costs dependent upon location and numbers, or at hotel.
Our Company Values
We are determined in developing new programmes and staying on-point with industry's trend, while maintaining exceptional quality standards.
When we commit to something, we’re totally devoted. Whether it’s our dedication to our clients; or to maintain at the leading edge of training services we offer; we are always dedicated to our task.
Our People
All our staff are highly motivated professionals, experienced and qualified in their own specialist areas, who are committed to works towards common goals.
Our trainers and consultants are quality assure and have been tested on their ability to deliver top-quality programmes. ...
Our Company Values
We are determined in developing new programmes and staying on-point with industry's trend, while maintaining exceptional quality standards.
When we commit to something, we’re totally devoted. Whether it’s our dedication to our clients; or to maintain at the leading edge of training services we offer; we are always dedicated to our task.
Our People
All our staff are highly motivated professionals, experienced and qualified in their own specialist areas, who are committed to works towards common goals.
Our trainers and consultants are quality assure and have been tested on their ability to deliver top-quality programmes. ...
Related Courses
Tertiary Infotech
Tertiary Infotech
Tertiary Infotech
Tertiary Infotech
