Microsoft Excel 2007 Intermediate Level by nfh12779

VIEWS: 0 PAGES: 3

									                Microsoft Excel 2007 Intermediate Level
2 days; Instructor-Led

Course Outline
Apply Formulas and Functions


   •   Performing One Time Calculations
   •   Converting Formulas and Values
   •   Correcting Calculation Errors
   •   Correcting Formulas
   •   Auditing a Worksheet
   •   Locating Circular References
   •   Performing Calculations Using Functions
   •   Creating Functions
   •   Creating Functions Using the Library
   •   Calculating Multiple Results
   •   Using Nested Functions
   •   Using Constants and Functions in Names

Template for Worksheets and Workbooks

   •   Creating Custom Views
   •   Saving a Workspace Layout
   •   Creating a Template
   •   Opening a Template
   •   Changing a Template

Viewing and Printing Worksheets and Workbooks

   •   Introduction
   •   Setting Up the Page
   •   Adjusting Page Margins
   •   Adding Headers and Footers
   •   Inserting Page Breaks
   •   Customizing Worksheet Printing
   •   Setting the Print Area
   •   Previewing a Worksheet
   •   Printing a Worksheet and Workbook
   •   Creating a PDF Document
   •   Creating an XPS Document

Formatting a Worksheet

   •   Introduction
   •   Formatting Numbers
   •   Formatting Text
   •   Applying Conditional Formatting
   •   Applying Specialized Conditional Formatting
   •   Creating Conditional Formatting
    •   Clearing Conditional Formatting
    •   Managing Conditional Formatting
    •   Finding Conditional Formatting
    •   Changing Data Alignment
    •   Controlling Text Flow
    •   Changing Data Color
    •   Adding Color and Patterns to Cells
    •   Adding Custom Colors
    •   Adding Borders to Cells
    •   Formatting Tabs and Background
    •   Copying Cell Formats
    •   Understanding Color Themes
    •   Viewing and Applying a Theme
    •   Creating Theme Colors
    •   Choosing Theme Fonts
    •   Choosing Theme Effects
    •   Creating a Custom Theme
    •   Choosing a Custom Theme
    •   Applying and Creating Cell Styles
    •   Modifying a Cell Style
    •   Finding and Replacing Cell Formatting

Inserting and Modifying Graphics

    •   Introduction
    •   Locating and Inserting Clip Art
    •   Inserting Media Clips
    •   Accessing Clip Art on the Web
    •   Organizing Clips into Categories
    •   Adding and Removing Clips
    •   Inserting a Picture
    •   Adding a Quick Style to a Picture
    •   Applying a Shape to a Picture
    •   Applying a Border to a Picture
    •   Applying Picture Effects
    •   Modifying Picture Size
    •   Compressing a Picture
    •   Modifying Picture Brightness and Contrast
    •   Recoloring a Picture
    •   Cropping and Rotating a Picture
    •   Creating WordArt Text
    •   Formatting WordArt Text
    •   Applying WordArt Text Effects
    •   Modifying WordArt Text Position
    •   Creating SmartArt Graphics
    •   Using the Text Pane with SmartArt Graphics
    •   Modifying a SmartArt Graphic
    •   Resizing a SmartArt Graphic
    •   Formatting a SmartArt Graphic
    •   Formatting a Shape in a SmartArt Graphic
    •   Creating an Organization Chart
    •   Modifying an Organization Chart
Drawing and Modifying Shapes

   •   Introduction
   •   Drawing and Resizing Shapes
   •   Inserting Multiple Shapes
   •   Adding Text to a Shape
   •   Drawing Lines and Arrows
   •   Creating and Editing Freeforms
   •   Copying and Moving Objects
   •   Adding a Quick Style to a Shape
   •   Adding a Quick Style to Shape Text
   •   Applying Color Fills
   •   Applying Picture Fills
   •   Applying Texture Fills
   •   Applying Gradient Fills
   •   Applying Shape Effects
   •   Adding 3-D Effects to a Shape
   •   Adding 3-D Rotation Effects to a Shape
   •   Creating Shadows
   •   Aligning and Distributing Objects
   •   Connecting Shapes
   •   Selecting Objects Using the Selection Pane
   •   Changing Stacking Order
   •   Rotating and Flipping a Shape
   •   Grouping and Ungrouping Shapes
   •   Adding a Shape to the Clip Organizer

Creating and Modifying Charts

   •   Introduction
   •   Understanding Chart Terminology
   •   Choosing the Right Type of Chart
   •   Creating a Chart
   •   Editing a Chart
   •   Moving and Resizing a Chart
   •   Selecting Chart Elements
   •   Changing a Chart Type
   •   Changing a Chart Layout and Style
   •   Formatting Chart Elements
   •   Changing Chart Gridlines and Axes
   •   Changing Chart Titles
   •   Changing Chart Labels
   •   Pulling Out a Pie Slice
   •   Formatting Chart Data Series
   •   Formatting Chart Text
   •   Formatting Line and Bar Charts
   •   Changing the Chart Background
   •   Enhancing a Chart
   •   Editing Chart Data
   •   Adding and Deleting a Data Series
   •   Saving a Chart Template
   •   Managing Chart Templates

								
To top