About the Course
Learn how to carry out simple procedures to help you understand your data and transform it into meaningful tables and outputs.
Many telecommunications data files and survey files come in the form of tables, which can be viewed and analysed in Microsoft Excel. The course shows you how to add and split text fields, convert text numbers to values, analysing data with pivot tables and how to sort data without corrupting it.
Understand how to:
Create subsets of data to work on independently
Work with text and the difference between text and values
Create and use pivot tables
Format data for presentations
Filter and sort data without corrupting it
Convert csv files to xlsx and vice versa.
Prerequisites
Whilst there are no formal prerequisites for this online course, ideally you will have some basic computer skills.