efficiency_svensson_a0904

efficiency_svensson_a0904 - Efficiency with Excel Anders...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Subject; Efficiency with Excel 1 Efficiency with Excel Anders Svensson, 2009-03-28 Introduction Microsoft Excel is a program with great opportunities. The normal user only uses a fraction of its possibilities. The individual use depends on which tasks your daily work involves. These tasks can be executed in many different ways using Excel. One way is not necessary better than the other; there are however certain tasks that can be executed with greater or lesser efficiency. This essay reflects my personal way of working with Excel. I am still learning new functions and ways of working. Due to the fact that this essay does not necessarily show the most optimal ways, some people who read the essay may have different background and experience, and they might have better solutions. Moreover, that is just the fascinating thing with Excel - a continuous development of knowledge and skills. This essay is neither a basic education nor an advanced course. It is just my recommendations about how Excel can be used with greater efficiency. Many of my ideas are based on my experience of working with excel tables created by other users. Basic efficiency Quick access toolbar In a new installation of Excel, the quick access toolbar is showed above the ribbon. The toolbar only includes Save Undo Repeat Verktygsfältet snabbåtkomst (Swedish) Symbolleiste schnellzugriff (German)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Subject; Efficiency with Excel 2 By clicking on the drop-down list to the right of the toolbar a menu for customizing it is shown. Some commands may be chosen directly from the menu, others can be chosen after selecting “More Commands…”. My recommendation is to include all the commands that are shown directly on the menu. The most efficient way of using the quick access toolbar is to include all the commands that you use frequently. It is also recommendable to show the quick access toolbar below the ribbon, where it is more visual.
Background image of page 2
Subject; Efficiency with Excel 3 Right mouse button The right mouse button includes shortcuts to commands that Excel finds appropriate for the specific situation. By clicking on the right mouse button a menu drops down with the alternatives. The keyboard The keyboard is the fastest and most ergonomic shortcut to many commands. The commands are in most cases applicable to other office-programs. Ctrl + N New Excel Workbook O Open S Save P Print C Copy X Cut V Paste A Mark the whole worksheet or table
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Subject; Efficiency with Excel 4 B Block letters (F if Swedish or German program)* I Italic (K if Swedish or German program)* U Underline* Space Mark a column + Insert a new cell, row or column - Delete a cell, row or column Home Takes you to the top left cell End Takes you to the bottom right cell To the top of the column To the bottom of the column To the right side of a row To the left side of a row Page Up Previous worksheet Page Dn Next worksheet ) Next workbook * On German keyboards the “Ctrl” key is called “Strg”. In order to obtain block, italic or underlined characters in a
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/09/2010 for the course NL MV 00923 taught by Professor Messing during the Spring '10 term at Sveriges lantbruksuniversitet.

Page1 / 18

efficiency_svensson_a0904 - Efficiency with Excel Anders...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online