TTS Turbo Macros & Shortcut Keys Installation and User’s Guide
Preparing Financial Professionals for Success © 1999-2011 Training The Street, Inc. All rights reserved.
TTS_Turbo_Macros_v11.0.0.ppt 2/14/11
© 1999-2011 Training The Street, Inc. All rights reserved. Training The Street, Inc. (“TTS”) owns all rights, including copyright, in this publication This publication may not be reproduced or redistributed publication. redistributed, in whole or in part, in any format or by any means without TTS’s prior written consent. No TTS seminar, workshop, or other instructional activity may be recorded or transmitted in any format or by any means without TTS’s prior written consent.
Preparing Financial Professionals for Success www.trainingthestreet.com
TTS Turbo Macros Overview For Excel 2003, 2007 & 2010 Want to be on our macros update list? Email us at
[email protected]
TTS Turbo Macros* Overview
Turbo TTS ribbon as seen in Excel 2007 Turbo TTS menu as seen in Excel 2003
•
Useful Excel tools to improve efficiency – Formatting F tti • • • • • • • •
• •
Font Color toggle Pattern toggle Border toggle Number toggle Alignment toggle Increase decimals Decrease decimals AutoColor
– Functionality F ti lit • • • • •
Increase zoom Decrease zoom Trace precedents Disable F1 key Worksheet Control
Ability y to customize! Excel Add-In (.xla) – Allows portability
* Note: As with most Excel macros, macros you lose the functionality of Edit Undo (Ctrl + Z) after executing a macro. macro WHEN AUTOCOLOR IS ENABLED, MACROS ARE CONTINUALLY BEING EXECUTED AND YOU THEREFORE LOSE THE ABILITY TO UNDO. © 1999-2011 Training The Street, Inc. All rights reserved.
4
Adding g TTS Turbo Macros 1) Go to Windows Explorer and copy both the .ttsm and .xla TTS Turbo Macro files
2) Alt+Tab back to Excel 3) Go to… • 2003: 2003 T Tools, l Add-Ins Add I (Alt T, T I)1 • 2007: Office button, Excel Options, Add-ins, Go (Alt F I A A, Alt+G)2 • 2010: File tab, Options, Add-ins, Go (Alt F T A A, Alt+G)2 4) Click Cli k on “Browse” “B ” •
1Excel
2003
2Excel
2007 & 2010
DO NOT change your default location Microsoft\AddIns folder
5) Paste both TTS Turbo Macro files • •
Only the xla file will appear Th .ttsm The tt fil is file i th there but b t hidden hidd
6) Double-click on the TTS Turbo Macro file •
The TTS Turbo Macro should now appear as an available add-in
Note: The macros should automatically load when Excel is opened. May have to deselect, click OK & reselect if not working
© 1999-2011 Training The Street, Inc. All rights reserved.
5
Customizing TTS Turbo Macros and the F1 Key •
Access by Ctrl+Shift+1 – Disables F1 key to prevent Microsoft Help from opening – Permanent… will remember last setting! TTS Menu bar / Ribbon will show status of either “Enabled” or “Disabled”
•
Access option p tabs Ctrl + Shift + S – – – – – –
Shortcut Keys (assign shortcuts) Number Format (choose number format) Font Color (choose font colors) Pattern Toggle Colors(choose fill colors) AutoColor (choose font colors) Other Options (zoom increment, color l palate) l )
* When settings are changed changed, you may notice Excel saving to the XLA file file. This may take a few seconds as the toolkit is storing your settings. After this pause, Excel should work regularly. © 1999-2011 Training The Street, Inc. All rights reserved.
6
New e Features eatu es for o TTS S Turbo u bo Macros ac os 5 5.0 0 •
Worksheet Control Ctrl+Shift+Z – – – –
•
Sett zoom percentage S t Show/hide gridlines Page view set to normal or page-break Show/hide column/row headers
Turbo AutoColor* Ctrl+Shift+A – Enabled/Disabled AutoColor
• •
AutoColor Selection Alt S A Down Arrow AutoColor Active Sheet Alt S A Down Arrow
* NOTE: WHEN AUTOCOLOR IS ENABLED YOU LOSE THE ABILITY TO UNDO (CTRL + Z)
© 1999-2011 Training The Street, Inc. All rights reserved.
7
Considerations with TTS Turbo Macros •
As with many macro toolkits you lose the ability to undo (CTRL + Z) after executing a macro –
• •
TTS Turbo Macros might conflict legacy systems TTS Macros can be installed in Mac computers depending on the version of Excel being used – –
• •
Versions 2003 and 2011 will allow TTS Macros installation Version 2008 will not allow any macros to be installed
Computers with different language settings may experience some or all of TTS Macros are not working File names are very important but can sometimes change when downloading. downloading Make sure files installed are named – –
•
When the AutoColor is Enabled you are continuously executing macros and therefore lose the ability to undo
TTS_TURBO_MACROS_V5.0 TTS_TURBO_MACROS_V5.0.TTSM
If TTS Macros M stop t working ki go tto th the Add Add-ins i and d uncheck h k TTS M Macros, close l outt off Add Add-ins i before going back to check TTS Macros again – – –
2003: Tools, Add-Ins (Alt T, I) 2007: Office button, Excel Options, Add-ins, Go (Alt F I A A, Alt+G) 2010: File tab, Options, Add-ins, Go (Alt F T A A, Alt+G)
© 1999-2011 Training The Street, Inc. All rights reserved.
8
TTS Turbo Macros - Shortcut Keys y Macro Type
Description
Shortcut
Color Toggle
(1) blue, (2) green, (3) red and (4) automatic
Ctrl + Shift + C
Fill Toggle
(1) light yellow, (2) light turquoise, (3) gray (25%) and (4) none
Ctrl + Shift + V
Border Toggle
(1) top border, (2) right border, (3) top with right border and (4) none
Ctrl + Shift + B
Number Toggle
1) Number: #,##0.0_);(#,##0.0)
Ctrl + Shift + N
y $#,##0.0_);($#,##0.0) _) ( ) 2)) Currency: 3) Percentage: #,##0.0%_);(#,##0.0%) 4) Multiple: #,##0.0x 5) General format Alignment Toggle
(1) center across selection, (2) left alignment,
Ctrl + Shift + M
(3) right alignment and (4) general AutoColor Toggle
Turns Auto Color on / off
Ctrl + Shift + A
Increase Decimal
Increases decimal by 1 place
Ctrl + Shift + ,
Decrease Decimal
Decreases decimal by 1 place
Ctrl + Shift + .
Increase Zoom
Increases zoom by 5%
Ctrl + Shift + J
Decrease Zoom
Decreases zoom by 5%
Ctrl + Shift + K
Precedent Tracer
Traces cell’s precedents
Ctrl + Shift + T
Worksheet Control
Zoom percentage percentage, gridlines, gridlines page view view, column / row headers
Ctrl + Shift + Z
Disable F1 Key
Turns F1 on / off
Ctrl + Shift + 1
TTS Toolbar
Hides TTS Turbo Macros Toolbar
Ctrl + Shift + E
TTS Options
Customize macros functionality
Ctrl + Shift + S
© 1999-2011 Training The Street, Inc. All rights reserved.
9