98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formats
Formats
Resolved · High Priority · Version 2007
Wed 18 Mar 2009, 16:35Delegate Lisa said...
Lisa has attended:
Excel Introduction course
Excel Intermediate course
Formats
How can I find formatting sections?
Fri 20 Mar 2009, 10:17Trainer Stephen said...
RE: Formats
Hi Lisa
Thank you for your question.
Could you clarify your requirements for me please. In particular.
1. Do you want to alter the formats for specified ranges?
2. Do you want to find cells with specified formats
3. Do you want the formats in a cell to change depending on its value?
Regards
Stephen
Wed 15 Apr 2009, 11:58Delegate Lisa said...
RE: Formats
1. Do you want to alter the formats for specified ranges?
I need to understand them first.
2. Do you want to find cells with specified formats
Yes I tink thats the term, I want to understand what I do to find formats and how I find the glossary and language of the formatting.
I have just implemented an excel sheet at work for my stamps, we dont have a budget but I have a few columns and rows incorporating amt of stamps, total they cost, along with who spends what amt per day (if any) on stamps, and I would like to monitor and combine the value of the stamps to go down with the total, therefore I can see how much I have in stamps and cash.
3. Do you want the formats in a cell to change depending on its value?
I need to understand them first. How do i find out what they mean?
Wed 15 Apr 2009, 11:45Trainer Rajeev said...
RE: Formats
Dear Lisa
Thank you for attending Excel courses!! I hope you enjoyed the courses and benefited from them.
Further to my colleagues request would you please elaborate your query? Do you want to use the Format as Table feature that allows you to manipulate data easily and efficiently?
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT
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:Creating custom listsIn Excel if you type in January in a cell, you can then copy this cell to replicate Febraury, MArch, April etc. |
