This assignment received Distinction for covering 5/A.D1: Evaluated how the features of spreadsheet software contribute to the decision-making process- - Unit 3 Data Modelling Assignment 1 (Task4)
Evaluate how the features of spreadsheet software contribute to the decision-making
process.
Introduction: This following assignment is a report where I will generally evaluate the usage
of crucial functions used in Microsoft Excel, describing the functions used in and why the
user or data analyst uses the function, explaining how to use these functions and affirming
their advantages and disadvantages (2 for each). While stating whether and these functions
would be helpful to the cheese company, how and why these would these tools be
considered.
The functions that are going be mentioned are: VLOOKUP, Data Table, Goal Seek, Data
Validation, Range Name, Macro, Trend Analysis, IF Functions, SUM IF and COUNT IF. These
functions are commonly used and found in Excel along with other tools, and how are they
are going to be useful and if they should be considered by the cheese company.
, Name: ID: Unit 5: Data Modelling
VLOOKUP:
As VLOOKUP stands “Vertical Lookup”. Its role as an implement is looking up a piece of
information in a data or table set and withdrawing some related information or data. It
displays the data from the already existing table that includes the information.
VLOOKUP is used as an important tool in MS Excel in order to search, analyse and find
specific things by row in either a range or a table, for example in this scenario: finding the
employee’s name by their employee ID in the cheese company. Furthermore, VLOOKUP can
easily extract and lookup data rather than an individual having to looking up a piece of
information manually.
One of its benefits is that it deals perfectly with time management and saves it, instead of a
person specifically a data analyst in this scenario having to do it manually especially if the
data in the tables is long and more complex, using VLOOKUP will immediately extract the
data needed in a short time. Another benefit is that it can categorise data in the
correspondent table, this will deal with the spreadsheet especially if it too complex.
Moreover, the data records in the tables and rows will be readable and comprehensible to
lookup for.
However, the drawbacks of using VLOOKUP is that it only looks at the columns to the right
side, this would be a massive limitation if the most major and crucial data and values are
located in the columns at the left side. Another limitation is that VLOOKUP will give incorrect
results if a user inserts any column in the lookup table as the column is hard coded in the
formula, this would a problem if a data is inserted in a blank column.
Overall, I would consider using VLOOKUP as it will save time instead of just looking for a
data over time, this would help especially if there many tables in which the values are
needed to extract. It also will help with more complex matches in the cheese company.
VLOOKUP function has used all the
values from the “ID” and “Company”
columns from the chosen lookup value
which is “HP” in order to look for it.
Alle Vorteile der Zusammenfassungen von Stuvia auf einen Blick:
Garantiert gute Qualität durch Reviews
Stuvia Verkäufer haben mehr als 700.000 Zusammenfassungen beurteilt. Deshalb weißt du dass du das beste Dokument kaufst.
Schnell und einfach kaufen
Man bezahlt schnell und einfach mit iDeal, Kreditkarte oder Stuvia-Kredit für die Zusammenfassungen. Man braucht keine Mitgliedschaft.
Konzentration auf den Kern der Sache
Deine Mitstudenten schreiben die Zusammenfassungen. Deshalb enthalten die Zusammenfassungen immer aktuelle, zuverlässige und up-to-date Informationen. Damit kommst du schnell zum Kern der Sache.
Häufig gestellte Fragen
Was bekomme ich, wenn ich dieses Dokument kaufe?
Du erhältst eine PDF-Datei, die sofort nach dem Kauf verfügbar ist. Das gekaufte Dokument ist jederzeit, überall und unbegrenzt über dein Profil zugänglich.
Zufriedenheitsgarantie: Wie funktioniert das?
Unsere Zufriedenheitsgarantie sorgt dafür, dass du immer eine Lernunterlage findest, die zu dir passt. Du füllst ein Formular aus und unser Kundendienstteam kümmert sich um den Rest.
Wem kaufe ich diese Zusammenfassung ab?
Stuvia ist ein Marktplatz, du kaufst dieses Dokument also nicht von uns, sondern vom Verkäufer lydii. Stuvia erleichtert die Zahlung an den Verkäufer.
Werde ich an ein Abonnement gebunden sein?
Nein, du kaufst diese Zusammenfassung nur für 8,01 €. Du bist nach deinem Kauf an nichts gebunden.
