HOME
 

Microsoft Excel LIVE Intermediate E-Learning

Global PA Association & Training Academy
Course summary
2 hours
36 GBP excl. VAT
English
Part time
Online courses

Course description

Global PA Tech: Intermediate Excel E-Training with fully qualified Microsoft Trainer

Tuesday 26th January 2021 at 11am-12.30 via Zoom

  • Copy rows filtered using a criteria range
  • Display several lines of data in one cell
  • Absolute reference in a formula
  • Copy values, copy with a link, transposing
  • Move, copy, hide sheets
  • Select, delete, copy and move objects
  • Format chart items; Modify chart’s text items; Legend and plot area; Data series and chart axes; Manage series, chart templates
  • Create and manage sparklines
  • Modify a text box, drawing
  • Rotate, align, stack and group objects
  • Apply, manage conditional, custom formats
  • Validation criteria
  • Convert data; Create a data series
  • Use cell ranges in functions
  • Summarise data with an outline
  • Attach a comment to a cell
  • Calculate with copied values.

Suitability - Who should attend?

This bite-size E-Course on Intermediate Microsoft Excel is for anyone in the workplace who wishes to update their skills and knowledge of Excel. 

This course is for Office Professionals - Executive Assistants, Personal Assistants, Executive PA, Team Assistants, Admin Assistants, Secretaries, Office Managers, Team Leaders & Managers

Outcome / Qualification etc.

You will be eligible for the Global PA Association CPD Certificate for 1.5 hours of learning.

Training Course Content

Tuesday 26th January 2021 at 11.00-12.30 - LIVE with Microsoft Trainer

  • Copy rows filtered using a criteria range
  • Display several lines of data in one cell
  • Absolute reference in a formula
  • Copy values, copy with a link, transposing
  • Move, copy, hide sheets
  • Select, delete, copy and move objects
  • Format chart items; Modify chart’s text items; Legend and plot area; Data series and chart axes; Manage series, chart templates
  • Create and manage sparklines
  • Modify a text box, drawing
  • Rotate, align, stack and group objects
  • Apply, manage conditional, custom formats
  • Validation criteria
  • Convert data; Create a data series
  • Use cell ranges in functions
  • Summarise data with an outline
  • Attach a comment to a cell
  • Calculate with copied values.

Course delivery details

Tuesday 26th January 2021 at 11.00-12.30.  

Why choose Global PA Association & Training Academy

90% Client Satisfaction

12 years of developing thousands of EAs & PAs across the world

Specialists in understanding the role of Office Professionals

Expenses

£36 inc. VAT

Continuing Studies

Microsoft Intermediate Powerpoint E-Course on Tuesday 2nd February 2021 at 11.00-12.30pm

Delegates can attend further E-learning & Masterclass Workshops with the Global PA Association & Training Academy which are:

  • The Role of the Executive Assistant - E-Learning and/or Masterclass Workshop
  • 7 Key Skills PA Management Programme - 6 week E-Learning or 3 day Masterclass Workshop
  • Management Skills for Executive Assistants - 4 week E-Learning
  • Project Management Skills for Executive Assistants - E-learning and/or Masterclass Workshop
  • Microsoft Outlook, Powerpoint & Excel E-Learning
  • 1:1 Training & Mentoring with the Founder - via Zoom
  • Fellow, Platinum & Associate Membership of the Global PA Association offering discounts on Masterclass Workshops, Seminars, free Webinars & CPD points. 

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Get Inspired! Watch the Video

About provider

Global PA Association & Training Academy

Global PA Association & Training Academy have been established 12 years and are global leaders in training and development of Office Professionals. Our training is delivered around the world from China to Australia across the Far East, Middle East, USA,...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Microsoft Excel LIVE Intermediate E-Learning.

  Contact the provider

  Get more information

  Register your interest

Country *

Contact info

Global PA Association & Training Academy

Dudley House 169 Piccadilly, Mayfair
W1J 9EH London

 Show phone number


Request information

Find out more about this Microsoft Excel LIVE Intermediate E-Learning course - simply fill out your details:

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here