Home > Courses > Office Automation Windows > Distance > Egremont > Excel 2007 Training Course - Distance

Excel 2007 Training Course - Distance

Speak without obligation to UK Open Learning

To contact you must accept the privacy policy

Comments about Excel 2007 Training Course - Online

  • Academic Title
    Excel 2007 Training Course
  • Course description
    Excel 2007 Training Course

    Office applications evolve to fit new challenges and add innovative features for ease of use and convenience. Whether you are a small to medium business or a corporation, you will use spreadsheets to analyze data and do projections. If you're a spreadsheet novice or an experienced professional, the Excel 2007 course from LearnKey can help you master spreadsheets. LearnKey expert Michael Meskers uses practical examples to show you Excel fundamentals before moving step-by-step into more advanced topics like graphs, charts, formulas and macros.

    Benefits

    • Learn skills in one of the most powerful spreadsheet programs.

    • Produce impressive business documents easily and quickly.

    • Enhance your personal productivity and promotional value.

    Course Outline:

    Session 1
    Section A: Introduction

        * What You Will Learn
        * Excel 2007 Interface
        * Ribbon and Tabs
        * Document Windows
        * Navigation Tips

    Section B: Creating and Manipulating Data

        * Entering Data
        * AutoFill a Series
        * Fill Non-Adjacent Cells
        * AutoFill on Multiple Sheets
        * Creating Custom Lists
        * Series Formatting

    Section C: Managing Worksheets

        * Copying Worksheets
        * Inserting and Deleting Worksheets
        * Hiding Worksheets

    Section D: Data Integrity

        * Validation Criteria
        * Character Validation
        * Drop-Down Lists

    Section E: Modifying Cell Content

        * Cut, Copy, Paste
        * Transposing Data
        * Copy Cell Format Only
        * Removing Duplicates
        * Data Validation

    Section F: Changing Views

        * Zoom Features
        * Workbook Views
        * Page Layout View
        * Repeating Cell Content
        * Freeze Panes
        * Split Windows
        * Viewing Multiple Windows
        * Saving Hot Links
        * Hiding the Ribbon

    Session 2
    Section A: Formatting Data

        * Formatting Worksheets
        * Worksheet Backgrounds
        * Watermarks

    Section B: Modifying Rows and Columns

        * Inserting Rows
        * Inserting Columns
        * Cutting and Inserting Columns
        * Modifying Cell Width/Height
        * Inserting Multiple Rows and
        * Columns
        * Inserting and Deleting Cells
        * Formatting Rows and Columns
        * Hiding/Unhiding Rows and
        * Columns

    Section C: Formatting Numbers

        * Currency Format
        * Format Painter
        * Formatting Dates
        * Special Formats
        * Cell Styles

    Section D: Formatting Text and Tables

        * Fonts, Fills, and Alignment
        * Comments
        * Merging and Splitting Cells
        * Inserting Hyperlinks
        * Formatting as a Table
        * Summary Function

    Section E: Understanding Formulas

        * Using Operations
        * Creating
        * Formulas
        * AutoSum
        * Common Functions
        * Searching for Functions
        * Copying Formulas
        * Absolute Cell References

    Session 3
    Section A: Referencing Formulas

        * Dependent References
        * Multiple Sheet References
        * Consolidating Data
        * Consolidating with Links

    Section B: Ranges and Dates

        * AutoSum
        * Cell Names
        * Formulas with Cell Names
        * COUNT
        * COUNTA
        * Date Formulas

    Section C: Subtotals

        * Overview
        * Subtotal Options
        * Selecting Visible Data

    Section D: Lookups

        * Lookups Purpose
        * VLOOKUP
        * VLOOKUP Exact Match
        * HLOOKUP
        * HLOOKUP Exact Match

    Section E: Conditional Logic

        * IF Syntax
        * IF Statement
        * Nested IF
        * Nested IF Syntax

    Section F: More Conditional Logic

        * AND
        * OR
        * NOT
        * IFERROR
        * SUMIF
        * AVERAGEIF
        * COUNTIF
        * SUMIFS
        * AVERAGEIFS
        * COUNTIFS

    Session 4
    Section A: Financial Formulas

        * Future Value
        * Payment
        * Goal Seek
        * Changing Rate
        * Scenario Manager

    Section B: Text Formulas

        * Case Formulas
        * Paste Column Widths
        * Operations in Paste Special
        * Skip Blanks
        * AutoCalculate
        * Fix Number Fields
        * Trim Spaces
        * Substitute Text

    Section C: Introduction to Charts

        * Chart Types
        * Instant Chart
        * Update Chart
        * Column Chart
        * Picture Fill
        * Adjust Chart Size
        * Line Chart
        * Scatter Chart

    Section D: Formatting Charts

        * Chart Styles
        * Chart Layouts
        * Add Labels
        * Axis Options
        * Chart Title
        * Legends
        * Data Labels

    Section E: Conditional Formatting

        * Highlight Cells Rules
        * Top/Bottom Rules
        * Data Bars
        * Colour Scales
        * Custom Formatting Rule
        * Text Formatting

    Section F: Adding Graphics to Spreadsheets

        * Insert Pictures
        * Modifying Pictures
        * Insert Shapes
        * Insert SmartArt
        * Apply Themes

    Session 5
    Section A: Outlining, Sorting, and Filtering

        * Group and Ungroup
        * Sort Data
        * Sort Multiple Levels
        * Filter Data
        * Advanced Filter
        * Conditional Sorting and Filtering
        * Sorting and Filtering Data
        * Attributes

    Section B: PivotTables

        * Overview
        * Creating PivotTables
        * Choosing Fields
        * Sub Fields
        * PivotTable Layout
        * Filtering PivotTables
        * Totals
        * Modifying PivotTable Data
        * PivotCharts

    Section C: Protecting Data

        * Workbook Passwords
        * Protecting Workbooks
        * Hiding Worksheets
        * Unlocking Cells

    Section D: Collaboration

        * Document Properties
        * Formatting Comments
        * Document Inspector
        * Sharing a Workbook
        * Track Changes
        * Accept/Reject Changes
        * Information Rights Management
        * Using IRM
        * Signature Line
        * Mark as Final

    Section E: Saving a Workbook

        * Save As Previous Version
        * Templates
        * Save As PDF
        * Save As Web Page
        * Macro-Enabled Workbook

    Section F: Printing

        * Page Orientation
        * Page Breaks
        * Print Area
        * Margins
        * Headers and Footers
        * Scaling

Other programs related to Office Automation Windows

This site uses cookies. If you continue navigating, the use of cookies is deemed to be accepted. See more  |