Free Essay

The System of Finance Shortcuts

In: Business and Management

Submitted By rhbjunkemail
Words 2359
Pages 10
Commonly Used Shortcut Keys v13.0 Excel 97-2003

Action
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

Keystroke
F4 (in edit cell mode (F2)) Alt T U Alt T U T Alt T U D Alt T U A Alt+= Ctrl+Shift+7 Ctrl+Underscore (Ctrl+Shift+–) Alt E A Shift+F2 or (Alt I M) Alt E A M Ctrl+C / Ctrl+X Ctrl+V or (Enter) Ctrl+C, Alt E S T Ctrl+C, Alt E S F Ctrl+– / Ctrl++ Shift+Backspace F2 Ctrl+R / Ctrl+D Ctrl+Shift+P Ctrl+1 or (Alt O E) Alt I F or (Shift+F3) F5 or (Ctrl+G)
25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48

Action
Go to end (contiguous range) Group rows or columns ...Hide grouped range ...Show grouped range ...Ungroup rows or columns Highlight a contiguous range Highlight entire column / row Move a sheet / Copy a sheet Name a cell Page Break Preview / Normal Page setup… Print Print preview Redo Rename sheet Repeat Replace Set print area Tools options Undo Workbooks – toggle Worksheets – move between Zoom – sizing / return to 100%

Keystroke
Ctrl+Arrow Keys Alt D G or (Shift+Alt+) Alt D G H Alt D G S Alt D G or (Shift+Alt+) Ctrl+Shift+Arrow Keys Ctrl+Spacebar / Shift+Spacebar Alt E M / Alt E M, Alt+C Alt I N D or (Ctrl+F3) Alt V P / Alt V N Alt F U… Ctrl+P or (Alt F P) Alt F V Ctrl+Y Alt O H R F4 Ctrl+H Alt F T S Alt T O… Ctrl+Z Ctrl+Tab Ctrl+Page Up / Ctrl+Page Down Alt V Z / Alt V Z 1
Preparing Financial Professionals for Success

Anchoring cells Auditing toolbar ...Trace precedents ...Trace dependents ...Remove arrows Auto sum Borders – outside area Borders – remove all Clear Comment – inserting Comment – deleting Copy / Cut … Paste (after copy or cut) Copy, Paste special formats Copy, Paste special formulas Delete / Insert Deselect to original cell Edit cell / Highlight precedents Fill right / Fill down Font – change size Format cells… Function – inserting Go to

Go to precedent cell(s) / Return Ctrl+[ / F5, Enter

Go to constants (highlight inputs) F5, Alt+S O X

© 1999-2013 All rights reserved.

Commonly Used Functions

Excel 97-2003

© 1999-2013 All rights reserved.

Preparing Financial Professionals for Success

Commonly Used Shortcut Keys v13.0 Excel 2007

Action
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

Keystroke
F4 (in edit cell mode (F2)) Alt M… (See "Formula Auditing") Alt M P Alt M D Alt M A A Alt+= Ctrl+Shift+7 Ctrl+Underscore (Ctrl+Shift+–) Alt H E Shift+F2 or (Alt R C) Alt R D Ctrl+C / Ctrl+X Ctrl+V or (Enter) Ctrl+C, Alt H V S T or (Ctrl+Alt+V T) Ctrl+C, Alt H V F or (Ctrl+Alt+V F) Ctrl+– / Ctrl++ Shift+Backspace F2 Ctrl+R / Ctrl+D Alt H F S or (Ctrl+Shift+P, Alt S) Ctrl+1 or (Alt H O E) Alt M F or (Shift+F3) F5 or (Ctrl+G)
25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48

Action
Go to end (contiguous range) Group rows or columns ...Hide grouped range ...Show grouped range ...Ungroup rows or columns Highlight a contiguous range Highlight entire column / row Move a sheet / Copy a sheet Name a cell Page Break Preview / Normal Page setup… Print Print preview Redo Rename sheet Repeat Replace Set print area Tools (Excel) options Undo Workbooks – toggle Worksheets – move between Zoom – sizing / return to 100%

Keystroke
Ctrl+Arrow Keys Alt A G G or (Shift+Alt+) Alt A H Alt A J Alt A U U or (Shift+Alt+) Ctrl+Shift+Arrow Keys Ctrl+Spacebar / Shift+Spacebar Alt H O M, Alt+C Alt M M D or (Alt M N N) or (Ctrl+F3) Alt W I / Alt W L Alt P S P Ctrl+P or (Alt F P) Alt F W V or (Ctrl + F2) Ctrl+Y Alt H O R F4 Ctrl+H Alt P R S Alt F I… Ctrl+Z Ctrl+Tab Ctrl+Page Up / Ctrl+Page Down Alt W Q / Alt W J
Preparing Financial Professionals for Success

Anchoring cells Auditing toolbar ...Trace precedents ...Trace dependents ...Remove arrows Auto sum Borders – outside area Borders – remove all Clear Comment – inserting Comment – deleting Copy / Cut … Paste (after copy or cut) Copy, Paste special formats Copy, Paste special formulas Delete / Insert Deselect to original cell Edit cell / Highlight precedents Fill right / Fill down Font – change size Format cells… Function – inserting Go to

Go to precedent cell(s) / Return Ctrl+[ / F5, Enter

Go to constants (highlight inputs) F5, Alt+S O X

© 1999-2013 All rights reserved.

Commonly Used Functions

Excel 2007

© 1999-2013 All rights reserved.

Preparing Financial Professionals for Success

Commonly Used Shortcut Keys v13.0 Excel 2010

Action
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

Keystroke
F4 (in edit cell mode (F2)) Alt M… (See "Formula Auditing") Alt M P Alt M D Alt M A A Alt+= Ctrl+Shift+7 Ctrl+Underscore (Ctrl+Shift+–) Alt H E Shift+F2 or (Alt R C) Alt R D Ctrl+C / Ctrl+X Ctrl+V or (Enter) Ctrl+C, Alt H V S T or (Ctrl+Alt+V T) Ctrl+C, Alt H V F or (Ctrl+Alt+V F) Ctrl+– / Ctrl++ Shift+Backspace F2 Ctrl+R / Ctrl+D Alt H F S or (Ctrl+Shift+P, Alt S) Ctrl+1 or (Alt H O E) Alt M F or (Shift+F3) F5 or (Ctrl+G)
25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48

Action
Go to end (contiguous range) Group rows or columns ...Hide grouped range ...Show grouped range ...Ungroup rows or columns Highlight a contiguous range Highlight entire column / row Move a sheet / Copy a sheet Name a cell Page Break Preview / Normal Page setup… Print Print preview Redo Rename sheet Repeat Replace Set print area Tools (Excel) options Undo Workbooks – toggle Worksheets – move between Zoom – sizing / return to 100%

Keystroke
Ctrl+Arrow Keys Alt A G G or (Shift+Alt+) Alt A H Alt A J Alt A U U or (Shift+Alt+) Ctrl+Shift+Arrow Keys Ctrl+Spacebar / Shift+Spacebar Alt H O M, Alt+C Alt M M D or (Alt M N N) or (Ctrl+F3) Alt W I / Alt W L Alt P S P Ctrl+P or (Alt F P) Alt F P V or (Ctrl + F2) Ctrl+Y Alt H O R F4 Ctrl+H Alt P R S Alt F T… Ctrl+Z Ctrl+Tab Ctrl+Page Up / Ctrl+Page Down Alt W Q / Alt W J
Preparing Financial Professionals for Success

Anchoring cells Auditing toolbar ...Trace precedents ...Trace dependents ...Remove arrows Auto sum Borders – outside area Borders – remove all Clear Comment – inserting Comment – deleting Copy / Cut … Paste (after copy or cut) Copy, Paste special formats Copy, Paste special formulas Delete / Insert Deselect to original cell Edit cell / Highlight precedents Fill right / Fill down Font – change size Format cells… Function – inserting Go to

Go to precedent cell(s) / Return Ctrl+[ / F5, Enter

Go to constants (highlight inputs) F5, Alt+S O X

© 1999-2013 All rights reserved.

Commonly Used Functions

Excel 2010

© 1999-2013 All rights reserved.

Preparing Financial Professionals for Success

Commonly Used Shortcut Keys v13.0 Excel Mac 2008

Action
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

Keystroke
Cmd+T (in edit cell mode (Ctrl+U)) Ctrl+F2 T Enter AU Enter Ctrl+F2 T Enter AU Enter Enter Ctrl+F2 T Enter AU Enter T Enter Ctrl+F2 T Enter AU Enter A Enter Cmd+Shift+T Enter Cmd+Option+0 (zero) Cmd+Option+ - (minus) Ctrl+F2 E Enter A Enter Enter Shift+F2 Shift+F2 Delete Ctrl or Cmd+C / Ctrl or Cmd+X Ctrl or Cmd+V or Enter
Ctrl+F2 E Enter P  (Paste Spl.) Enter, Cmd+T Ctrl+F2 E Enter P  (Paste Spl.) Enter, Cmd+F

Action
25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48

Keystroke
Ctrl+Arrow Keys Cmd+Shift+K Ctrl+F2 D Enter GR Enter Enter Ctrl+F2 D Enter GR Enter  Enter Cmd+Shift+J Ctrl+Shift+Arrow Keys Ctrl+Spacebar / Shift+Spacebar Ctrl+F2 E Enter M Enter / (Cmd+R) Ctrl+L Ctrl+F2 V Enter P Enter / N Enter Ctrl+F2 F Enter P Enter Ctrl+P Mac operating system function Cmd+Y Ctrl+F2 FO Enter S Enter Enter Cmd+Y Ctrl+H Ctrl+F2 F Enter PR Enter Enter Cmd+, (comma) Ctrl (or Cmd)+Z Ctrl+Tab +Ctrl+ Down Arrow / Up Arrow

Anchoring cells Auditing toolbar ...Trace precedents ...Trace dependents ...Remove arrows Auto sum Borders – outside area Borders – remove all Clear All Comment – insert or read Comment – delete Copy / Cut … Paste (after copy or cut) Copy, Paste special formats Copy, Paste special formulas Delete / Insert Deselect to original cell Edit cell / Highlight precedents Fill right / Fill down Font – change size Format cells… Function – inserting Go to

Go to end (contiguous range) Group rows or columns ...Hide grouped range ...Show grouped range ...Ungroup rows or columns Highlight a contiguous range Highlight entire column / row Move a sheet / Copy a sheet Name a cell Page Layout / Normal Page setup… Print Print preview Redo Rename sheet Repeat Replace Set print area Tools (Excel) options Undo Workbooks – toggle Worksheets – move between

Go to precedent cell(s) / Return Ctrl+[ / F5, Enter

Ctrl+ - (minus) / Ctrl+ I Shift+Delete Ctrl+U Ctrl+R / Ctrl+D Cmd+Shift+. (period) / , (comma) Cmd+1 Shift+F3 F5 (or Ctrl+G)

Go to constants (highlight inputs) F5 Cmd+S Cmd+O Cmd+X Enter

Zoom – sizing / (return to 100%) Ctrl+F2 V Enter Z Enter / (Cmd+1)

▪ To access the menu bar w/o using the mouse you must hold Ctrl and press F2. You may then jump to a menu with the keyboard letters and use the down arrow to access it. This takes the place of the “Alt” key that is used in Windows. ▪ These keystrokes assume Mac has been optimized for financial modeling by following the steps in the TTS Mac Setup Guide

© 1999-2013 All rights reserved.

Preparing Financial Professionals for Success

Commonly Used Functions

Excel Mac 2008

© 1999-2013 All rights reserved.

Preparing Financial Professionals for Success

Commonly Used Shortcut Keys v13.0 Excel Mac 2011

Action
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

Keystroke
Cmd+T (in edit cell mode (Ctrl+U)) Ctrl+F2 T Enter AU Enter Ctrl+F2 T Enter AU Enter Enter Ctrl+F2 T Enter AU Enter T Enter Ctrl+F2 T Enter AU Enter A Enter Cmd+Shift+T Enter Cmd+Option+0 (zero) Cmd+Option+ - (minus) Ctrl+F2 E Enter A Enter Enter Shift+F2 Shift+F2 Delete Ctrl or Cmd+C / Ctrl or Cmd+X Ctrl or Cmd+V or Enter Ctrl+C, Ctrl+Cmd+V, Cmd+T Ctrl+C, Ctrl+Cmd+V, Cmd+F Ctrl+ - (minus) / Ctrl+ I Shift+Delete Ctrl+U Ctrl+R / Ctrl+D Cmd+Shift+. (period) / , (comma) Cmd+1 Shift+F3 F5 (or Ctrl+G)
25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48

Action
Go to end (contiguous range) Group rows or columns ...Hide grouped range ...Show grouped range ...Ungroup rows or columns Highlight a contiguous range Highlight entire column / row Move a sheet / Copy a sheet Name a cell Page Layout / Normal Page setup… Print Print preview Redo Rename sheet Repeat Replace Set print area Tools (Excel) options Undo Workbooks – toggle Worksheets – move between

Keystroke
Ctrl+Arrow Keys Cmd+Shift+K Ctrl+F2 D Enter GR Enter Enter Ctrl+F2 D Enter GR Enter  Enter Cmd+Shift+J Ctrl+Shift+Arrow Keys Ctrl+Spacebar / Shift+Spacebar Ctrl+F2 E Enter M Enter / (Cmd+R) Ctrl+L Ctrl+F2 V Enter P Enter / N Enter Ctrl+F2 F Enter P Enter Ctrl+P Mac operating system function Cmd+Y Ctrl+F2 FO Enter S Enter Enter Cmd+Y Ctrl+H Ctrl+F2 F Enter PR Enter Enter Cmd+, (comma) Ctrl (or Cmd)+Z Ctrl+Tab +Ctrl+ Down Arrow / Up Arrow

Anchoring cells Auditing toolbar ...Trace precedents ...Trace dependents ...Remove arrows Auto sum Borders – outside area Borders – remove all Clear All Comment – insert or read Comment – delete Copy / Cut … Paste (after copy or cut) Copy, Paste special formats Copy, Paste special formulas Delete / Insert Deselect to original cell Edit cell / Highlight precedents Fill right / Fill down Font – change size Format cells… Function – inserting Go to

Go to precedent cell(s) / Return Ctrl+[ / F5, Enter

Go to constants (highlight inputs) F5 Cmd+S Cmd+O Cmd+X Enter

Zoom – sizing / (return to 100%) Ctrl+F2 V Enter Z Enter / (Cmd+1)

▪ To access the menu bar w/o using the mouse you must hold Ctrl and press F2. You may then jump to a menu with the keyboard letters and use the down arrow to access it. This takes the place of the “Alt” key that is used in Windows. ▪ These keystrokes assume Mac has been optimized for financial modeling by following the steps in the TTS Mac Setup Guide

© 1999-2013 All rights reserved.

Preparing Financial Professionals for Success

Commonly Used Functions

Excel Mac 2011

© 1999-2013 All rights reserved.

Preparing Financial Professionals for Success…...

Similar Documents

Premium Essay

Excel Shortcuts

...Excel Excel ShortCut Keys and Tips Enter data by using shortcut keys To Complete a cell entry Cancel a cell entry Repeat the last action Start a new line in the same cell Delete the character to the left of the insertion point, or delete the selection Delete the character to the right of the insertion point, or delete the selection Delete text to the end of the line Move one character up, down, left, or right Move to the beginning of the line Edit a cell comment Create names from row and column labels Fill down Fill to the right Fill the selected cell range with the current entry Complete a cell entry and move down in the selection Complete a cell entry and move up in the selection Complete a cell entry and move to the right in the selection Complete a cell entry and move to the left in the selection Press ENTER ESC F4 or CTRL + Y ALT + ENTER BACKSPACE DELETE Enter the time Insert a hyperlink Complete a cell entry Copy the value from the cell above the active cell into the cell or the formula bar Alternate between displaying cell values and displaying cell formulas Copy a formula from the cell above the active cell into the cell or the formula bar Enter a formula as an array formula Display the Formula Palette after you type a valid function name in a formula Insert the argument names and parentheses for a function, after you type a valid function name in a formula Display the AutoComplete list CTRL + SHIFT + : (COLON) CTRL + K ENTER CTRL + SHIFT + " (QUOTATION MARK) CTRL +......

Words: 3690 - Pages: 15

Premium Essay

Excel Shortcuts

...Excel Excel ShortCut Keys and Tips Enter data by using shortcut keys To Complete a cell entry Cancel a cell entry Repeat the last action Start a new line in the same cell Delete the character to the left of the insertion point, or delete the selection Delete the character to the right of the insertion point, or delete the selection Delete text to the end of the line Move one character up, down, left, or right Move to the beginning of the line Edit a cell comment Create names from row and column labels Fill down Fill to the right Fill the selected cell range with the current entry Complete a cell entry and move down in the selection Complete a cell entry and move up in the selection Complete a cell entry and move to the right in the selection Complete a cell entry and move to the left in the selection Press ENTER ESC F4 or CTRL + Y ALT + ENTER BACKSPACE DELETE Enter the time Insert a hyperlink Complete a cell entry Copy the value from the cell above the active cell into the cell or the formula bar Alternate between displaying cell values and displaying cell formulas Copy a formula from the cell above the active cell into the cell or the formula bar Enter a formula as an array formula Display the Formula Palette after you type a valid function name in a formula Insert the argument names and parentheses for a function, after you type a valid function name in a formula Display the AutoComplete list CTRL + SHIFT + : (COLON) CTRL + K ENTER CTRL + SHIFT + " (QUOTATION MARK)......

Words: 3690 - Pages: 15

Free Essay

Keyboard Shortcut

...Non-Operative Financial Holding Company 10) What is the name of a recently constituted committee to take decisions on investments, whose first meeting was held on 30 January 2013? – Cabinet Committee on Investments (CCI) 12) Which two public sector undertakings (PSUs) were granted the Maharatna status by union govt. on 1 February 2013? – BHEL and GAIL (This will provide these two PSUs greater financial and functional autonomy and ensure better valuation of their shares) 13) What is the new name of MetLife India Limited, after Punjab National Bank (PNB) signed an agreement to acquire 30 per cent stake in the company on 4 February 2013? – PNB MetLife India Insurance Company Limited (PNB MetLife Insurance was also launched officially by Union Finance Minister P. Chidambaram on 4 February 2013) 14) What is the name of a newly formed association, formed recently by 30-odd software companies of India, which is going to evolve as an alternative to NASSCOM? - Indian Software Product Industry Round Table or iSpirt (iSpirt has been formed by Indian software companies who believe that NASSCOM would not be able to provide more growth avenues to them in future.However, iSpirt members clearly stated that they see no conflict with NASSCOM) 15) Union govt. on 6 February 2013 constituted an advisory panel for the electricity sector with an objective to iron out the issues impacting the growth of the sector. Who is the head of this panel? – Jyotiraditya Scindia, Union Power Minister (This......

Words: 7901 - Pages: 32

Free Essay

Shortcut in Mathematical Calculations

... 5 5 2 5 → Final Answer ● Difference of Two Square Numbers Given: 16² - 25² Steps: - Get the sum of the two base numbers 25 + 16 = 41 - Difference of the two base numbers 25 – 16 = 9 - Multiply the sum and difference 41 × 9 = 369 ↓ Final Answer Examples: 1. Given: 17² - 20² - 20 + 17 = 37 - 20 – 17 = 3 - 37 × 3 = 111 → Final Answer 2. Given: 58² - 69² - 69 + 58 = 127 - 69 – 58 = 11 - 127 × 11 = 1397 → Final Answer 3. Given: 45² - 51² - 51 + 45 = 96 - 51 – 45 = 6 - 96 × 6 = 576 → Final Answer SHORTCUTS IN MATHEMATICAL CALCULATIONS (Project in Number Theory 8) Phoebe Kyle Nadine B. Malig-on 8 – Archimedes Mdme. Marichu S. Gajardo (subject teacher)...

Words: 535 - Pages: 3

Free Essay

Linux Shortcut

...time, most recent first. ls -lt # Move/rename a file or directory (be careful that you don't move the source over a destination with the same name): mv source destination # Delete target forever (be very careful), use -r recursive flag for directories: rm target # Copy file or directory: cp source destination # Mount filesytem: mount /dev/device_name /media/device_name # Unmount: umount /media/device_name # Forensically clone filesystems and do other low-level operations on files. Be careful with this one. Can be destructive: dd # Work with disk partitions: parted # Filesystem creation tool: mkfs **** System Administration: # Execute command as an administrator (can be destructive/insecure. Use only for system administration tasks): sudo command # Become system administrator: sudo -s # Quit system administration: exit # Forgot to type sudo in front of a command and already hit enter? Repeat the last command using sudo: sudo !! ***** Installing software from a .tgz (also known as a tarball): # First, unzip the tarball (see section on tar, below) # Next, move into unzipped directory: cd software_directory # Always read README first if it is provided, in case there are any modifications to the procedure outlined below: cat README # Automatically check for appropriate configurations and generate a MAKE file in the directory: ./configure # Compile software. May require sudo: make # Move files into their......

Words: 1920 - Pages: 8

Premium Essay

Simple Keyboard Shortcuts

...The General Shortcuts We’ll kickoff the list with some really general shortcuts that you often used. * CTRL+C (Copy) * CTRL+X (Cut) * CTRL+V (Paste) * CTRL+Z (Undo) * Delete (Delete) * Shift+Delete (Delete the selected item permanently without placing the item in the Recycle Bin) * CTRL while dragging an item (Copy the selected item) * CTRL+Shift while dragging an item (Create a shortcut to the selected item) * F2 key (Rename the selected item) * CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word) * CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word) * CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph) * CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph) * CTRL+Shift with any of the arrow keys (Highlight a block of text) * Shift with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document) * CTRL+A (Select all) * F3 key (Search for a file or a folder) * Alt+Enter (View the properties for the selected item) * Alt+F4 (Close the active item, or quit the active program) * Alt+Enter (Display the properties of the selected object) * Alt+Spacebar (Open the shortcut menu for the active window) * CTRL+F4 (Close the active document in programs that enable you to have multiple documents open simultaneously) * Alt+Tab (Switch......

Words: 1298 - Pages: 6

Free Essay

Finance

...my skills effectively. To achieve and strive for endless knowledge, face challenges with confidence and commitment. ACHIEVEMENTS  Promoted to Accounts Executive post within two months after joining Core Solutions.  Spare Parts controller within two months after joining Danieli & C. EXPERIENCE Accounts Assistant Suhail Al Mazroui Trading Company L.L.c., Mussafah Abu Dhabi November 11, 2013 till Present Supporting the business by assisting to produce accurate financial and management accounting information on which financial decisions are based. Also, involved in compiling financial reports and analyses, whilst working to strict deadlines. Duties:         Preparing sales invoices & the upkeep of an accurate accounts filing system. Preparation and input of month end journal vouchers. Inputting of supplier invoices and employee expenses claim to the ledger. Debtor and creditor reconciliations. Preparation of various reports for senior managers. Fixed asset accounting, reconciliations and depreciation journals. Preparation of bi-weekly invoice and expense claim payment runs. Assist in the preparation of monthly balance sheet account reconciliation. Accounts Assistant & Spare Parts Controller as an Assistant Supply Chain on Contract Danieli & C. Officine Maccaniche S.P.A (Contracting Company of Emirates Steel Industries) February 2011 – November 9, 2013 Working as part of a team that is responsible for making sure that the flow of costs and revenues between......

Words: 837 - Pages: 4

Premium Essay

Excel Shortcut

...Excel 2013 Help Page 1 of 8 Keyboard shortcuts in Excel This article describes what Key Tips are and how you can use them to access the ribbon. It also lists Ctrl combination shortcut keys, function keys, and some other common shortcut keys for Microsoft Excel 2013. In this article Keyboard access to the ribbon Will my old shortcuts still work? Ctrl combination shortcut keys Function keys Other useful shortcut keys Keyboard access to the ribbon If you're new to the ribbon, the information in this section can help you understand the ribbon's keyboard shortcut model. The ribbon comes with new shortcuts, called Key Tips. To make the Key Tips appear, press Alt. To display a tab on the ribbon, press the key for the tab—for example, press the letter N for the Insert tab or M for the Formulas tab. This makes all the Key Tip badges for that tab's buttons appear. Then, press the key for the button you want. Will my old shortcuts still work? Keyboard shortcuts that begin with Ctrl will still work in Microsoft Excel 2013. For example, Ctrl+C still copies to the clipboard, and Ctrl+V still pastes from the clipboard. Most of the old Alt+ menu shortcuts still work, too. However, you need to know the full shortcut from memory — there are no screen reminders of what letters to press. For example, try pressing Alt, and then press one of the old menu keys E (Edit), V (View), I (Insert), and so on. A box pops up saying you're using an access key from an earlier version of......

Words: 2819 - Pages: 12

Premium Essay

Finance and Accounting Systems in Aviation Industry

...Finance and Accounting Information systems used in Aviation sector Finance and Accounting Information systems used in Aviation sector SUBMITTED BY: BHAVIK K. VORA 421 MBA (Tech.) Telecommunications Contents | SR. NO. | TOPICS | PAGE NO. | 1 | Aviation Sector: An overview | 3 | 2 | Effect of information system in aviation sector | 3 | 3 | Finance and accounting information system | 4 | 4 | Sirax Airfinance platform by Lufthansa systems syssystesm | 4 | 5 | Sirax Revenue Accounting | 5 | 6 | Sirax Cost Accounting | 8 | 7 | Sirax Business Intelligence | | Aviation industry: An overview The aviation industry traditionally grew due to increase in demand of business travellers as the companies started expanding their operations in different places all over the world. Moreover rise and income of the people had a positive effect on the tourism industry and thus leading to the growth of aviation industry. Deregulation and Privatisation of the aviation industry provided further impetus to its growth. Since 1970, the growth rate in the aviation industry has been about 6-7% Sirax Airfinance platform by Lufthansa systems With respect to the uncertainties that airlines are facing today, Sirax Airfinance platform can prove to be of great help to the airlines as it provides the right information at the right time. It keeps the airline updated about their operations and financial condition. It provides the airline with timely,......

Words: 1268 - Pages: 6

Premium Essay

Internet Finance

...Chapter 2 A Behavioral Finance Approach to Decision Making in Entrepreneurial Finance Rassoul Yazdipour By ‘uncertain’ knowledge, let me explain,… We simply do not know. J.M. Keynes (1937) Humans have an additional capability that allows them to alter their environment as well as respond to it. This capacity both creates and reduces risk. Paul Slovic (1987) All risk that is acted upon must be perceived risk because perception is based upon sensory data. We can only sense the ‘real world’ because we have no other way of being informed. Robert Olsen (2010) Understanding a problem is half of the solution Unknown Abstract  Three central decisions in entrepreneurship and entrepreneurial finance – entry/seed funding, financing/investment, and growth/exit – are discussed and case is made for applying the behavioral finance theories and concepts to better understand the involved decision processes, and consequently, to help improve the decisionmaking process for both entrepreneurs and venture capitalists. The behavioral finance approach is important because the traditional finance has remained silent on the first issue, and the Agency Theory (financial contracting), which is effectively the only theory that is applicable to issues in entrepreneurial finance, has produced mixed empirical results. (See for example Bitler et al. [Bitler MP, Moskowitz T J, VissingJorgensen A (2009) Why do entrepreneurs hold large ownership shares? Testing agency theory using......

Words: 7844 - Pages: 32

Premium Essay

Finance

...housing finance industry barely accounts for 30% of the home loans disbursed in the country. The last few years have seen the home loans market growing at a CAGR of over 30 percent. The growth has been mainly fuelled by certain fiscal, social and regulatory drivers: • Changes in demographic profile including increase in the rate of household formation due to structural shift from joint family system to nuclear family • Ever increasing middle class, migration of population and increasing urbanization resulting in acute shortage of housing units Vice President Ambit Corporate Finance Pte. Ltd. Vinod Wadhwani is Vice President, Ambit Corporate Finance Pte Ltd., He is responsible for Mergers and Acquisitions Group in the company. Earlier, he has worked as a marine engineer in merchant navy for eight years. • Increase in disposable income levels due to decrease in marginal tax rates and increase in total income levels • Tax benefits and other fiscal incentives announced in the Union Budgets • Increasing affordability of housing property purchase due to declining interest rates and stable property prices • Decline in the average house cost to annual income ratio to around 4-5 from 11-14 during the last decade resulting in an affordable EMI as a percentage of monthly income • Aggressive lending by banks to the housing sector due to lower credit offtake by the corporate sector, attractive spread and lower non performing assets The major players in Indian housing finance......

Words: 2541 - Pages: 11

Free Essay

Mac Keyboard Shortcuts

...By pressing a combination of keys, you can do things that normally need a mouse, trackpad, or other input device. To use a keyboard shortcut, hold down one or more modifier keys while pressing the last key of the shortcut. For example, to use the shortcut Command-C (copy), hold down Command, press C, then release both keys. Mac menus and keyboards often use symbols for certain keys, including the modifier keys: Command ⌘ Shift ⇧ Option ⌥ Control ⌃ Caps Lock ⇪ Fn If you're using a keyboard made for Windows PCs, use the Alt key instead of Option, and the Windows logo key instead of Command. Some Mac keyboards and shortcuts use special keys in the top row, which include icons for volume, display brightness, and other functions. Press the icon key to perform that function, or combine it with the Fn key to use it as an F1, F2, F3, or other standard function key. To learn more shortcuts, check the menus of the app you're using. Every app can have its own shortcuts, and shortcuts that work in one app may not work in another. Cut, copy, paste, and other common shortcuts Shortcut Description Command-X Cut: Remove the selected item and copy it to the Clipboard. Command-C Copy the selected item to the Clipboard. This also works for files in the Finder. Command-V Paste the contents of the Clipboard into the current document or app. This also works for files in the Finder. Command-Z Undo the previous command. You can then press Command-Shift-Z......

Words: 2262 - Pages: 10

Premium Essay

Shortcut

...Support Sign in Cart0 ------------------------------------------------- Top of Form  Bottom of Form  Manage my account  Ask the community  Contact Answer Desk  Find downloads Keyboard shortcuts for Windows * Email * Print Support for Windows XP has ended Microsoft ended support for Windows XP on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected. Support for Windows Server 2003 ended on July 14, 2015 Microsoft ended support for Windows Server 2003 on July 14, 2015. This change has affected your software updates and security options. Learn what this means for you and how to stay protected. Summary This article lists keyboard shortcuts that you can use with Windows. More information Windows system key combinations * F1: Help * CTRL+ESC: Open Start menu * ALT+TAB: Switch between open programs * ALT+F4: Quit program * SHIFT+DELETE: Delete item permanently * Windows Logo+L: Lock the computer (without using CTRL+ALT+DELETE) Windows program key combinations * CTRL+C: Copy * CTRL+X: Cut * CTRL+V: Paste * CTRL+Z: Undo * CTRL+B: Bold * CTRL+U: Underline * CTRL+I: Italic Mouse click/keyboard modifier combinations for shell objects * SHIFT+right click: Displays a shortcut menu containing alternative commands * SHIFT+double click: Runs the alternate default command (the second item on the menu) * ALT+double click: Displays properties *......

Words: 1247 - Pages: 5

Free Essay

Ms-Office Shortcuts

...MICROSOFT WORD KEYBOARD SHORTCUTS Here is a list of keyboard shortcuts which can be very useful if you want to work faster! CTRL Shortcuts: CTRL and A Selects all in the current document. CTRL and B Bold text. CTRL and C Copies the item or text to the Clipboard and can be pasted using CTRL and V. CTRL and D Displays the Font dialogue box. CTRL and E Centre Alignment. CTRL and F Displays the Find dialog box, to search the current document. CTRL and G Displays the Go to dialog box, to go to a specific location in the current document. CTRL and H Displays the Replace dialogue box. CTRL and I Italic text. CTRL and J Full Justification. CTRL and K Create Hyperlink CTRL and L Left Alignment CTRL and M Tab. CTRL and N Creates a new document. CTRL and O Displays the Open File dialogue box. CTRL and P Displays the Print dialog box. CTRL and R Right Alignment. CTRL and S Displays the Save dialog box. CTRL and U Underline text. CTRL and V Pastes the copied item or text from the Clipboard into the current position in the document. CTRL and X Cuts the item or text selected to the Clipboard. CTRL and Y Redo the last undone action. CTRL and Z Undoes the last action. CTRL and ENTER Insert Page Break. CTRL and F2 Show Print preview. CTRL and F4 Closes the active document window. CTRL and F6 Opens the next document window. F and SHIFT shortcut keys: F1......

Words: 462 - Pages: 2

Premium Essay

The Finance

...able to see the visible fruits that are the yield of good stewardship and decisions. The book of Proverbs was a series of exhortations and encouragements written by King Solomon to his son.  In chapter 23 verse 23, Solomon states, “Buy truth, and do not sell it; buy wisdom, instruction, and understanding.” For thousands of years, mankind has been given stewardship of resources; natural, human, intellectual and financial. The process of managing these resources, specifically financial resources, requires intentional short-term and long-term planning. More importantly, in order for capital management to be deemed successful, it is required that all members of an organization are on board. “Capital budgeting is not only important to people in finance or accounting, it is essential to people throughout the business organization”< /span> (Block, Hirt, & Danielsen, 2011). As the duration of the investment period increases, and the size of investment increases, the residual risk also increases. For a firm to effectively manage its resources it begins with the administrative considerations, ranges to the ranking of the capital investments, the strategy of selection processes and various other financial planning details and concerns. Once again, we find in Proverbs 24:3-4, “By wisdom a house is built, and by understanding it is established; by knowledge the rooms are filled with all precious and pleasant riches.” We find that through the seeking of wise counsel, wise......

Words: 1039 - Pages: 5

Maya Rasamee | Windows8 | Fiction Bücher