logical functions and lookup

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Logical Functions and Lookup Functions

Logical Functions and Lookup Functions

resolvedResolved · Medium Priority · Version 2007

Logical Functions and Lookup Functions

Is there anywhere where I can find activities to be able practice these functions and consolidate what I have learned on the course.

RE: Logical Functions and Lookup Functions

Hi Susan

There are a couple of things I could suggest:

1. If you look up a particular function in Excel Help (e.g. IF function) and then find the associated topic, quite often there will be examples that you can copy and paste into an Excel spreadsheet - the Help box does then give you instructions on what to do with the data. Generally the examples are quite short ones and can be useful.

2. The following page is quite useful for being able to look up all sorts of Excel topics and gives examples with accompanying screenshots (i.e. pictures of the Excel screen):
http://www.contextures.com/tiptech.html

I hope this helps.
Amanda

Thu 18 Dec 2008: Automatically marked as resolved.


 

Excel tip:

Return to the active cell after scrolling

When I scroll a long way down the screen from a selected cell, I can return to that cell with the Ctrl+Back Space shortcut. The active cell now appears in roughly the middle of the screen.

Shift+Back Space does something similar. Scroll down from the active cell and Shift+Back Space returns me to it and puts the active cell at the top of the screen; scroll up from the active cell and Shift+Back Space returns me to it and puts the active cell at the bottom of the screen.

Note also, that while Ctrl+Back Space will return me back to a selected range, Shift+Back Space only ever returns me to the active cell, which is normally at the top left-hand corner of any selected range.

View all Excel hints and tips


Server loaded in 0.09 secs.