Dreamweaver course in north London

Microsoft Excel: Advanced (Level 3)

This course will give students the ability to create advanced spreadsheets using the full range of Microsoft Excel 2003's tools and features.

The course is intended for existing users of Microsoft Excel 2003 who want to use the more advanced features of the software in order to increase their productivity and effectiveness. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

Delegates on this course should have a good working knowledge of the topics covered in the Intermediate course.

Course outline

Using Formulas in Excel
  • Relative and Absolute Cell References 
  • Basic Mathematical Operators 
  • Formulas and Multiple Cell References 
  • The Formula Auditing Bar 
  • Fixing Formula Errors 
  • Displaying And Printing Formulas 
Using Functions in Excel
  • Inserting Functions 
  • Using Functions And Autofill To Perform Difficult Calculations 
  • The IF Function 
  • Working With Nested Functions 
Working with Names and Ranges
  • Defining And Using Range Names 
  • Selecting Nonadjacent Ranges 
  • Auto Calculate? 
Working with Array Formulas
  • Basic Array Formulas 
  • Using Functions With Array Formulas 
  • Using The IF Function In Array Formulas 
Working with Lists
  • Creating Lists 
  • Modifying Lists 
  • What Is The Total Row?
Working with Records and Fields
  • Adding Fields By Inserting Columns 
  • Adding Records By Inserting Rows 
  • Adding Records With A Data Form 
  • Finding And Deleting Records 
Working with Lists and Filters
  • Sorting A List 
  • What Is An Autofilter 
  • Custom Autofilters 
  • Using An Advanced Filter 
  • Copying Filtered Records 
Using Excel in Word
  • Inserting Excel Data In Word 
  • Modifying Excel Data After Insertion 
  • Linking Excel Data In Word 
  • Linking An Excel Chart In Word 
Using Excel with Other Programs and Files
  • Using Outlook To Send Excel Data 
  • Opening An Excel File In A Different Format 
  • Importing Data From A Text File 
  • Importing Data From A Database 

Class time is 10:00 a.m.- 4:30/5:00 p.m. Breaks are scheduled throughout the day and lunch is typically scheduled between 1-2 pm. We provide you with Tea, Coffee, Biscuits and other refreshments on the house. We also have a fridge and a microwave available for you to store/warm up any food you wish to bring along for your lunch.

We recommend the following courses that relate to this class: Microsoft Excel Advanced and Microsoft Access Introduction

Course Duration 1 Day
Private Course Price and dates This course is only available as individual 1:1 on a bespoke
Please call centre on 0208 443 2888 for a quote and to arrange dates
Course Times 10:00 till 16:00