Microsoft Excel 2007 - Level 2

Progressive Training & Development

Short course

Inhouse

Price on request

The best Excel courses

See all

See all

Description

  • Type

    Short course

  • Methodology

    Inhouse

  • Duration

    1 Day

This course spends time on some of the built-in functions and formulae within Excel, as well as exposing you to Excel as a database, adding clipart, WordArt and AutoShapes to enhance your spreadsheet, protecting your sheet from unwanted changes, and exchanging data between Excel and other Office applications.

About this course

You need to be comfortable with Excel basics, including
using sum functions and typical navigation around a spreadsheet.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

DESCRIPTION
This course spends time on some of the built-in functions and formulae within Excel, as well as exposing you to Excel as a database, adding clipart, WordArt and AutoShapes to enhance your spreadsheet, protecting your sheet from unwanted changes, and exchanging data between Excel and other Office applications.

PREREQUISITES
You need to be comfortable with Excel basics, including using sum functions and typical navigation around a spreadsheet.


ADVANCED FILE TASKS
  • Using My Computer within Excel
  • Saving your Files
  • Using Templates

WORKING WITH FUNCTIONS AND FORMULAS
  • Using Formulas in Excel

    • Understanding Relative and Absolute Cell References
    • Basic Mathematical Operators
    • Fixing Formula Errors
    • Displaying and Printing Formulas

  • Exploring Excel Functions

    • What are Functions?
    • Finding the Right Function

  • Using Functions in Excel

    • Inserting Functions
    • Using the IF Function
    • Working with Nested Functions

  • Working with Names and Ranges
  • Working with Array Formulas

    • What are Array Formulas?
    • Using Basic Array Formulas
MANAGING TABLES
  • Working with Records and Fields
  • Working with Records and Fields

  • Working with Tables and Filters
  • Using Excel as a Database

ENHANCING YOUR WORKBOOK
  • Customizing your Workbook
    • Inserting a Symbol or Special Character
    • Adding and Editing Shapes
    • Creating and Altering Diagrams
    • Working with Text Boxes
    • Adding a Text Box
    • Selecting a Text Box
    • Manipulating a Text Box

  • WordArt
  • ClipArt
  • Using Objects

FINALIZING YOUR WORKBOOK
  • Protecting your Workbook
    • Protecting your Workbook
    • Protecting your Worksheets
    • Unlocking Cells

  • Finishing Your Workbook
    • Using the Document Inspector
    • Using the Compatibility Checker
    • Marking a Workbook as Final

  • Using Excel in Word
    • Inserting Excel Data in Word
    • Modifying Excel Data after Insertion

  • Using Excel and Access
    • Linking an Excel Workbook to an Access Database
    • Importing Table, PivotTable, and PivotChart Data from Access

  • Using Excel With other Programs and Files
    • Using Outlook to Send Excel Data
    • Opening an Excel File in a Different Format
    • Importing Data from a Text File
    • Importing Data from External Data Sources
    • Faxing a Workbook

See related categories

Microsoft Excel 2007 - Level 2

Price on request

The best Excel courses

See all

See all