When you get stuck with a spreadsheet would you like to be able to email your problem and get advice, help or support from one of our experts?
How much do you think that would cost?
You'll be surprised. Welcome to Excel Advice by Email.
| Subscribe in GB Pounds | Subscribe in US Dollars |
"Excel Advice by Email has always provided me with just the information I need in response to my numerous queries concerning Microsoft Excel. Without fail I receive prompt, knowledgeable and accurate advice which I see as invaluable in my day to day work."
Thomas Bilton, Financial Accountant, Siemsen Group Pty Ltd, NSW, Australia
How does it work?
| - | Subscribe using one of the options above and you will be given the email address to use for your questions |
| - | When you get stuck, or want some advice, simply email your Excel problem to the address provided |
| - | You will receive an email response from one of our experts with our suggestions(s) - Typically this will be same day, often within an hour or two, however as this is advice provided by real human beings, we ask that you allow up to two working days. |
The Small Print
| - | Your subscription does not cover any development work. It is intended to provide advice for you to do the job yourself. Obviously, if you do wish us to build a spreadsheet for you, we can quote for this in the normal way. |
| - | All enquiries must be by email to the address provided, telephone enquiries are not covered. |
| - | The service is intended to provide support to a named individual. All enquiries must come from that named individual. Also, we operate a fair use policy of a maximum of 15 enquiries per calendar month from any individual. |
| - | The service extends to the standard features of Microsoft Excel and excludes help with programming in VBA. |
Example Question and Answer:
Q: "I am trying to create a formula that displays the day of the week relating to a particular date. Can this be done?"
A: "Where A1 contains the date, use
=WEEKDAY(A1,1)
to return the day of the week as a number (where Sunday=1 and Saturday=7). If you want Monday=1, change the second argument to 2, or if you want Monday=0, change the second argument to 3).
If you need to show the day as a word, i.e. Monday, Tuesday, etc. you can simply convert the date to text, using the TEXT function:
=TEXT(A1,"dddd")
This function converts any number into text using the defined number format. The format "dddd" shows just the name of the day included in the date."
| Subscribe in GB Pounds | Subscribe in US Dollars |