Intermediate Excel Course For Business

Course

Online

£ 50 + VAT

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Intermediate Excel for Business Level II is the second of a three part series that aims to tackle the most common and practical uses of Excel in business. This course is perfect for those who have either taken Level I or already have a basic working knowledge of excel and would like to improve efficiency and expand into Excel's more complex functions and data management features. By the end of this course, you will feel confident dynamically extracting data from large databases using advanced functions such as Vlookup, and quickly organizing and analyzing large amounts of raw data with Pivot Tables. The skills acquired in this course are what many employers have come to expect and look for in new applicants and existing employees.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Extracting data from large databases using advanced functions such as Vlookup
Organizing and analyzing large amounts of raw data with Pivot Tables

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • MS Excel
  • Project
  • Excel

Course programme

Introduction to Excel for Business Level II 20 lectures 02:30:50 Introduction Tips & Fundamentals Navigation Paste Special Paste Special Values Splitting Text Joining Text Named Ranges Data Validation Remove Duplicates Vlookup Hlookup Sort & Filter Pivot Tables Pivot Tables & Grouping Multiple Pivot Tables If Statements And, Or Function COUNTIFs and SUMIFs Combo Charts Introduction to Excel for Business Level II 20 lectures 02:30:50 Introduction Tips & Fundamentals Navigation Paste Special Paste Special Values Splitting Text Joining Text Named Ranges Data Validation Remove Duplicates Vlookup Hlookup Sort & Filter Pivot Tables Pivot Tables & Grouping Multiple Pivot Tables If Statements And, Or Function COUNTIFs and SUMIFs Combo Charts Introduction Introduction Introduction Introduction Tips & Fundamentals Tips & Fundamentals Tips & Fundamentals Tips & Fundamentals Navigation Navigation Navigation Navigation Paste Special Paste Special Paste Special Paste Special Paste Special Values Paste Special Values Paste Special Values Paste Special Values Splitting Text Splitting Text Splitting Text Splitting Text Joining Text Joining Text Joining Text Joining Text Named Ranges Named Ranges Named Ranges Named Ranges Data Validation Data Validation Data Validation Data Validation Remove Duplicates Remove Duplicates Remove Duplicates Remove Duplicates Vlookup Vlookup Vlookup Vlookup Hlookup Hlookup Hlookup Hlookup Sort & Filter Sort & Filter Sort & Filter Sort & Filter Pivot Tables Pivot Tables Pivot Tables Pivot Tables Pivot Tables & Grouping Pivot Tables & Grouping Pivot Tables & Grouping Pivot Tables & Grouping Multiple Pivot Tables Multiple Pivot Tables Multiple Pivot Tables Multiple Pivot Tables If Statements If Statements If Statements If Statements And, Or Function And, Or Function And, Or Function And, Or Function COUNTIFs and SUMIFs COUNTIFs and SUMIFs COUNTIFs and SUMIFs COUNTIFs and SUMIFs Combo Charts Combo Charts Combo Charts Combo Charts Bonus 6 lectures 32:24 Project Countifs Sumifs Vlookup-Closest Match Ranking Table Review Bonus 6 lectures 32:24 Project Countifs Sumifs Vlookup-Closest Match Ranking Table Review Project Project Project Project Countifs Countifs Countifs Countifs Sumifs Sumifs Sumifs Sumifs Vlookup-Closest Match Vlookup-Closest Match Vlookup-Closest Match Vlookup-Closest Match Ranking Ranking Ranking Ranking Table Review Table Review Table Review Table Review

Additional information

Basic knowledge of excel  Go Through Excel for Business Level I Course

Intermediate Excel Course For Business

£ 50 + VAT