Excel: Special Charts and Dashboards
Details
Outline
1. Review of Chart Elements
2. Special Charts and Techniques
- Waterfall Chart and the Concept of Floating Chart Stack
- Gantt Chart in Excel
- Conditional Charts
3. Dynamic Charts with OFFSET Function
4. Dynamic Charts using PivotCharts
- Advanced PivotTables
- Grouping
- Slicers and Report Connections
5. Dashboards
Prerequisite: Knowledge of advanced Excel
Speaker/s
DONNIE RAY BAJE
Microsoft Certification ID: 15447524
Donnie has been in the professional Learning & Development field for over 10 years, with experience in both administrative, executive, and managerial roles. His experience with the Business Process Outsource industry exposed him to various levels of training
needs, including Communication Skills, Customer Service, Technical, Sales, Collections, and Leadership Development.
Working with one of the top IT schools in the Philippines and other training providers, he has developed his expertise on MS Office applications, designing training modules for various corporate clients.
He also conducts training on leadership and professional skills. He had written several ebooks on various topics and had ghostwritten some leaning materials for clients locally and abroad.
Insights Manila (registered as Insights MLA Business Solutions) is a training services company based in Makati. The company believes that the country’s workforce requires ample training that is effective and insightful, yet affordable.
The consultants of Insights Manila are experienced professionals who had executed the courses several times for different companies under various training institutions.
Insights Manila mostly offers exclusive training for companies. The courses are customized to meet specific training needs. The company also offers public classes where individuals can enroll, and one-on-one training for people who wish focused training. Other than training, the company also accepts Excel automation projects and course development projects.
With Insights Manila, you are directly dealing with the consultants– no intermediary parties who just add costs to the training delivery.