|
 
(
020 7256 6668
|
|
 |
|
|
 
EXCEL 2010
Core
Click here for Expert level
A
course designed for flexibility allowing you to work at your
own pace and at times that best suit you. A
personalised workbook is yours to keep and use as a
reference guide along with the opportunity to gain a widely
recognised Pitman Training Certificate.
COURSE
OBJECTIVES:
To teach the Excel 2010 program to an employable level and
to cover part of the Microsoft Office Specialist (MOS) exam.
PREREQUISITES:
Familiarity with the Windows environment and basic
keyboarding experience.
DURATION:
24 hours
|
Course Content:
|
|
Lesson One
Including:
Opening the Excel 2010 program, identifying the
elements of the opening screen, creating a
worksheet with text and numbers, entering
addition formulas, adjusting column widths,
using the SUM function in a formula, using the
AutoSum feature, editing text and numbers,
navigating a workbook and worksheets, saving,
naming and closing a workbook, opening an
existing workbook, exiting Excel.
Lesson Two
Including:
Applying bold, italic and underline formats,
changing font type and size, using the mini
toolbar, changing the font colour, selecting and
formatting cells ranges, selecting columns and
rows, aligning cell contents horizontally, using
merge and centre, applying number formats,
printing the active worksheet, creating a new
folder, saving a workbook with a different name
and file type, viewing files in the open dialog
box, using AutoFill, entering formulas for
subtraction, multiplication, division and
percentages.
Lesson Three
Including:
Inserting and deleting rows and columns, hiding
and unhiding rows and columns, minimising the
ribbon, modifying column widths and row heights,
aligning cell contents vertically, wrapping and
indenting text, applying a fill colour, applying
borders, undo and redo, moving and copying cell
contents using drag and drop, moving and copying
cell contents using cut, copy and paste, copying
formats using format painter, clearing formats.
Lesson Four
Including:
Using AutoComplete, changing text orientation,
selecting non-adjacent data, freezing and
unfreezing panes horizontally and vertically,
using Zoom, page break preview, page layout
view, naming a worksheet, inserting and deleting
a worksheet, repositioning worksheets, using the
count function, saving a workbook as a template,
creating a workbook from a template, accessing
installed and online templates.
Lesson Five
Including:
Using styles to format a worksheet, creating a
custom cell style, using themes to format a
workbook, creating and saving a custom theme,
deleting a custom theme, page orientation,
adjusting margins and scaling, centring the
sheet horizontally and vertically, print preview
and print a worksheet, viewing/hiding gridlines
and row and column headings, printing gridlines
and row and column headings, setting and
clearing a print area, using COUNT, AVERAGE, MAX
and MIN functions, sorting columns in ascending
and descending order.
Lesson Six
Including:
Inserting and formatting headers and footers,
inserting header and footer codes including
date, page number and file name, copying and
pasting data between worksheets, grouping and
formatting multiple worksheets, switching
between workbooks, viewing multiple workbooks,
inserting and applying styles to a column, line
and pie chart, changing chart type.
Lesson Seven
Including:
Creating more complex formulas, calculating
percentages, making a cell reference absolute
and knowing when this is needed, displaying all
formulas on a worksheet, customising and viewing
calculations in the status bar, the insert
function dialog box, using the NOW, TODAY and IF
functions, the function library, adding, viewing
and editing comments, adding a button to the
Quick Access toolbar, then deleting.
Lesson Eight
Including:
Displaying a hidden worksheet, using the PMT and
FV functions, recognising errors, using the
IFERROR function, creating 3D formulas.
Lesson Nine
Including:
Inserting column, line and pie charts, moving a
chart to a new worksheet, adding labels to a
chart, adding and removing a data table,
switching chart rows/columns, changing chart
layout options, selecting and formatting chart
elements, inserting sparklines, inserting
moving, resizing and rotating pictures, making
picture ‘corrections’ and applying picture
styles and effects, aligning multiple objects,
inserting and formatting WordArt, inserting and
modifying shapes, creating and modifying
SmartArt.
Lesson Ten
Including:
Using Spell check text in a worksheet, using
Filter to display specific data, finding and
replacing text and formats within a worksheet,
saving a workbook as a web page, inserting and
using hyperlinks in a worksheet, using
conditional formatting in a worksheet,
customising the ribbon.
|
| |
.
EXCEL 2010
Expert
Click here for Core level
A course
designed for those who wish to learn this popular
spreadsheet program to an advanced level.
COURSE
OBJECTIVES:
To teach the Excel 2010 program to an advanced level and to
cover the Microsoft Office Specialist (MOS) and ECDL
Advanced (Spreadsheets) exams.
PREREQUISITES:
Working knowledge of the Excel 2010 program, ideally having
completed the Excel 2010 course.
DURATION:
18-20 hours
|
Course Content:
|
|
Lesson One
Including:
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/unhiding
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, creating and using
a slicer, formatting a slicer
Lesson Six
Including:
Using the VLOOKUP function, inserting an
embedded object into a spreadsheet, inserting a
linked object into a spreadsheet, using paste
special to create a link between programs,
linking Excel workbooks, using the scenario
manager, setting up data tables
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
|
| |
|
|
