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
Customer Outreach Award
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.
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.
Request info
Global PA Association & Training Academy
Global PA Association & Training Academy is a Professional Membership Association & Training Academy for Executive Assistants, Executive PAs, Private PAs, Office Managers, Team Assistants & Junior Managers. Global PA upskill the Office Professional Sector across the World and provide...