|
 
(
020 7256 6668
|
|
 |
|
|
 EXCEL 2007
Part 1 (Core)
Click here for Expert level
COURSE
OBJECTIVES:
To teach the Excel
2007 program to an employable level and to cover the City &
Guilds Spreadsheet Processing Techniques Intermediate exam as
well as part of the Microsoft Certified Application Specialist
test (MCAS) and ECDL Advanced (Word Processing) exam.
PRE-
REQUISITES:
Familiarity with the
Windows environment and basic keyboarding experience
|
Course Content:
|
|
-
Lesson
One – Including: The opening Excel 2007 screen,
creating a worksheet with text and numbers, entering
simple formulas, adjusting column widths, editing
cells, navigating a workbook and worksheets, using
AutoSum, saving, naming and closing a workbook,
adding a button to the Quick Access Toolbar, opening
an existing worksheet, accessing Help in Excel
-
Lesson
Two – Including: Formatting text, changing font type
and size, using the mini toolbar, changing the font
colour, selecting cells and ranges, aligning text
horizontally, merging and splitting cells,
formatting numbers, printing the active sheet,
creating a folder, saving in a different format
-
Lesson
Three – Including: Inserting and deleting rows,
hiding and unhiding rows and columns, modifying
column widths and cell heights, aligning cells
vertically, wrapping and indenting text, adding
colour to cells and ranges, applying borders to
cells and ranges, moving and copy cells, undo and
redo, cut, copy and paste, AutoFill
-
Lesson
Four – Including: AutoComplete, text orientation,
selecting non-adjacent data, freezing and unfreezing
panes horizontally and vertically, using Zoom, page
break preview, naming and renaming a worksheet,
inserting a worksheet, repositioning worksheets,
deleting a worksheet
-
Lesson
Five – Including: Using styles to enhance a
worksheet, creating a custom style, the Page Layout
ribbon, using themes to enhance a worksheet,
creating and deleting a custom theme, page
orientation, adjusting margins and scaling, centring
the sheet horizontally and vertically, print
preview, displaying gridlines, printing row and
column headings, setting and clearing a print area
|
-
Lesson Six – Including: Inserting headers and footers,
copying and pasting data between worksheets,
grouping and ungrouping worksheets, creating a new
workbook, switching between workbooks, viewing
multiple workbooks, hiding and unhiding a workbook,
saving as a template, creating a workbook from a
template, using existing templates and online
resources
-
Lesson
Seven – Including: More complex formulas, absolute
as well as relative cell references, AutoCalculate,
functions SUM, DATE/TIME, COUNT, IF, adding, viewing
and editing comments
-
Lesson
Eight – Including: AVERAGE, MAX and MIN functions,
sort columns using ascending and descending order,
the PMT and FV functions, entering formulas into
grouped worksheets, recognising errors, using the IFERROR function, using 3D referencing to link
worksheet data
-
Lesson
Nine – Including: Inserting charts, changing chart
type, formatting a plot area, formatting a data
series, inserting and resizing a picture, applying
picture effects, aligning multiple objects,
inserting WordArt, inserting and modifying a drawing
object, creating and modifying SmartArt
-
Lesson
Ten – Including: Using Spell check, using Filter to
display specific data, finding and replacing text
within a worksheet, saving a workbook as a web page,
publishing a web page, inserting and using
hyperlinks, using conditional formatting
|
| |
Benefits
-
Learn how to use
this popular spreadsheet program
-
The flexibility
and value of a self-study course designed to enable you to
work at your own pace
-
A personalised
workbook to use as a reference guide on completion of the
course
-
The opportunity
to gain the widely recognised Pitman Training Certificate
Duration:
24 Hours
.
EXCEL 2007
Part 2 (Expert)
Click here for Core level
COURSE
OBJECTIVES:
To teach the Excel
2007 program to an advanced level and to cover the City & Guilds
Spreadsheet Processing Techniques Intermediate exam as well as
the Microsoft Certified Application Specialist test (MCAS) and
ECDL Advanced (Spreadsheets) exam.
PRE-
REQUISITES:
Familiarity with the
Windows environment and basic keyboarding experience
|
Course Content:
|
|
-
Lesson
One – Including: Using AutoFill, carrying out date
calculations, adding a worksheet background,
showing/hiding gridlines and headings, creating and
working with tables, converting text to columns,
removing duplicates, consolidating data,
hiding/un-hiding worksheets, using paste special,
creating a custom format
-
Lesson
Two – Including: Defining, using and managing named
ranges, using named ranges in formulas, inserting,
modifying and removing hyperlinks, formatting
elements of a column chart, using functions: ROUND; SUMIF; SUMIF; IF; IFERROR; AND, using the IF
function nested with OR
-
Lesson
Three – Including: Using conditional formatting,
editing a conditional formatting rule, using the
Rules Manager, formatting cells meeting a specific
condition, applying more than one conditional
formatting rule, sorting data using cell
attributes, filtering data using cell attributes,
using advanced filter options
-
Lesson
Four – Including: Recording and running macros,
editing a macro, running a macro from the Quick
Access Toolbar, deleting macros, using data
validation, tracing precedent/dependent cells in a
worksheet, evaluating formulas, tracing errors.
|
-
Lesson
Five – Including: Summarising data using subtotals,
using database functions, grouping and ungrouping
data, creating a pivot table, refreshing pivot table
data, filtering information in a pivot table,
formatting pivot table data
-
Lesson
Six – Including: Inserting headers and footers,
copying and pasting data between worksheets,
grouping and ungrouping worksheets, creating a new
workbook, switching between workbooks, viewing
multiple workbooks, hiding and unhiding a workbook,
saving as a template, creating a workbook from a
template, using existing templates and online
resources
-
Lesson
Seven – Including: Protecting worksheet cells,
applying and removing passwords, setting file
properties, sharing workbooks, merging workbooks,
tracking changes, accepting or rejecting changes,
using the Document Inspector, marking a workbook as
final, removing a password, adding a digital
signature
-
Lesson
Eight – Including: Using statistical functions: COUNTA, COUNTBLANK, COUNTIF, using text functions:
PROPER, UPPER; LOWER, CONCATENATE, using financial
functions: PV; NPV; RATE, using nested functions
|
| |
Benefits
-
Learn how to use
this popular spreadsheet program
-
The flexibility
and value of a self-study course designed to enable you to
work at your own pace
-
A personalised
workbook to use as a reference guide on completion of the
course
-
The opportunity
to gain the widely recognised Pitman Training Certificate
Duration:
18 - 20 Hours
|
|
