Skip Main Navigation
Page Content

Save This Event

Event Saved

MS Excel Data Analysis for modern managers, London

PCWorkshops

Wednesday, 15 February 2017 at 11:00 - Thursday, 16 February 2017 at 18:00 (GMT)

MS Excel Data Analysis for modern managers, London
Available Dates

Ticket Information

Ticket Type Sales End Price Fee Quantity
Excel Data 15 Feb 2017 £195.00 £12.68

Who's Going

Loading your connections...

Share MS Excel Data Analysis for modern managers, London

Event Details

Course summary

Excel Techniques required for manipulating sets of data stored in Excel, to analyse and obtain useful business insights from the data

Course Outline

Working with Names and Ranges, Working with Array Formulas
Conditional Formatting, Data Validation, custom lists
Function wizard for statistical functions:

  • -- If,
  • -- Sumif(s), Averageif(s), Countif(s)

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

  • -- Advanced Filter
  • -- Setting up criteria
  • -- Using Wildcards

Subtotals, Group, Outline
Dsum, Daverage, Dcount
Hlookup, Vlookup, Match, Index
Pivot Tables
Working with sheets and files
Graphs and Pivot charts

 

INCLUDED:

  • What can/can't I bring to the event?
  • You can bring your own Laptop - let us know beforehand
  • You canbring your own data and examples - let us know beforehand
  • Refreshments: Tees, coffees and light refreshments are included in the price
  • Certificates: You will get attendance certificates
  • Notes: You will get brief course notes
  • After course support: Scheduled Skype sessions
 




 

Do you have questions about MS Excel Data Analysis for modern managers, London? Contact PCWorkshops

Save This Event

Event Saved

When & Where


PC Workshops at The Grand
8 Northumberland Ave
WC2N London
United Kingdom

Wednesday, 15 February 2017 at 11:00 - Thursday, 16 February 2017 at 18:00 (GMT)


  Add to my calendar

Organiser

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 Organiser
MS Excel Data Analysis for modern managers, London
Things to do in London Course 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.