Microsoft Excel Advanced with CPD Certificate - Leeds

This intensive 1 day, hands-on course Microsoft Excel Advanced course is fully Accredited by CPD and helps you gain comprehensive, practical understanding of Excel.

You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.

This course is suitable for anybody wanting to learn 2013, 2010 or 2007, as it covers all the aspects and differences between the versions.

Benefits of Studying Excel with Infero Training:

• Instructor-Led course in a small group for maximum knowledge retention
• Comfortable Premises with the latest technology
• Microsoft Official Curriculum (optional)
• Free 12 Months Post Course Support
• Certificate of Completion
• CPD Points
• Refreshments

Certification

Upon completion of the course, you will receive CPD Points.

This course is also one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets. The Microsoft Certified Application Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified

Course Content

Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously

Topic 1A: Use 3-D References

Topic 1B: Use Links and External References

Topic 1C: Consolidate Data

Lesson 2: Sharing and Protecting Workbooks

Topic 2A: Collaborate on a Workbook

Topic 2B: Protect Worksheets and Workbooks

Lesson 3: Automating Workbook Functionality

Topic 3A: Apply Data Validation

Topic 3B: Work with Forms and Controls

Topic 3C: Work with Macros

Lesson 4: Applying Conditional Logic

Topic 4A: Use Lookup Functions

Topic 4B: Combine Functions

Topic 4C: Use Formulas and Functions to Apply Conditional Formatting

Lesson 5: Auditing Worksheets

Topic 5A: Trace Cells

Topic 5B: Search for Invalid Data and Formulas with Errors

Topic 5C: Watch and Evaluate Formulas

Lesson 6: Using Automated Analysis Tools

Topic 6A: Determine Potential Outcomes Using Data Tables

Topic 6B: Determine Potential Outcomes Using Scenarios

Topic 6C: Use the Goal Seek Feature

Topic 6D: Activate and Use the Solver Tool

Topic 6E: Analyse Data with Analysis ToolPak Tools

Lesson 7: Presenting Your Data Visually

Topic 7A: Use Advanced Chart Features

Topic 7B: Create Sparklines

Course Objectives

Upon successful completion of this course, students will be able to:

• Work with multiple worksheets and workbooks simultaneously.
• Share and protect workbooks.
• Automate workbook functionality.
• Apply conditional logic.
• Audit worksheets.
• Use automated analysis tools.
• Present your data visually.

This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

Before taking this course, students are recommended to take the following courses, or have equivalent knowledge:

• Microsoft Excel Introduction
• Microsoft Excel Intermediate

Being proficient in Excel can open the door to many career opportunities such as:

• Administrative Assistant
• Data Analyst
• Accountants
• Financial Analyst
• Retail Store Manager
• Project Manager
• Business Analyst