Suffolk Chamber of Commerce - we mean businessMatrix

Courses / Microsoft Excel Advanced

Microsoft Excel Advanced

Provider
Corazon Training
Summary
1 day advanced course on Microsoft Excel.

About the Course

Target
More experienced users of Excel
Entry requirements
Delegates should already be using Microsoft Excel
Outcome
After completing this course delegates will be able undertake more complex tasks within Microsoft Excel.
Content
Custom Formatting
  • Formatting Numbers
  • Using Custom Formats
  • Custom Number Format
  • Sections
  • Custom Number Format Codes
  • Custom Date Format Codes

  • Using Conditional Formats Working with Named Ranges
  • Creating Range Names
  • Using the Go To Command
  • Range Names in calculations

    Importing and Exporting Data Using Paste Special
  • Object Linking and Embedding
  • Sharing Data with Other Applications
  • Importing a Text File into Excel
  • Importing Data from Web Pages Templates and Add-Ins
  • Creating Workbook Templates
  • Custom Templates; Storing Templates
  • The Default Template
  • Loading Add-In Programs
  • Working with Multiple Workbooks
  • Creating Custom Views
  • Creating a Workspace File
  • Using Workspace Files
  • Linking Workbooks

    Creating Formulae to Link Data Printing Workbooks and Reports
  • Printing Multiple sheets
  • Printing Multiple Workbooks
  • Using the Report Manager Lookup and Reference Functions
  • Using the LOOKUP Function
  • Using the VLOOKUP Function
  • Using the HLOOKUP Function
  • Preventing LOOKUP

    Errors Working with Toolbars
  • Displaying Hidden Toolbars
  • Floating and Docking Toolbars
  • Customising Toolbars
  • Creating a New Toolbar Using Macros
  • Understanding Macros
  • Recording a Basic Macro
  • Running a Macro
  • Assigning a Macro to a Toolbar
  • Button Image Editor
  • Editing a Macro
  • Macro Virus Protection Creating Map Charts
  • Creating Data Map Charts
  • Editing a Map Chart Excel and the Internet
  • Creating Hyperlinks
  • Saving a Worksheet as a Web Page
  • Web Page Preview
  • Sending Worksheets and Workbooks Via E-mail

    Course outlines are for guidance only as training is provided on a consultancy basis to ensure relevant work related issues are covered.
  • Cost
    Training rates are available on request
    Enrolment
    .

    Availability

    Starts
    All training is delivered on clients site and can be either one to one or in groups.
    Duration
    Up to 1 day
    Timetable
    By mutual agreement
    Provider
    Corazon Training

    Venues/Contact

    Main (View map) 146 Woodbridge Road
    IPSWICH
    Suffolk
    IP4 2NS
    UNITED KINGDOM

    Telephone 01473 219593 m: 07702911223

    Fax 01473 219593

    Email info@corazonit.com

    Website http://www.corazonIT.com

    Venue Notes At Client's site:

    Contact Elene Marsden

    Course Ratings and Comments

    There are currently no ratings for this course.

    Rate and comment on this course

    You need to be logged in before you can give a rating and comment on this course.

    Disclaimer

    The information on this website is gathered from third parties and responsibility cannot be accepted on their behalf.

    Where we have signposted to 'Informal Learning' we can not guarantee that all details/links are fully current.

    Join Suffolk TAP

    To get full access to the Courses, Forums, and even add your own courses on the site please register with Suffolk TAP.

    Join TAP