Office information

Instructions on how to name, note and protect cells in Excel. 1. Name the data cell. - Normally, the data cell with the default name is the combination of the column and row order

The following article will guide you in detail how to handle cells, columns, rows in spreadsheets in Excel. 1. Change the width of columns, rows and cells in Excel. 1.1 Resize a

Instructions on how to format data in Excel 2013. 1. Format text. 1.1 Font format, type, font size: - Select the data to format - Home - Font - quickly select the font, font size,

How to insert a SmartArt object in Excel. Excel has a tool to help you with SmartArt images that allows you to build complex diagrams quickly and easily. To insert SmartArt

Show you how to insert a WordArt object in Excel. WordArt objects are indispensable in Excel sheets. It is a tool to help your spreadsheet more diverse and rich, attracting

Instructions on how to insert image objects in Excel. Insert image objects are available on the computer. For example, to add a photo to a spreadsheet: Step 1: Go to Insert -

Instructions on how to insert Textbox in Excel. To insert Textbox in Excel, follow these steps: Step 1: Click Insert - Text - TextBox: Step 2: Drag and select the area for Textbox

Show you how to insert special characters in spreadsheets in Excel. To insert special characters in Excel, perform the following steps: Step 1: Place the cursor at the position

Instructions on how to insert and edit flowcharts (SmartArt) in Excel. To insert the flowchart you perform the following steps: Step 1: Go to the Insert card - illustration -

Show you how to set print margins in Excel. Setting margins for pages in Excel is an indispensable operation for print jobs after calculations. To set the margins for the printed

Show you how to repeat the title of the spreadsheet when you turn the page in Excel. To repeat the worksheet title when moving to the page, follow these steps: Step 1: Go to Page

Teach you how to create headers and footers in Excel. To create the header, the footer follows these steps: Step 1: Go to Page layout - Page SetUp tab - click on the arrow below:

Guide you to perform printing in Excel. After setting up the page to print the final step, you can manipulate to print the worksheet in Excel. Step 1: After setting up the

Instructions on how to insert and edit charts in Excel. To insert a chart, follow these steps: Step 1: Select the data to create a chart. The example here wants to create a sales

Show you how to create and edit mathematical expressions in Excel. To insert mathematical formulas, you perform the following steps: Step 1: Go to the Insert - Text - Symbols -

Instructions on how to create and edit Textbox in Excel. To insert Textbox you perform the following steps: Step 1: Go to the Insert - Text - Textbox tab: Step 2: Drag and move the

Instructions on how to insert and edit Word Art in Excel. Step 1: Go to the Insert - Text - Word Art tab - select the type of font you want to create Word Art: Step 2: Enter the

Instructions on how to filter data in Excel. 1. Simple data filtering 1 condition. Step 1: Select the data you want to filter - Data - Filter - the data column appears arrow

How to enter formulas in Excel. To enter a formula in Excel, you must start with the equal sign or Excel will interpret it as a string. To enter the formula do the following: Step

Familiarize yourself with PivotTable reports in Excel. What are PivotTable reports? - PivotTable reports are the most useful feature of Excel that helps you to statistic data