Mr. Dioscoro Baylon

EXCEL TIPS AND TRICKS TO BOOST BUSINESS PRODUCTIVITY

Featured Speaker:  Mr. Dioscoro Baylon, Jr.
Professor – De La Salle University
November 27, 2020
2:00pm –  5:00pm
*******************************************************************
Regular Rate           Php 1,499.00 + VAT starting November 21, 2020
Early Bird Rate        Php 1,399.00 + VAT until November 20, 2020
Group Rate              Php 1,299.00 + VAT per pax for 5 or more pax

Inclusive of the Webinar Session and the Digital Certificate
*******************************************************************

PROGRAM OVERVIEW

Are you and your colleagues taking advantage of the several very useful Microsoft Excel features that can fast track your business processing time? Whether you are in finance, accounting, supply chain, marketing or project management, you can save valuable time and efforts if you will uncover some of the most helpful but little-known functionalities of Excel. Join this immensely important learning session and see for yourself how your work can be finished more quickly, conveniently and effortlessly, thus giving you a distinct advantage over others.

COURSE CONTENT

1: Working With Functions

• Work with Ranges
• Use Specialized Functions
• Work with Logical Functions
• Work with Date and Time Functions
• Work with Text Functions

2: Working With Lists

• Sort Data
• Filter Data
• Query Data with Database Functions
• Outline and Subtotal Data

3: Analyzing Data

• Create and Modify Tables
• Apply Intermediate Conditional Formatting
• Apply Advanced Conditional Formatting

4: Visualizing Data With Charts

• Create Charts
• Modify and Format Charts
• Use Advanced Chart Features

5: Analyzing Data With PivotTables and PivotCharts

• Create a PivotTable
• Analyze PivotTable Data
• Present Data with PivotCharts
• Filter Data by Using Timelines and Slicers

 

RESOURCE SPEAKER – MR. BOBBY BAYLON, JR.
Professor – De La Salle University

• Full-time professor at the De La Salle University, at the Financial Management Department of the RVR-College of Business.
• Former Dean of the School of Professional and Continuing Education (SPACE) of the College of St. Benilde.
• He teaches quantitative courses in business and finance.
• He conducts public and corporate seminars in Microsoft Excel.
• He finished Masters in Business Administration and Masters in Computational Finance in De La Salle University.

IMPORTANT REMINDERS

LIMITED SLOTS. Limited slots are available. To avoid last-minute delays and inconveniences, we advise you to please register at the latest two days or one day before the webinar event.

REGISTRATION. You must register or be registered by someone else to be able to join our webinars.  Webinar access links are strictly sent through email therefore make sure you indicate the right email addresses for the participants. Please indicate how many participants you wish to include before hitting the REGISTER NOW button.

CHECK OUT. When you go to the Checkout Page, double-check the number of participants you have to register, if you change your mind or wish to make last-minute adjustments, do not forget to update your cart by clicking the UPDATE CART button.  Once everything is final, you may now click the PROCEED TO CHECK OUT button.

BILLING DETAILS AND THE NAMES OF THE PARTICIPANTS. On the upper portion, you have to enter your details (esp. your email address) as the one paying for the registration. Underneath, you have to enter the details (esp. the email addresses) of the participants you wish to join the webinar.

PAYMENT

POWERMAX provides three (3) payment options:
(1) Bank Deposit/Online Bank Transfer
(2) G-Cash
(3) PayPal/Credit or Debit Card Through PayPal

Bank Deposit or Online Bank Transfer / G-Cash
If you choose Bank Deposit/Online Bank Transfer or G-Cash, you have to send the proof of payment to info@powermax.ph.

IMPORTANT:  Proof of payment must be sent to info@powermax.ph.  Failure to send the proof of payment to info@powermax.ph means the participants will not receive the webinar links even if the proof of payment is sent to other contact details of Powermax or its representatives (e.g., Facebook, Messenger, Viber, other email addresses, etc.).

Payment Through PayPal
If you choose to pay for your registration using PayPal you may do so.  Please take note that PayPal also accepts Debit Cards and Credit Cards bearing the VISA and Mastercard logo. Unlike the Bank Deposit/Online Bank Transfer, the PayPal process automatically updates our system to issue the participants their access to our webinars.

WEBINAR ACCESS LINKS.  Once payment is made and verified, we can activate the spot on the webinar then we can send the webinar access links to the email addresses of the participants – this only goes with Bank Deposit/Online Bank Transfer / G-Cash.  However, for payments made using PayPal, the activation process is automatic. Note that your webinar access link cannot be shared with anyone else.  If you cannot attend on the date and time of the webinar kindly advise us at the latest one day ahead.

POWER WEBINARS. Powermax live webinars are designed to give you an incisive insight into a plethora of interesting and relevant topics using Zoom technology. It aims to uncork the latest updates, best practices, useful strategies, and tactics, and/or practical tips and techniques not just to widen your horizon but also to equip you with the essential knowledge and skills. Hopefully, this will also encourage you to register for the other webinars of Powermax. Just visit our site – www.powermax.ph to see our other webinars.

A PLEASANT WEBINAR EXPERIENCE

To ensure a pleasant webinar experience, we recommend to registrants to:

1. Download and install the Zoom application beforehand
2. Ensure that there is a proper internet WIFI connection
3. Use a working webinar streaming device.

 

TERMS AND CONDITIONS

1. Definition of Terms
   • REGISTRANT – The person who has registered himself or other people for a webinar of Powermax
   • ENROLLEE(S) – The person(s) registered by the REGISTRANT
   • PAID REGISTRANT – The registrant who has paid in full for the registration of the ENROLLEE(S)
   • ATTENDEE(S) – The enrollee(s) who has / have actually attended the webinar

2. The Official Receipts will be made available for pick up at the office of

Powermax Consulting Group. If you need a soft copy, we can take a picture of it and send you a copy online. However, if you want the physical copy delivered to your office, you can arrange with and pay for a local courier service like Lalamove or Grab Express.

3. Sharing of the presentation materials depends on the webinar speaker.

(a) Some speakers willingly share their materials while others don’t.
(b) For the speakers who are willing to share their presentation materials

• Some prefer that the materials be sent in advance while others prefer that they be sent after the webinar
• Some prefer that the handouts to be given to the attendees are different from the PowerPoint files that they use and will not share the PPT files

Powermax cannot guarantee that the presentation materials of each webinar will be shared, or shared in advance, or will be the same as the PPT file of the speaker.

4. Any form of video, image or audio recording during the webinar is not allowed unless with the express permission of the speaker and the management of Powermax Consulting Group.
5. Your registration fee entitles your enrollee(s) to a slot in a webinar you have paid for but no record of the video of the webinar will be given.
6. If an enrollee fails to join the webinar because Powermax fails to give the webinar link, the payment of his / her REGISTRANT will be refunded in full or if the REGISTRANT prefers, the payment will be rolled over to other webinars of his / her choice.
7. If an enrollee advises Powermax five (5) days before the scheduled date of the webinar that he / she cannot attend it, the payment for that slot will be rolled over to another webinar. But if he / she avails of the presentation materials of that webinar (assuming the speaker has shared the materials), the payment cannot be rolled over to another webinar.
8. If an enrollee fails to attend a webinar and also fails to advise Powermax five (5) days before the scheduled date of the webinar, the presentation materials of that webinar (assuming the speaker has shared the materials) will be given to him / her but there will be no option for rollover.
9. If an enrollee fails to attend a webinar because of a technical glitch on his / her device but other enrollees manage to join the said webinar, there will be no liability on the part of Powermax unless it can be established that there is a clear fault by a representative of Powermax.
10. Certificates will be given to the ATTENDEES only.
11. Questions or clarifications about the subject matter of a webinar can only be entertained by the speakers during the holding of the webinar. After the webinar, the speaker cannot be obliged to answer them through email, Facebook chat or some other means.

 

Thank you and enjoy!

Keep safe and God Bless!