MS Excel Advanced Course

by PCWorkshops

Excel Advanced is for Excel Experts: you work daily with Excel and your work revolves around spreadsheets and Excel databases. This course is offered one-to-one, because we understand that individuals have varying skill levels and varying applications.

£290

Contact the Institutes

Fill this form

Advertisement

PCWorkshops Logo

img Duration

1 Day

Course Details

Excel Advanced is for Excel Experts: you work daily with Excel and your work revolves around spreadsheets and Excel databases. This course is offered one-to-one, because we understand that individuals have varying skill levels and varying applications.

 

Content:

  • 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, Logical, Array, 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
  • WC2N Branch

    Golden Cross House, 8 Duncannon Street, WC2N, London
  • M2 Branch

    53 Fountain Street, M2, Manchester
  • MK9 Branch

    Exchange House, 494 Midsummer Boulevard, MK9 , Milton Keynes
  • City Centre Branch

    One Victoria Square, City Centre, Birmingham
  • Cosham Branch

    Ground Floor, Building 1000, Lakeside North Harbour, Western Road, Cosham, Portsmouth

Check out more MS Excel courses in UK

Infero Training Logo

Microsoft Access Programming With VBA

In Access VBA you will learn how to extend the functionality of Access using a programming language called Visual Basic for Applications (VBA). With VBA you can create code which will allow you to automate the functionality of your database.

by Infero Training [Claim Listing ]
Computer Training Wales Logo

Microsoft PowerPoint Beginner Course

This course is designed to provide you with the essential skills and knowledge to create dynamic and engaging presentations using Microsoft PowerPoint.

by Computer Training Wales [Claim Listing ]
London IT Training (LIT) Logo

Office 365 Administrator Training (MS030)

Office 365 Administrator MS030 training course covers the deployment and administrative configuration process of Office 365.

by London IT Training (LIT)
Computer Tutoring Logo

Microsoft Visio 2019 Training Course (Beginner)

Become an expert flowcharter with the customisable tools of Microsoft Visio 2019. Easily create a professional-looking visual product by using its extensive gallery of shapes.

by Computer Tutoring [Claim Listing ]
Elliott Training UK Logo

Microsoft Word – Introduction

On successful completion of the course, delegates will be able to create, edit and print professional-looking content more quickly than ever, apply format changes, produce professional tables and accelerate routines via the AutoCorrect feature.

by Elliott Training UK [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy