Dreamweaver course in north London

Microsoft Excel: Intermediate (Level 2)

This hands-on training course has been designed to give delegates a solid understanding of more advanced Excel tools and concepts in order to increase their knowledge and productivity.

Users with a basic understanding of Microsoft Excel who want to consolidate and expand on their knowledge of the basic features in a short space of time.

Delegates on this course should have a good working knowledge of the topics covered in the Introduction 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?
Tabe and Chart Practice
  • Table and Chart Basics 
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 Word Advanced and Microsoft Excel Introduction

Course Duration 1 Day
Private Course Price and dates Please call centre on 0208 443 2888 for a quote and to arrange dates
Course Times 10:00 till 16:00

*Please note that we rarely run this Microsoft Word introductory course as a public course at present time. However, if 2 or more people book together then we can open it up to the public or provide it as small group tuition. If you can't come to us we can come to you! Please click here for more information.