where is the data analysis tool in excel 2011

Pro Tip: Use the Data Validation function to ensure consistency in cells.

You also access the sort, filter, remove duplicates, data validation, consolidation, group, ungroup, and subtotal functions on the Data menu.

The Data menu also contains many important functions in Excel, including imports and connections with databases. Pro Tip: You can name cells or ranges of cells-this can make it easier to customize your formulas. Excel comes with lots of formulas including financial, logical, text, date & time, lookup & reference, and math & trigonometry. The Formulas menu is where you find all the number-crunching options. Just click Background and select the image you want to use. Pro Tip: You can add a background to a collection of cells-or even your entire spreadsheet. You can also customize cell height and width on the Page Layout menu. You’ll see many options for configuring pages for viewing and printing-including page size, margins, colors and fonts, and so forth. Page LayoutĪgain, the name suggests the collection of functions on the Page Layout menu. Pro Tip: You can also insert hyperlinks and even maps using the Insert menu. You can insert a variety of things ranging from pivot table to picture, clip art, shapes, screen shots, charts and graphs, text box, header and footer, symbols, equation, and more. InsertĪs the name suggests, the Insert menu helps you insert various options and items into an Excel spreadsheet. It allows you to copy the formatting from one cell to another, which can be a great time saver. All these functions help one in performing various effective calculations. The Home ribbon items include options for formatting font, color, conditional formatting, filter, number type, and more. The Home menu is the second menu in the Excel menu bar. Instead, the File menu appears in the Application Menu Bar. Pro Tip: The File menu does not appear as a ribbon in Excel for Mac. You also use the File menu to import from external sources into Excel, along with options that allow you to tweak Excel itself. The File ribbon items enable you to perform file management functions, including open, save, close, and print. The File menu is the leftmost item in the Excel ribbon.

Where is the data analysis tool in excel 2011