₱0 – ₱1,763.83

Advanced Excel (Day 2)

Event Information

Share this event

Date and Time

Location

Location

Manaig, Manaig & Co., CPAs

G/F MMCo Building

8000 Lakeview Subd. Phase 3

Calamba, Calabarzon 4027

Philippines

View Map

Event description

Description

Earn 8 CPD Units - Competence Area B

Seminar Fee (incl. of lunch and pm snack) - P1500+VAT

To register

Click the TICKETS button and choose your preferred option


Course Description: Microsoft Excel is a powerful tool in many jobs. It enables you to organize and interpret data in a more productive way. This program is designed to help learners to be equipped in Excel and take advantage of the functionalities and features of it to improve their work performances.

Advanced Excel (Day 1) Link: https://www.eventbrite.com/e/advanced-excel-day-1-tickets-54568872968

Objectives:
1. To equip participants on the basic and advanced features and functionalities of MS Excel;
2. To know how excel features and functionalities can be of help in doing analyses and reports.
3. To help participants appreciate the importance of data security and accuracy in preparing spreadsheets.
4. To apply all these learnings in various cases and problems at work.

Day 2
1. Data Handling and Analysis (using data validation, pivot table, sort, filter, conditional formatting)
2. Data Outlining and Grouping (using group/ungroup function, split and freeze panes)
3. Creating reports (data entry forms, charting)
4. Sharing and protecting workbooks (password enable files or sections of a workbook)

Remarks:
1. Working with Scenarios & Using If- formula
2. Using Data Tables & Pivot Tables
3. Learning Macros
4. Creating Reports
5. Sharing and Protecting Workbooks

Disclaimer: Whatever will be taught here may not work if user is using Google Sheets, WPS or Open Office.

Directions:

From SM City Calamba Laguna, move towards way going Halang/Bucal/Pansol. Upon reaching Burger King-Halang, turn right going to the inside of the Lakeview Subdivision. On 2nd street-St. Angela Street, turn left. Our location is about 40 meters to your left black gate with MM&Co. logo. We are adjacent to Calamba Water District-Halang.
Coordinates: 14.192978, 121.164613


Speaker: Joseph Peter Anthony “Ice” S. Ayson

Education
• Bachelor of Science in Accountancy - San Beda College

Experience
• Chairman and Managing Director - Outright Biz Solutions and Consultancy, Inc.
• Chairman and Chief Executive Officer - Travel Without Boundaries Inc.
• Manager, Audit and Assurance - Maceda Valencia & Company
• Manager and Business Controls - IBM Business Services, Inc.
• Senior Manager - PeopleSupport (Philippines), Inc.
• Audit Senior, Audit and Assurance - Punongbayan & Araullo

Share with friends

Date and Time

Location

Manaig, Manaig & Co., CPAs

G/F MMCo Building

8000 Lakeview Subd. Phase 3

Calamba, Calabarzon 4027

Philippines

View Map

Save This Event

Event Saved