Notes![what is notes.io? What is notes.io?](/theme/images/whatisnotesio.png)
![]() ![]() Notes - notes.io |
When I first started using vlookup as a tool for extracting relevant data for comparison during UAT, I was faced with the issue of the formula not working correctly. Because of this, I was astonished as I was quite familiar with the usage of vlookup and had never encountered such a problem before. After consulting my colleague, it turned out that the formula was not working due to many of the results having the same lookup value. Therefore, by creating a unique key to lookup values with multiple criteria, the formula would be able to work correctly.
This was something new to me as in the module of Decision support with spreadsheets (DSS), I only learnt about using one lookup value to match data from another source.
Besides the formulas which I have picked up in school, I have also learnt many new functions such as using a pivot table to categorise data, as well as other unfamiliar formulas.
At the beginning of my internship, i was tasked to add up the subtotals for each component for each portfolio. Therefore, i entered the formula sumif to total up the values if the components were the same. However, my supervisor suggested creating a pivot table as a more efficient way to do it. By selecting all the data and creating a pivot table, columns can be hidden by adjusting the options on the field list. Also, if the absolute sum of values is required, the absolute function would prevent any offset.
In the group project for the module DSS, we were tasked to use functions and formulas which would aid the business in ways such as retaining staff information and reporting future forecasts for the company. However, i never imagined that Excel would be useful in the context of doing such tests as well.
Through this, i have understood that what I learnt in the module DSS were just the basics, as there are many more useful functions which I can pick up. As learning is a never ending process, I will constantly strive to pick up new technical skills to improve myself.
![]() |
Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 12 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team