𝑳𝒊𝒗𝒊𝒏𝒈 𝒊𝒏 𝒕𝒉𝒆 𝑰𝑻 𝑬𝒓𝒂 - 𝑪𝒂𝒃𝒊𝒍𝒆𝒔

EXERCISE 09: PIVOT TABLE & PIVOT CHART      For this Exercie 09, we will be exploring the functionality of the Pivot Charts in Microsoft Excel. I personaly do not have that much idea and clue on how to use pivots charts from my previous years and I am lucky to have discovered it as it really is an efficient way to get specific data from a general table.      Upon commanding the Pivot Chart, there are four categories/areas to create certain table and filter out graph results. For instance, the Columns basically imply the portions of data that will be distrubuted in columns. As for the Rows, the information will be basically used and distributed by rows. For the Values, this will be numerical datas or will convert informations to numerical datas by the use of counts. When it comes to the Filter, it will be a setup for the whole table wherein the data placed in this area will be the main focus of the Pivot table. MAIN DATA TABLE WHAT IS THE TOTAL AMOUNT SO...

 EXERCISE 08: PAYROLL      For this exercise, the main task is to use various formulas such as: VLOOKUP, IF Conditions, AVERAGE, MAXIMUM, and MINIMUM. Way back when I was on Grade-11, I was introduced to this formulas on Google Sheets and understood the elements needed to avoid errors on the formula. As of today, I recall some few formulas, but it was a relief to actually have my old files to use as reference. I have used the same business set-up with the previous exercise which is the "Haus of Cookies" with a total of 6 employees to run the small business. PAYROLL PAYROLL FORMULAS

 EXERCISE 07 CHART, SORTING FILTER, SUBTOTAL     For this Exercise, we are tasked to apply column formats that would allow to sort each data in a specific order using the drop down menu. I created this Food Service Restaurant type of business to be the base for the data and information that I will be using. These commands are really helpful in easily identifying a certain information  as the filters provide direct results. In creating the graph, I used the idea of Movie Genres as a basis for the data needed in order to complete the graph.  SORTED DATA OF ID TYPE LOWEST TO HIGHEST SORTED DATA OF NAME A TO Z SORTED DATA OF LOAN AMOUNT HIGHEST TO LOWEST FILTERED DATA OF ITEM DESCRIPTION  A TO Z FILTERED DATA OF ITEM TYPE  A TO Z SORTED DATA OF DEADLINE TYPE NEWEST TO OLDEST SUBTOTAL DATA OF LOAN AMOUNTS CUSTOM GRAPH BASED ON MOVIE GENRE

EXERCISE 06: BUDGET AND SUPPLY  & CUSTOMER INVOICE      In this activity, we are tasked to use the full potential of Microsoft Excel by using commands and various formulas that would be really useful and efficient for common job taskings. I have decided to have this Cookie Business as a basis for the computations and data for the formulas to function.  BUDGET AND SUPPLY      For the Budget and Supply, I researched on the main ingredients and packaging tools used to run a Cookie Business. I included specified measurements to be more accurate. The photo below displays the formulas that I have used. It can be seen that I used a conditional formatting for the Peso Sign in order to not encode manually. CUSTOMER INVOICE      When it comes to the Customer Invoice, it is actually just the similar process. I made  sure that I encoded the right cell numbers for the formula to avoid confusing and misleading results. With the whole tab...