Microsoft Excel Intermediate with CPD Certificate - Nationwide

Infero Training Ltd

Microsoft Excel Certificate of completion

Digital certificate - Included

Microsoft Excel Intermediate Course Content

Lesson 1: Customising the Excel Environment with Microsoft Excel

• Configure Excel Options
• Customise the Excel Ribbon and the Quick Access Toolbar
• Enable Excel Add-Ins

Lesson 2: Creating Advanced Formulas with Microsoft Excel

• Use Excel range names in formulas
• Use specialised Excel functions
• Use Excel array formulas

Lesson 3: Analysing Data with Functions and Conditional Formatting with Microsoft Excel

• Analyse data in Excel by using text and logical functions
• Apply advanced conditional formatting in Excel

Lesson 4: Organising And Analysing Datasets and Tables with Microsoft Excel

• Create and modify Excel tables
• Sort Excel data
• Filter Excel data
• Use SUBTOTAL and database Excel functions

Lesson 5: Visualising Data with Basic Charts with Microsoft Excel

• Create Charts in Excel
• Modify and Format Charts in Excel

Lesson 6: Analysing Data with PivotTables, Slicers, and PivotCharts with Microsoft Excel

• Create a PivotTable in Excel
• Analyse PivotTable Data in Excel
• Present Data with PivotCharts in Excel
• Filter Data by Using Slicers in Excel

.

Microsoft Excel Intermediate Course Objectives

Upon successful completion of this Microsoft Excel Intermediate course, you will have gained the skills necessary to:

• Customise the Excel environment
• Create advanced Excel formulas
• Analyse data in Excel by using functions and conditional formatting
• Organise and analyse Excel datasets and tables
• Visualise Excel data by using basic charts
• Analyse Excel data with PivotTables, slicers, and PivotCharts

.

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 friendly and endlessly patient. There are just the right number of breaks between concise, targeted modules to make learning as near effortless as 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 Intermediate course is designed for individuals who already have foundational knowledge and skills in Excel presented in the Microsoft Excel Introduction course to help you get the most of your Excel experience . It will prepare to advance their data analysis skills and abilities through the application of advanced Excel functionality such as advanced formula creation, tables, charts, PivotTables and PivotCharts.

.

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 Intermediate course, it is recommended to take the Microsoft Excel Introduction 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