When using Excel text colors should really be limited to two colors black text is always in style. Using the banding function of alternating colors increases readability. The best way to display titles is by using the merge and center command located in the Excel ribbon. Using the wrap text function allows for a lengthy amount of text to be formatted to the cell to increase readability.
As for dates Excel recognizes them in different styles and has many formats for display.
When displaying numbers excel can format the numbers to have the dollar sign $ up to including decimal points for displaying cents. Excel has several formats for numbers ranging from general, number, currency, accounting, date, time, percentage, fractions, scientific, text, special, even custom if you feel that the aforementioned list does not suit your needs.
Yes, black text is always in style as it shows up well against most colors!
ReplyDeleteSometimes, for emphasis, I change the background or cell fill (in Excel) to black and text to white for emphasis ^_^
Banding rows/alternating colors, merge and center, and wrap text definitely help with readability and the visual beauty of the spreadsheet. Orientation and indentation also help :-)
There are many styling and formatting options in Excel to be creative yet professional. I agree banding alternate colors increases readability, so much easier to follow along especially if there's a lot of data.
ReplyDeleteFormatting anything and everything in Word and Excel has endless possibilities. With Excel, it will be getting put to good use now that I have a lot more knowledge of the functions and formatting options.
ReplyDeleteThanks for sharing. You are definitely ahead of everyone when it comes to exploring excel! Many details of the observation and grasp, you do better than me! I need to learn from you!
ReplyDeleteKevin, nice to meet you! Having you as my classmate in IS101 makes me feel that this class is more tremendous!
The banding function is very neat. I started using it and it has helped me with reading excel worksheets.
ReplyDeleteI haven't started 5.5 yet but this was good to know.
ReplyDeleteCell formatting remembering the many ways that formatting is used on different platforms is very difficult. Different platforms have different formatting and some that are similar. The lesson material is good at showing what to do, but to memorize specific formatting can get confusing.
ReplyDeleteFormatting has many possibilities and you can be as creative as you want.
ReplyDeleteOnce I start creating business brochures, I will definitely need to use formatting to make it make sense.
ReplyDeleteI find it useful to be able to change font text in order to sort by color too! I tend to do this for work spreadsheets.
ReplyDeleteI never knew we could do any of this stuff till this class it was all hit and miss for me. I would sometimes change my writing on my email to script or bold and then change the color to blue. Never knew about being able to wrap text around a picture. I would always use the spacebar. Old school. LOL.
ReplyDeleteWOW nicely done just noticed the certifications.
ReplyDeleteI always Like to use black but then again i never really used Excel until this class.
ReplyDeleteYou gave some useful advice on how to use Excel in a professional manner. The spreadsheet does look more organized with black text, and merging the title columns also gives it a more polished appearance.
ReplyDelete