Verify and use formulas and functions built-in excel formulas

MCU-CS500: ADVANCED DATA ANALYSIS

Introductory Overview
Week 1

Chapter breakdown

In Chapter 1 we will demonstrate how to create an Excel spreadsheet, how to modify and to format this. We will also see how to create and format charts for visualising data. These concepts will be demonstrated using monthly budget amounts data, which will be used to create a budget worksheet.

Learning Objectives:

Chapter 1: You will learn to:

	Format Excel worksheets, for example by changing the cell style, font and colour. Create 3-D pie charts. Display data statistics using the AutoCalculate area.

Chapter 3: You will learn to:

At this point, you are required to access our ebook: