Get this course

Information Technology

MS Excel : Data Management


Description
This MS Excel: Data Management module is designed to help the learner to explore the various features in MS Excel which is used to sort, manage large pool of data, present it in a meaningful way and to increase the digital knowledge of learner in this program.

Module Content Outline:

1. How to sort data

2. How to filter data

3. How to create Pivot Table

4. How to create chart from data


Created by,

MA Batch 2020

Ng Samuel



Disclaimer Note:

The videos and files in the courses are just for internal use and the illustrations attached are all for education purposes only. The resources and information used are all obtained from internet. Kindly refer to the other official sources for more detailed information.
Content
  • 1. INTRODUCTION
  • 1.1 INTRODUCTION
  • 2. HOW TO SORT DATA
  • 2.1 HOW TO SORT DATA
  • 2.2 HOW TO SORT DATA (GUIDE)
  • 3. HOW TO FILTER DATA
  • 3.1 HOW TO FILTER DATA
  • 3.2 HOW TO FILTER DATA (GUIDE)
  • 4. HOW TO CREATE PIVOT TABLE
  • 4.1 HOW TO CREATE PIVOT TABLE P1
  • 4.2 HOW TO CREATE PIVOT TABLE P2
  • 4.3 HOW TO CREATE PIVOT TABLE (GUIDE)
  • 5. HOW TO CREATE CHART FROM DATA
  • 5.1 HOW TO CREATE CHART FROM DATA
  • 5.2 HOW TO CREATE CHART FROM DATA (GUIDE)
Completion rules
  • All units must be completed
Back