Easter special sale Get up to 45% OFF until 31st Marsee the offers

  • No products in the basket.

Microsoft Excel 2016 Data Analysis

4.5( 2 REVIEWS )
Microsoft Excel 2016 Data Analysis


Microsoft Excel 2016 Data Analysis focuses on the data analysis or math. The course will teach learners on data analysis methods and concepts. Excel is used for the math formulas and calculations, as formulas are presented as Excel spreadsheets.  If you would like to learn how you can use Excel 2016 and generate relevant information, this course is perfect for you.

The Microsoft Excel 2016 Data Analysis course will cover key features such as functions and formulas, financial and statistical functions, data tables, validating cells, analytical tools and pivot tables.  The course is designed to equip learners on how they can apply their relevant Excel skills to analyse data in business applications. The course will educate you on how to import data, merge data, organise and analyse data in business applications.

Become a power user of Excel and increase your efficiency in your job. Learn how to be effective in a work environment and a high performing individual. The course will enable you to impress your employer and even potential organisations.  The qualification will be helpful in enhancing career opportunities or job promotion.

Why consider 1Training?

As improvements and advancements are made in technology, online courses are no longer just conventional means of studying at affordable costs. In many aspects online training offers superiority to traditional learning. There is an effectiveness and convenience that traditional learning cannot provide. The overall convenience and flexibility makes it a superior learning method.

1Training offers the most convenient path to gain an internationally recognised qualification that will give you the opportunity to put into practice your skill and expertise in an enterprise or corporate environment. You can study at your own pace at 1Training and you will be provided with all the necessary material, tutorials, qualified course instructor and multiple free resources which include Free CV writing pack, Nus Discounted Card, Free career support and course demo to make your learning experience enriching and more rewarding.

What will I learn?

  • Have a clear understanding of how to apply lookup and statistical functions
  • Learn how to gather and organise data for business analysis
  • Have a sound knowledge in chart generation
  • Learn how to build dashboards using PivotCharts and PivotTables
  • Acquire skills in how to use data analysis tools to generate different scenarios to aid decision making

Access Duration

The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course.  The course is self-paced and you can complete it in stages, revisiting the lectures at any time.

Who is this Course aimed at?

  • Managers
  • Administrative Officers
  • Executives
  • Office Administrators
  • HR Officers
  • Finance Officers

Entry Requirement

  • There are no formal pre-requisites for this course
  • Basic skills in computer
  • Knowledge of Microsoft Excel is recommended but not necessary

Method of Assessment

In order to complete the Microsoft Excel 2016 Data Analysis course successfully and gain your professional qualification, all students are required to complete an online multiple choice question assessment test. This online test is marked automatically and learners will receive an instant grade on whether they have passed the course.

If it is an official exam, you can purchase it separately on the relevant website.

Certification and Awarding Body

At the successful completion of the course you will be awarded the Microsoft Excel 2016 Data Analysis Certification by CPD and iAP. It will make you valuable to employers, and your motivation at gaining new skills will be recognised.

Progression and Career Path

Once you successfully complete the Microsoft Excel 2016 Data Analysis, you will gain an accredited qualification that will give your career the jumpstart you have always wanted. With this qualification you can further expand your education or go onto work in numerous positions that will also put you in line to demand a higher salary or job promotion. The average UK salary per annum according to is given below.

  • Manager – £24,439 per annum
  • Administrative Officer – £19,507 per annum
  • Executive Assistant – £30,502 per annum
  • Office Administrator – £17,477 per annum
  • HR Officer – £24,435 per annum
  • Finance Officer – £22,692 per annum

 Other Benefits

  • Written and designed by the industry’s finest expert instructors with over 15 years of experience
  • Repeat and rewind all your lectures and enjoy a personalised learning experience
  • Gain access to quality video tutorials
  • Unlimited 12 months access from anywhere, anytime
  • Save time and money on travel
  • Learn at your convenience and leisure
  • Eligible for a TOTUM discount card

Key Features

Gain an accredited UK qualification

Access to excellent quality study materials

Learners will be eligible for TOTUM Discount Card

Personalized learning experience

One year’s access to the course

Support by phone, live chat, and email

Course Curriculum Total Units : 54
➤ Module 01: Functions and Formulas
01 Lesson - Topic A: Logical and Conditional Functions
1.1. Logical and Conditional Functions – Part 1
1.2. Logical and Conditional Functions – Part 2
1.3. Logical and Conditional Functions – Part 3
02 Lesson - Topic B: Financial and Statistical Functions
2.1. Financial and Statistical Functions – Part 1
2.2. Financial and Statistical Functions – Part 2
2.3. Financial and Statistical Functions – Part 3
03 Lesson - Topic C: Date/Time and Arrays
3.1. Date/Time and Arrays – Part 1
3.2. Date/Time and Arrays – Part 2
3.3. Date/Time and Arrays – Part 3
➤ Module 02: Lookups and Data Tables
01 Lesson - Topic A: Lookup Functions
1.1. Lookup Functions – Part 1
1.2. Lookup Functions – Part 2
1.3. Lookup Functions – Part 3
02 Lesson - Topic B: Data Tables
2.1. Data Tables – Part 1
2.2. Data Tables – Part 2
2.3. Data Tables – Part 3
03 Lesson -Topic C: Validating Cells
3.1. Validating Cells – Part 1
3.2. Validating Cells – Part 2
3.3. Validating Cells – Part 3
04 Lesson - Topic D: Filtering
4.1. Filtering – Part 1
4.2. Filtering – Part 2
4.3. Filtering – Part 3
05 Lesson - Topic E: Charting and Graphics
5.1. Charting and Graphics – Part 1
5.2. Charting and Graphics – Part 2
5.3. Charting and Graphics – Part 3
➤ Module 03: PivotTables
01 Lesson - Topic A: Working with PivotTables
1.1. Working with PivotTables – Part 1
1.2. Working with PivotTables – Part 2
1.3. Working with PivotTables – Part 3
02 Lesson - Topic B: Modifying PivotTable Data
2.1. Modifying PivotTable Data – Part 1
2.2. Modifying PivotTable Data – Part 2
2.3. Modifying PivotTable Data – Part 3
03 Lesson - Topic C: Formatting PivotTables
3.1. Formatting PivotTables – Part 1
3.2. Formatting PivotTables – Part 2
3.3. Formatting PivotTables – Part 3
04 Lesson - Topic D: Using PivotCharts
4.1. Using PivotCharts – Part 1
4.2. Using PivotCharts – Part 2
4.3. Using PivotCharts – Part 3
05 Lesson - Topic E: PowerPivot
5.1. PowerPivot – Part 1
5.2. PowerPivot – Part 2
5.3. PowerPivot – Part 3
06 Lesson - Topic F: Exporting and Importing Data
6.1. Exporting and Importing Data – Part 1
6.2. Exporting and Importing Data – Part 2
6.3. Exporting and Importing Data – Part 3
➤ Module 04: Analytical Tools
01 Lesson - Topic A: Goal Seek
1.1. Goal Seek – Part 1
1.2. Goal Seek – Part 2
1.3. Goal Seek – Part 3
02 Lesson - Topic B: Scenarios
2.1. Scenarios – Part 1
2.2. Scenarios – Part 2
2.3. Scenarios – Part 3
03 Lesson - Topic C: Solver
3.1. Solver – Part 1
3.2. Solver – Part 2
3.3. Solver – Part 3
04 Lesson - Topic D: Instant Data Analysis
4.1. Instant Data Analysis – Part 1
4.2. Instant Data Analysis – Part 2
4.3. Instant Data Analysis – Part 3
WhatsApp chat