Make your Life at work Easier: Speed Up your Ms-Excel, Word, and MS-Access record-keeping and reporting!
For years MS-Office has trained YOU and I to perform redundant and obscure shortcut-key-combinations ?
Finally someone has fought back and deposited 15 years of painfully acquired experience at your finger tips!
Excel Help topics include:
a) Data Cleanup when pasted or inherited from unknown source??
- How to extract hyperlinks from entire sheet or selection?
- How to remove graphics pasted into Excel from outside?
- Can a shortcut key append date and time stamp into a cell?
- How to extract and list hyperlinks hidden by labels?
- How to strip graphics pasted from web pages or Word
- How to convert Windows “smart quotes” and auto-punctuation to normal?
- How to clean up large tables ? (trim and replace multiple spaces, double-byte characters? )
- How to obfuscate – weak password scrambling?
b) so many tabs– How to manage, find, create??
- My spreadsheet has many tabs – some are filtered and don’t show data – how can I un-filter and re-filter them as they were?
- How to give all tabs unique / uniform header / footer
- How to list and select and to go tab
- How to unfilter, restore data filter?
- How to write all tab names to an empty column or row?
- How to Create multiple tabs from a list?
- DEC2bin – convert decimal number to binary
- bin2dec – convert binary number to decimal
- How to hide and recover a password? obfuscate (string) deobfuscate (string)
d) Pretty Presentation & Print – Conditional Format
- How to alternate line background – blue-bar?
- How to autosize height, width, wrap to avoid clipped cells?
- to quickly identify Pass, Fail, Block and out of range data?
- quick find- color highlight differences – compare two large grids
e) SPECIAL TOOLs
- STOP WATCH? (How can) Excel mimic a stop watch and record each event with a keystroke?!
- Automatically List and Graph test progress metrics
- Export into HP ALM Quality Center