Trainings

MS Excel Advanced Skills for Business

16Feb
Trainings

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.

In one day, the participants will be able to appreciate the Excel environment and its tools by learning four modules as stated below; execute advanced functions of Excel; create business systems such as time management; sales tracking and analysis, and more. In addition, participants will be able to learn pivot tables.

Module 1

  • Formulas (Operators, Referencing Types, Defining Names
  • Introduction to Functions
  • Deep Dive on Functions
  • Array Formulas

Module 2

  • 3D Referencing
  • Nesting Functions
  • Nesting Functions Part 2

Module 3

  • Nesting Function Part 3
  • Data Tables
  • Intro to Slicers and Sparklines

Module 4

  • Intro to Pivot Table
  • Pivot Table & Useful properties for creating reports
  • Creating Simple Dashboards (Optimizing Pivot Tables)
ABOUT OUR FACILITATOR
Ralph Mapute
Ralph Mapute
Microsoft Lecturer & Consultant
Whole Brain Training Consultancy Co.

Ralph is a well-respected lecturer and speaker who used to be a web developer and designer. He has been teaching several IT classes in the academe for eight years. In 2013, he began working as a corporate lecturer at one of Metro Manila's top corporate training providers and International schools. Since then, he has given numerous training sessions for various business in Cavite, Laguna, Metro Manila, and other Philippine locations. Presently, he works as a senior corporate instructor for Microsoft Office and other IT-related programs at Whole Brain Training Consultancy Co.

  • Europe-PH News

  • September 17, 2024

    Converge Unlocks Next-Level Hospitality with Converge Concierge with SkyTV

    Converge ICT Solutions Inc., the Philippines’ leading fiber broadb... Read More

  • June 24, 2024

    Turkish Airlines Named Best Airline in Europe at Skytrax Awards for the Ninth Time

    Turkish Airlines, the airline that flies to more countries than an... Read More

  • July 02, 2024

    Eastern Communications' employee-centric culture earns Great Place To Work Certification™

    Manila, Philippines — Eastern Communications... Read More