Telephone - 01905 726222
info@neos-it-training.com
Excel 2007
INTERMEDIATE
1 Day
Colour code data based on its value
Filter and sort data in tables
Create decision-making functions
Make use of date and time functions
Make use of financial functions
Make use of statistical functions
Make use of text based functions
Work with data across multiple workbooks and worksheets
Share workbooks for collaborative working
Import and Export data
Delegates should have a good working knowledge of using Excel 2007 as can be gained from our Excel 2007 core skills course.
Conditional Formatting
Introduction to Conditional Formatting
Highlighting Specific Values
Data Bars
Color Scales
Icon Sets
Fine-Tuning Conditional Formatting
Using Multiple Rules
Organizing Data Using Tables
Create Tables
Modify Tables
Format Tables
Sorting and Filtering
Sorting Data
Mutlilevel Sorting
Filtering a List with Autofilter
Filtering a List with Advanced Filter
Working With Tables
Highlighting Duplicates
Combining Data from Multiple Tables
Auto Outline
Automatic Subtotaling
Advanced Charting
Exploding Slices in a Pie
Grouping Slices in a Pie
Creating Combination Charts
Working with Graphics
Inserting Pictures
Inserting ClipArt
Creating AutoShapes
Formatting Graphic Objects
Advanced Formulas and Functions
Inserting Functions
Formula Building Recommendations
Naming Cells and Ranges
Logical Statements
Conditional Formulas (AND, OR, NOT)
IF Functions
Nested IF Functions
Combining IF with AND, OR, and NOT
IS Functions
Using IS with IF to Change Error Messages
Database Formulas and Functions
The LOOKUP Function
Array Lookup
Vector Lookup
The VLOOKUP Function
The HLOOKUP Function
Detailed Functions
Date and Time Calculations
Text and Data Functions
Mathematical Functions
Statistical functions
Importing and Exporting
Exporting Data From Excel
Importing Data From Other Applications
CSV files