RMD Training - Hull

 

RMD Business Excel 2007 Intermediate Syllabus

 

This course is designed for delegates who have a working knowledge of Microsoft Excel 2007 and covers common tasks required to allow you to work more efficiently.

 

If the course syllabus does not entirely match your requirements, please contact us as we are able to customise it to your needs.

 

This course has a duration of 1 day.

 

Advanced File Tasks

 

Using My Computer within Excel

  • Using the My Places Toolbar
  • Navigating with My Computer
  • Performing Basic Tasks with My Computer
  • Changing Views

     

    Saving your Files

  • File Formats
  • File Properties
  • AutoRecover
  • Upgrading a Workbook

     

    Using Templates

  • Opening a Template
  • Downloading a Template
  • Using a Template
  • Creating a Template

     

    Working with Functions and Formulas

     

    Using Formulas in Excel

  • Understanding Relative and Absolute Cell References
  • Basic Mathematical Operators
  • Using Formulas with Multiple Cell References
  • The Formula Auditing Buttons
  • Fixing Formula Errors
  • Displaying and Printing Formulas

     

    Exploring Excel Functions

  • What are Functions?
  • Finding the Right Function
  • Some Useful and Simple Functions

     

    Using Functions in Excel

  • Inserting Functions
  • Using Functions and AutoFill to Perform Difficult Calculations
  • Using the IF Function
  • Working with Nested Functions

     

    Working with Names and Ranges

  • What Are Range Names?
  • Defining and Using Range Names
  • Selecting Nonadjacent Ranges
  • Using AutoCalculate

     

    Working with Array Formulas

  • What are Array Formulas?
  • Using Basic Array Formulas
  • Using Functions with Array Formulas
  • Using the IF function in Array Formulas

     

    Managing Tables

     

    Working with Tables

  • What is a Table?
  • Creating Tables
  • Modifying Tables
  • What is the Total Row?

     

    Working with Records and Fields

  • What are Records and Fields?
  • Adding Fields by Inserting Columns
  • Adding Records by Inserting Rows
  • Quickly Adding Records to a Data Table
  • Deleting Records or Fields

     

    Working with Tables and Filters

  • Sorting Data in a Table
  • What is an AutoFilter?
  • Custom AutoFilters
  • Using an Advanced Filter
  • Copying Filtered Records

     

    Using Excel as a Database

  • Filtering with Wildcard Characters
  • Validating Your Data
  • What are Database Functions?

     

    Enhancing your Workbook

     

    Customising your Workbook

  • Inserting a Symbol or Special Character
  • Adding and Editing Shapes
  • Creating and Altering Diagrams
  • Changing the Diagram Type
  • Incorporating Text
  • Adding a Signature Line

     

    Working with Text Boxes

  • Adding a Text Box
  • Selecting a Text Box
  • Manipulating a Text Box
  • Formatting a Text Box

     

    WordArt

  • Adding WordArt to your Spreadsheet
  • Changing the Font Colour
  • Changing the Outline Colour
  • Adding Effects

     

    ClipArt

  • Finding ClipArt
  • Inserting ClipArt
  • Manipulating ClipArt
  • Inserting a Photographic Image

     

    Using Objects

  • Creating New Embedded Objects
  • Embedding Existing Files
  • Editing Embedded Objects
  • Embedding Parts of Files

     

    Finalizing Your Workbook

     

    Protecting your Workbook

  • Protecting your Workbook
  • Protecting your Worksheets
  • Unlocking Cells
  • Protecting your Excel Files

     

    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
  • Linking Excel Data in a Word Document
  • Modifying Excel Data after Insertion
  • Insert an Excel Chart into a Word Document

     

    Using Excel and Access

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

     

    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
  • Publishing a Workbook as a PDF File
  • Faxing a Workbook

     

     

    •