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

Cost of Capital

...Cost of Capital FINANCING DECISION  In financing decision, it is totally concentrated on how to generate finance from long term sources  It is also considered the following points:  Cost of Finance  Time period  Purpose of Finance  Amount of Finance  Risk involvement SOURCES OF FINANCE Finance required for investing purpose may be from one or combination of the following sources: 1) From Debt Source 2) From Equity Source i. Ordinary Shares ii. Preference Shares iii. Retained Earning Why do we use different source of finance? COST OF FINANCE It is the minimum rate of return that a firm must earn on its investment for the market value of the firm to remain unchanged. WEIGHTED AVERAGE COST OF CAPITAL Capital is the combination of different components (sources) and the cost of each component is called specific cost. When these specific costs are combined to arrive at overall cost of capital, it is referred to as the weighted average cost of capital. Assumptions  Entity’s financial and business risks are unaffected by the acceptance and financing of projects.  Financial structure of the entity remains constant. It means that if the entity needs additional funds then are to be raised in accordance with the existing proportion. Components of Cost of Capital  Risk-free cost of particular type of financing (r)  Business risk premium (b)  Financial risk premium (f) k = r + b +f Explicit and Implicit Cost Explicit Cost From the desk of M.......

Words: 2762 - Pages: 12

Free Essay

Business Pricing Strategy Advantage and Desadvantage

...overall working experience than your competition. You put your firm on an upward spiral of improvement. 2. You can do exponentially higher quality (thus higher value) work for your clients. Think about it. A Ferrari doesn't take 10 times more time and effort to me make than a Ford. Yet, even an entry level Ferrari costs more than 10 times of a Ford. And there is a huge difference in the quality of service. 3. You can retain top-tier talent to provide top-drawer service. Unlike junk food joints that can produce consistent and predictable results using minimum-wage kids and rigid systems, selling high-margin stuff need both good systems and real talents, not merely workers. Go to a specific junk food joint and order only some deserts. The kid on the other side of the counter will ask you, following the rigid system, if you want fries with it. 4. You can create a fatter piggy bank to finance various initiatives in your firm. You can be more responsive to your clients, you can send your people to the best skill building programmes. You have more time and financial resources to respond rapidly to client emergencies which will put you head and shoulders above your competition. 5. You can better focus on servicing the few existing clients and stay in touch with your five star prospects. It means you can create value beyond the scope of the basics of your merchandise because you're not watching the watch and you're not on an airtight schedule. 6. Your overall......

Words: 1115 - Pages: 5

Premium Essay

Banyan Tree

...with international exposure, variety and experience result in an optimum exposure to learning opportunities. The interlocking of business verticals can be best understood by undergoing rigors of a well crafted MBA curriculum. The theoretical grounding in subjects of marketing, finance and strategy prepares a well rounded business manager who can leverage his learning to morph any bystander into a potential client - investor who sees value in your proposals. Myriads treat the course as any education program running behind grades and frittering away invaluable time. Instead the objective of a bschool should be to inculcate skills in students to do research, gain perspectives and experience that an industry expects out of a manager. For students and other potential stakeholders such as parents the perceived undercurrent (cost benefit analysis) when it comes to placement announcements and the bschool ratings justifies their decision for considering one bschool over another. Is MBA a shortcut to getting better paid jobs and is it a guarantee of minimum skills? This irrational belief that absolute recognition and relative compensation is more important than quality, promises to suffocate our education system. If Ph.D. faculties can facilitate better research, professors with rich industry experience provide the global thought leadership. Instead of clinging slavishly to the western models of thinking, bschools should focus on improving their ties with the business fraternity.......

Words: 504 - Pages: 3

Premium Essay

Corporate Law

...Economy: A Shortcut to Economic Literacy. "In contrast, partners are legally liable for all debts and unpaid bills of the partnership. Because investors in a corporation do not risk their personal assets if the firm goes belly-up, the corporate system encourages people to invest." Moreover, while a corporation can be targeted in legal actions such as lawsuits, the personal assets of the company's owners cannot be touched if a judgement is rendered against their establishment since it is recognized as a legal entity separate from the owners/shareholders. DISADVANTAGES OF INCORPORATION • Regulatory and Record keeping Requirements—Corporate operations are governed by local, state, and federal regulations to a greater degree than are other businesses. • Added Cost of Doing Business—Regulatory and record keeping guidelines and requirements often make it necessary for corporations to make additional investments (in accounting staffing, etc.) devoted to seeing that those legal requirements are met. In addition, there are fees associated with incorporating that business partnerships and sole proprietorships are not subject to. • "Double" Taxation—People who are owners of a corporation, and who also work as an employee of the business, can receive financial compensation in two different ways. In addition to receiving a salary for work performed, the owner may also receive a dividend or distribution on the stock that they owns. • Separation of Finances—While......

Words: 609 - Pages: 3

Premium Essay

1. Relate How Windows Server 2008 R2 Active Directory and the Configuration of Access Controls Achieve C-I-a- for Departmental Lans, Departmental Folders, and Data.

...are get grouped together. For example, the finance department of a company typically only communicates with other members of that same group. An Active Directory distribution group allows all members of the finance department to email without having to type every individual name in the email. Security groups are used to provide or deny access to users or devices to shares, files, or even other devices, these are called security permissions. Security permissions can be added to any distribution or security group, however email cannot be sent to a distribution group. Active Directory allows administrators to designate network users as owners or delegates of other security or distribution groups, to be updated as needed. Organizational management is made possible through the use of Organizational Units aka OU’s. Basically, OU’s allow users, computers, or devices on the same network to be grouped together to best fit the Companies needs. This makes searching for or accessing a device, user, or group far less complex than if all domain items were listed together. For example, the Company I work for has over 20 sites spread across the U.S., and to simplify user management and security each site has OU’s setup within Active Directory. This means that users in Georgia are grouped differently than users in California, which allows administrators to only apply the security rights needed for that site. Also Active Directory is full of shortcuts to assist in account creation and OU......

Words: 705 - Pages: 3

Free Essay

Management Information Systems

...Information Systems: A Research Paper By Greg Butler Student ####### American Military University MC302 D002 Summer 07 October 23, 2007 Management Information Systems: A Research Paper Executive Summary. In April 2004, after a year of planning, preparation, and training, the City of La Quinta “went live” with an enterprise-wide, integrated information system for the first time in its 22-year history. For the roughly one hundred member staff, it was a revolutionary leap. Previously, each functional department had selected, purchased, and implemented its own best solution to facilitate day-to-day operations. The implementation of SunGard’s HTE NaviLine software required infrastructure improvements and behind-the-scenes setup. The result was several databases for common use among departments and several automation improvements to previous transaction processing systems. Functional departments, individually and collectively, are able to spend more time concentrating on serving customers and less time searching City Hall for a needed piece of information. Implementation in two final departments will lead to even better service, particularly for those in the development community. The system is challenging, but powerful by virtue of its use of a multi-platform IBM® System i™ server. It is moderately user-friendly by virtue of NaviLine’s Web browser interface. Several improvements are necessary to make the system truly great, but in its current state the system......

Words: 2522 - Pages: 11

Premium Essay

Outsourcing Risks

...provider for processing information systems applications, the use of vendors to support your desktop computers, and the use of a vendor to provide network security. Outsourcing Data Storage A company that secures its valuable assets and protects their secret information within the four walls of the building allows themselves to be vulnerable as soon as they outsource their data to stored by a third party. The problem is generally a manageable one for small business with one or two vendors they outsource too, but as the company grows and the amount of vendors they deal with grows; the issue then becomes exponentially greater. If that vendor gets their network hacked and a hacker steals the information you gave the vendor to protect, then there is nothing you can do besides terminating your business agreement with that vendor and taking your business elsewhere, but who is to say that won’t happen again. Conducting a risk analysis of the outsourced company can help you determine which vendor to outsource the work to or the risk assessment might convince the company to not outsource to begin with. The risk assessment should start with drafting “an oversight program to monitor and perform assessments on vendors and external outsource providers that manage, process or store your confidential information” (Sans Institute, 2004). The oversight program should include a financial health statement of the vendors in question to protect from shortcuts a vendor might make and......

Words: 1102 - Pages: 5

Free Essay

Short Cuts

...Keyboard shortcuts To do this Press Switch to the next program. ALT+TAB Switch to the previous program. ALT+SHIFT+TAB Display the Windows Start menu. CTRL+ESC Close the selected workbook window. CTRL+W or CTRL+F4 Restore the window size of the selected workbook window. CTRL+F5 Switch to the next pane in a worksheet that has been split (Window menu, Split command). F6  Note   When the task pane (task pane: A window within an Office application that provides commonly used commands. Its location and small size allow you to use these commands while still working on your files.) is visible, F6 includes that pane when switching between panes. Switch to the previous pane in a worksheet that has been split. SHIFT+F6  Note   When the task pane is visible, SHIFT+F6 includes that pane when switching between panes. When more than one workbook window is open, switch to the next workbook window. CTRL+F6 Switch to the previous workbook window. CTRL+SHIFT+F6 When a workbook window is not maximized, perform the Move command (on the Control menu for the workbook window). Use the arrow keys to move the window, and when finished press ESC. CTRL+F7 When a workbook window is not maximized, perform the Size command (on the Control menu for the workbook window). Use the arrow keys to resize the window, and when finished press ENTER. CTRL+F8 Minimize a workbook window to an icon. CTRL+F9 Maximize or restore the selected workbook......

Words: 7223 - Pages: 29

Premium Essay

Corporate Compliance

...For many businesses, risk management has been identified as a way to thwart and reduce losses, as well as develop business performance. A collection of new tools have been introduced over the past few years to help measure enterprise risk. The Committee of Sponsoring Organizations of the Treadway Commission (COSO) has also played a major role in helping companies manage risk. COSO was formed in 1985 and is a U.S. private sector initiative whose major goal is to identify the different factors that lead to fraudulent activities such as fraudulent financial reporting and make recommendations to reduce the incidences. COSO established a variety of internal controls and criteria that companies and organizations can use to assess their control systems in order to manage risk. “In 2001, COSO initiated a project, and engaged PricewaterhouseCoopers, to develop a framework that would be readily usable by managements to evaluate and improve their organizations’ enterprise risk management” (COSO Executive Summary, 2004). Based on the many COSO recommendations of risk management, many companies and businesses have implemented enterprise risk management techniques within their organization. The goal of this paper is to summarize a plan to apply enterprise risk management for New Mexico Solutions. “The underlying principle of enterprise risk management is that every entity exists to provide value for its stakeholders. All entities face uncertainty and the challenge for management is to......

Words: 1169 - Pages: 5

Premium Essay

Forensi Accountant

...accountant in an ethical way then your reputation will precede you. If you take short cuts then the decisions that you make will be questioned your entire career. In this field one bad judgment can be the end of your career There are a lot of other characteristics that a Forensic Accountant has to portray to be able to their job efficiently. The skills that a Forensic Accountant needs are the action of identifying, recording, settling, extracting, sorting, reporting, and verifying past financial data or other accounting activities for settling current or prospective legal disputes or using such past financial data for projecting future financial data to settle legal disputes. Forensic Accountants play a vital role in the legal system they handle divorce finances and they proceed over case where there are tax matters at hand. Sometimes they have to look at documents to determine if they are legitimate or if certain documents are forged. The information that they provide the court can be the information that decides whether a case is found in a person’s favor or not. Lastly they need to know how to present the information so that it upholds the justice within the courtroom, and the court and jurors have a clear understanding of the knowledge that you are presenting. While in a business, the forensic accountant needs to understand, that without a court granted subpoena, that his or her right to access computer information, question people or rummage through files may limited......

Words: 2131 - Pages: 9

Premium Essay

Decision Making

...Key Performance Indicator (KPI)?  Virtual Advisor, Inc.: Analyzing Your Competition About the Author Financial information and decision making The finance department of a company generates a variety of financial information that is helpful in decision making, including: Read more: http://businesscasestudies.co.uk/business-theory/strategy/financial-information-and-decision-making.html#ixzz3fjrtrlw4 Under Creative Commons License: Attribution Non-Commercial Share Alike Follow us: @BizCaseStudies on Twitter | bizcasestudies on Facebook Profit and Loss accounts providing details of whether the business is making efficient use of financial resources. • Balance Sheet information providing details of a businesses assets and liabilities, as well as the liquidity of the business. • Sales and purchases information setting out particular types of trading and accounts with particular customers and suppliers. • Information about the purchase of assets and liabilities. • Information about the wages paid out by a business. • Information about costs. By providing a steady and up-to-date flow of information, a business is able to make appropriate decisions about: • how to reduce costs • how to increase sales • how to raise profitability • when to purchase new capital assets • the best sources of finance, and duration, etc. Financial statements Budgets are plans for the future. Managers are able to monitor budgets in order to spot variances and make......

Words: 1833 - Pages: 8

Premium Essay

Management Information Systems

...ASSIGNMENT (MIS IN ACTION) NAME: COMMFORT HAMMOND CLASS: LEVEL 400, BHM INDEX NUMBER: 11016152 COURSE: MANAGEMNET INFORMATION SYSTEMS DATE: 13/9/2012 MANAGEMENT INFORMATION SYSTEMS GROUP ASSIGNMENT PROGRAMME: BHM, LEVEL 400 LECTURER: DR. MARGARET CRABBE 1. What kind of information does the Web site provide for individuals, small businesses and large businesses? List these services and write several paragraphs describing one of them, such as UPS Trade Direct or Automated Shipment Processing. Explain how you or your business would benefit form it. Answer United Parcel Service (UPS) has a wide variety of information and services for its various clients across the globe. Individuals can tap into a network of resources that helps them manage their businesses more easily, from packing and shipping, to tracking and billing such as: * Reliable delivery services without any worries on the part of the individual * * Provision of information on how to prepare a shipment from the Packaging Advisor and then create shipments online. * Invoices and pay bills are made available for viewing and billing reports are built to monitor shipping expenses, and to find out instantly how much products have been shipped all from the UPS Billing Center. * Better staff management techniques are also provided r when anticipating high-volume shipping and receiving with UPS Tracking. * People are more able to focus on their priorities through......

Words: 1220 - Pages: 5

Premium Essay

Windows 8

...It All Together 4. Launch and Install Apps, Multitasking 4.1 Launching Apps 4.2 Switching Between Applications 4.3 Closing Apps 5. Photos, Music and Video 5.1 Enjoying Photos in Windows 8 5.2 Playing Back Media 5.3 Streaming Media, Windows 8 Store Alternatives HTTP://MAKEUSEOF.COM CHRISTIAN CAWLEY, WWW.CMCAWLEY.CO.UK 6 7 7 8 9 9 9 10 10 11 11 12 12 13 13 13 13 13 13 13 13 13 14 15 15 15 16 17 17 17 17 3 share: YOUR GUIDE TO WINDOWS 8 6. The Windows 8 Store 6.1 Use Your Windows Account 6.2 Finding, Reviewing and Buying an App 6.3 Installation Issues and Updating Apps 6.4 Don’t Forget the Native Apps! 7. Email, Internet, People and the Cloud 7.1 Internet Explorer: Browsing and Downloading 7.1.1 Navigating Internet Explorer 10 7.1.2 Shortcuts and Tabs 7.1.3 Downloading with Internet Explorer 10 7.2 Managing People and Social Networks 7.2.1 Catching Up with Social Networks 7.2.2 Communicating with Contacts 7.2.3 Adding New People 7.2.4 Editing and Linking Your Contacts 7.3 Emails: Setting Up, Collecting and Sending 7.4 Accessing and Browsing SkyDrive 8. Tweaking Your Windows 8 Device 8.1 Start Screen and Lock Screen Wallpaper 8.2 Adjusting Tile Size, Moving and Unpinning 8.3 Battery management, on and off button/features 8.4 Windows 8 Sync 9. Windows 8 Security 9.1 Networking Windows 8 9.2 Local vs. Windows Account 9.3 Setting Passwords 9.4 Windows Firewall 9.5 Windows 8 Privacy Settings 9.6 Privacy Concerns 10. Desktop Mode and Advanced Settings 10.1 Can I Use Desktop Mode......

Words: 14640 - Pages: 59

Premium Essay

Service Request Sr-Rm-004

...Abstract This paper is in response to Riordan Manufacturing service request SR-rm-004 and will analyze the HR system and how to integrate the existing tools in use today into a single application. Riordan is seeking an upgraded system for their human resources department. In this paper I will identify and describe each phase of this new system development life cycle project from beginning to end. We will break down each section to make sure that each phase of the project is well communicated and answer any questions that may arise. The COO of Riordan Manufacturing, requests an analysis of the HR system. The request is for an integration of the existing range of tools into one unified system. Riordan is looking for a modern information system for the human resources department. A system plan to improve human resources department information systems will be the basis of this summary. History and Background of Riordan Manufacturing Riordan Manufacturing Inc. began with Dr. Riordan, a chemistry professor. Dr. Riordan received approval for a few patents that involved processing polymers into super strong plastic substrates. In 1991 Dr. Riordan started Riordan Plastics, Inc. after he discovered the commercial power and economic benefits of his patents. Riordan took on a new direction of paying more attention to research and development. He also made sure he maintained the licenses of those patents he had already obtained to help further is......

Words: 3197 - Pages: 13

Premium Essay

Advance Institute of Competetive Studies

...shares etc. Why Career In Banking With the growing appetite of banks to venture into services and expanding the definition of the term “banking”, there is clearly a huge opportunity for people who want to have banking as their career option. The avenues and opportunities in this sector seem to be limitless with the advent of this new age banking systems. There are currently 81 scheduled commercial banks with a combined network of 53,000 branches in India. With this kind of a growth it comes as no surprise that the banking sector was the largest job provider for the last 3 years. It is estimated that there is a requirement for about 7.5 lakh bank job positions that needs to be filled in the next 5 years. These openings are across the various banking designations: from bank clerks to probationary officers, IT officers. Apart from the MBAs and CAs there is a good scope for technical posts like agricultural officers, industry officers, law officers and economic officers. Career Path of Probationary officer A banks probationary officer is the entry level recruitment for bank officers. They will be trained for accounting, marketing, finance, investment as well as billing and a PO’s career can progress is any one of the mentioned fields. Normally after the confirmation the Bank PO becomes Assistant Bank Manager and may be posted in any branch across the country to handle daily customer transaction like passing a cheque, cash management, draft issuance etc. After considerable......

Words: 1572 - Pages: 7