PCWorkshops

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

MS Excel Intermediate Course

Download pdfContact UsBook Now

Course Aims

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

Who Should Attend

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 should have a good working knowledge and understanding of the concepts covered in the Introduction course.

Course Outline

Advanced File Tasks

  • Using Windows Explorer within Excel
  • Saving your Files
  • Using File Management Tools, Part One
  • Using File Management Tools, Part Two

Working with Functions and Formulas

  • Using Formulas in Excel
  • Exploring Excel Functions
  • Using Functions in Excel
  • Working with Names and Ranges
  • Working with Array Formulas

Managing Tables

  • Working with Tables
  • Working with Records and Fields
  • Working with Tables and Filters
  • Using Excel as a Database

Adding the Finishing Touches

  • Research Tools
  • Using Themes
  • Adding Text Boxes
  • Inserting Pictures and ClipArt
  • Editing Pictures

Showing Data as a Graphic

  • Inserting SmartArt
  • Formatting SmartArt
  • Adding Symbols, Equations, and Shapes
  • Sparklines
  • Editing Sparklines
Training Location

8 Northumberland Avenue, Embankment, London WC2N 5AP

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