EXERCISE 06: BUDGET AND SUPPLIES & CUSTOMER INVOICE



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 table format, I actually made a custom template in order to be in line with the general design that I have created.

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