重复上一次“查找”操作：SHIFT+F4 在保护工作表中的非锁定单元格之间移动：TAB 2>Excel快捷键之处于END模式时在工作表中移动 打开或关闭 END 模式：END 在一行或列内以数据块为单位移动：END, 箭头键 移动到工作表的最后一个单元格.：END, HOME 在当前行中向右移动到最后一个非空白单元格。：END, ENTER 3>Excel快捷键之处于“滚动锁定”模式时在工作表中移动 打开或关闭滚动锁定：SCROLL LOCK 移动到窗口中左上角处的单元格：HOME 移动到窗口中右下角处的单元格：END 向上或向下滚动一行：上箭头键或下箭头键 向左或向右滚动一列：左箭头键或右箭头键 4>Excel快捷键之用于预览和打印文档 显示“打印”对话框：CTRL+P 在打印预览中时： 当放大显示时，在文档中移动：箭头键 当缩小显示时，在文档中每次滚动一页：PAGE UP 当缩小显示时，滚动到第一页：CTRL+上箭头键 当缩小显示时，滚动到最后一页：CTRL+下箭头键 5>Excel快捷键之用于工作表、图表和宏 插入新工作表：SHIFT+F11 创建使用当前区域的图表：F11
Words: 505 - Pages: 3
Qualifications: The successful candidate will have strong accounting knowledge and financial analytic abilities. The candidate should be passionate about the use of technology to solve business problems, including a very high proficiency with MS Excel, notably pivot tables and formulas. The candidate must be extremely detail oriented and have the ability to sort through and summarize detailed information to senior management. The candidate must be able to work closely with the accounting groups
Words: 347 - Pages: 2
outline for the following: 1. Information about the presentation of written work; 2. Late assignment policy. REQUIRED: This assignment comprises two case studies and you are required to complete them as an individual assignment (i.e. not group work). An excel spreadsheet program, may be used where necessary, but is not compulsory. An Assignment Cover Sheet should be completed, signed and attached to the hard copy of the assignment prior to being handed in. These forms are available at the Front Office.
Words: 398 - Pages: 2
investment and salvage Warranty costs WACC NPV and IRR Any other supporting exhibits you feel are relevant A file containing your spreadsheet file, including all supporting elements. I want to get a sense of how well you used the power of the Excel program to make your calculations. A simple typed report is adequate. I do not need fancy graphics or covers. Use 12 pitch, Times Roman font for the body of the report. Single spacing is preferred, and will allow you more than enough space to
Words: 313 - Pages: 2
Reports and Memos * The most straightforward use of Microsoft Word for businesses is word processing. As such, Word offers the ability to type and lay out reports, memos, letterheads, and other written business papers. Word has several key built-in functions, including bold, italics, underlining, super- and sub-script, paragraph and line formatting, bullet points, and so forth. The page layout function allows users to customize the size and format of the paper they are trying to create. Flowcharts
Words: 1550 - Pages: 7
How to calculate Present Value in MS Excel 2007 1. Suppose followings are the cash flows Cash Flows | 1500 | 2100 | 1545 | 1987 | 2500 | 2. The discount rate is 15%. 3. Write the cash flows in a column for example in column C starting from C5 to C9. 4. Now at a cell (e.g. in E5) write the following formula =PV(0.15,5,C5:C9) 5. Now Press ENTER button and you will get the present value (Notice that the figure is red in color and has a negative sign like the following
Words: 291 - Pages: 2
Unit 4 discussion Board By: Karen Horne 9 June 24, 2011 The tools that can be of use to Ms Excel for helping to interpret data is that it can be used for forecasting, control charts, summary charts and also regression analysis and the last would be the simulations. However when it comes to Ms Excel it will provide the necessary tools so the person (s) will be able to manage their projects. Ms Excel will help the manager keep track of all the important records and inventories and this can be done
Words: 257 - Pages: 2
versus their current database, Microsoft Excel. Team B will explain the usefulness of converting data currently held in Microsoft Excel into a relational database using Microsoft Access. Team B will also introduce types of collaborative software; how this software can improve communications and streamline work processes. Microsoft Excel Microsoft Excel is the most used spreadsheet program (Grauer, Poatsy, Mulbery, Hulett, Krebs, & Mast, 2011). In Excel, a worksheet is a single spreadsheet that
Words: 691 - Pages: 3
Activity 6.6 – Module Problems Complete the following problems and submit the results in either a Microsoft Word document or a Microsoft Excel spreadsheet. If you choose to use an Excel spreadsheet, place each problem on a separate sheet and label the tab with problem number. Save your document with a descriptive file name, including the assignment and your name. | 6-1 The famous Y. S. Chang Restaurant is open 24 hours a day. Waiters and busboys report for duty at 3am, 7am, 11am, 3pm, 7pm, or
Words: 1387 - Pages: 6
done correctly, for example, time frame, or number of completed tasks per week) Responsibility 2 – for example, “to manage the daily operations of the office including organising mail, couriers, catering and travel. Staff need to be able to use MS EXCEL confidently, to arrange global travel and to work on their own.” Work standard – for example, “at the end of each working week, all catering events for the following week must be finalised.” Responsibility 3 – (insert additional items as needed)
Words: 409 - Pages: 2
