How to create pivot table in Excel 2013

When you process your data in Excel 2013, you can use pivot table feature to analyze your data. So you can review your data easily. Such as, you can analyze sold item in your shop. How to insert pivot table is easy. Check the steps below!

How to create pivot table in Excel 2013

1. Select all data

2. Click “INSERT”
3. Click “Pivot Table”

4. Check that you have select correct tables or ranges and choose where you want to place the pivot table.

5. Click “OK” and the pivot table will place in new worksheet.
6. Drag the dragging fields to values, rows or column areas.

7. And done. 

Read More »

How to create collapsible rows in Excel 2013

When you process data in Excel 2013, you can collapse/group the rows or column easily. By using group and ungroup, you can hide or unhide the rows or columns. Check it below!

How to create collapsible rows in Excel 2013

1. Select rows that you want to collapsible

2. Click “DATA”
3. Click “Group”, and next click “Group”

4. Click “negative” button to hide the rows

5. And click “positive” button to unhide the rows

Read More »

How to create pie chart in excel 2013

In excel 2013, you can create pie chart easily. You can explode the pie chart, format the data point (data series) etc. Check the details below!

How to create pie chart in excel 2013

1. Select all data in table

2. Click “Insert”

3. Click “pie chart” button and then select a pie chart form. Such as 3-D Pie.

How to explode the pie chart

1. Click on chart area
2. Right-click

3. Click “Format chat area…”
4. Click the arrowhead and then click “Series….”

5. Up the pie explosion number

How to change the color of chart data series

1. Click on chart area
2. Right-click
3. Click “Format chat area…”
4. Click the arrowhead and then click “Series….”
5. click on paint button and you can select a color that you want or you can select “Vary colors by slice”

Read More »

How to create a histogram in excel 2013

There is people got difficult to create a histogram in excel 2013. Actually, how to create a histogram is easily. You just have to create a 2-D Clustered Column and decrease the gap width to zero percent. Check the details below!

How to create a histogram in excel 2013

1. Select all table

2. Click “Insert”

3. Click “Insert column chart” and select 2-D Clustered Column.

4. Click on chart area and then right-click.

5. Click “Format Chart Area…”
6. Click “Arrowhead” and select “Series …..”

7. Decrease the gap width until 0%

How to change the data series color of histogram

1. Click on data series
2. Click “FORMAT”

3. Click “Shape fill”
4. And you can select the color
5. Or you can right click on chart area and then click “Format Chart Area…”. And select “data series option”. Next you can change the color fill and border.

On “FORMAT” ribbon, you can change shape style, word art style, arrange or size of your histogram easily.

Read More »

How to create a 3-D chart in Excel 2013

In word 2013 everyone can create a 2-D chart or 3-D chart easily. For example you can create 3-D Line, 3-D Column, 3-D bar, 3-D Area, or 3-D Pie chart etc.  And also you set up and customize of the chart form easily. Check the sample below!

How to create a 3-D chart in excel 2013

1. Select your data

2. Click “INSERT”

3. Click “Insert column chart” and select “3-D Column”

4. Click on “Data Series” and then right-click your mouse.

5. Click “Format Data Series…”, and then;
• You can customize the series option. Such as increase or decrease the gap etc.

• You can change the fill and border color

• You customize the shadow, glow, soft edges, or 3-D Format of your chart

6. You can click “Arrowhead” and select “Plot Area” to customize the plot area of chart. 

7. Such as you can set up the 3-D Rotation, set up the 3-D format etc.

Read More »

How to hide and show the ribbon in Excel 2013

 

In excel 2013, you can hide or show the ribbon easily. Do you have trouble to do it? Check how to hide or show on the direction below!

How to hide and show the ribbon in Excel 2013

1. Direct your cursor to command tab. Such as HOME, INSERT, PAGE LAYOUT, FORMULA etc.
2. Right-click your mouse
3. Check or click “Collapse the Ribbon” to hide the ribbon

4. Uncheck or click “Collapse the Ribbon” to show the ribbon

5. Done.

Read More »

How to create calendar in Excel 2013

You can create a calendar in excel 2013 easily. You can select 12-month, monthly, weekly or daily calendar. There are many calendar template available. And you can customize the calendar as you need. You can check how to create it below! But, make sure that your computer was connected to internet.

How to create calendar in Excel 2013

1. Click “FILE”
2. Click “New”

3. Type “Calendars” on search box and then click enter.

4. Select the category. 

5. Select and click the calendar template

6. Click “Create”

7. Select the year and you can edit the calendar manually. Such as you can change the color etc.

Read More »

How to remove duplicates data in Excel 2013

In Excel 2013, you can remove data by using “Remove Duplicates” easily. You can select and unselect the data that you want. And you will how many duplicate data that exist, how many duplicate data that has been removed and how many unique data. Check the details below!

How to remove duplicates data in Excel 2013

1. Select your data
2. Click “DATA”
3. Click “Remove Duplicates”

4. You can select and Unselect data on the tab and then click “OK”

5. And the duplicate data will show up and then click “OK”. 

Read More »

How to insert object in Excel 2013

In Excel 2013, you can insert an object easily. Such as Adobe Acrobat, Microsoft Equation, Microsoft Graph Chart, Microsoft PowerPoint etc. but there is people cannot insert object. The reason is they do not know where the insert object button. Do you have the same experience? Check the details below!

How to insert object in Excel 2013

1. Click “INSERT”

2. Click “Insert Object” button

3. Select the object type

4. Click “OK”
5. And you can customize the object.

Read More »