Microsoft Excel – Level 4
Course Outline

DURATION	1 Day
PREREQUISITES	Delegates should have a strong working knowledge of almost all aspects of Excel including Charts, Pivot Tables, advanced functions and array formulas.
DESCRIPTION	This course introduces Add-Ins, custom Smart Tags, Macros and basic VBA programming.  Advanced functions (PMT and FV) are also covered.
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 Thu, 16-Feb-12 09:30 - 16:30 £180.00 +VAT Weekday Thu, 16-Feb-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 25-Feb-12 10:00 - 16:30 £200.00 +VAT Weekday Fri, 9-Mar-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 26-Mar-12 and Tue, 27-Mar-12 18:30 - 21:30 £200.00 +VAT Weekday Tue, 17-Apr-12 09:30 - 16:30 £180.00 +VAT Weekend Sat, 28-Apr-12 10:00 - 16:30 £200.00 +VAT Weekday Fri, 4-May-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 26-May-12 10:00 - 16:30 £200.00 +VAT Weekday Mon, 18-Jun-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 25-Jun-12 and Tue, 26-Jun-12 18:30 - 21:30 £200.00 +VAT Weekday Thu, 5-Jul-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 28-Jul-12 10:00 - 16:30 £200.00 +VAT Weekday Mon, 6-Aug-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 25-Aug-12 10:00 - 16:30 £200.00 +VAT Weekday Wed, 12-Sep-12 09:30 - 16:30 £200.00 +VAT Evening Mon, 24-Sep-12 and Tue, 25-Sep-12 18:30 - 21:30 £200.00 +VAT Weekday Thu, 4-Oct-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 27-Oct-12 10:00 - 16:30 £200.00 +VAT Weekday Tue, 6-Nov-12 09:30 - 16:30 £200.00 +VAT Weekend Sat, 17-Nov-12 10:00 - 16:30 £200.00 +VAT Weekday Tue, 18-Dec-12 09:30 - 16:30 £200.00 +VAT Evening Wed, 26-Dec-12 and Thu, 27-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.

ADD-INS AND SMART TAGS

• Add-ins and the Trust Center

• What is a COM Add-in?

• Add-In Management

• Installing Add-ins

• Using the Trust Center

• Information Rights Management

• What is IRM?

• Requirements for IRM

• Downloading and Installing the Rights Management Client Software

• Using IRM

• Opening an IRM Protected Document

DIGITAL SECURITY

• What is a Digital Signature?

• Obtaining a Digital Signature

• Attaching your Signature to a Workbook

• Smart Tags and XML

• What is a Smart Tag?

• Inserting Smart Tags into a Worksheet

• Setting Smart Tag Options

• Creating Custom Smart Tags

MACROS, VBA, AND EXCEL PROGRAMMING

• Macros

  • Recording Macros

  • Playing a Macro

  • Macro Security

  • Recording a Relative Reference Macro

  • Running a Relative Reference Macro

  • Assigning a Keystroke to a Macro

  • Copying a Macro from a Workbook or Template

• Visual Basic and Macros

  • Opening the Visual Basic Editor

  • Adding Code to your Macro

  • Adding Comments to VBA Code

  • Declaring Variables

  • Prompting for User Input

  • Iteration over a Range

  • Using IF Then Else Statements

EXPERT TOPICS

• Form Controls

  • What is a Form Control?

  • Adding a Control to a Worksheet

  • Assigning a Macro to a Control

  • Using Form Controls

• Advanced Functions

  • Using Financial Functions (PMT and FV)

  • Understanding Logical Functions

  • Applying Logical Functions

• Using SharePoint

  • Creating a Document Workspace

  • Accessing a Workspace

  • Publishing to a Document Workspace

• User Forms and ActiveX Controls

  • Creating a Blank User Form

  • Adding Controls to the Form

  • Adding Buttons and VBA Code

  • Starting the User Form with a Macro

Home | Contact | Terms and Conditions