Skip to main content

Main Secondary Navigation

  • About Ateneo de Manila
  • Schools
  • Research
  • Global
  • Alumni
  • News
  • Events

Main navigation

  • Learn & Grow
  • Discover & Create
  • Make an Impact
  • Campus & Community
  • Apply
  • Home >
  • News >
  • Ateneo Math holds Excel Workshop, a perspective

Ateneo Math holds Excel Workshop, a perspective

13 Dec 2024 | Mark Clarence G Rodriguez (BS AMF)

Quality Education

As part of the Theory of Interest (MATH 101.6) course of the junior math majors and in preparation for the succeeding financial mathematics courses, the Ateneo Department of Mathematics held its Excel Workshop session entitled “MATH 101.6 Excel Workshop: How to be a Freak in the Sheets” last 19 October 2024. This workshop aims to strengthen the students’ skills in using excel as various computations involving finance-related concepts heavily rely on the use of this software. Whether the math majors wanted to know more about how excel works, to be more prepared for the MATH 101.6 group project, or to simply spend time with their friends, this workshop was surely suited for them.

Excel file with man on the corner
CELLS AND CELLS. Excel workshop for Math 101.6 centered around the use of the spreadsheets for ease of financial calculations.

Prior to the workshop, he provided the working file so that everyone could work along while he teaches. The file included various exercises which were answered during the session. The workshop was conducted via a hybrid setup in order to accommodate the students residing far from the campus, including myself, since it was held on a weekend. Facilitated by Gelo Nery (5 M AMF), the workshop included topics on essential etiquette on using Excel, alongside the necessary formulas and shortcuts in various financial computations. One of my blockmates (3 BS AMF) even expressed how it was pretty interesting for her to learn the industry standard of how to use the software.

Gelo Nery
FACILITATOR. Gelo Nery (5 M AMF) facilitated the entire event.

Some musings about the workshop

Allow me to share three biggest takeaways I received during the workshop. He began by suggesting not to use the upper leftmost cell (A1) and instead make the first column a margin so that the working sheet is neater. As a person who wants a presentable working file, I resonate with him as well. I would usually begin with the second column when creating tables so that all outer borders will be seen. 

The next point he tackled was something I only discovered during the workshop. He also proposed an alternative to merging cells when we want to place a text at the center of certain cells, because all columns will be selected once we highlight from the merged cell. To remedy this, the center across selection is used so that only a particular column is highlighted. As someone who frequently uses the merge function, this is definitely a new insight for me (my blockmates definitely know this as I would send them working files (e.g., sign-up sheets, class compilation of MATH 90.1 (Advanced Calculus) and MATH 62.1 (Introduction to Statistical Theory) solutions using Google Sheets).

The final input from Gelo that I want to highlight is the functions used to determine a certain date or the number of days in between two dates. I found this really helpful especially in our final long test in MATH 101.6 where we had to compute the purchase price of a bond during a date in between payment periods. Instead of going through the nitty-gritty manual counting of days using the number of days per month, the DAYS function of Excel and Google Sheets minimized the burden for us.

What really made the session feel light was the facilitator himself, Gelo, a graduate student who once underwent the journey of an AMF major, which was something that Samantha Say (3 BS AMF), my blockmate, also appreciated about the session. According to her, the session felt casual and it was also interesting how Dr. Jeric Briones, the program adviser of the AMF program, would pitch in from time to time and provide input as well. This was extremely efficient as the workshop was conducted via a hybrid setup, wherein Dr. Briones was the one monitoring the Zoom call if there are questions being asked from the online participants.

Outlook

Overall, I feel that having a crash course on the use of Excel is greatly helpful especially for those who heavily rely on the use of spreadsheets. Jiro Tanyag (3 BS AMF), my blockmate, shared with me how the workshop has provided a good foundation to build upon for further learning of Excel, since a lot of the careers we aim for as math majors demand high proficiency in the said software. Especially for AMF juniors who are about to take a series of courses on financial mathematics, the workshop made us well-equipped with the fundamental skills in Excel. Although the two hours is definitely not enough to cover everything that Excel has to offer due to its numerous functions, the workshop was a good starting point to explore more about Excel which other spreadsheets like Google Sheets do not have.

Computer Science and Mathematics Campus Life School of Science and Engineering
Share:

Recent News

Families of drug war victims, Ateneo community gather for DEKADA solidarity night

10 Nov 2026

Interdiscipline: Global and Area Studies Conversations

10 Nov 2026

A Message to the Ateneo Community

10 Nov 2026

ASOG holds course on communication for development: Policy and advocacy communications for public sector leaders

10 Nov 2026

EAGLE SCOUT | ISSUE NO. 26-20

10 Nov 2026

Libraries are more than just infrastructure: Kritika Kultura hosts lecture by Dr Bono Olgado on rethinking libraries as infrastructure

10 Nov 2026

AGS celebrates Feast of the Holy Guardian Angels with three days of faith, fun, and charity

10 Nov 2026

Enlistment Schedule (Plan A and Contingency Plan B) & Regular Online Enrollment for the Second Semester, SY 2026-2027 for GBSEALD, JGSOM, SOH, SOSE, RGLSOSS

09 Nov 2026

Freedom in faith: Finding sanctuary behind bars of maximum security

09 Nov 2026

Traffic Bulletin: Dismissal Schedule – 9 to 14 November (CSMO Memo)

07 Nov 2026

Pagination

  • First page « First
  • Previous page ‹ Previous
  • …
  • Page 2
  • Page 3
  • Page 4
  • Page 5
  • Page 6
  • Page 7
  • Page 8
  • Page 9
  • Page 10
  • …
  • Next page Next ›
  • Last page Last »

You may also like these articles

ATCM group photo

03 Nov 2026

Ateneo hosts 30th Asian Technology Conference in Mathematics

The Ateneo Department of Mathematics, in partnership with the School of Science and Engineering and the Ateneo Office of the Assistant Vice President for University

Frep Featured Pic

01 Nov 2026

Ateneo grade schoolers experience joy of problem solving in summer math program

Ateneo Grade School (AGS) students from Grades 2 to 5 strengthened their problem-solving and analytical thinking skills during the 2026 Ateneo Summer Math Problem-Solving Program

frep pic 1

01 Nov 2026

A math major’s training: How the Freshman Enhancement Program (FrEP) solidified my math journey

Under the bright fluorescent lights of the SEC A classrooms, math majors were being prepared for their college life. You could see papers filled with

Ateneo Math at MSP

01 Nov 2026

Ateneo Math showcases diverse research at 2026 MSP Annual Convention in Pangasinan

Faculty members, collaborators, alumni, and both graduate and undergraduate students from Ateneo de Manila University presented their latest research at the 2026 Mathematical Society of

ASOG Promotes Cybersecurity Awareness in the Public Sector

27 Oct 2026

ASOG promotes cybersecurity awareness in the public sector

As government services increasingly rely on digital systems, cybersecurity plays a vital role in protecting sensitive information, strengthening public institutions, and safeguarding the people they

Ateneo BUILD and TRL teams with PSA officials at the PSA, 6 October 2026

13 Oct 2026

PSA to run Ateneo-built National ID verification for local governments and NGOs

Built for areas with limited or no connectivity, including geographically isolated and disadvantaged areas. The same software is available to banks and other institutions.

Katipunan Avenue, Loyola Heights, Quezon City 1108, Philippines

info@ateneo.edu

+63 2 8426 6001

Connect With Us
  • Contact Ateneo
  • A to Z Directory
  • Social Media
Information for
  • Current Students
  • Prospective Students
  • International Students
  • Faculty & Staff
  • Alumni
  • Researchers & Visiting Academics
  • Parents
  • Donors & Partners
  • Visitors & Media
  • Careers
Security & Emergency
  • COVID-19
  • Campus Safety
  • Network & Tech
  • Emergency Management
  • Disaster Preparedness
Digital Resources
  • AteneoBlueCloud
  • Archium
  • Rizal Library
  • Ateneo Mail (Staff)
  • Ateneo Student Email
  • Alumni Mail
  • Branding & Trademarks
  • Data Privacy
  • Acceptable Use Policy
  • Report Website Issues
  • Ateneo Network
  • Philippine Jesuits

Copyright © 2022 Ateneo de Manila University. All rights reserved. | info@ateneo.edu | +63 2 8426 6001

Search