excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Medium Priority · Version 2007

Hakan has attended:
Excel Introduction course

Excel

Identify common functions

RE: Excel

Hello Hakan

Thank you for your question and welcome to the forum.

The 'common' Excel functions usually refers to the SUM, AVERAGE, MIN, MAX and COUNT functions.

To view a full list of Excel's functions, go to the Insert Function button (to the left of the formula bar), and change the Category dropdown to all.

When you select a particular function from the list, a description of what the function is designed to do will appear at the bottom of the Insert Function dialogue box.

Kind regards
Amanda

Thu 12 Mar 2009: Automatically marked as resolved.


 

Excel tip:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips


Server loaded in 0.09 secs.