Archive August 2019

How to Print a Selection in Excel

Set Print Area

In our example, we’ll print the records for the top 40 salespeople on the Central worksheet. Steps: 1. Select the cells you want to print. 2. Navigate to the Print pane. Select Print Selection from the Print Range drop-down menu. 3. A preview of your selection will appear in the Preview pane. 4. Click the

Read More

How to draw an arrow symbol in excel

C:\Users\Administrator\Desktop\0827\-- (4)\Q_`ZNPVCX]3F[6V1EWOF)XQ.png

  How to draw an arrow symbol in excel Steps: 1. Click on the “Insert” tab. 2. Click on the “Shape” button. 3. There are a variety of arrow shapes to choose from in the pop-up menu. 4. Mouse click on the shape of the arrow you want to draw. 5. After clicking, the mouse

Read More

How to draw and dimension in Excel software

C:\Users\Administrator\Desktop\0827\-- (3)\I0E2NSQO03NPK9WQ}SUYEJH.png

  How to draw and dimension in Excel software Steps: 1. First draw a graphic, taking a rectangle as an example. After opening the Excel software, click Insert – Shape – Select Rectangle. 2. After selecting a point in the table position, hold down the mouse and move the mouse to another position. You will

Read More

How to type hollow text in word

C:\Users\Administrator\Desktop\0829\- (11)\~GMAE~WCK0W@]WPRQ06[)NR.png

  How to type hollow text in word Steps: 1. First type the text content to be set to hollow in the word. 2. Select the text you want to set as hollow. 3. Open the word [Home] tab. 4. Click the text effect button shown in the Start tab. 5. Click on the style

Read More

How to Add Columns to PivotTable

finished pivottable

So far, our PivotTable has only shown one column of data at a time. In order to show multiple columns, you’ll need to add a field to the Columns area. Steps: 1. Drag a field from the Field List into the Columns area. In our example, we’ll use the Month field. 2. The PivotTable will

Read More

How to Calculate Binomial Distribution in Excel

word image 168 - How to Calculate Binomial Distribution in Excel

Excel has got many features connected with statistics. For examples Excel could help you to calculate binomial distribution. Let’s teach yourself how to do it in this easy steps. Steps: 1. Enter data in Excel sheet and form three columns, one indicating no. of successes, probability of success and trials. 2. It is calculated by

Read More