• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Excel Advanced  Course, 1-Day

Excel Advanced Course, 1-Day

By PCWorkshops

4.6(12)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • Delivered Online or In-Person

  • Advanced level

Description

Excel Advanced Course, 1-Day.


Who should attend: Excel Advanced is for Excel Experts: Your work daily with Excel and your work revolves around spreadsheets and Excel databases.


Course Details:
Location: Instructor-led, Online.
Our Style: Hands-on, Practical Course.
Group Size: Max 4 people per group.
Qualification: PCWorkshops Excel Advanced Certification
Hours: 1 Day, 10am-5pm
Delivery Style: 1-1, because we understand that individuals have varying skill levels and varying applications.


Excel Advanced Course Description

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

Excel Tables and Advanced Filter
Working with Excel tables
Copy specific datasets from sheets, workbooks or external data

Consilidate

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 Functions,
Logical Functions,
Array Functions,
Rounding Functions

Advanced Excel Pivot Table Tools
Importing Pivot Table Data,
Calculated Fields in Pivot Tables,
Showing Pivot Data as a Percentage,
Creating Custom Pivot Tables Styles
Pivot Charts

Excel Macros
Creating, amending and deleting macros
Running macros
Macro menus, toolbars and shortcuts

Alternative Excel Courses

Inlcuded with the Excel Advanced Course

  • PCWorkshops Excel Advanced Certificate on completion

  • Excel Advanced Notes

  • Excel Code Examples

  • Practical Excel Advanced exercises

  • Personalised attention in a 1-1 session

About us

  • Our experienced trainers are award winners.

  • FAQ's

  • Client Comments

Location

Golden Cross House, 8 Duncannon St, WC2N 4JF, United Kingdom, London

About The Provider

PCWorkshops
PCWorkshops
London
4.6(12)
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.
Read more about PCWorkshops

Tags

Reviews