Microsoft Excel 2003, 2007, XP Intermediate

Course contents

More Functions and Features
Conditional tests and logical operators
Using IF and nested IF statements
Naming cell ranges
Attaching comments to cells
Viewing, printing, deleting, copying comments
Auditing
Consolidation
Conditional formatting
Using Multiple Spreadsheets
Inserting, deleting, moving, renaming sheets
Changing the tab colour of sheets
Linking workbooks and worksheets
Format multiple spreadsheets at once
Comparing workbooks side by side
Creating 3D formulas (across sheets)
Protecting workbooks and worksheets
Sorting and Filtering Lists
Sorting rows and columns
Sorting and formulas
Creating and using custom sort orders
Using AutoFilter and removing filters
Custom AutoFilter
Advanced Filters
Using List Functionality
Designating data as a list and using this interface
to manage and analyse your data
Using Format a Table
Removing duplicates

 
Automatic Subtotals
Converting a list to a range
Applying and removing subtotals
Counting
Multi-Level Subtotals
Creating Outlines
Using Auto Outline
Collapsing and expanding outlines
Removing outlines
Creating Charts
Using ChartWizard to create charts
Moving and resizing charts
Using the Chart toolbar
Changing the chart type, adding titles
Combination charts
Adding and deleting floating text
Adding labels to data points
Formatting the data series and plot area
Customising 3-D charts, rotating 3-D charts
Exploding slices of pie charts
Drawing
Drawing using the Illustrations tab
Drawing lines and shapes
Changing colours and patterns
Changing line and arrow styles
Selecting, moving and resizing objects
Including text in a drawing
Grouping and ungrouping objects
Creating diagrams
Using Smart Art