how to use data analysis in excel for non numerical value

Right click on any item in the Office Button or the Ribbon and click Add to Quick Access Toolbar and a shortcut will be added. You can also add items to the quick access toolbar. To change the location of the quick access toolbar, click on the error at the end of the toolbar and click Show Below the Ribbon. You can place the quick access toolbar above or below the ribbon. The quick access toolbar is a customizable toolbar that contains commands that you may want to use. View: Workbook Views, Show/Hide, Zoom, Window, Macros Page Layouts: Themes, Page Setup, Scale to Fit, Sheet Options, Arrangeįormulas: Function Library, Defined Names, Formula Auditing, Calculationĭata: Get External Data, Connections, Sort & Filter, Data Tools, Outline Insert: Tables, Illustrations, Charts, Links, Text Home: Clipboard, Fonts, Alignment, Number, Styles, Cells, Editing To view additional features within each group, click the arrow at the bottom right corner of each group. The groups are logical collections of features designed to perform function that you will utilize in developing or editing your Excel spreadsheets.Ĭommonly utilized features are displayed on the Ribbon. The ribbon is the panel at the top portion of the document It has seven tabs: Home, Insert, Page Layouts, Formulas, Data, Review, and View. This button allows you to create a new workbook, Open an existing workbook, save and save as, print, send, or close. The Microsoft Office Button performs many of the functions that were located in the File menu of older versions of Excel. The workbook is the holder for related worksheets. An Excel spreadsheet can contain workbooks and worksheets. A cell can contain data and can be used in calculations of data within the spreadsheet. A cell is where the column and row intersect. There are vertical columns and horizontal rows. SpreadsheetsĪ spreadsheet is an electronic document that stores various types of data. The function of these features will be more fully explored below. There are three features that you should remember as you work within Excel 2007: the Microsoft Office Button, the Quick Access Toolbar, and the Ribbon. You will also notice that there are many new features that you’ll be able to utilize. Getting started with Excel 2007 you will notice that there are many similar features to previous versions.

How to use data analysis in excel for non numerical value