Formulas and Functions

A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel. For example, cell A3 below contains a formula which adds the value of cell A2 to the value ...

0
0
ShareMore

Protect Excell Work

Encrypt an Excel file with a password so that it requires a password to open it. 1. Open a workbook. 2. On the green File tab, click Save As. | 3. Click on the Tools button and click General Options. ...

0
0
ShareMore

How to Share Excel Work

Learn how to share Excel data with Word documents and other files. Paste Most of the time, you’ll simply need to paste static Excel data in a Word document. 1. Select the Excel data. 2. Right click, and then click ...

0
1+
ShareMore

Print in Excel

This chapter teaches you how to print a worksheet and how to change some important print settings in Excel. Print a Worksheet To print a worksheet in Excel 2010, execute the following steps. 1. On the File tab, click Print. ...

0
0
ShareMore

Keyboard Shortcuts in Excel

Keyboard shortcuts allow you to do things with your keyboard instead of your mouse to increase your speed. Basic Select cell B2. 1. To select the entire range, press CTRL + a (if you press CTRL + a one more ...

0
0
ShareMore

Templates in Excel

Instead of creating an Excel workbook from scratch, you can create a workbook based on a template. There are many free templates available, waiting to be used. Existing Templates To create a workbook based on an existing template, execute the ...

0
0
ShareMore

Find & Select in Excel

You can use Excel’s Find and Replace feature to quickly find specific text and replace it with other text. You can use Excel’s Go To Special feature to quickly select all cells with formulas, comments, conditional formatting, constants, data validation, ...

0
0
ShareMore

Format Cells in Excel

When we format cells in Excel, we change the appearance of a number without changing the number itself. We can apply a number format (0.8, $0.80, 80%, etc) or other formatting (alignment, font, border, etc). 1. Enter the value 0.8 ...

0
0
ShareMore

Worksheets in Excel

A worksheet is a collection of cells where you keep and manipulate the data. By default, each Excel workbook contains three worksheets. Select a Worksheet When you open Excel, Excel automatically selects Sheet1 for you. The name of the worksheet ...

0
0
ShareMore

Ribbon in Excell

Excel selects the ribbon’s Home tab when you open it. Learn how to minimize and customize the ribbon. Tabs The tabs on the ribbon are: File, Home, Insert, Page layout, Formulas, Data, Review and View. The Home tab contains the ...

0
0
ShareMore