Discovery consists of seeing what everyone has seen and thinking what nobody has thought.
Albert Szent-Gyorgyi (1893-unknown)
Monthly Archives: July 2022
General Format
The General format is Excel’s default format.
It doesn’t really do much. It can be handy to use though if Excel applies a format you don’t want, like a date or a percentage.
The keyboard shortcut to apply the General format is
Ctrl + Shift + ~
Be careful if you forget the Shift key as it will display formulas. If that happens, press it again (without the Shift key) and it will revert back to normal.
MIN and MAX and Dates in Excel
Automating the latest date
The MIN and MAX functions can provide easy ways to capture current dates.
The different between ordinary and extraordinary is that little extra.
Anonymous
One Minute to Excel #28 – Eight More Charts in a Minute
Fast mouse work to the rescue
OK in the last video I cheated and used Sparkline charts to create 8 charts in a minute.
This time I set myself a real challenge to create 8 real charts in a minute.
Its close – check out the video and learn a few useful techniques.
Navigation Columns in Excel
Great for long reports
When working in long spreadsheets it can be a good idea to use a navigation column to make it easier to move between the different sections.
It is the supreme art of the teacher to awaken joy in creative expression and knowledge.
Albert Einstein (1879-1855)
One Minute to Excel #27 – Eight Charts in a Minute
Sparklines to the rescue
Let’s see if I can create 8 charts in a minute – one for each state and territory in Australia
I cheat a little bit and use Sparkline charts. If you haven’t seen Sparklines before check out the video.
Switching Between a Line and a Column Chart
Keeping charts simple is a good rule to live by. Two of the simplest charts are a column chart and a line chart. People have their preferences. Here is a short macro that lets you switch between the two chart types.
One Minute to Excel #26 – Fix AutoSum’s Weakness
Get the right range every time
AutoSum’s cryptonite is a blank cell – it stops AutoSum in its tracks every time.
Here’s how you can avoid AutoSum’s blind spot.
Excel Power Pivot Limitations
It is not all bad
Power Pivots and the Data Model take pivot tables to another level or two, but there are a few limitations you need to be aware when you use Excel’s data model to create a pivot table.