Microsoft Excel 2010 Intermediate

Total time

Microsoft Excel 2010 Intermediate

S & G
Logo S & G
Provider rating: starstarstarstarstar 10 S & G has an average rating of 10 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

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…

Read the complete description

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

There are no reviews yet.

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.