Advanced MS Excel by GCSS, Inc. - SpeedyCourse Philippines
We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Details

Visit our website for the full course outline. 

Link: https://gcssinc.com/advanced-ms-excel-training-workshop/

Outline

The following are the subjects to be taken up during the workshop proper

Day 1

  • Using Excel’s built-in Format as Table (FAT) feature
  • Automated formula name replication across all worksheets
  • Simplified Cell referencing using static and dynamic named ranges (like bookmark recall style)
  • Applying named cell ranges for more easily understandable and traceable “English-style formulas”
  • Using built-in business cycles for appends, edits and report updates
  • Simplifying Report generation
  • Using Excel powerful lookup features such as Xlookup, Xmatch, Filter, Vlookup, Lookup
  • Geo-Mapping Features

Day 2:

  • Other powerful charts (Waterfall, Histograms, and many more powerful data visualizations)
  • Stocks and Map Data LIVE Data
  • AI-assisted features
  • Natural Query Language with Visual Results
  • Creating dynamic dashboards
  • Updating and refreshing dynamic dashboards
  • Appending data to formatted tables
Reviews
Be the first to write a review about this course.
Write a Review
ABOUT GCSS Inc.

GCSS Inc. was formed to build the sustainability capabilities of the corporations in Philippines. With the strong experience of implementing process, strategies, disclosures on sustainability; we firmly believe in effective integration and alignment of Sustainability principles in practice to operational process to achieve the desired result.

Sustainability does not only focus on environmental, social and economic performance but operational efficiency is also very critical. Our aim at GCSS is to ensure organizations become more sustainable in all aspects of operations.
GCSS, Inc.
Unit 3A, 329 CSV Properties, , Mandaluyong City, Metro Manila, Philippines
+63 9171395416
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.