info@h2htraining.co.uk
|
Tel: 01494 558988 Fax: 01494 464904 |
||
EXCEL | WORD | ACCESS | POWERPOINT |
VISIO | FRONTPAGE | PROJECT | OUTLOOK |
¨
The Excel
Workspace
¨
Creation and
saving of workbooks
¨
Opening,
closing and switching between multiple workbooks
¨
Navigating
in a workbook
¨
Worksheets:
insert, delete, rename, move and copy
¨
Selecting
Cells
¨
Entering/deleting/editing
data in cells
¨
Undo and
Redo
¨
Columns
& Rows: width and height; inserting and deleting
¨
Moving and
copying data; using AutoFill
¨
Creating
formulae to calculate values
¨
Using the
AutoSum function
¨
Formatting:
font, size, colour, borders, font styles, effects, number formats
¨
Formatting:
aligning, merging and wrapping text in cells; changing text orientation
¨
Sorting data
alphabetically, numerically and chronologically
¨
AutoFilter
– show specific data from a larger list
¨
Preparing
for Print
¨
Creating
formulae to calculate values
¨
Theory: the
order of precedence that Excel uses in calculations
¨
Copying
formulae using relative and absolute references
¨
Using the
AutoSum key/Sum function
¨
Using Excel
functions: Average, Max and Min
¨
IF functions
¨
VLOOKUP /
HLOOKUP functions
¨
Naming cells
and ranges
¨
Linking
spreadsheets and workbooks
¨
Cell
protection
¨
Functions
and features to combine data from multiple cells / splitting data into multiple
cells
¨
Create, format and modify Charts
¨
Link charts to other applications (Word or PowerPoint)
¨
Hide columns, rows and formulae
¨
Apply formatting to numeric data depending upon values
¨
Use data validation to restrict the type of data entered in a
specific area within a spreadsheet
¨
Use a Data Form to enter, delete and search for records
¨
Use Subtotals to flexibly show totals and averages of sections of
data
¨
Use Advanced Filters to condense a large list of data
¨
Create and modify Pivot Tables:- grouping, showing/hiding data,
adding subtotals, consolidating multiple ranges
¨ What-if
analysis using one- and two- variable tables
¨
Forecast, Growth, and Trend functions
¨
Goal Seeking
¨
Moving Averages
¨
Regression Analysis
¨
Scenarios
¨
Solver
¨
Goal Seek
¨
Using Trend lines in Charts