Download to read offline
![Agentic Systems and Compliance - A brief intro [1.2]](https://cdn.slidesharecdn.com/ss_thumbnails/agenticsystemsandcompliace-1-251018025303-958a42ec-thumbnail.jpg?width=600ounds&width=560&fit=bounds)
Microsoft Excel tutorial for enhamcing data analysis
- 1. Microsoft Excel Instructors: Connie Hutchison &Christopher McCoy
- 2. …Microsoft Excel isthe spreadsheet component of the Microsoft Office Suite. It is used primarily to enter, edit, format, sort, perform mathematical computations, save, retrieve and print numeric data. Microsoft Excel…
- 3. • Identify themain components of the program. • Identify the purpose of the commands on the menu bar. • Work with the buttons on the toolbar. Objectives
- 4. • Work withtext and numbers. • Explain the use of primary keyboard shortcuts and key combinations. • Enter data into a spreadsheet. Objectives
- 5. • Perform basicmathematical operations in a spreadsheet. • Insert charts into a spreadsheet. • Explain the purpose of options available for printing a spreadsheet. Objectives
- 6. • Explain thedifference between a workbook and a spreadsheet. • Successfully move from one cell to another containing formulas and text. Objectives
- 7. • Understand absoluteand relative cell references. • Copy, Cut and Paste text and formulas. • Use the fill function for dates and formulas. Objectives
- 8. Screen Components The openingscreen for Microsoft Excel 2010 looks like this…
- 9. While different versionshave different appearances, they all have most of the same features. If you know what to call it, you should be able to find it in other versions. Terminology
- 10. The area outlinedin red is called the title bar. It displays the names of the open program (in this case Microsoft Excel) and the name of the current file.
- 11. This file hasnot yet been saved so its name is Book2. Files created in Microsoft Excel are often referred to as spreadsheets or workbooks and have the file extension .xls or .xlsx
- 12. The area outlinedin red contains the minimize, maximize/restore and close buttons for the program window.
- 13. These three buttonsare on almost every window that opens in a Windows based platform. They are on Mac windows as well, but they are circles instead of squares.
- 14. When you clickthe minimize button the program becomes a button on the Windows taskbar located at the bottom of the screen.
- 15. You can restorethe document to its original shape and size by either: Clicking on the button on the task bar one time to restore it to active mode,
- 16. If you havemultiple files from the same program open you will need to select the one you want to restore to active mode.
- 17. When you clickthe maximize / restore button the program assumes the same shape and size it was before you minimized it. Or The program window will fill the screen.
- 18. When you clickthe close button the program will ask you if you want to save the changes if you have made any changes. Once you have responded to this question the program will close.
- 19. The area outlinedin red is called the quick access toolbar. It contains the most commonly used commands in Microsoft Excel: 1. Save 2. Undo 3. Repeat
- 20. Microsoft Office 2007& 2010 use what is referred to as the “Ribbon” interface. The area outlined in red is the Ribbon. The ribbons we are going to go over today are the default ribbons.
- 21. You may customizethe ribbon and or a group on the ribbon on your personal computer to have only the features you want to use. In order to do this all you have to do is right mouse click on the ribbon or the group you want to customize.
- 22. The words File,Home, Insert, etc… outlined in red are referred to as tabs. Each Tab has several Groups attached to it.
- 23. The area outlinedin red is referred to as the worksheet and most of its components remain the same regardless of which tab you are currently using.
- 25. The File Tabmenu contains the commands most commonly associated with the file.
- 26. The Home TabGroups contain the commands most commonly associated with the formatting and editing of cells and their contents. Clipboard Font Alignment Number Styles Cells Editing
- 27. The Insert TabGroups contain the commands most commonly associated with adding something to the document. Tables Illustrations Charts Sparklines Filter Links Text Symbols
- 28. The Page LayoutGroups contain the commands most commonly associated with settings that would affect the entire page or worksheet. Themes Page Setup Page Background Paragraph Arrange
- 29. The Formulas Groupscontain the commands most commonly associated with Excel’s formulas and functions. Function Library Defined Names Formula Auditing Calculation
- 30. The Data Tabgroups contain the commands most commonly associated with data from external sources, and evaluating or arranging data. Get External Data Connections Sort & Filter Data Tools Outline
- 31. The Review Tabsgroups contain the commands most commonly associated with the text portions of a spreadsheet and sharing changes. Proofing Language Comments Changes
- 32. The View Tabgroups contain the commands most commonly associated with the variety of ways you can “look at” a worksheet or workbook. Workbook Views Show Zoom Window Macros