Trainings
Microsoft Excel 1: Basic to Intermediate Data Reporting
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.
On this two-day workshop, 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. Plus, participants will be able to learn pivot table.
Additionally, attendees will be able to make better reports for efficient work flow.
TARGET ATTENDEES
Finance, Marketing, Operations and HR professionals who are tasked to create and generate reports.
TOPICS COVERED
- Logical function
- Conditional functions
- Financial functions (SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS)
- Text functions
- Date and me function
- Error functions (ISNA, ISERROR)
- Using lookup functions
- Creating and using names
- Managing names
- Validating cell entries
- Conditional formatting
- Outlining and consolidating data
- Creating subtotals
- PivotTables and PivotCharts
- Working with PivotTables
- Modifying PivotTable data
- Formating PivotTables
- Using PivotCharts
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.
Workshop Facilitator
Maria Anna Masindo
MARIA ANNA MASINDO is a dynamic and results-focused I.T. specialist (Trainer, Project Manager, Consultant) with proven training, leadership and management skills. Anna exceptional speaker, Proactive in identifying and resolving problems, reliable and capable of handling any situations even in a fast-paced environment. In addition, she knows how to multi-task effectively, versatile and interact well with others and is driven by new challenges and desire to be successful in all endeavors.
Anna is an MOS certified and has an in-depth knowledge and understanding of numerous software packages and operating systems in Computer Software Applications, Accounting Information Systems, Programming Languages and Operating Systems such as Windows, Sun Solaris, Linux Cent OS, MAC/OSX, Android.
Learning Investment:
Php 16,500 ECCP Members
Php 18,500 Non-Members
(includes coffee breaks, lunches, seminar materials and certificate of attendance)
For confirmations and more information, please contact
Ms. Nichole Raynera of ECCP at 845 1324 or email nichole.raynera@eccp.com
