Excel 2003 Intermediate

ELECTUS
Adelaide, SA, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' In this 2 day program, you will learn advanced editing and formatting and expand your working knowledge of formulas and graphs. You will also explore the powerful database tools within Excel



You will learn to

Ø How to automate data entry

Ø Use a wider range of functions and formulas including conditional statements

Ø Set up complex formatting

Ø Customise number, date and time formats

Ø Creating and edit custom charts

Ø Add drawing objects and diagrams

Ø Create and query a database

Ø Work in multiple worksheets



What skills you need

You should already have some experience in using Excel functions and formulas writing as well as cell formatting, number formatting and creating simple graphs.

Course Content
Creating Web (HTML) files

· Saving a worksheet as a Web page

· Creating a hyperlink

· Editing a hyperlink

· Previewing a Web page

· Using Publihing options

· Opening an HTML file

Using Multiple Workbooks

· Copying Data between workbooks

· Comparing workbooks side by side

· Saving a Workspace

· Linking Workbooks

Working with Columns & Rows

· Selecting Columns & Rows

· Hiding/Unhiding Columns & Rows

More Formulas & Functions

· Using Function arguments

· Using Financial functions

· More Logical functions

· Using Lookup Functions

· Using Maths Functions

· Using Nested Functions

· Limiting the Precision of numbers

Managing Worksheets

· Copying & moving worksheets

· Using Grouped worksheets

· Creating 3D formulas

· Using 3D ranges in Functions

Using Worksheet Protection

· Unlocking cells

· Protecting a worksheet

· Unprotecting a worksheet

· Managing allow-editing ranges

· Hiding a worksheet

· Protecting workbook windows

· Assigning a password
Working with Data Series

· Creating a Linear Series

· Creating a Data Series

· Using a stop value

· Creating a Growth Trend series

· Creating Custom Lists

Using Paste Special

· Copying values between worksheets

· Copying formulas between worksheets

Using Page Setup

· Customising Headers & Footers

· Repeating row and columns labels

· Scaling a worksheet

Using Range Names

· Using range names in formulas

· Creating range names

· Applying range names

· Deleting range names

Working with Labels in Formulas

· Using labels to define a range

· Using multiple stacked labels

· Using labels to refer to cells

Using Conditional and Custom Number Formats

· Applying conditional formats

· Creating custom formats

Drawing Objects & Diagrams

· Drawing enclosed objects & lines

· Editing objects

· Adding text to objects

· Selecting & resizing objects

· Applying colours
Advanced Chart Editing

· Formatting Gridlines

· Formatting an Axis

· Formatting the Data Series

· Charting non-adjacent ranges

· Adding data �different worksheets

· Using a secondary axis

· Adding trendlines

· Adding data tables

· Creating chart templates

· Applying chart templates

Working with Databases

· Creating a database

· Modifying a database

· Sorting records

· Using Data Validation

· Using Validation lists

· Creating a custom error message

· Creating subtotals in a list

· Removing subtotals in a list

Exporting and Importing Data

· Exporting data to other applications

· Importing data

· Changing external data range properties

· Removing the query definition

· Importing dynamic data from the Web

· Copying a table from a Web page

Using AutoFilter

· Enabling AutoFilter

· Filtering a list

· Clearing AutoFilter criteria

· Creating a custom AutoFilter

· Disabling AutoFilter


...''

Phone:08 8221 5517

School Address:

37 Angas St
Adelaide SA 5000

Jobs & Resumes: Adelaide
Houses & Roommates: Adelaide

Telephone Techniques
Indispensable Assistant
Leadership
Time Management
Access - Advanced
Access 2003
CorelDRAW 12
Dreamweaver MX 2004 Advanced
Dreamweaver MX 2004
Excel 2003 Advanced
Excel 2003
FrontPage 2003 Advanced
FrontPage 2003
Outlook 2003
Photoshop CS2 Advanced
Photoshop CS2
PowerPoint 2003 Advanced
PowerPoint
Premiere 6.5 Advanced

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.