|
-
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
|
EXCEL 2007:
LEVEL1
