Description
Overview
Microsoft Excel Mastering the fundamentals is an intensive workshop of the Philippine Business School, aimed at supporting the enhancement of skills of Professionals on Excel spreadsheets, being one of the most commonly used applications in the business.
The approach of Philippine Business School on the workshop course gets you up to speed with the fundamentals of Excel, including the mastery of the key shortcuts without the dependency on your mouse.
MS Excel – Level 3 Analytics Tool and Dashboard Creation
Upon successful completion of this masterclass, students will be able to:
- Collaborate with other workbook users.
• Audit worksheets.
• Analyze data.
• Work with multiple workbooks.
• Import and export data.
Key Topics
Module 1: Collaborating With Other Users
- Protect Files
• Share a Workbook
• Set Revision Tracking
• Merge Workbooks
Module 2: Auditing Worksheets
- Trace Cells
• Troubleshooting and Formula Errors
• Watch and Evaluate Formula
Module 3: Working with Multiple Workbooks and Exporting/Importing data
- Consolidate Data
• Link Cells in Different Workbooks
• Edit Links - Export Excel Data
• Import Delimited Data File
Module 4: Creating Informative Dashboards
- Using Sparklines
- Using Data Tables
- Basics of Data Analysis
- Key points to focus on creating dashboards
- Create simple dashboards for management reporting
Reviews
There are no reviews yet.