7 Functions of Excel (Sum,average,if condition,vlookup,count,max,min,count)

this is my payroll for my JINHIT company 

Payroll 

Payroll Formula

Google Drive Link 

https://drive.google.com/drive/u/0/folders/1AbEjik38wQIBx9VquObfW3ZIzxK9lFXH

Introduction to Excel Computing Budget , Supplies and Customer Invoice

 first of all, what we need to do is to open excel.

after that click the blank worksheet. to create a budget and supply you need to create a company logo. 

so here is one of the tricks I know and I wanted to share to remove the lines or color of  the box just select the certain  cells that you wanted to color

I have highlighted it and now I'll be clicking Alt+H

you will see different letters so if I want to change the color I chose the h so. Enter Alt+H+H

I wanted to color my table so I did this.

as you can see I have adjusted the column and rows so that my text and company logo will not move.

and then for me to enter all the expenses for my company I have inserted a table.

first, highlight the specified cells for your preferred table.

 

and click the table then okay.

after that label your columns row 

so you have to change the unit to peso 

after this, you have to find the product for the quantities and per price

and then you enter the total of everything. this would be the formula for my table 

So for the customer invoice, I created another sheet 

so I just did the same thing as the first sheet which is the budget and supplies 

1. label them
2. Input all the number 
3. Compute it. so under this text is the formula.

and the final input for my activity for today is this.

it was a bit hard but I enjoy making my own company 

btw if you wanted to know the file for my activity 

https://drive.google.com/drive/folders/1AbEjik38wQIBx9VquObfW3ZIzxK9lFXH