1 / 10

Microsoft Excel 2011

Microsoft Excel 2011. The New Ribbon. Organized by Tabs Specialized Tabs appear depending on the object selected (for example while a chart is selected the Chart Layout tab is displayed) You can now personalize your ribbon. Table Management.

veata
Download Presentation

Microsoft Excel 2011

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Microsoft Excel 2011

  2. The New Ribbon • Organized by Tabs • Specialized Tabs appear depending on the object selected (for example while a chart is selected the Chart Layout tab is displayed) • You can now personalize your ribbon

  3. Table Management • Quickly create, format, and expand an Excel table or apply designer-quality styles to give tables a professional appearance. • You can delete duplicate table rows with the click of a button.

  4. Pivot Tables • The new PivotTable user interface helps you find insights and relationships in your data. • After you create a PivotTable, take advantage of features to summarize, analyze, and format your PivotTable data. • Use styles and banded reports to make your data look professional and attractive.

  5. The New Excel Filter The improved Excel filter helps you sift through large amounts of data by sorting it so you see only the data that you care about.

  6. Conditional Formatting • Microsoft Excel for Mac 2011 makes it easy to find exceptions and spot important trends in your data. • Apply gradient colors, data bars, and icon sets to the values on the cell table.

  7. Sparklines • Sparklines are tiny charts that fit within a cell. They give you at-a-glance insights into your data. • Sparklines reveal patterns to help you see trends, such as seasonal increases or decreases, economic cycles, or maximum and minimum values

  8. Workbook Gallery • The Excel Workbook Gallery provides professional-grade templates that you can customize by adding your own words, pictures, and favorite themes. • Templates make it easy to create common documents in Excel, such as budgets, creating calendars, and more.

  9. Security Measures • Excel for Mac has improved password protection to help prevent unauthorized access to important information. • It provides several layers of security and protection to control who can access and change the data in a workbook:

  10. Training Resources • Microsoft Office 2011 for Mac website - http://www.microsoft.com/mac/how-to • SHSU’s Newton Gresham Library’s Safari Techbooks Online books - http://library.shsu.edu/research/databases/databasesbysubject/computerscience.html • IT@Sam Service Desk – helpdesk@shsu.edu • IT@Sam Instructor led Training (available throughout the fall 2011 semester) – tas017@shsu.edu

More Related