About Us
21BIZ is a business training course center based at Elstree Film Studios, Borehamwood, Hertfordshire, home to many famous TV and Film Productions including Big Brother, Dancing on Ice and Who Wants To Be A Millionaire.

21BIZ run a variety of business, marketing and office related courses including business startup, business marketing techniques and a range of Microsoft Office training courses.

Please browse our courses on the right and we look forward to welcoming you at 21BIZ.

Home - Microsoft Office Training Courses - Microsoft Excel 2010 Intermediate



In our intermediate Microsoft Excel 2010 training course you will learn how to use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.

This course is ideal for those desiring to gain the advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks.

Also included are how to use advanced formulas, organize worksheet and table data using various techniques, create and modify charts, analyze data using PivotTables, Slicers, and PivotCharts, insert and modify graphic objects in a worksheet and how to customize and enhance workbooks and the Microsoft Excel environment itself.

Duration: 1 day.

Location: 21st Century New Media Ltd, Elstree Film Studios, Shenley Road, Borehamwood, Hertfordshire, WD6 1JG. [Click here for a map]

Times: 10.00am to 4.30pm. For security reasons, further details are only provided upon booking.

Equipment: Our fully featured training room includes six top-of-the-range iMac computers configured to work in both Macintosh (OSX) and PC (Windows) modes, ensuring you the maximum familiarity with your chosen operating system.

Accommodation: Details of local accomodation can be found here.

Further assistance: Our FAQ help page contains the answers to many popular questions. Alternatively please call 0844 844 2428 to arrange to speak to our training manager.

COURSE CONTENT


Calculating Data with Advanced Formulas

  • Apply Cell and Range Names
  • Calculate Data Across Worksheets
  • Use Specialized Functions
  • Analyze Data with Logical and Lookup Functions

Organizing Worksheet and Table Data

  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Data
  • Use Functions to Calculate Data

Presenting Data Using Charts

  • Create a Chart
  • Modify Charts
  • Format Charts

Analyzing Data Using PivotTables, Slicers, and PivotCharts

  • Create a PivotTable Report
  • Filter Data Using Slicers
  • Analyze Data Using PivotCharts

Inserting Graphic Objects

  • Insert and Modify Pictures and ClipArt
  • Draw and Modify Shapes
  • Illustrate Workflow Using SmartArt Graphics
  • Layer and Group Graphic Objects

Customizing and Enhancing the Excel Environment

  • Customize the Excel Environment
  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates

5-15% discount if you book for more than one delegate!
Further discounts are available when booking multiple courses,
Please call our training secretary on 0844 844 2428.

Schedule your own Excel 2010 Intermediate training course
Please tell us where and when YOU would like to attend this course.
If we are able to schedule the course we will contact you.

Course  Enter a custom course
Month
Time
Location
First Name *
Last Name *
Telephone Number *
Email Address *


If you cannot easily read the two words above,
click on the icon that has two arrows chasing each other
and new words will be displayed for you.



Help
More Courses

In addition to the courses displayed here at 21BIZ, we also run two other websites offering their own specific courses. The courses listed below are our web design training courses which we run at 21st Century New Media Ltd operating out of Elstree Film Studios, Hertfordshire.

New Courses for 2012
Web Site Design Courses / Web Development Courses
Web Site Programming Courses
Web Marketing Courses / Search Engine Optimisation (SEO) Training Courses
Web Site Management Courses
Video Editing Courses
Graphic Design Courses / Print Courses


Our second dedicated training website is the Elstree Film School, where we run a variety of Film, TV and Video training courses, also operating out of Elstree Film Studios, Hertfordshire.

Industry Introduction Courses
Digital Video Camera Courses
Video Editing Courses
Scriptwriting Courses


21st Century New Media Ltd, Elstree Film Studios, Borehamwood, Hertfordshire WD6 1JG.
Tel: 0844 844 2428     Email: enquiries@21biz.co.uk

Network sites: 21NewMedia | The Elstree Film School | 21BIZ | 21stCentury | 21CTV
Elstree Film Talent | Creative Herts | Holistic Herts | Clifford White