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

Teach All About IT Logo

ICDL Level 2 Word

The ICDL Level 2 is an internationally recognised certification that shows future and current employers evidence of your computer literacy. Tailored for beginners or occasional computer users, the Level 2 ICDL course units aim to elevate you to a high standard of computer proficiency.

by Teach All About IT [Claim Listing ]
I Train Scotland Logo

Microsoft Word (Level 1)

Whether you are a new user or have been using Word for years, this course will vastly increase your understanding of Word. Existing users will learn how to get the most out of Word, break any bad habits, learn shortcuts and discover a massive range of hints and tips from our expert Word trainers.

by I Train Scotland [Claim Listing ]
Escalla Logo

MS Visio Course

During this hands-on session, you will learn how to create flowcharts and cross-functional flowcharts to visualize business processes, and how to create organization charts to display a hierarchy of personnel.

by Escalla [Claim Listing ]
Infero Training Logo

Microsoft Visio (Advance)

You will create visually engaging diagrams, maps, and drawings, using graphical elements to make information easier to comprehend. This course is suitable for anybody wanting to learn 2016, 2013, 2010 or 2007, as it cover all the aspects and differences between the versions.

by Infero Training [Claim Listing ]
AJ Training Logo

 Microsoft Publisher Training Course

Publisher is a comprehensive solution for creating and publishing a wide variety of publications for desktop printing, commercial printing, E-mail distribution or for viewing on the Web.

by AJ Training [Claim Listing ]

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