|
|
|
|
COURSE TITLE:
Microsoft Excel Training UK
LEVEL:
Introduction : Intermediate : Advanced
COURSE LENGTH:
1 day
COURSE PRICES:
*All prices quoted exclude VAT
COURSE OVERVIEW:
Microsoft Excel will enhance your use of spreadsheets for data input, maintaining lists and detailed analysis.
Regardless of your role at work Microsoft Excel is used today by most people to maintain lists of data - staff information, stock levels and so on, to calculate numerical data, to analyse company data and much more. This is one of the most commonly used software packages yet many people do not feel confident about it and many others are unaware of the various features Excel has to offer. |
| |
|
The course outlines below set out the full range of topics you can choose to cover during your on-site training course, and you can build your course around your exact training requirements, or any specific projects you or your staff are working on at present.
You will find that this approach makes our courses the most effective and productive use of your training budget available today.
For off-site courses use the outline below as a guide to the modules available, contact us now for a full off-site course outline and training dates. |
Introduction Level
Introduction to Excel basics
The workbook environment
Enter and edit data
Navigate in a worksheet
Correcting data
Edit cell contents
Use AutoComplete
Save a file
Open a second and third file
Navigation and movement techniques
Modifying a workbook
Work with ranges
Create formulae
Move and copy data
Cut and paste data
Drag and drop data
Insert rows and columns
Use the clipboard
Use the fill series feature
Format a worksheet
Number formats
Text alignment
Copy and paste formats
Change font size and type
Add borders to cells
Change column width and row height
Shrink text to fit
Align cell contents
Merge and split cells
Apply an autoformat
Print a worksheet
Check spelling
Use print preview
Print a large worksheet
Additional print options
Set page display and print options
Freeze, unfreeze rows and columns
Set print titles
Set page margins
Create a header and footer
Change page orientation
Insert and remove a page break
Print a range
|
Intermediate Level
Absolute references
Work with multiple worksheets
Work with multiple workbooks
Link cells in different workbooks
Create workspaces
Formula construction
Logic functions: IF, nested IF functionAND, OR function
SUMIF, COUNTIF functions
Create, edit and delete comments
Use the auditing toolbar
Use data validation
Sort data
Single-level and multiple-level sorting
Sorting options
Data list design considerations
Filtering data
Create custom filters
Group and outline data
Add subtotals to a worksheet
Apply conditional formatting
Protect and display options
Protect the worksheet
Hide information
Create and apply styles
Create a custom numeric format
Create, edit and use templates
Create charts
Create a chart sheet
Create an embedded chart
Modify charts
Apply and use various chart types
Add and delete chart items
Move and size chart items
Format a chart
Format chart text and numbers
Insert and format labelsPreview and print charts
|
Advanced Level
Insert and edit graphic objects to enhance
worksheets and charts
Format graphic objects
Advanced techniques for filtering data
Multiple-condition criteria
Manage a filtered list
Create name ranges
Use name ranges in formula
Manage name ranges
LOOKUP functions
VLOOKUP, HLOOKUP functions
IS, ERROR functions
Create Pivot tables
Edit pivot tables
Group and summarise data in pivot tables
Consolidate and analyse data
Consolidate data from more than one worksheet
Use Goal Seek and Solver utilities
Use Scenario Manager to view a worksheet with different input values
Protect and display options
Protecting workbooks
Create and apply custom views
Use custom views with report manager
Share your workbook
Set revision tracking
Merge workbooks
Track changes
Introduction to macros
Record a macro in one workbook, for all workbooks
Record an absolute, relative and generic macro
Run a macro
Delete a macro
View and edit VBA code
Assign a macro to a button in the workbook
Assign a macro to a toolbar
Customise the work area
Modify existing toolbars
Create custom toolbars
Work with interactive excel web documents
Save excel worksheets as web documents
Spreadsheet web components
Query data
Database functions
External databases and queries
Running a Web Query on the Internet
|
|
BACK TO TOP |
|
|
|
"I would just like to say how pleased we were with the way in which ABC Dee Training handled our training requirements....." Vicky Farrow, Kent Fire & Rescue
"My experience with this company has been a positive one and
I would happily recommend ABC Dee Training to others."
Anna Faithfull, London Film
|
| |
