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

Knowledge Tree Logo

Excel VBA

Course is intended for those familiar the basics of VBA who want to develop their knowledge and greater use of language capabilities. The course is designed for users of Excel for creating analyzes and reports.

by Knowledge Tree [Claim Listing ]
Chamber of Commerce Training Logo

Microsoft Powerpoint (Getting Started New)

This morning session is aimed at anyone who needs to start creating presentations in Powerpoint.

by Chamber of Commerce Training [Claim Listing ]
Acuity Training Logo

Excel Training: Advanced Course

Learn to use Excel’s most powerful features on this 2-day advanced Excel training course.

by Acuity Training
Smartthink Training Ltd Logo

Microsoft Visio 2013 Essentials

Microsoft Visio 2013 Essentials is offered by Smartthink Training Ltd

by Smartthink Training Ltd [Claim Listing ]
M Training Logo

Microsoft Powerpoint Training Course

This one day course will train you how to create a more impressive presentation using some of the more advanced features of PowerPoint, in particular, transitions, custom animations and timings, advanced image editing, advanced formatting, using tables, charts, shapes, SmartArt, backgrounds

by M Training [Claim Listing ]

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