Microsoft Excel
Learn how to use Excel to manage business data
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
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.