IPATS Home
HR and Marketing

Data Analysis and Visualisation with Microsoft Excel - Introduction

Ahmed Nager Chatha, Pakistan

Course Description

Data Analysis and Visualisation with Microsoft Excel - Introduction
Description
Data Analysis and Visualisation with Excel Introduction Course Content

Lesson 1: Data Analysis Fundamentals

Topic A: Introduction to Data Science
Topic B: Create and Modify Tables
Topic C: Sort and Filter Data

Lesson 2: Visualising Data with Excel

Topic A: Visualise Data with Charts
Topic B: Modify and Format Charts

Lesson 3: Analysing Data with Formulas and Functions

Topic A: Analyse Data with Formulas and Named Ranges
Topic B: Analyse Data with Functions

Lesson 4: Analysing Data with PivotTables

Topic A: Create a PivotTable
Topic B: Analyse PivotTable Data

.

Course Objectives

Upon successful completion of this Data Analysis and Visualisation with Excel Introduction course, students will be able to:

perform data analysis fundamentals
visualise data with Excel
analyse data with formulas and functions
analyse data with PivotTables
.

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
Career path
Being proficient in Data Analysis and Visualisation with Excel Introduction can open the door to many career opportunities such as:

Administrative Assistant
Data Analyst
Accountants
Financial Analyst
Retail Store Manager
Project Manager
Business Analyst


*************************************************For Registration & Information***************************************
Whatsapp: +923O3553O865, 03035530865, +92 3219606785, 3035530865,+92 3315145601
Please Call: +923315145601, 03495021336
Website: www.ipatsedu.com || http://courses.ipatsedu.com || http://diplomas.ipatsedu.com
Email: ipatsedu@gmail.com
IPATS UK CANADA USA & Government recognized Education Institue Rawalpindi, Islamabad
Institute of Professional and Technical Studies (IPATS )
Head Office: 2nd Floor, Yasir Plaza, Near Chatri Chowk, Khanna Pull, Qadeer Road, Rawalpindi, Islamabad
Contact Office: +923O3553O865,03219606785, 03035530865, 0331-5145601, 0349-5021336
Email: ipatsedu@gmail.com || Website: www.ipatsedu.com || http://courses.ipatsedu.com || http://diplomas.ipatsedu.com || http://courses.ipatsedu.com || http://diplomas.ipatsedu.com