Microsoft Excel
Learn how to use Excel to manage business data
MICROSOFT EXCEL
Advanced
DURATION
1 Day
LEVEL
Advanced
PRICE
£ 410
COURSE OVERVIEW
Excel is Microsoft’s powerful and easy-to-use spreadsheet program. This version of Excel incorporates some new features and integration of features that were previously only available as separate add-ins.
This course builds on what was learned in the first two Excel courses. Topics include:
- Automating worksheet functionality
- Auditing worksheets
- Analysing and presenting data
- Working with multiple workbooks
- Exporting Excel data
- Importing and exporting XML data
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