Excel Introduction Course, Private 1-to-1, Live Online.

Excel Introduction Course, Private 1-to-1, Live Online.

During this 1-day Excel course you will master the best of Microsoft Office Excel. Instructor-led. Practical. Online. 1-1. Customizable.

By PCWorkshops

Select date and time

Wed, 14 May 2025 03:00 - 09:00 PDT

Location

Online

Refund Policy

No Refunds

About this event

MICROSOFT EXCEL COURSE: INTRODUCTION, 1-TO-1.


EXCEL COURSE SUMMARY

During this intensive one-day Excel course you will master the main features of Microsoft Office Excel. It is entirely ‘hands on’ and you will practice creating and modifying actual spreadsheets.

This course runs online via your internet connection and Gotomeeting.com


COURSE OUTCOME

Create a professional budget, personal budget or financial model with formulae.


EXCEL COURSE OUTLINE

Excel Beginners Course:

Excel Basics: The home ribbonFormatting:

  • Changing fonts style, size, bold, italics underlining, colour.
  • Border styles and cell shading.
  • Cell Styles with pre-defined styles.
  • Cell alignment, left, right, center, top, middle, bottom, indent, outdent, merging cells, text direction, text wrapping within cells.
  • Number formatting, currencies, formatting of dates.
  • Clearing content and formats of cells.
  • Copy formats.

Tables

  • Using Format as a table and working with tables and column filters.
  • Adding and removing filters.
  • Sorting.
  • Find and replace values.
  • Freeze panes on large spreadsheets.
  • Insert and delete rows, columns and cells.


Finding trends:

Conditional formatting.


Protecting:

Protecting cells and sheets, with and without passwords.

Protecting files with passwords.


Formulae and functions:

Formula basics. Popular functions, sum avg, count, minimu and maximum.

Function wizard basics.

Copying and cut cells and formulae, absolute and releative dell references, copying absolute cell references.

Creating a spreadsheet with formulae and functions.


Saving:

Save, Print, pdf and share your spreadsheets.


WHAT IS INCLUDED:

  • Excel Course Certificate on completion (assessment based)
  • Excel Course notes
  • Practical Class Excel Course exercises, Excel sample files.
  • 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.

 

 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

 

£185