Excel

Introduction to Microsoft Excel 2010

This class is designed to cover the following basics: What you can do with Excel Excel Ribbon Moving and selecting cells Formatting cells Adding Worksheets, Rows and Columns Resizing Rows and Columns Freezing Panes Formulas Functions Sorting Charts Autofill Styles

Microsoft Excel 2010

Excel allows you to create spreadsheets much like paper ledgers that can perform automatic calculations. Each Excel file is a workbook that can hold many worksheets. The worksheet is a grid of columns (designated by letters) and rows (designated by numbers). The letters and numbers of the columns and rows (called labels) are displayed in gray buttons across the top and left side of the worksheet. The intersection of a column and a row is called a cell. Each cell on the spreadsheet has a cell address that is the column letter and the row number. Cells can contain text, numbers, or mathematical formulas.

Microsoft Excel 2010 Screen Elements

Excel Ribbon Traditional menus and toolbars from earlier versions were left behind in the 2010 Microsoft products. They have been replaced with the Ribbon. The Ribbon is the row of icons and short cuts that perform commands and function, depending on what Ribbon Tab you have selected. The Ribbon is arranged into groups of related commands. Here’s a quick overview of Excel’s Ribbon tabs: File: You can Save, Save As, Open, Close, Print and create a New workbook using this Tab. The File Tab does not look like the rest of the Ribbons you’ll see when you click on the row of menu options. Instead, in the File Tab, you see the above options (and more) listed on the left-hand side of the screen. In addition, you can set Permissions, set up the file to be Shared with others and access Version Management in the middle of the screen. You can also look at the Properties of the file on the right-hand side of the screen. Microsoft sometimes refers to what you see when you click on the File Tab as the “Backstage View”....