MARS Excel 2007 Advanced - Working with Worksheets


Worksheet Techniques

  • inserting and deleting worksheets
  • copying a worksheet
  • renaming a worksheet
  • moving a worksheet
  • hiding a worksheet
  • unhiding a worksheet
  • copying a worksheet to another workbook
  • moving a worksheet to another workbook
  • changing worksheet tab
  • colours
  • grouping worksheets
  • hiding rows and columns
  • unhiding rows and columns
  • freezing rows and columns
  • splitting windows.

Finding And Replacing

  • understanding find and replace operations
  • finding text
  • finding cell references in formulas
  • replacing values
  • using replace to change formulas
  • replacing within a range
  • finding formats
  • finding constants using Go To Special
  • finding formulas using Go To Special
  • finding the current region
  • finding the last cell.

Page Setup

  • understanding page layout
  • using built in margins
  • setting custom margins
  • changing margins by dragging
  • centering on a page
  • changing orientation
  • specifying the paper size
  • setting the print area
  • clearing the print area
  • inserting page breaks
  • using page break preview
  • removing page breaks
  • setting a background
  • clearing the background
  • setting rows as repeating print titles
  • clearing print titles
  • printing grid lines
  • printing headings
  • scaling to a percentage
  • fit to a specific number of pages
  • strategies for printing larger worksheets.

Sorting Data

  • understanding lists
  • performing an alphabetical sort
  • performing a numerical sort
  • sorting on more than one column
  • sorting numbered lists
  • sorting by rows.

Filtering Data

  • understanding filtering
  • applying and using a filter
  • clearing a filter
  • creating compound filters
  • multiple value filters
  • creating custom filters
  • using wildcards.

Filling Data

  • filling a series
  • filling a growth series
  • filling a series backwards
  • filling using options
  • creating a custom fill list
  • modifying a custom fill list
  • deleting a custom fill list.

Labels And Names

  • understanding labels and names
  • creating names in a worksheet
  • using names in new formulas
  • applying names to existing formulas
  • creating names using the names box
  • using names to select ranges
  • pasting names into formulas
  • creating names for constants
  • creating names from a selection
  • scoping names to the worksheet
  • using the name manager.

On-Site Training

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.




User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info


Next Step

Enquire Now
Tell a Friend
Email Course Outline