Archive July 2019

How to Show Fewer Decimal Places in Excel

Calculation

Learn how to show fewer decimal places in Excel without changing the number itself. You can also round a number. Steps: 1. Enter the value 2.175 into cell A1. 2. On the Home tab, in the Number group, click the Decrease Decimal button twice. 3. Result Note: if you look at the formula bar, you

Read More

How to Create External Reference in Excel

External References in Excel

An external reference in Excel is a reference to a cell or range of cells in another workbook. To create an external reference, execute the following steps. 1. Open all workbooks. 2. In the Company workbook, select cell B2 and type the equal sign = 3. On the View tab, in the Window group, click

Read More

How to Sort on Multiple Columns in Excel

Sort On Multiple Columns in Excel

To sort on multiple columns, execute the following steps. 1. On the Data tab, in the Sort & Filter group, click Sort. The Sort dialog box appears. 2. Select Last Name from the ‘Sort by’ drop-down list. 3. Click on Add Level. 4. Select Sales from the ‘Then by’ drop-down list. 5. Click OK. Result.

Read More

How to Concatenate Strings in Excel

Concatenation

To concatenate (join) strings in Excel, use the & operator, the CONCATENATE function, the CONCAT function or the TEXTJOIN function. Today we will talk about Concatenate function in Excel. Steps: 1. The CONCATENATE function below concatenates the string in cell A2 and the string in cell B2. 2. The CONCATENATE function below concatenates the string

Read More

How to replace background picture in PPT

word image 874 - How to replace background picture in PPT

This article introduces how to replace background picture in PPT. Steps: 1.open the document and choose format background 2.then we can see the information 3.we can choose pattern fill 4.we can choose the picture from computer 5.then choose the picture 6.you can apply all