July 2022 Intake On-going. Learn more

Data Analysis With Microsoft Excel (Basic Level)

Course Prerequisites

About This Course

This is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel. 

Learning Objectives

By the end of the course, learner will be able to: 

  • get started with Excel  
  • explore the general environment of Excel  
  • use the new features of Excel  
  • use the new functions of Excel 
  • perform simple calculation & formatting 
  • use the shortcuts keys 
  • print the Excel worksheet 

Requirements

  • Basic understanding of data management concepts and constructs such as relational database tables
  • Know how different pieces of data logically relate to one another.

Target Audience

Learners who are new to Excel and needs to know the new features of Microsoft Excel. 

Training Outline

  1. Getting Started with Microsoft Excel 
  2. Setting Up a Workbook in Excel 
  3. Changing Workbook Appearance 
  4. Basic Calculation in Excel 
  5. Highlight the Features in Excel