Microsoft Excel Training Courses: Excel courses in Central London

	Home \| Training \| Solutions \|Contact Us t: +44(0)20 7729 1811
About Us \| IT Training \| Financial Training \| Management Training \|Delegate Information

Excel Training
This course guides participants through Excel's intermediate level features. Delegates learn how to create, edit and enhance Excel charts; work with multiple worksheets and workbooks, and use financial and logical functions. Learners will also gain hands-on experience using linking, consolidation of worksheets, and databases.

Microsoft Excel Courses
We offer a range of training courses on Microsoft Excel, from Introduction through to Microsoft Excel VBA. Excel is one of our regular scheduled training courses which are held at our city of London training centre.We can also offer in-house Excel training courses throughout the UK.

Microsoft Excel training from Premier Training

EXCEL INTERMEDIATE TRAINING COURSE CONTENT DURATION - 1 DAY

Next Scheduled Course Date

REVIEW OF BASICS

FILE LINKING
Creating to links to other workbooks and worksheets
Updating links to other workbooks
Changing link paths

FILE CONSOLIDATION & 3D SHEETS
File consolidation
Selecting more than one worksheet
Formatting and data entry in 3D worksheets
Creating 3D formulas
Copying 3D formulas
Compare and merge Workbooks

ADVANCED FORMATTING
Word Wrap
Merge Cells
Using Draw to create and modify lines and objects
Comments: adding, amending, deleting
Freezing titles
Error checking
Formula auditing mode

PASSWORDING
Files
Worksheets
Ranges within worksheets
Compare & Merge Workbooks
Allow users to edit ranges
Watch window

EXCEL CHARTS
Using the Chart wizard
Creating a basic chart
Overview of different chart types
Editing and formatting the chart
Changing the chart type
Adding labels
Working with x and y axes
Working with the legend
Working with chart titles

ABSOLUTE CELL REFERENCING
Distinguishing between absolute and partial cell addressing
Using absolute and partial cell addressing
Referencing in formulas

AUTO FILTER (DATABASES)
Creating an auto filter
Extracting data
Customise extracted data
Show all
Removing the auto filter

CUSTOMISED LISTS
Creating customised lists
Using customised lists

WORKING WITH DATES
Creating date series,
Calculations with dates

4 Ravey Street
London EC2A 4QP
t: +44(0)20 7729 1811
f:+44(0)20 7729 9412
information@premiercs.co.uk