Skip Main Navigation
Page Content

Save This Event

Event Saved

Excel Intermediate Course, Private 1-to-1

PCWorkshops

Wednesday, January 25, 2017 from 11:00 AM to 6:00 PM (GMT)

Excel Intermediate Course, Private 1-to-1
Available Dates

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
Excel Short Course Early Bird 1 Ticket Jan 18, 2017 £180.00 £6.79
Excel ShortCourse 1 Ticket Jan 24, 2017 £250.00 £9.24

Who's Going

Loading your connections...

Share Excel Intermediate Course, Private 1-to-1

Event Details

Excel Intermediate Course, Private 1-to-1

Course summary

This Excel course is offered one-to-one, because we understand that profesionals have varying skill levels and varying applications. You already have the basic Excel skills but habe many questions daily and want to be more proficients.

 

Included: Teas, Coffees, Notes, Course exercises and examples, access to online materials, Certificate

Course Outline

Working with Functions and Formulas

  • Creating Formulae in Excel, general calculations
  • The Function Wizard
  • Using Functions in Excel: The 5 Popular functions
  • If- function
  • Working with Names and Ranges
  • Copying formulae
  • Lookups - Vlookup, Hlookup, Index, Match

Managing Tables

  • Working with Tables
  • Working with Records and Fields
  • Filters and Sorting, Freeze panes, split, protecting and unprotecting
  • Using Excel as a Database- Advanced filter
  • Pivot-tables

Adding the Finishing Touches

  • Adding Comments
  • Using Themes
  • Adding Text Boxes

Charts and Sparklines

  • Adding and Editing Charts
  • Adding and Editing Sparklines

Adding Graphics

  • Inserting SmartArt, Formatting SmartArt, Adding Symbols, Equations, and Shapes

 

Have questions about Excel Intermediate Course, Private 1-to-1? Contact PCWorkshops

Save This Event

Event Saved

When & Where


PC Workshops at The Grand
8 Northumberland Avenue
WC2N 5BY London
United Kingdom

Wednesday, January 25, 2017 from 11:00 AM to 6:00 PM (GMT)


  Add to my calendar

Organizer

PCWorkshops

About Us

PC Workshops is an IT Training company with 21 years of IT training experience. 

Our inspiring IT training programs, aim to be practical and effective.

Specialties: MS Project, Java Programming,Database setup, SQL,  Excel, Microsoft Access,

MS Office (Word, PowerPoint, Publishing) Presentational skills training, Train-the-trainer

Winner : Trainer of the Year Award, 2007 awarded by the Learning and Performance Institute.

http://www.pcworkshopslondon.co.uk

Linkedin Profile

 

 

References:  

From: Aine

To: Sarah (Ms)

Date: 25/09/2014

Rating:                        

Report: Sarah is a fantastic tutor. She helped me to study for a Java Programming exam in University. I ended up doing really well in the exam thanks to Sarah. She not only has a brilliant understanding of the subject but also had the ability to explain things to me in a way I understood. I would recommend her to anyone!

 

From: Tim

To: Sarah (Ms)

Date: 15/08/2013

Rating:

Report: Sarah is a very versatile and knowledgeable tutor. She is very intelligent and so can understand the students specific needs very quickly (even in specialist areas of a wider subject). Sarah can focus her tutoring to be very fact and situation specific. Her teaching style is very relaxed and informative. I would fully recommend Sarah to anyone wanting to learn more in her chosen subject areas.

 

From: Mohamed

To: Sarah (Ms)

Date: 19/06/2014

Rating:

Report: Sarah Barnard is one of the greatest tutor that I have ever meet with, she has excellent knowledge for Javascript, SQL and Pseudo-Code .
She also has a great way of teaching. I really enjoyed learning from Sarah.

 

 

Our Location:

Training Location - 8  Northumberland Avenue, London, WC2N 5BY

  Contact the Organizer
Excel Intermediate Course, Private 1-to-1
Things to do in London Class Business

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.