catraining

 

advanced excel course london

Advanced Excel Training courses Excel 2013

Audience: This course is aimed at experienced Excel users wishing to further their Excel skills. Majoring on Pivot Tables and recorded macros we explore many of Excel's other great productivity features like auditing, protecting and linking workbooks and What-If analysis.

Course Duration: 1 day(1)

Course Types: Group bookings, public courses, 1-2-1 sessions, bespoke tailored courses and Saturday club.

Course Location: This Microsoft Excel 2013 Advanced training course is delivered at our training centre in London situated close to Liverpool Street station; training can also be delivered at your offices. Tailored course content can be customised to meet your specific requirements, with scheduled dates to suit you.

 

MOS Excel Specialist / Expert Exam Costs ( optional )

 

All Vouchers now include a Retake Voucher
Option 1 - Voucher & Retake

Option 2 - Voucher, Retake and Gmetrix ( Test Prep )

Option 3 - Exam Pack includes - Voucher, Retake, Gmetrix and Exam study manual

Discount 4 for 3 on MOS Exam Packs

 

View Scheduled Public Courses

reaining course

 

After completing this course, students will be able to:
    • Audit a worksheet
    • Link worksheets and workbooks
    • Perform What if Analysis
    • Protect and Outline Excel documents
    • Collaborate with other Excel users
    • Import and Export Data
    • Filter and summarise worksheet data
    • Analyse worksheet data with Pivot Tables
    • Record macros

  • Course Outline
    print this page
    Module 1: Auditing a worksheet
    • Tracing precedents and dependents
    • Tracing errors in the worksheet
    • Error checking
    • Watch window
    Module 2: Linking worksheets and workbooks
    • Make use of the way Excel 2013 opens each workbook (new)
    • Setting up related worksheets within a workbook
    • Entering a formula to link related worksheets and workbooks
    • Creating a workspace
    • Consolidate worksheets and workbooks
    Module 3: What if Analysis
    • Goal Seek
    • 1 way and 2 way Data Tables
    • Scenario Manager
    Module 4: Protection and Outlining
    • Protecting worksheets and workbooks
    • Grouping and outlining a worksheet
    Module 5: Working with other Excel users
    • Create a shared workbook
    • Tracking changes in a shared workbook
    • Responding to proposed changes and comments in a shared workbook
    • Module 6: Importing and Exporting Data
      • Importing data from a text or web based file
      • Working with other applications such as Access
     
    Module 7: Filtering and summarising worksheet data
    • Use the Quick analysis tool (new)
    • Autofilter and advanced filter
    • Adding a criteria range with advanced filter
    • Database functions
    • Using subtotals and nested subtotals
    • Use the subtotal function
    • Power Maps (new)
    Module 8: Pivot Tables
    • What is a Pivot Table?
    • Best practice on setting up Pivot Tables
    • Creating a Pivot Table
    • Resetting the summary function in a Pivot Table report
    • Grouping Pivot Table data
    • Formatting a Pivot Table
    • Charting a Pivot Table
    • Printing the Pivot Table
    • Normalising Pivot Table data sources
    • Convert Ranges to Tables
    • Using other Microsoft data sources with Pivot Tables
    • Using Slicers and TimeLines to filter PivotTable data (new)
    • Integrating Power Pivot and Power View (new)
    Module 9: Recording Macros
    • Macro guidelines
    • Macro security settings
    • Recording and deleting macros
    • Running macros
    • Assign a macro to the QAT, ribbon or shortcut keys
    • Recording relative and absolute cell selection
     
     
      Microsoft

Advanced Excel Training Courses

This course is instructor led, and involves lots of  examples and exercises in a workshop environment. Led by highly experienced Microsoft Excel trainers with many years of experience our hands-on courses mean that you will leave with lots of practical Excel experience as well as useful tips and tricks. We  train on the following versions 2007, 2010, 2013, 2016 and office 365, please make the trainer aware on the day if you use a another version and they can point out anything that may be slightly different.

do you need advanced excel course in london or advanced excel training courses accross the uk maybe advanced excel courses for accountants exploring financial functions,

For all your Advanced Excel Training courses Excel 2013

Call us now for further information Tel:08001601666