Excel Advanced Course, 1-to-1, London, Live Online

Excel Advanced Course, 1-to-1, London, Live Online

Excel Advanced is for Excel Experts: you daily work revolves around spreadsheets and Excel databases. Online. Practical. Instructor-led.

By PCWorkshops

Select date and time

Wed, 24 Apr 2024 02:00 - 07:00 PDT

Location

Online

Refund Policy

No Refunds

About this event

MICROSOFT EXCEL ADVANCED COURSE, PRIVATE 1-TO-1

Excel Advanced is for Excel Experts - you work daily with Excel and your work revolves around spreadsheets and Excel databases. This course is offered one-to-one, because we understand that individuals have varying skill levels and varying applications. Read more

EXCEL COURSE OUTLINE

General

  • Editing Standard Formatting Rules 
  • Input Validate rules 
  • Using Formulas in Conditional Formatting 
  • Group and Outline 
  • Filter and Sorting 

Data Insights with Pivot Tables

File and sheet Linking

  • Referring to multiple sheets and external files within formulae and functions 
  • Working with multiple sheets
  • Linking external files

Excel Tables and Advanced Filter 

  • Working with Excel tables 
  • Selectively Copy specific datasets, selective rows and columns from sheets, workbooks or external data 
  • Automate this process and integrate with data importing

Consolidate Goal seek, consolidate and scenarios Using Form Templates 

  • Creating Templates 

Advanced Excel Lookup Functions 

  • VLookup Function 
  • Hlookup Function 
  • Using the Index Function,
  • Using the Match Function,
  • Index and Match Together 
  • Using the Indirect Function 

Excel Advanced Functions 

  • Using Error, Logical, Array, Rounding Functions 

Excel Macros 

  • Creating, amending and deleting macros 
  • Relative and Absolute recording of cell references
  • Running macros 
  • Creating Macro menus, toolbars and shortcuts to execute macros by the click of a button

WHAT IS INCLUDED:

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

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.

 

 

 

£100 – £185