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 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