1 / 9

Basic Excel training KTHFS

Basic Excel training KTHFS. Amadeus Wennström Anders Bergvall 2013-05-02. Agenda Why learn Excel Basics Working in excel How to move in excel C ells The Ribbon and some effective short commands Formulas Formulas for text Freezing cells in formulas Case Find & Replace

devika
Download Presentation

Basic Excel training KTHFS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Basic Excel training KTHFS Amadeus Wennström Anders Bergvall 2013-05-02

  2. Agenda • Why learn Excel • Basics • Working in excel • How to move in excel • Cells • The Ribbon and some effective short commands • Formulas • Formulasfor text • Freezing cells in formulas • Case • Find & Replace • Sort and auto-filter • Formula reference to other sheets • Error handling

  3. Why learn Excel • Microsoft's Excel dominates the marketplace and is found on nearly every business computer • By learning Excel now you will get up to speed much faster and feel more secure when starting your new job • A few uses of Excel • Number crunching: Perform just about any type of financial analysis you can think of • Creating charts and diagrams: Create a wide variety of highly customizable charts • Organizing lists: Use the row-and-column layout to store lists efficiently • Accessing other data: Import data from a wide variety of sources • Creating graphical dashboards: Summarize a large amount of business information in a concise format • Automating complex tasks: Perform a tedious task with a single mouse click with Excel’s macro capabilities

  4. Working in Excel • Fomula bar • A fomula always has to start with an equal sign • Active cell • Market cell • Column headings • A to XFD (Maximum 16384 columns) • Name box • Name of cell or range • Row headings • 1 to 1048576 (Maximum 1048576 rows) • Sheet tabs • Split up data for better controll

  5. How to move around in Excel • To speed up your work in Excel use you keyboard instead of mouse • There is a shortcut for everything!!! • Learn them from the begining and you will save tones of time, Google is you friend • Use arrowkeys to move in data • Ctrl + Arrow key will take you to end of data in choosen direction • Shift + Arrow key will activate/ mark cell in choosen direction • Ctrl + Shift + Arrow key will activete/ mark cells to end of data in choosen direction • Page up will move you one sceen up • Page down will move you one sceen down • Alt + Page up will move you one screen to the left • Alt + Page down will move you one screen to the right • Crtl+ Space willactivate the column • Shift + Space willactivate the row • Crtl + Homewilltakeyouto cell A1 Start the first training in the excel file…

  6. The ribbon and some effective short commands • By pressing Alt you find the short cuts named in the ribbon

  7. Cells • Format cells by pressing Ctrl + 1 • Change the type of number format depending on data • E.g. Date, currency, percentage • Change colour of text and cell • Set a border to the cell or cells • Change protection to the cell to be able to write in it after protecting the whole sheet or workbook with password • Make a new row in a cell by pressing Alt + Enter • Make a bullet in a cell by pressing Alt + 7 or 9 on the numpad

  8. Formulas for text • Problems in data are often one of the most time consuming tasks • Can often be solved with the right knowledge of formulas to get the data in the format that you need • Use text to data if you want to split up text, data that you want to use often comes as a text file and not in nice excel format Formulas often used for text Start the second training in the excel file…

  9. The case Functions • Find & Replace • Sort • Auto-filter • Paste special • Function references to other sheets • STDEV, AVERAGE & MIN/MAX Instructions • Change dots to comma to be able to work with the numbers • Add three new sheets and name them after each company • Use sort and autofilter function to separate the different companies • Add the separated company data to the corresponding sheet • Go to the sheet "Sort data results" • ill in the table by using STDEV, AVERAGE & MIN/MAX functions with references to the company sheets Start the case training in the excel file…

More Related