Excel Pivot Table Course, The Magic Cube for Excel Data, 1 Hour Online
Multiple dates

Excel Pivot Table Course, The Magic Cube for Excel Data, 1 Hour Online

Excel Pivot Tables is most likely the easiest and quickest way to get brilliant insight to your business KPI's by analysing data.

By PCWorkshops

Location

WC2N 4JF

Duncannon Street London WC2N 4JF United Kingdom

Refund Policy

Refunds up to 7 days before event.

Agenda

Excel Pivots to Visualise the Key Achievements of your Business

9:00 AM - 9:05 AM

Intro's

9:05 AM - 9:50 AM

Excel Pivot tables training sessions and demos

9:50 AM - 10:00 AM

Questions

About this event

EXCEL PIVOT TABLES IN 45 MINUTES COURSE

Powerfule data insight in minues:

Pivot Tables are really very easy to create, but very very powerful. By using Excel Pivot Tables, one can get very interesting and valuable business intelligence from your data, in very little time.

This short session aims to give you the techniques to use this valuable Excel tool creatively.

It is enough time to learn a lot about Excel Pivot Tables, but there is very little time for other questions.

The session runs every Friday morning, and hopefully won't distract too much from your working day.

Course Outline:

  • Create an Excel Pivot Table in 10 Minutes 
  • Changing a Pivot Table 
  • Formatting a Pivot Table 
  • Sorting by values or categories
  • Grouping Dates
  • Filter
  • Slicers to add interactive filters
  • Creating additional formulae 
  • Create a Pivot Charts 
  • Changing a Pivot Table and more...

You will have time to discuss and ask questions

WHAT IS INCLUDED:

  • Certificate on completion 
  • Course notes, Practical Class exercises, Homework Excercises
  • After the course, 1 free online revision / questions session 
  • Max group size is 4. 

Frequently asked questions

Should I have Excel?

No, but it would be better

Do I need to good with Excel?

No, I teach so that beginners will also find this course excellent, and they would be able to create pivot tables from scratch at the end of this course.

Organised by

At PCWorkshops, we offer instructor-led online courses in our Live Virtual Classroom. We cover Java programming, Python Coding, Database Development, SQL, Data Analytics and MS Project.

More about us:

training@pcworkshopslondon.co.uk

  • Our classes are instructor led, in our Live Virtual Classroom
  • Courses well developed by registered, qualified instructors with a wealth of experience in software development and training.
  • The maximum groups size that can access our Virtual Classroom, is 4.
  • Every one gets personalised attention.

Why learn with us at PCWorkshops:

  • Excellent, up-to-date courses, following latest trends and technologies.
  • Excellent trainers with professional experience.

Award Winning Trainer

We offer Training Courses in Software Packages:

  • Java Programming
  • Python Programming, Python data analytics, Python Machine Learning
  • Database design and Data Normalisation
  • SQL Courses
  • Data Analysis and 
  • MS Excel, data analyses with Excel. Excel VBA
  • Access Database Courses.
  • MS Project Training
  • MS Office Training

Our Style:

  • Relaxed, Practical, Useful

Methods of instruction:

  • Classroom training with max class-size 4 people
  • Virtual classrooms via online video links
  • 1-1 mentoring
  • Customised training

Certification:

Our PCWorkshops certificates are assessment based.Our Java course outlines are aligned with Oracle courses. We assist with exam prep for the prestigious, international Oracle Certified Associate qualification.

Our clients are:

Data analysts and all others who use large sets of dataSoftware companies, testing companies, companies employing software developersCoders and new coders who need Accredited Java qualification

Customisation:

We can tailor all our courses. Email to customise location, times, content.

 

 Terms and Conditions:

By booking a course with us, you agree to the terms and conditions specified on our website: https://pcworkshopslondon.co.uk/termsandconditions.html

 

From £16.96
Multiple dates