Working with Excel for Seniors

Sorted by:  

For Seniors: How to Use Common Excel Functions

Excel has hundreds of functions, but most of them are very specialized. The basic set of Excel functions that the average user works with is much more manageable. [more…]

For Seniors: Get Familiar with Spreadsheet Structure in Microsoft Excel

Microsoft Excel is all about data and spreadsheets. Each cell in a spreadsheet has a unique cell address consisting of its column letter and row number. [more…]

For Seniors: How to Enter Text or Numbers in Microsoft Excel

To enter text and numbers in a cell in a Microsoft Excel worksheet, you simply select the cell and begin typing. Whatever you type appears both in the cell and in the Formula bar. When you finish typing [more…]

For Seniors: How to Format Text in Cells in Microsoft Excel

Text formatting within a cell in Microsoft Excel works very much like it does in Word and PowerPoint. You can change the font, font size, color, attributes [more…]

For Seniors: How to Row Height and Column Width in Microsoft Excel

You can adjust the row and column sizes in a Microsoft Excel spreadsheet to create space between columns or rows of text. That feature is handy because by default, each column and row in an Excel spreadsheet [more…]

For Seniors: How to Apply Gridlines or Borders in Microsoft Excel

You can apply gridlines or borders to your Microsoft Excel worksheets. Gridlines are the faint, gray-blue lines you see onscreen that separate the rows and columns. [more…]

For Seniors: How to Fill Color in Microsoft Excel

Fill color — also called shading — is the color or pattern that fills the background of one or more Excel worksheet cells. Applying shading can help the reader’s eyes follow information across a page and [more…]

For Seniors: How to Use Multiple Excel Worksheets

Each Microsoft Excel workbook contains three worksheets by default: Sheet1, Sheet2, and Sheet3. You may not even notice at first that the workbook contains three sheets, because you see only the spreadsheet [more…]

For Seniors: How to Insert and Delete Rows and Columns in an Excel Worksheet

Even if you’re a careful planner, you’ll likely decide that you want to change your Excel worksheet’s layout. Maybe you want data in a different column in your worksheet [more…]

For Seniors: How to Move and Copy Cell Content in an Excel Worksheet

When you’re creating an Excel spreadsheet (or worksheet), you may place your data in a cell that you decide later that you don’t want it to be in. Fortunately, moving content between cells in an Excel [more…]

For Seniors: How to Understand Excel Functions

Sometimes, writing a formula to perform an Excel calculation is awkward or lengthy. In Excel, a function refers to a certain math calculation. Functions can greatly shortcut the amount of typing you have [more…]

For Seniors: How to Assign a Color to an Excel Sheet Tab

Here’s a formatting trick to keep your Excel workbooks organized. Each Excel worksheet tab can have a different color, or you can color several tabs all the same to indicate that they’re somehow related [more…]

For Seniors: How to Write Excel Formulas

A formula is a math calculation, like 2 + 2 or 3(4 + 1). In Microsoft Excel, formulas are different from regular text in two ways: [more…]

For Seniors: How to Create a Basic Excel Chart

When you have a lot of numeric data on a Microsoft Excel worksheet, using a chart can help make more sense out of the numbers. Excel offers various chart types, each suited for a different type of data [more…]

For Seniors: How to Identify the Parts of an Excel Chart

Every part of the chart has a name, and learning the Microsoft Excel lingo can help you format the specific parts. The following list points out some of the key features of a chart: [more…]

For Seniors: How to Format an Excel Chart

You can format nearly every aspect of a Microsoft Excel chart. You can change the color of every data series, for example, and change the font and size of each text item. You can adjust the rotation of [more…]

For Seniors: How to Move around an Excel Worksheet

You can move around a Microsoft Excel worksheet using the cell cursor (also called the active cell indicator). The cell cursor is the dark outline around the active cell. To change which cell is active [more…]

For Seniors: How to Format an Entire Excel Worksheet

To save time, you can format an entire Excel worksheet (also known as spreadsheet) at once. The Page Layout tab contains various formatting controls that affect the entire worksheet. These controls affect [more…]

Sign Up for RSS Feeds

Computers & Software