Categories: HR

Excel Tips – Save Time in Formatting Raw Data Using “Table Styles”

I have attached Save Time In Formatting Your Excel Data – Free Illustration PDF on Table Styles.


Save Time in Formatting Raw Data Using “Table Styles”
Step1:
Select your raw data.

Step2:
Go to “Home” tab, under the “Styles” group, choose any style from the “Format As Table”

Excel Tips –  2012

Step3:

Place a check mark under the option “My Table has headers”, click “OK”

Step 4:
Now you would have an extra tab on the ribbon called “Design”
Excel Tips – ReachHarry.Com 2012

Step5:
Go to “Design” tab; activate “Total Row”, now you should have an extra row at the bottom of your table.

Step6:
Go to the last row of any numeric column, click on the drop down, and choose the function which you want to perform on those numbers.

This table styles save a lot of time in formatting our table data and getting calculations in a button.

Source – ReachHarry.Com

Click Here To Download Excel Tips – Table Styles

Hrformats

View Comments

Recent Posts

Letter to Announce an Employee Training Session for skills improvement

Whenever a company announces employee training session for skills development then it is supposed to…

2 months ago

Example Immediate Resignation Letter for Various Reasons

If you are planning to immediately resign from your job but you can have your…

3 months ago

Sample Letter to Accept to Serve in a Honorary Position

If you have been invited to serve in an honorary position at any institution and…

3 months ago

Warning Letter for Policy Violations Template, Example

Violating the policy of the company will not be accepted by any organization and if…

3 months ago

Sample Warning Letter to Restaurant Manager Example

Whether it is poor performance or unprofessional behavior that you have experienced at the restaurant…

3 months ago

Sample Grievance Letter to Supervisor for Retaliation

If there is retaliation that you have observed in a particular team or department then…

3 months ago