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

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

You will learn a lot of things about Microsoft Excel, including how to create advanced formulas and organise your data into tables. You'll discover the power of PivotTables and PivotCharts and how slicers can make data filtering as easy as clicking a few buttons.

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

.

Benefits of Studying Microsoft Excel Intermediate with Infero Training:

• CPD Accredited Classroom training in Small Groups for Max Focus
• Only Microsoft Approved Courseware and Exercise Files are used
• Free Assessment of Skills prior to booking
• Certificate of Completion & Complementary 12 Months Post Course Support
• Premier Locations, Latest Tech, Refreshments, OR We Come to You
• 100% Money Back Guarantee & Price Match Guarantee
• Bespoke Courses & Group Discounts from £89 per person

.

Certification

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

This Microsoft Excel Intermediate 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 Application Specialist certification.

Microsoft Excel Intermediate Course Content

• Lesson 1: Customising the Excel Environment
  • Topic 1A: Configure Excel Options
  • Topic 1B: Customise the Ribbon and the Quick Access Toolbar
  • Topic 1C: Enable Excel Add-Ins

• Lesson 2: Creating Advanced Formulas
  • Topic 2A: Use Range Names in Formulas
  • Topic 2B: Use Specialised Functions
  • Topic 3C: Use Array Formulas

• Lesson 3: Analysing Data with Functions and Conditional Formatting
  • Topic 3A: Analyse Data by Using Text and Logical Functions
  • Topic 3B: Apply Advanced Conditional Formatting

• Lesson 4: Organising And Analysing Datasets and Tables
  • Topic 4A: Create and Modify Tables
  • Topic 4B: Sort Data
  • Topic 4C: Filter Data
  • Topic 4D: Use SUBTOTAL and Database Functions

• Lesson 5: Visualising Data with Basic Charts
  • Topic 5A: Create Charts
  • Topic 5B: Modify and Format Charts

• Lesson 6: Analysing Data with PivotTables, Slicers, and PivotCharts
  • Topic 6A: Create a PivotTable
  • Topic 6B: Analyse PivotTable Data
  • Topic 6C: Present Data with PivotCharts
  • Topic 6D: Filter Data by Using Slicers

.

Microsoft Excel Intermediate Course Objectives

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

• Customise the Excel environment
• Create advanced formulas
• Analyse data by using functions and conditional formatting
• Organise and analyse datasets and tables
• Visualise data by using basic charts
• Analysing 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 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 Intermediate course is designed for individuals who already have foundational knowledge and skills in Excel and are ready 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.

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

• Microsoft Excel Introduction

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

Certificate of completion

Digital certificate - Included