Learning Outcomes
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.
Class Schedule
- 4 Sessions with 2 hours each session
- July 3, 17, 24, and 31, 2022
- 10:00 AM - 12:00 PM UAE Time

Course Outline
- Protect Files
- Share a Workbook
- Set Revision Tracking
- Merge Workbooks
- Trace Cells
- Troubleshooting and Formula Errors
- Watch and Evaluate Formula
- Consolidate Data
- Link Cells in Different Workbooks
- Edit Links
- Export Excel Data
- Import Delimited Data File
- Using Sparklines
- Using Data Tables
- Basics of Data Analysis
- Key points to focus on creating dashboards
- Create simple dashboards for management reporting
Registration fee
AED
600
-
Speed up your MS Excel Skills
-
Build meaningful and report-ready Dashboards
-
Value added skills for you
-
Learn advanced formulas
Profile of the speaker

Aimberly De Viana
CPA, CMA, CSCA
-Six years total working experience in providing assurance and non-assurance services such as financial statements audit, data protection requirements audit, bookkeeping, financial advisory services, VAT consultancy to over a hundred companies.
-Subject Matter Expert in Accounting and MS Excel
-Proficient in data analytics using excel and Power BI
-Currently working in Deloitte Touch Tohmatsu Limited – Middle East as an Auditor.
– Co-head of events of Philippine Institute of Certified Public Accountants – Dubai
Testimonials from the students
5/5
It was a great initiative for PBS to conduct such special classes here in the UAE. Specially for Filipino’s or OFW’s like us who can’t have an access for such classes.The team behind this institute are so professional and enthusiastic in helping everyone who are willing to learn more and to guide them for their better future.
Ruby Jane Almiñe-De Silva
A great learning institution and venue of Education where it offers the wonders of Business Education. Sustaining those who are hungry for wisdom and knowledge about business. Philippine Business School is the best place. Thank you so much PBS for being generous not only with the wisdom and knowledge but all the more with quality service you’ve rendered to all students... God bless PBS!
Bry Bryan
I’m constantly amazed with the professionalism and enthusiasm of the whole team especially the staffs behind the show. This institution does not just develop and enhance your skills but doing it with finesse and in a lavish way that every Filipinos can desirably afford. I am willing to be influenced and molded by PBS! Kudos PBS team!!!
MJ Dioquito
Quality trainings and education with in the grasp of OFW's. Keep up the quality and improve more for the development of those who dreams to become more successful.
Mandy Villegas
Highly recommended to all ofws in UAE, my friends and colleagues its very interesting how to build a solid Business! thanks PBS!
Leo Gardon
The knowledge sharing ideas from the professional expertise of PBS Speakers truly gave us more enthusiasm to proceed with the business plan which we formed and proceed on it.. the workshop is truly a worthy time to invest and learn.. my best wishes to the PBS team who aims for a good mission to OFW Filipinos..
Roxane Concepcion
Philippines Business School is compose of extra ordinary people with passion of giving filipino expat here in UAE a great learning plus an opportunity to grow as an excellent individual and create their new future inline with their DNA of being a Thinker. Leader and Communicator. The wisdom that they impart to us students are priceless!
Jonas Pucan
It's been a while since I have worthy sleepless nights. PBS will teach you what "BUSINESS" really means. Other educators and speakers will give you the picture of the rainbow, however PBS will help you reach the pot of gold. And mind you, PBS has no short cuts, instead you will experience detailed and realistic educational approach. And the circle of friends that you will create,,, PRICELESS!
Larry Jotic
PBS is an educational institution that caters our need to eagerly learn more of something that we want to be good at. In this fast changing society,especially here in UAE, I believe we need to always have our edge in terms of education and skills.
Tonette Oilegnave
Do you want to enhance your leadership, communication and analytical skills? The Philippine Business School has thought me additional skills for my career development. My experience was priceless, gained new friends & most of all discovered new things about myself.
Fritz Ballenas Elbina RN
Lyndon Magsino is an inspiration of success and you just want to aspire and be like him, a successful Filipino in the business world. He is dedicated not only to his vision of having Filipinos occupy good and respectable positions in the business world but also he has offered this Vision to God, for His greater Glory. This is an inspiration.
Rico Legaspi
I really enjoyed the Masterclass for many reasons… not least for interacting with professionals from various disciplines in our organization. Mr. Lyndon’s presentation was inspiring, informative and his method of delivery is much appreciated.
Dharmesh Asokan
I pray that God bless you all and you continue to work hard to create THE IMPACT! The content of the training was also too rich & the delivery style of trainers was also very good. Lyndon Magsino's session was full of quality knowledge and Christine's friendly teaching style was soo good!
Syed Ahmed Shah Bukhari
Its nice to be student again. A wonderful exprience refreshing and expanding your knowledge. A very good instructor as well and understandable hand-outs. Will definitely enrol again soon. God bless and more power to you guys. Lets becoming a global business minded people.
Julie Cervantes
It was my pleasure to be part of the Stock Market Masterclass. I can say now that I am enlightened and ready to face the trading world. Special thanks to Sir Lyndon, we’ve learned a lot from him.
Conie Gonzales Tarrobal
Everytime i take a course at PBS, I always have satisfaction and excited to share my learnings and experiences... PBS have great instructors, staffs, venue and amenities. Good job Philippines Business School!
Rhoda Galicia-Alcantara
Previous
Next