advanced excel course london - regional training development

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

• Home
• Courses
• Promotions
• Schedule
• Formats
• Our Clients

Forum home » Delegate support and help forum » » advanced excel course london - Regional Training & Development Adminstrator | Excel forum

# advanced excel course london - Regional Training & Development Adminstrator | Excel forum

Resolved · Low Priority · Version Standard

### Regional Training & Development Adminstrator

I am currently working on developing our Excel spreadsheets so that we do not miss any training course deadlines. I am looking to design the 'best fit' spreadsheet. We can have over 150+ courses a year to co-ordinate from our spreadsheets with 4+ deadlines per course.

Is there a way of logging on to a spreadsheet and having prompts which immediately display the nearest deadlines.

Or a way you would recommend setting up a spreadsheet to best get this information eg> Course 1 Deadline 1/2/3/4 Course 2 Deadline 1/2/3/4.

Now Course 1 Deadline 1 will occur first, then Course 2 Deadline 1. However, in a spreadsheet with approx 10 - 15 courses per month, you just end up with a load of deadlines that you switch between. Moving back and forth between deadlines for different courses.

### RE: Regional Training & Development Adminstrator

have you tried using IF statements

### RE: Regional Training & Development Adminstrator

No, how do I do that?

Edited on Fri 24 Nov 2006, 12:56

### RE: Regional Training & Development Adminstrator

We cover this on our Excel Advanced course. To get a good overview of the way IF Statements work, look in the Help section of Excel.

Essentially an IF statement evaluates the contents of a cell, and returns a value based on your input into the statement.

EG:

Basic syntax:
=IF (evaluation criteria, true_statement, false_statement)

So if you wanted to know if the value in a cell (B7) is greater than 300 (criteria), then you could use the following formula.

=IF (B7>300, "yes, greater than 300", "NO, less than 300")

Training courses

Training information:

 Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions What does 'Resolved' mean? Any suggestions, questions or comments? Please post in the Improve the forum thread.

### Change the Default Width of All Columns in Excel 2010

If you want to change the width of the columns in your Excel 2010 spreadsheet, making them either larger or smaller, here's how:

In the Cells group on the Home tab, click Format.

Hover over the section called Cell Size and a drop down list will appear, select Default Width from this list.

In the Standard Width dialog box, enter the size you want to set as the default width and click OK.

View all Excel hints and tips