Excel 2007 - foundation

Intuition Computer Training

Short course

In London

£ 225 + VAT

The best Excel courses

See all

See all

Description

  • Type

    Short course

  • Location

    London

  • Duration

    1 Day

plan and create worksheets incorporating different data types. construct and edit formulas and functions. use a variety of formatting techniques to enhance worksheet presentation. print and select print options. manage large worksheets, multiple sheets and workbooks. generate and print charts using the chart wizard. sort long lists quickly

Facilities

Location

Start date

London
See map
210 Borough High St, SE1 1JX

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

course description
after completing this course, participants will be able to:
  • plan and create worksheets incorporating different data types
  • construct and edit formulas and functions
  • use a variety of formatting techniques to enhance worksheet presentation
  • print and select print options
  • manage large worksheets, multiple sheets and workbooks
  • generate and print charts using the chart wizard
  • sort long lists quickly

topic
  • getting started-screen layout, navigation tools, help
  • data entry-data types, autocorrect, autocomplete, pick from list, autofill, custom lists, find & replace, import text file, undo/redo, move/copy cells
  • file management-save, open, close workbooks
  • formula construction-mathematical operators, order of calculation, autocalculate, relative/absolute cell references, range finder, range names
  • printing-preview, headers and footers, page break preview, view and print formulas, set print areas
  • formatting-alignment, fonts, indent text, borders, numeric formats, format painter, custom formats, conditional formats, freeze panes
  • auditing toolbar-trace formulas, comments
  • worksheet management-column widths, insert/delete rows/columns, insert delete move worksheets, name worksheets
  • data validation-input messages, data restrictions, drop-down list boxes
  • functions-statistical;, date and time, logical
  • group and outline-automatic, manual, select visible cells
  • multiple sheets and workbooks-create, name, delete and view sheets; copy/move data to other sheets; group editing, workspaces, copy to other worksheets, copy to other workbooks, link sheets/ workbooks
  • sorting lists
  • charts-chart types, modify elements, add labels titles, legends, scales and gridlines

See related categories

Excel 2007 - foundation

£ 225 + VAT

The best Excel courses

See all

See all