advanced excel course london - regional training development

AI Training: For Busy Decision Makers & Professionals Book now

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

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

resolvedResolved · 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.

So is there a way to prompt? Prioritise? Or is a spreadsheet re-design in order?

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")



 

Excel tip:

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


Server loaded in 0.11 secs.