Trainings
Intermediate to Advanced Microsoft Excel Workshop
Learn beyond the normal bars and graphs so that your reports will be easier to understand.
Microsoft Excel is one of the most powerful and useful business programs. It is used by millions of businesses globally primarily because it is effective and can be used by every industry there is.
In this 2-day hands-on workshop, the participants will be able to appreciate the Excel environment and its tools; execute advance functions of Excel; create business systems such time management; sales tracking and analysis and more. In addition, participants will be able to learn pivot table.
TARGET AUDIENCE:
Finance, Marketing, Operations and HR professionals who are tasked to create and generate reports.
TOPICS COVERED:
- Excel Interface
- Excel Functions
- Encoding & Editing
- Creating & Saving
- Keyboard Shortcuts
- Charts
- Creating and using names
- Managing names
- Validating cell entries
- Advanced filtering
- Conditional formatting
- Outlining and consolidating data
- Creating subtotals
- PivotTables and Pivot Charts
- Working with PivotTables
- Modifying Pivot Table data
- Formatting PivotTables
- Using Pivot Charts
Note: Pre-work assessment Included. This workshop includes an online Training Needs Analysis (TNA) to know how to effectively put the participants to the right level of Excel.
PHP 12,000
ECCP Members
PHP 14,000
Non-Members
No shows will be billed at full cost. Cancellations should be made at least 48 hours/two working days before the event.
Participants from outside Manila, requiring airfare and hotel bookings, should coordinate with ECCP for final confirmation of course schedule before booking. The ECCP shall not be responsible for charges incurred for changes in booking or flights.
For confirmations and more information, please contact
Ms. Nichole Raynera of ECCP at (02) 8845 1324 or email nichole.raynera@eccp.com
