Lesson 1a-Introduction to Microsoft Excel_46a2ff42_240924_163101.pdf

LABORATORY Introduction to Microsoft Excel Lesson Objectives At the end of this session, you are expected to: 1. Understand the basic Microsoft Excel interface, including ribbons, worksheets, cells, and the formula bar. 2. Enter and modify text, numbers, as well as navigate the worksheet, and...

LABORATORY Introduction to Microsoft Excel Lesson Objectives At the end of this session, you are expected to: 1. Understand the basic Microsoft Excel interface, including ribbons, worksheets, cells, and the formula bar. 2. Enter and modify text, numbers, as well as navigate the worksheet, and edit cell content. 3. Understand formula syntax (starting with "=") and use simple math operators (+, -, *, /). 4. Apply basics of sorting & filtering, inserting a table, and inserting dropdown lists What is Microsoft Excel? It is a spreadsheet program developed by Microsoft. Excel organizes data in columns and rows and allows you to do mathematical functions. It runs on Windows, macOS, Android and iOS. The first version was released in 1985 and has gone through several changes over the years. However, the main functionality mostly remains the same. Excel is typically used for: Analysis Data analysis Data entry Visuals and graphs Data management Programming Accounting Financial modeling Budgeting And much, much more! Why Use Microsoft Excel? It is the most popular spreadsheet program in the world It is easy to learn and to get started. The skill ceiling is high, which means that you can do more advanced things as you become better It can be used with both work and in everyday life, such as to create a family budget It has a huge community support It is continuously supported by Microsoft Templates and frameworks can be reused by yourself and others, lowering creation costs Navigating the Excel Environment + + + + + + + + + + + + Navigating the Excel Environment + + + Quick Access Toolbar The Quick Access Toolbar + + you access common lets commands no matter which + tab is selected. You can customize the commands depending on your preference. + + + + + + Navigating the Excel Environment + + + The Ribbon + all of the + Ribbon contains The commands you will need to + perform common tasks in Excel. It has multiple tabs, each with several groups of commands. + + + + + + Navigating the Excel Environment + + + + + Name Box + The Name box displays the location, or+name, of a selected cell. + + + + + Navigating the Excel Environment + + + + + Formula Bar + In the formula bar, you can + enter or edit data, a formula, or a function that will appear in a specific cell. + + + + + Navigating the Excel Environment + + + + + + Column + A column is a group of cells that runs from the top of the page to the bottom. In Excel, columns are identified by letters. + + + + + Navigating the Excel Environment + + + + + + + Cell Each rectangle in a workbook is called a cell. A cell is the intersection of a row and a column. Simply click to select a cell. + + + + + Navigating the Excel Environment + + + + + + + Row A row is a group of cells that runs from the left of the page to the right. In Excel, rows are identified by numbers. + + + + + Navigating the Excel Environment + + + + + + + Worksheets Excel files are called + workbooks. Each workbook holds one or more worksheets. Click the tabs to switch between them, or right- click for more options. + + + + Navigating the Excel Environment + + + + + + + Vertical and Horizontal Scroll Bars + The scroll bars allow you to scroll up and down or side to side. To do this, click and drag the vertical or horizontal scroll bar. + + + + Navigating the Excel Environment + + + + + + + + Zoom Control Click and drag the slider to use the zoom control. The number to the right of the slider reflects the zoom percentage. + + + + Navigating the Excel Environment + + + + + + + Worksheet View + Options There are three ways to view a worksheet. Simply click a command to select the desired view. + + + + Navigating the Excel Environment + + + Tell me + + The Tell me box works like a search bar to help you + quickly find tools or commands you want to use. + + + + + + Welcome to Excel: Take a tour to the most popular spreadsheet app