Microsoft Excel Advanced with CPD Certificate - Onsite/In-Company

Infero Training Ltd

Certificate of completion

Digital certificate - Included

Microsoft Excel Advanced 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

.

Microsoft Excel Advanced Course Objectives

Upon successful completion of this Microsoft Excel Advanced course, you will have gained the skills necessary 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

.

Microsoft Excel Course Testimonials from our Website and Google Reviews

I was absolutely delighted with the Excel courses that Infero delivered which more than exceeded my expectation. I learnt new ways of using Excel that I can now use in my day to day work to make my work more efficient. Pivot tables were always a mystery to me but now I use them regularly to display HR and Payrol data.

Lisa Dunstan (Payroll Manager) from Decathlon UK

.

The day after taking the Excel Intermediate Course, I created two pivot tables and used several advanced formulas to do, in ten minutes, tasks that would previously have taken me hours. The teaching at Infero is easy to follow, the lessons are brilliantly delivered and the instructors are experts in their field, extremely friendlyand endlessly patient. There are just the right number of breaks between concise, targeted modules to make learning as near effortlessas possible. The ‘aftercare’ element - a tutor will usually answer your queries within hours - is particularly valuable. A great lunch, too.

Harry Frost (Marketing Assistant) from Babcock International Group

.

Had Excel training with Infero last week, I must say it was a good day, I am not the most gifted on excel, but after spending the day with our tutor Martin I came away with a lot more confidence and knowledge, and i will be back for more at a later date, Martin paced the course excellently so no one got left behind or not understanding how to do something. We had good rapport with Martin, even though he forgot how to spell his name :) must be an age thing Lol

Martin Pountney

.

I attended the level 3b training course offered by Infero Training and, like with many similar courses I have attended, was initially worried that it would be too much information to take in at once. However, the manuals and exercises provided along with the guidance and experience of our trainer Martin made the course interactive, concise and, dare i say it, enjoyable. I would highly recommend.

Michael Sexton

.

I attended the Excel Basic and Excel Intermediate course which I found very useful. Martin is an excellent trainer, made you feel at ease, he is very helpful and patient. I wish I had undertaken the training ages ago as would have been very beneficial in my previous role.

Leela Patel

This Microsoft Excel Avanced course is designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyse worksheet data, incorporate multiple data sources, and import and export data.

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

• Microsoft Excel Introduction
• Microsoft Excel Intermediate

Being proficient in Microsoft 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