Microsoft Office Excel 2008 Level 2 Macintosh
Course Description
In Microsoft Office Excel 2008 Level 1 Macintosh, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel 2008 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.
1 days
Contact us for pricing
Prerequisites
Before starting this course, participants are recommended to take the following course: Microsoft Office Excel 2008 Level 1 MacintoshCourse Objective
You will apply visual elements and advanced formulas to a worksheet to display data in various formats.Calculating Data with Advanced Formulas
Manage Cell and Range NamesCalculate Data Across Worksheets
Use Specialized Functions
Analyze Data with Logical and Lookup Functions
Organizing Worksheet and List Data
Create ListsSort or Filter List Data
Presenting Data Using Charts
Create a ChartModify Charts
Format Charts
Analyzing Data Using PivotTables
Create a PivotTable ReportAnalyze PivotTable Data
Inserting Graphic Objects
Insert and Modify Pictures and ClipArtDraw and Modify Shapes
Illustrate Workflow Using SmartArt Graphics
Arrange and Group Graphic Objects
Customizing and Enhancing Workbooks and the Excel Environment
Customize the Excel EnvironmentCustomize Workbooks
Manage Themes
Create and Use Templates
Advanced Excel