Trainings

Advanced MS Excel for Business Reports

17Nov
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.

On this one-day session, the participants will be able to appreciate the Excel environment and its tools; execute advanced functions of Excel; create business systems such time management; sales tracking and analysis and more. In addition, participants will be able to learn pivot table.

Topics Covered:

  • V-Lookup Function
  • X-Lookup Function
  • Logical If
  • Nested Ifs
  • Conditional Formatting
  • Sumif and Sumifs
  • Countif and Countifs
  • Pivoting table & Chart
  • Concatenate Functions
  • Upper, Lower and Proper
  • Left, Right and MID Formulas
ABOUT OUR PARTNER FACILITATOR
Anna Masindo
Anna Masindo
Consultant

Anna is an MOS certified and has an in-depth knowledge and understanding of numerous software packages and operating systems in Computer Software Applications, Accounting Information Systems, Programming Languages and Operating Systems such as Windows, Sun Solaris, Linux Cent OS, MAC/OSX, Android.

  • Europe-PH News

  • July 02, 2024

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

    Manila, Philippines — Eastern Communications... Read More

  • June 28, 2024

    Healthy Employee, Happy Employee: How the Right Workspace Layout Can Lessen Health Risks

    The average office space at its core has not changed much in terms... Read More

  • April 05, 2024

    Unleash Hell in Makati: The Ultimate MMA Festival Showdown at Kombat Sports Kalayaan!

    Get ready to witness the ultimate showdown as Kombat Spo... Read More