Microsoft Excel Advanced with CPD Certificate - Nationwide

Infero Training Ltd

Microsoft Excel Advanced Course Content

Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously with Microsoft Excel

• Use 3-D Excel References
• Use Excel Links and External References
• Consolidate Data in Excel

Lesson 2: Sharing and Protecting Workbooks with Microsoft Excel

• Collaborate on a Workbook in Excel
• Protect Excel Worksheets and Workbooks

Lesson 3: Automating Workbook Functionality with Microsoft Excel

• Apply Excel Data Validation
• Work with Excel Forms and Controls
• Work with Excel Macros

Lesson 4: Applying Conditional Logic with Microsoft Excel

• Use Excel Lookup Functions
• Combine Functions in Excel
• Use Excel Formulas and Functions to Apply Conditional Formatting

Lesson 5: Auditing Worksheets with Microsoft Excel

• Trace Cells in Excel
• Search for Invalid Data and Formulas with Errors in Excel
• Watch and Evaluate Excel Formulas

Lesson 6: Using Automated Analysis Tools with Microsoft Excel

• Determine Potential Outcomes Using Excel Data Tables
• Determine Potential Outcomes Using Excel Scenarios
• Use the Goal Seek Excel Feature
• Activate and Use the Solver Tool in Excel
• Analyse Excel Data with Analysis ToolPak Tools

Lesson 7: Presenting Your Data Visually with Microsoft Excel

• Use Advanced Excel Chart Features
• Create Sparklines in Excel

.

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 Excel worksheets and workbooks simultaneously
• Share and protect Excel workbooks
• Automate Excel workbook functionality
• Apply conditional logic in Excel
• Audit Excel worksheets
• Use Excel's automated analysis tools
• Present your Excel 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 Microsoft 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 Microsoft 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 Advanced course is intended for students who are experienced Excel users and have a desire or need to advance their skills in working with some of the more advanced Excel features. Students will likely need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel functions, and use those functions to perform rigorous analysis of extensive, complex datasets.

This Microsoft Excel Advanced course builds on the foundational and intermediate knowledge presented in the Microsoft Excel Introduction and Microsoft Excel Intermediate courses to help you get the most of your Excel experience.

.

Suggested Learning Path:

• Start with Microsoft Excel Introduction to learn the basic Excel functions and interface
• Move onto Microsoft Excel Intermediate once you're comfortable with Excel basic operations, focusing on more advanced Excel formulas and data manipulation
• Progress to Microsoft Excel Advanced if you need to handle large datasets, automation, and complex Excel analysis tasks.

Before taking this Microsoft Excel Advanced course, it is recommended to take the Microsoft Excel Introduction course and Microsoft Excel Intermediate course, or have equivalent knowledge.

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