Microsoft Excel

Learn adanced features in Excel how to use Excel to manage business data

MICROSOFT EXCEL

Advanced

DURATION

1 Day

LEVEL

Advanced

PRICE

£ 410

COURSE OVERVIEW

Give students the chance to expand on the knowledge they gained in previous Velsoft Excel 2016 courseware by introducing them to Microsoft Excel 2016 and VBA course.

Microsoft Office Excel 2016 and VBA continues Velsoft’s in-depth training material for Excel 2016. This course gives students the skills they need to harness Visual Basic for Applications, or VBA, to automate many tasks they encounter while using Excel 2016.

This comprehensive training package explores the following topics:

  • Developing Macros
  • Formatting Worksheets Using Macros
  • Creating an Interactive Worksheet
  • Working with Multiple Worksheets
  • Performing Calculations

LEARNING OBJECTIVES

At the end of the course you will be able to:

  • Advanced Excel functions to consolidate data to meet business criteria
  • Co-authoring documents by enabling document sharing and track changes
  • Searching and analyzing data with advanced criteria
  • Preparing reports by grouping and consolidation techniques
  • Advanced data presentation by using conditional formatting and charts
  • Exchanging data between software by using plain text files
  • Allowing users to input correct data by applying validation rules
  • Protecting documents with passwords
  • An overview of task automation by using Macros

PREREQUISITES

BENEFITS OF TAKING THIS COURSE

  • Marketable Skill

    The skill is sort after by employers.

  • Career Path

    Enhance & solidify your technology skillset.

  • Get Certified

    This course is on the Certification Path

WHAT IS INCLUDED

  • Course Materials

    Study Manuals and all required material for the course

  • Certificate

    Certificate on completion of the course.

  • Refreshments Provided

    Refreshments provided through out the course.

WHY CHOOSE US

  • Expert Trainers

    All our courses are provided by expert trainers with industry experience

  • Exceptional Pass Rate

    98% pass rate across our diverse training range

  • Industry Experience

    With over 25 years training and consulting experience.