+65 8133 0642 / +65 9138 9813 info@xaltius.tech

Data Analysis with Excel

This is an intermediate Excel and SQL short course taking you through the functionalities of Excel for data management and analysis and introducing SQL as an important data tool.

What You’ll Learn

The objective of the workshop is to familiarize the participants with the fundamentals of how to manage, transform and analyze data using the various functions and the power of Microsoft Excel. Excel is a very widely used tool with many organizations and departments and being able to produce a quick analysis is an asset. Along with Excel being a data source and tool to manipulate data, nowadays databases are becoming very popular and part of every organization. Hence, learning and knowing the basics of SQL (Structured Query Language) has become very important. This workshop also takes you through the nuances and fundamentals of how SQL can be used with databases to ingest, manipulate and store data.

Please click the event link in the timetable for the respective price.

Course Plan

MODULE 1: EXCEL PIVOT TABLES
  • Creating Pivot Tables
  • Sorting and Filtering Pivot Tables
  • Formatting Pivot Tables
  • Creating Pivot Charts
MODULE 2: FUNCTIONS & FORMULA
  • IF and Related Functions
  • Lookup and Reference Functions
  • Power Functions, Statistical Functions
  • Math Functions
  • Date and Time Functions
  • Array Functions
  • Text Functions
MODULE 3: ADVANCED CHARTS
  • Creating Basic Charts
  • Style Charts with Design Tabs
  • Fine Tune Chart Elements
MODULE 4: SIMPLE DATA ANALYSIS
  • Installing Data Analysis Tool
  • Goal Seeker & Solver
  • Histogram
  • Linear Regression
MODULE 5: BASICS OF SQL AND DATA IN SQL
  • Basics of Databases and Tables
  • Database and Table Designs
  • Normal Forms
  • Basics CRUD Operations on Tables
  • Where, Having Clauses
  • Joins (Inner/Outer)
  • Aggregate Queries
  • Sub-queries
  • Basics of Stored Procedures

Timetable

June 20th, 2020 – Click here to register

Prerequisites

Basic knowledge of Excel and tables would be beneficial for this workshop.

About the Course

With the basic knowledge of excel, this is an opportunity to move on to the next level and learn more about the advanced functionalities excel has to offer along with a taste of SQL and its importance in the data world today.

Relevant Courses

Data Literacy – Let the data journey begin!

Data Literacy Before embarking on the data journey, organizations need to be equipped with the right skills and be data literate. This course walks through that journey and empowers individuals with the skills required to get an organization ready. What You'll...

read more

Excel VBA for Beginners

In order to increase office productivity, we require to automate our business processes. In this training learn how VBA can be used to automate Excel tasks.

read more

Amazon Web Services and Introduction to DevOps

Cloud has become the go-to place today for storage, computation, security and many other services. The cloud is disrupting the analytics industry and taking over processes and applications by storm! This course helps you understand the fundamentals of AWS and DevOps Lifecycle.

read more