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)
Free Excel Webinar Recording
FREE – Excel Mouse Shortcuts
Following up from my keyboard shortcuts session in February. This month we will look at quick ways to do common tasks with the mouse. Some of the topics and techniques I will cover include:
the various cursor shapes and how to use them correctly
right clicking options you may not know exist
copying anything quickly with the mouse, even sheets
drawing perfect circles and squares
lining up charts and other shapes perfectly
cool techniques with the Fill Handle
something you may never have tried with the right mouse button
using the the Office clipboard
This session will demonstrate lots of techniques using the mouse and also using the mouse with the keyboard. Even if you prefer using the keyboard you might learn a few useful new techniques.
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)
How to Copy a Sheet
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.