MS Excel Course For Data Analytics, Online & Classroom

MS Excel Course For Data Analytics, Online & Classroom

MS Excel Data Analysis 1-Day Course, Online, Instructor-led, Practical.

By PCWorkshops

Select date and time

Fri, 26 Apr 2024 02:00 - 09:00 PDT

Location

Online

Refund Policy

Contact the organiser to request a refund.

About this event


Excel Formulas and Functions

You can work on Excel but sometimes marvel at the formulas, that your colleagues have created. Excel is easy. We will cover formulae in depth in this interesting course.

Course Outline

Session 1:

Popular Functions:

  • Sum, Average, Count, Counta, Countblank, Maximum and minimum.

Create from Scratch:

  • Program general arithmetics into Excel,
  • using addition, subtraction, multiply, divide, brackets

Copy Formulae

  • using absoulte $ or relative, down accross and both

Excel function wizard for statistical functions:

  • If,
  • Nested if,
  • Sumif(s), Averageif(s), Countif(s)

Names, Ranges and Tables,

  • To simplify cell-referencing
  • Using Ranges as Tables
  • Conditional Formatting

Working with Excel sheets and files,

  • calculating using multiple sheets
  • or files

Session 2:

SubTotals:

  • Excel Subtotals,
  • Group, Outline

Cross referencing data:

  • Xlookup,
  • Vlookup,
  • Hlookup,
  • Match,
  • Index,
  • Indirect

Excel Pivot Tables

  • Create
  • Modify
  • Format
  • Sort
  • Group
  • Charts and Pivot Charts




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.

 

 

 

£185 – £285