Excel has three functions that handle case. LOWER, UPPER and PROPER.
See image below for the results of using these functions. Cell A2 contains an entry.
Cell B2 has =LOWER(A2)
Cell C2 has =UPPER(A2)
Cell D2 has =PROPER(A2)
Note: The PROPER function capitalises the first letter of every word in the cell – see below.
Simplicity is the ultimate sophistication.
Leonardo da Vinci
Blanks in Excel can cause a lot of issues, but there is one instance where you can skip them and speed up copying and pasting.
What you do makes a difference, and you have to decide what kind of difference you want to make.
Jane Goodall
To check if two cells are the same you can use
=A1=B1
This returns TRUE if the values are the same or the text is the same ignoring case sensitivity.
In the above formula TEST will equal test.
To check if entries are identical, taking into account upper and lower case, then you can use
=EXACT(A1,B1)
In this case comparing TEST and test will return FALSE.
Excel has great charts to help you visual your numbers, but it can also allow you to use flowcharts to help visualise numbers in a different way and help explain relationships between numbers and how they are formulated.
When I examine myself and my methods of thought, I come to the conclusion that the gift of fantasy has meant more to me than my talent for absorbing positive knowledge.
Albert Einstein (1879-1955)
Achievement is largely the product of steadily raising one’s level of aspiration and expectation.
Jack Nicklaus (1940-)
When formatting a Pivot Table is best to right click the values section of the report and choose Number Format.
This will format the whole report, not just the selected range. Avoid using the Format Cells option as it only applies to the range selected.
When you use date grouping (by months) in one Pivot Table report it affects other Pivot Table’s date reporting from the same data. There is a work around to allow you to have daily, monthly and quarterly Pivot Table reports.
Well-timed silence hath more eloquence than speech.
Martin Farquhar Tupper (1810-1889)
Don’t be afraid to take a big step if one is required. You can’t cross a chasm in two small jumps.
David Lloyd George (1863-1945)
I am only one; but still I am one. I cannot do everything, but still I can do something; I will not refuse to do the something I can do.
Helen Keller (1880-1968)
It’s kind of fun to do the impossible.
Walt Disney (1901-1966)
The easiest way to copy a sheet is to click and hold on the sheet tab name and then press and hold the Ctrl key down and move the mouse to where you want to paste the new sheet and release the mouse.
When you press Ctrl a small plus sign will display in the document icon to show it is copying, not moving the sheet.
To get your ideas across use small words, big ideas, and short sentences.
John Henry Patterson
Excel’s Filtering feature (formally called AutoFilter) is quick and easy to use, but it doesn’t always provide enough solutions to your filtering needs.