PCWorkshops

Java and Data-related training courses to companies of all sizes

MS Excel Advanced Course

Download pdfContact UsBook Now

Course Aims

This intensive hands-on one-day training course has been designed to provide delegates with a very advanced set of Excel tools and concepts in order to further increase their knowledge and productivity.

Who Should Attend

Users with a solid understanding of, and experience with, Microsoft Excel who want to increase their ability in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction, Intermediate and Advance courses.

Course Outline

Advanced Conditional Formatting

  • Editing Standard Formatting Rules
  • Input Validate rules
  • Using Formulas in Conditional Formatting

Using Form Controls and Templates

  • Using Form Controls
  • Creating Templates

Macros

  • Advanced Calculations
  • Goal seek, consolidate and scenarios

Advanced Lookup Functions

  • Using Hlookup and VLookup Functions
  • Using the Index Function
  • Using the Match Function
  • Using Index and Match Together
  • Using the Indirect Function

Advanced Functions

  • Using Error Functions
  • Using Logical Functions
  • Using Array Formulas
  • Using Rounding Functions

Advanced Pivot Table Tools

  • Importing Pivot Table Data
  • Calculated Fields in Pivot Tables
  • Showing Pivot Data as a Percentage
  • Creating Custom Pivot Tables Styles
Training Location

8 Northumberland Avenue, Embankment, London WC2N 5AP

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s