Course Library View the full range of courses
-
Accounting (145 courses)
- Xero Accounting and Bookkeeping Online
- Sage 50 Accounting & Payroll
- Project Finance
- Financial Modelling Training
- Tax Accounting
- Introduction to VAT
- Accounting and Finance Course for Managers
- Internal Compliance Auditor
- Financial Statement Analysis
- Payroll Administrator Level 3 Diploma
- View all Accounting courses
-
Language (67 courses)
- British Sign Language (BSL) Level 1 & 2
- Speech and Language Therapy Diploma
- TEFL (TESOL) Course
- English Spelling, Punctuation, and Grammar
- Child & Adult Speech & Language Disorders Training
- Teaching English as Foreign Language (TEFL) Certificate
- Mastering Spanish Language
- French Course for Beginners
- German Course for Beginners
- Body Language and Gesture Training
- View all Language courses
-
Teaching & Education (37 courses)
- Teaching Assistant Complete Course (TA, SEN, Autism, ADHD & Dyslexia) – CPD Certified
- EYFS Teaching Assistant Training Course
- Advanced Diploma in Coaching and Mentoring
- Level 3 Diploma in Teaching and Classroom Management
- Remote Teaching
- SENCO – Special Educational Needs Coordination
- Teaching English as Foreign Language (TEFL)
- Life Coaching
- Phonics Teaching Diploma
- View all Teaching & Education courses
-
Health and Social Care (138 courses)
- Health and Social Care Management
- Paediatric Nursing Assistant
- Mental Health Awareness Training
- Emergency Medicine – Paramedicine
- Level 3 Diploma in Adult Care
- Paediatric First Aid Training
- Safeguarding Children Level 3
- Level 3 Diploma in Anatomy and Physiology of Human Body
- Play Therapy
- The Care Certificate Preparation – Standards (1 to 15)
- View all Health and Social Care courses
-
Management (539 courses)
- Office Admin, Secretarial and PA Diploma
- Estate Agent and Property Management Training
- Diploma in Data Analysis Fundamentals
- Advanced Diploma in Stress & Anxiety Management
- Good Manufacturing Practice (GMP)
- Property Development and Management Course
- Diploma in Hotel Management
- Supply Chain Management
- Quality Assurance (QA) Manager
- Compliance and Risk Management
- View all Management courses
-
IT & Software (123 courses)
- Coding with Python 3
- Search Engine Optimisation (SEO) Training
- Cyber Security
- Motion Graphics with After Effects
- CompTIA A+ Core 1 (220-1101) Course
- Machine Learning for Aspiring Data Scientists
- Next.js Web Dev: Master this Powerful React Framework
- Learn 2D Animation with Adobe Animate
- GDPR Challenges in Education
- View all IT & Software courses
-
Employability (1043 courses)
- Office Administrator Skills
- Presentation Skills
- Legal Secretary and Office Skills
- Hospitality Management
- Estate Agent Diploma
- Hairdressing and Barbering
- Diploma in UK Employment Law
- Diploma in Data Analysis Fundamentals
- Building Surveyor Training
- Emotional Intelligence Training
- View all Employability courses
-
Personal Development (1438 courses)
- Productivity Habits
- Minute Taking Course
- Presentation Skills
- Excel: Top 50 Microsoft Excel Formulas in 50 Minutes!
- Critical Thinking and Problem Solving Skills
- Time Management
- Self Esteem and Confidence Building Course
- Essential IT Skills
- Legal Secretary and Office Skills
- Personality Development
- View all Personal Development courses
Microsoft Excel 2016 Intermediate
24 Students (4 Reviews)
Learn Microsoft Excel 2016 Intermediate with formulas, PivotTables, charts, data analysis, conditional formatting, and workbook management skills.
GET THIS COURSE AND 3000+ OTHERS FOR ONLY £49 PER YEAR. FIND OUT MORE
Overview
Microsoft Excel 2016 Intermediate is a comprehensive course designed to help learners expand their spreadsheet skills and use Microsoft Excel more efficiently for business, administrative, and data management tasks. This programme introduces intermediate-level features that improve productivity, accuracy, and data analysis. Learners will gain valuable insight into managing complex worksheets, organising large datasets, creating professional reports, and using Excel tools to support informed decision-making in a variety of workplace environments.
Developing intermediate Excel skills requires logical thinking, attention to detail, and a practical understanding of spreadsheet functions. Participants will explore topics such as advanced formulas, logical functions, data validation, conditional formatting, tables, charts, PivotTables, sorting and filtering, worksheet protection, and workbook management. The course helps learners understand how to organise, analyse, and present data efficiently while improving workflow and reducing manual tasks.
Strengthening Microsoft Excel 2016 knowledge can create valuable opportunities within administration, finance, accounting, business operations, customer service, project management, and data analysis. The skills gained through this training may support career progression across a wide range of industries while enhancing confidence in producing accurate spreadsheets, reports, and business documents.
Learning Outcomes
- Understand intermediate Microsoft Excel 2016 features
- Develop advanced spreadsheet management skills effectively
- Apply formulas and logical functions confidently
- Analyse data using PivotTables and charts
- Manage worksheets and workbooks efficiently
- Enhance reporting and data presentation abilities
Why choose this course
- Affordable, Accessible, informative and well-structured study materials
- Earn a globally recognised accredited qualification
- Study in your own time, at your own pace, through any device
- Benefit from feedback through mock exams and multiple-choice assessments
- Excellent career advancement/career switch opportunities
- Get 24/7 help or advice from our email and live chat teams
Certification
Certificate of Achievement
After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.
Entry Requirements
Basic knowledge of Microsoft Excel 2016 or equivalent spreadsheet experience is recommended for this course. Learners should be familiar with creating worksheets, entering data, and using basic formulas before progressing to intermediate-level topics.
Who is this course for?
This course is ideal for:
- Office professionals improving Excel proficiency
- Administrative staff expanding spreadsheet skills
- Finance professionals managing business data
- Business users analysing workplace information
- Beginners progressing to intermediate Excel knowledge
Career Paths
This course can support progression into roles and opportunities such as:
- Administrative Assistant
- Office Administrator
- Data Entry Specialist
- Finance Assistant
- Business Support Officer
- Operations Administrator
Course Curriculum
| Microsoft Excel 2016 Intermediate | |||
| Apply Range Names | 00:30:00 | ||
| Use Specialized Functions | 00:30:00 | ||
| Use Text Functions | 00:30:00 | ||
| Use Logical Functions | 00:30:00 | ||
| Use Lookup Functions | 00:30:00 | ||
| Use Date Functions | 00:30:00 | ||
| Use Financial Functions | 00:30:00 | ||
| Create and Modify Tables | 00:30:00 | ||
| Sort and Filter Data | 00:30:00 | ||
| Use Subtotal and Database Functions to Calculate Data | 00:30:00 | ||
| Create Charts | 00:30:00 | ||
| Modify and Format Charts | 00:30:00 | ||
| Create a Trendline | 00:30:00 | ||
| Create Advanced Charts | 00:30:00 | ||
| Create a PivotTable | 00:30:00 | ||
| Filter Data by Using Slicers | 00:30:00 | ||
| Analyze Data with PivotCharts | 00:30:00 | ||
| Insert and Modify Graphic Objects | 00:30:00 | ||
| Layer and Group Graphic Objects | 00:30:00 | ||
| Incorporate SmartArt | 00:30:00 | ||
| Customize Workbooks | 00:30:00 | ||
| Manage Themes | 00:30:00 | ||
| Create and Use Templates | 00:30:00 | ||
| Protect Files | 00:30:00 | ||
| Preparing a Workbook for Multiple Audiences | 00:30:00 | ||
| Activities | |||
| Activities and Exercise Files – Microsoft Excel 2016 Intermediate | 00:00:00 | ||
| Mock Exam | |||
| Mock Exam- Microsoft Excel 2016 Intermediate | 00:20:00 | ||
| Final Exam | |||
| Final Exam- Microsoft Excel 2016 Intermediate | 00:20:00 | ||
| Order your Certificates & Transcripts | |||
| Order your Certificates & Transcripts | 00:00:00 | ||
Original price was: £319.£25Current price is: £25. ex Vat
SAVE 92% - OFFER ENDS IN
ALL
COURSES FOR £49 
14-Day Money-Back Guarantee
- Personal
- Team
Quantity:
Total:
50% discount for orders of 10+ courses
60% discount for orders of 50+ courses
70% discount for orders of 100+ courses
For more personalised package, contact us
Frequently asked questions
Can’t find the anwser you’re looking for ? Reach out to customer support team.
This course builds on basic Excel knowledge by teaching intermediate features used to manage, analyse, and present business data more effectively.
The course is best suited to learners who already have basic Excel knowledge and want to develop intermediate spreadsheet skills.
You will learn advanced formulas, logical functions, PivotTables, charts, conditional formatting, data validation, worksheet protection, and workbook management.
Intermediate Excel skills improve productivity, support better data analysis, and are highly valued across many business and administrative roles.
Yes, learners should have a basic understanding of Microsoft Excel, including entering data, creating simple formulas, and formatting worksheets.
The course covers formulas, functions, PivotTables, charts, tables, sorting, filtering, conditional formatting, workbook management, and data validation.
Yes, the course develops practical spreadsheet skills that can improve efficiency, accuracy, and reporting in many workplace environments.
Important skills include attention to detail, logical thinking, organisation, problem-solving, analytical ability, and computer literacy.
Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks.
We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase.
Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course.
If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.