Untitled

[jawadahmad457]

Make Pro Excel Presentation in one click (Pivot Table)

Did you check the new update of Microsoft Office of ‘’Pivot Table’’

It’s amazing, now you can select the data and calculate from many different angles

and the best thing is you can change the filter from Chart too

Let me show you

1- Make a table just like this

2- Click anywhere in the table > Insert > Pivot Table (Upper Right Corner) > Choose the location if you select ‘’Existing Worksheet’’ just by clicking > Ok

3- Select the Data you want to add and calculate in the chart and table > Enter

Note: You can edit it any time from ‘’Field List’’ Note: You can Edit the type of calculation from ‘’Values’’

4- Select you Chart

From these filters, you can change anything.

You can change style and colors from here.

[jawadahmad457]

ALL IN ONE EXCEL SHEET (Data Entry Form)

Are you also getting confused because you made a lot of excel sheets for different types of invoices and bills? It has been more than two months since I started working in accounts and supply control. I got a bunch of responsibilities but making different sheets for all suppliers, petty cash bills sheet, company expense sheets, marketing expense sheets, project breakdown sheets,

it just make me confuse in front of Boss because I had opened a lot of excel sheets. I was finding a way to make one sheet for all of them so I made a data entry form which is very simple.

1 — Make a table with all possible kinds of data names. For Example Bills of office expenses have a payment mode (cash or bank transfer) but not address and supplier bills have an address but not payment mode so I put both in the table.

Select all of them and make table from Insert.

2- Find the option ‘’Form ‘’

Note — If you can’t find it then go to ‘’ File>Options>Customize Ribbon>Choose Commands>All commands>Form‘’

Make a new tab and add it in it.

3- Click anywhere in the table and click ‘’Form‘’

Now you can add all kind of bills in one sheet and differentiate them by filter.

For Example:

For ‘’ Supplier Invoice sheet ‘’ I filter the ‘’ Type ‘’  For ‘’ Project Break down I ‘’ Sort ‘’ Address and Quote For ‘’ Company Expense i Filter Type.