Cart

No products in the cart.

070322 Masterclass in MS Excel: Data Analytics and Management Reporting Using Graphs & Dashboards


Masterclass in MS Excel: Data Analytics and Management Reporting Using Graphs & Dashboards
Microsoft Excel Mastering the fundamentals is an intensive workshop of the Philippine Business School, aimed at supporting the enhancement of skills of professionals on Excel Spreadsheet, being one of the most commonly used application in the business. The approach of Philippine Business School on the workshop course gets you up to speed with the fundamentals on Excel, including the mastery of the key shortcuts without the dependency with your mouse.
Register Here

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
Register Here

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

Follow us on social media

Facebook Twitter Youtube Linkedin Instagram

For inquiries:

email: admission@phbusinessschool.com
whatsapp numbers:
+971 56 888 1477
+971 54 766 2888

Quick Links

Courses

PBS Links

Contact

Office 173, Sky Tower, Financial Center, Sheikh Zayed Road, Dubai UAE

©2018- 2025 Philippine Business School, All Rights Reserved.

Linkedin Facebook Youtube

Report

Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts
  • Invite this member to groups
  • Message this member
  • Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this