Microsoft Excel 2010 Intermediate
Starting dates and places
S & G offers their products as a default in the following regions: London, Surrey
Description
Overview
For those who have a sound basic working knowledge of Excel or have attended the Excel Introduction course. Expand your skills and confidence with the package. Advanced formatting, search data using criteria based searches, analyse and summarise data, customise charts and manipulate data.
Who is it for?
Those looking to develop their Microsoft Excel skills and confidence
Description
1) Advanced Functions
Absolute Cell References
IF Statement: SUMIF, COUNTIF, IF, AND, OR
VLookUp
HLookUp
Data Validation
2) List Functionality
Forms
Criteria, Record count
Sorting Options
Filtering Options including:-
AutoFilter
Advanced Filter
Filter by colour, text criteria
Copy to another Location
Remove Duplic…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
Overview
For those who have a sound basic working knowledge of Excel or have attended the Excel Introduction course. Expand your skills and confidence with the package. Advanced formatting, search data using criteria based searches, analyse and summarise data, customise charts and manipulate data.
Who is it for?
Those looking to develop their Microsoft Excel skills and confidence
Description
1) Advanced Functions
Absolute Cell References
IF Statement: SUMIF, COUNTIF, IF, AND, OR
VLookUp
HLookUp
Data Validation
2) List Functionality
Forms
Criteria, Record count
Sorting Options
Filtering Options including:-
AutoFilter
Advanced Filter
Filter by colour, text criteria
Copy to another Location
Remove Duplicates
3) Enhanced Format Tools
Date Formats
Number Formats
Text Alignment
Drawing Toolbar
Clear Data, Formats, Comments
All Graphics:
Clip Art, WordArt, Importing Pictures, enhancing Worksheet/Cell
appearance
Working with/Creating Styles
4) Charts
Customising:-
Type, Data, Titles, Legend, Labels
Manipulation of Data
Creating a Combination Chart
5) Additional Tools
Paste Special
Working with Sheets
Comments - Show/Hide
Smart Tags Overview
Hyperlinks
Worksheet Protection/Password Protection
Track Changes
Name Ranges
Create & Define Names
Hiding Columns, Data, Comments
Editing Data Entries, Cell Contents, Formulae
Subtotals
Compare side by side
Arrange all
Conditional formatting
Find duplicates
6) Advanced Data Manipulation Tools
Linking:
Cells, Worksheets, Workbooks
Updating Links
7) Customising
Screen view options
Excel options
All printing options
Keyboard shortcuts
8) Auditing
Precedents and Dependants
Auditing Toolbar
9) Introduction to Macros
Requirements
Basic IT skills
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.