Excel 2010 Tips and Tricks for Efficiency and Productivity
Excel 2010 Tips and Tricks for Efficiency and Productivity Marc Atkins
Using Excel 2010 Shortcuts • Excel shortcuts enable us to work faster and more efficient while navigating through the Excel environment. • Tapping the Alt key twice enables us to see all the corresponding letters associating with using keyboard shortcuts in Excel. • Some people use keyboard shortcuts in Excel in particular in the finance industry to quickly execute commands on data – “Time is money”
Basic Shortcuts in Excel
Formatting Cells • Formatting an Excel spreadsheet makes the design of the data appear seeming more organized – Bold formatting is (Ctrl+B) – Currency and accounting formatting » Ctrl+1 and Right Click Format cells
• Difference between currency and accounting – No alignment of $ and $0.00 (currency) – Numerical alignment $-- (accounting) • Alignment of Excel Data
Formulas AutoSum
Click on AutoSum or you can use Keystroke Alt+= Inserting a Formula
– Shift+F3
Creating an Absolute Reference Absolute Reference Cell reference in which the formula remains constant in an Excel spreadsheet Note:$Column$Row Keyboard Shortcut: F4 Editing a Formula Edit data in cells in a spreadsheet – F2
Various Excel Features • You can open Files in Excel and other programs using Ctrl+O • When saving files for the first time you can either use Keyboard shortcut Ctrl+S or the F12 key at the top of the keyboard • Printing Excel and other File types is Ctrl+P • Utilizing the thesaurus (Shift+F7) • Spell Check is a key component when using any software but Excel in particular. – Keyboard Shortcut is F7 at the top of the keyboard
Thank You Life Long Learners!
Using Excel 2010 Shortcuts • Excel shortcuts enable us to work faster and more efficient while navigating through the Excel environment. • Tapping the Alt key twice enables us to see all the corresponding letters associating with using keyboard shortcuts in Excel. • Some people use keyboard shortcuts in Excel in particular in the finance industry to quickly execute commands on data – “Time is money”
Basic Shortcuts in Excel
Formatting Cells • Formatting an Excel spreadsheet makes the design of the data appear seeming more organized – Bold formatting is (Ctrl+B) – Currency and accounting formatting » Ctrl+1 and Right Click Format cells
• Difference between currency and accounting – No alignment of $ and $0.00 (currency) – Numerical alignment $-- (accounting) • Alignment of Excel Data
Formulas AutoSum
Click on AutoSum or you can use Keystroke Alt+= Inserting a Formula
– Shift+F3
Creating an Absolute Reference Absolute Reference Cell reference in which the formula remains constant in an Excel spreadsheet Note:$Column$Row Keyboard Shortcut: F4 Editing a Formula Edit data in cells in a spreadsheet – F2
Various Excel Features • You can open Files in Excel and other programs using Ctrl+O • When saving files for the first time you can either use Keyboard shortcut Ctrl+S or the F12 key at the top of the keyboard • Printing Excel and other File types is Ctrl+P • Utilizing the thesaurus (Shift+F7) • Spell Check is a key component when using any software but Excel in particular. – Keyboard Shortcut is F7 at the top of the keyboard
Thank You Life Long Learners!
