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
- Create, edit and format spreadsheets
- Navigate within worksheets and books
- Use Insert Function to create built-in functions
- Work with absolute references
- Create named ranges
- Create Tables within Excel
- Sort and filter data