Microsoft Excel Intermediate - 2003 or 2007 Version courses available

» Course Outline

    More Functions and Formulas
            Formulas with several operators and cell ranges
            Using the Insert function feature
            Creating and using range names
            Selecting nonadjacent ranges and using autocalculate
            Using the IF function to create conditional formulas
            Using the PMT function
            Displaying and printing formulas
            Fixing formula errors
            The Watch window
            Using the series command

    Creating and Working with Charts
            Creating a chart
            Moving and resizing a chart
            Formatting and editing objects in a chart
            Changing a chart’s source data
            Changing a chart type and working with pie charts
            Adding titles, gridlines and a data table
            Formatting a data series and chart axis
            Annotating a chart
            Working with 3D charts
            Selecting and saving a custom chart
       

    Using fill effects
   

        

        

Working with Lists

            Creating a list
            Working with lists and using the total row
            Adding records using the data form dialog box and insert row
            Finding records
             Deleting records
            Sorting a list
            Filtering a list with the auto filter
            Creating a custom auto filter list
            Filtering a list with an advanced filter
            Copying filtered records
            Using data validation

Working with Other Programs

            Inserting an Excel worksheet into a Word document
            Modifying an inserted excel worksheet
            Inserting a linked Excel Chart in a Word document
            Managing links
             Inserting a graphic into a worksheet
            Opening and saving files in different formats

Using Excel with the Internet

            Adding and working with hyperlinks
            Browsing hyperlinks and using the web toolbar
            Saving a workbook as a non-interactive web page
            Saving a workbook as an interactive web page
            Import an external data source
            Refresh a data source and set data source properties
            Create a new web query

More Editing and Formatting

            Paste special
            Creating a custom number format
            Creating, applying and modifying a style
            Conditional formatting
            Finding and replacing formatting

Working with Templates

            Creating templates
            Protecting worksheets
            Protecting workbooks
            Security

Customising Excel

            Hiding, displaying and moving toolbars
            Customising Excel’s toolbars
            Creating a custom auto fill list
            Changing Excel’s options
            Saving a custom view

    Excel 2003 / 2007 and Other Applications
            Converting Files from Other Applications
            Copying Data from Another Application
            Embedding and Linking Objects
            Hyperlinks
            Managing Links


» Prerequisites
Attendees should have already completed our Microsoft Excel Introductory course or have skills to that level. 

» Assessment
On completion of this course, attendees will be provided with a Certificate of Participation.

» Duration
1 Day - 9:00am to 4:00pm.

» Cost
$299.00 (Inc GST) per person - Attend this course and Microsoft Excel Advanced for only $499.00! 

» Dates
Please visit our timetable for current dates.

» Registration
To register for this course please click here.

» More Infomation
If you require more infomation please don't hesitate to contact us.