98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum 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
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.
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?
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 information:
See also:
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Change the Default Width of All Columns in Excel 2010If you want to change the width of the columns in your Excel 2010 spreadsheet, making them either larger or smaller, here's how: |