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

microsoft excel

ResolvedVersion 2010

JOSEPH has attended:
Excel Intermediate course

Microsoft excel

need to refresh on Microsoft excel intermediate if possible.Thanks

RE: microsoft excel

Hi Joseph

Do you have a particular area you want to refresh from the Excel Intermediate course?

The modules are

Working with large worksheets
Creating a 3D formula
Linking sheets and workbooks
Conditional formulas (IF)
Conditional Formatting
Creating Tables, filtering and sorting
Creating Subtotals
Formula auditing
Cell protection
Creating templates

The workbook you received gives details about these topics.

Regards
Doug
STL


Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.