Microsoft Excel – Level 2
Course Outline

DURATION 1 Day
PREREQUISITES Delegates should be comfortable working with basic references and formulas, and fundamentals like Autosum, Autofill and controlling Smart Tag options.
DESCRIPTION This course differentiates absolute and relative references, introduces named ranges and a variety of powerful functions such as the IF Statement and VLookup.  You will learn to deal with large datasets, as well as explore some of the better features of Excel that give you control over how data is entered and displayed
COURSE DATES Special: Four Days of MS Office training for the price of Three!

Click here to request an alternate date
Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday.
Weekday Mon, 13-Feb-12 09:30 - 16:30 £180.00 +VAT
Weekend Sat, 18-Feb-12 10:00 - 16:30 £200.00 +VAT
Weekday Thu, 1-Mar-12 09:30 - 16:30 £180.00 +VAT
Evening Mon, 19-Mar-12 and Tue, 20-Mar-12 18:30 - 21:30 £200.00 +VAT
Weekday Fri, 13-Apr-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 21-Apr-12 10:00 - 16:30 £200.00 +VAT
Weekday Wed, 2-May-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 19-May-12 10:00 - 16:30 £200.00 +VAT
Weekday Thu, 14-Jun-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 18-Jun-12 and Tue, 19-Jun-12 18:30 - 21:30 £200.00 +VAT
Weekday Tue, 3-Jul-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 21-Jul-12 10:00 - 16:30 £200.00 +VAT
Weekday Thu, 2-Aug-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 18-Aug-12 10:00 - 16:30 £200.00 +VAT
Weekday Mon, 10-Sep-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 17-Sep-12 and Tue, 18-Sep-12 18:30 - 21:30 £200.00 +VAT
Weekday Tue, 2-Oct-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 20-Oct-12 10:00 - 16:30 £200.00 +VAT
Weekday Fri, 2-Nov-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 10-Nov-12 10:00 - 16:30 £200.00 +VAT
Weekday Fri, 14-Dec-12 09:30 - 16:30 £200.00 +VAT
Evening Wed, 19-Dec-12 and Thu, 20-Dec-12 18:30 - 21:30 £200.00 +VAT
Any One-to-One Tuition
Any Date - Fully Customisable		 09:30 - 16:30 £375.00 +VAT

Alternatively, use our BOOKINGS FORM for an alternative payment method, or for multiple dates/courses.

 

 

WORKING WITH CHARTS, PART 2

  • Changing the Type of Chart

  • Changing the Source data

  • Working with the Chart Axis and Data Series

WORKING WITH FUNCTIONS AND FORMULAS

  • Using Formulas in Excel

    • Recap of Relatice & Absolute Cell References

    • Using Formulas with Multiple Cell References

  • Exploring Functions in Excel

    • What are Functions?

    • Finding the Right Function

  • Working with Names and Rangesl

    • Using the IF Function

    • Nesting Functions

  • Using the VLOOKUP Function

    • How to Find an Exact Match

    • Find the Closest Match

MANAGING TABLES

  • Working with Tables

  • Working with Records and Fields

  • Working with Tables and Filters

    • Sorting Data
    • AutoFilter
    • Custom AutoFilter
    • Advanced Filter
    • Copying Filtered Records
  • Using Excel as a Database

ENHANCING YOUR WORKBOOK

  • Working with Text Boxes

  • WordArt

  • ClipArt

  • Using Embedded and Linked objects

USING EXCEL FEATURES

  • Adding Comments
  • Using Find and Replace
  • Creating Custom Number and Date Formats
  • Conditional Formatting
  • How to Use Paste Special
  • Using Drop-Down Lists and Controlling What is Entered into Cells (Data Validation)

USING AUTOMATIC OUTLINING

  • Displaying and Collapsing Levels
  • Grouping Data Manually
  • Creating Subtotals

FINALIZING YOUR WORKBOOK

  • Protecting your Workbook
  • Finishing Your Workbook
    • Using the Document Inspector
    • Using the Compatibility Checker
    • Marking Workbook as Final
  • Using Excel in Word

 

Home | Contact | Terms and Conditions