Excel Intermediate 1-Day Course, 1-1, Online.
Multiple dates

Excel Intermediate 1-Day Course, 1-1, Online.

This practical, instructor-led, online course is designed to give you excellent techniques to improve your good already Excel Spreadsheet.

By PCWorkshops

Location

Online

Refund Policy

No Refunds

About this event

EXCEL INTERMEDIATE COURSE, 1-TO-1, ONLINE


COURSE SUMMARY


This Excel course is offered one-to-one or in small group of up to 4, because we understand that professionals have varying skill levels and varying applications.

We run the class in our Virtual Online Classroom, Instructor-led, Practical, Interactive.

You already have the basic Excel skills but have many questions daily and want to be more proficient.


COURSE OUTLINE

Hour 1: Working with Functions and Formulas

· Creating Formulae in Excel, general calculations

· The Function Wizard

· Using Functions in Excel: The 5 Popular functions

· Working with Names and Ranges

· Copying formulae

· Remove duplicates, data validations, drop lists

S ubtotals:

· Group and Outline, Range names,

· Sub Totals

Hour 2: Functions

· CountBlanks, Count Non numeric cells, Count numeric cells

· If Function, Nested if

· And and Or functions


Hour 3:

· Vlookup, Hlookup, Index, Match

· Sumifs, averageifs, countifs, maxifs, minifs

Hour 4: Sheet linking and file linking

· Working with multiple files and sheets,

· Linking files and sheets with formulae.

· Updating files

Consolidate:

· Create functions using labels and not cell references

Templates:

· Create and save a template file with formulae,

· Protecting and unprotecting formula cells


Hour 5: Pivot-tables

· Create Pivot Table, Amend, Filter, Sort, Group Data, Format Pivot Tables, Add additional formulas, Refresh Data. Pivot Charts

Hour 6: Finding Trends

· Conditional Formatting

· Add, remove, format Spark Lines

Managing Tables

· Working with Tables , Working with Records and Fields ,


WHAT IS INCLUDED:

  • Certificate on completion
  • Course notes
  • Practical Class exercises, Homework / Revision work
  • To assist after the course, 1 free session for questions online

Frequently asked questions

Do I need Excel on my laptop for the session?

Preferrably

Can the course be customised?

Yes, let us know by email beforehand

Can I bring my own worksheets?

Yes, make sure sensitive data is anonymised

Tags

Organised by

PCWorkshops

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 £108.39
Multiple dates