Overview of formulas in Excel
Get started on how to create formulas and use built-in functions to perform calculations and solve problems. Create a formula that refers to values in other cells 1. Select a cell.…
10 advanced formatting tricks for Excel users
Most Excel users know how to apply basic numeric and text formats. But users who push beyond the basics will create more readable and effective sheets. In addition, knowing how…
Format Cells
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,…
Worksheets
A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets. Select a Worksheet When you open an Excel workbook, Excel automatically selects…
Create a new workbook
A workbook is a file that contains one or more worksheets to help you organize data. You can create a new workbook from a blank workbook or a template. Create a workbook…
Workbook
In Microsoft Excel, a workbook is a collection of one or more spreadsheets, also called worksheets, in a single file. Below is an example of a spreadsheet called "Sheet1" in an Excel workbook file called…
Print preview
Print preview is a feature that displays on the screen what a hard copy would look like when printed. Using print preview, you can find any errors that may exist or fix the…
Print in black and white
If you have a Word document that contains color text or graphics but you want to print it in black and white or grayscale, you can do so by changing…
Print a document in Word
Preview your document 1. Click File > Print. 2. To preview each page, click the forward and backward arrows at the bottom of the page. If the text is too small to read, use the…
Proofreading Your Document
Besides checking for spelling or grammatical mistakes, Word can also proofread your document to highlight other possible problems, such as misplaced commas or correctly spelled words that may be used…
