EXERCISE 09: PIVOT TABLE & PIVOT CHART


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 SOLD IN EACH REGION?


SALESPERSON & ORDER AMOUNT ROWS


REGION & SALESPERSON AND MONTH & ORDER AMOUNT
CURRENCY FORMAT

SALES PERSON & ORDER AMOUNT


REGION, SALESPERSON, & ORDER AMOUNT


SALESPERSON, MONTH, & ORDER AMOUNT








 

Comments

Post a Comment

Popular posts from this blog

EXERCISE 11: HYPERLINKS AND ACTION BUTTONS

Image
 EXERCISE 11: HYPERLINKS AND ACTION BUTTONS       For the Final Exercise in this Fisrt Semester, I want to apply my ample learnings from the prelim, midterm, and the final term. With my running theme being this retro and vintage appearance, it was really fun to play around the elements such as cutouts and textured shapes that would just simply go well with each other. For some parts of the slides, I used glitch or static moving backgrounds to add more depth to the appearance of the presentation. As per the fonts that I used, I have discovered this futuristic set of font family that would go well when organized and used in the right way.      From the previous lessons, I learned about various transition and effects to improve the interactiveness of the presentation. But I carefully used each animations to not make it too exhausting and messy to the viewers.      For the Hyperlinks and Action Buttons, I used a button that looks like o...
Read more

EXERCISE 03: SMART ART GRAPHICS

Image
_______________________________________________________________________________ INFOGRAPHIC DESIGN       This exercise in general challenged me to understand the use of Smart Art Templates provided by Microsoft Office. At first there were certain parts that took me time to understand such as the adding of columns for this Infographic. To unify my creative thought for this Infographic, I created digital artworks that would accompany the whole design.  _______________________________________________________________________________ HIERCHY CHART      On creating this Heirchy Chart, I have formulated an idea of a small cafe business compossed of 6 employees an 1 head manager/owner. The taskings are divided in 3 which are the Financial Department, Service Department, and Production Stocks Department. The Assistant Manager is incharge of daily supervision of how the employees work and the customer service. With the Head Barista, the taskings can be distrubut...
Read more

EXERCISE 10: ANIMATED AND AUTOMATIC POWERPOINT INSPIRATIONAL PRESENTATION

Image
 EXERCISE 09: ANIMATED AND AUTOMATIC POWERPOINT INSPIRATIONAL PRESENTATION      For this activity combined with the application of the principles of design, I have managed to create this presentation that centers on the topic of how relevant Multimedia Arts is in the modern world that we are currently in. As time progress in the development of our country and the world, Multimedia Arts holds the capacity to elevate and become sophisticated through adaptation in this modernity.      These are a couple of word edits and a little minimalistic art piece that I have created and used for the presentation. With the use of textures and the lines used for the buildings adds a subtle relaxing city view and as if the whole piece is in motion. Upon adding textured background, it sets the line art apart from the whole horizon of the clear sky. With the word art, it came along with the same princple of making it appear in motion. The word is repeated in a way that i...
Read more