Utiva

Learning Outcomes

Learning Slides : Excel

Introduction

Introduction to Spreadsheets

Save Workbooks, Access recent workbooks _ Pin workbooks

Excel Templates

Tabs, Ribbons _ Groups

Cells, Rows, Columns _ Ranges

Inputting _ Formatting Data

Creating Basic Excel Formulas

Relative _ Absolute Cell References

Learning Outcomes

Structure of an Excel Function

SUM() Function

MIN() _ MAX() Functions

AVERAGE() Function

COUNT() Function

Adjacent Cell Errors

Autosum

Learning Outcomes

Applying Simple Formats

Conditional Formatting

Named Ranges and Tables

Learning Outcome

Datasets

The IF() Function

Nested-IF()

IFS() Function

COUNTIF() Function

SUMIF() Function

IF ERROR() Function

Learning Outcomes

Datasets

VLOOKUP() Function

HLOOKUP() Function

Submit your Assignment

INDEX() Function

MATCH() Function

INDEX() _ MATCH() Functions

Learning Outcomes

Datasets

Basic Excel Charts

Pivot Tables

Grouping Pivot Tables

Calculated Fields in Pivot Tables

Filtering Pivot Table Data

PivotCharts

Filtering with Slicers

Learning Outcomes

Datasets

Dashboard - 1

Dashboards - 2

PowerPivot

Activating the PowerPivot Add-in

Data Models with PowerPivot

Creating PivotTables from Data Models

Learning Outcomes

Datasets

What If Analysis - Goal Seek Tool

What If Analysis - Solver Tool

What If Analysis - Data Tools

What If Analysis - Scenario Manager

Learning Outcomes

Datasets

Data Cleaning in Excel

Importing Data from External Sources - Web Example

Capstone Project

Submit your Project

Feedback Survey

Reinforce Your Learning

Mid-Term

LinkedIn Optimisation I

LinkedIn Optimisation II

LinkedIn Optimisation III

Introduction to PostgreSQL

Learning Outcomes

Introduction to databases I

Introduction to Databases II

Introduction to Databases [Presentation]

Learning Outcomes

Introduction to databases III

Introduction to Databases [Presentation II]

Learning Outcomes

Datasets

PostgreSQL Installation

The PostgreSQL GUI I

The PostgreSQL GUI II

The PostgreSQL GUI III

Importing CSV Files to pgAdmin I

Importing CSV Files to pgAdmin II

Submit your Assignment

Learning Outcomes

Simple SELECT statements I

Simple SELECT statement II

Simple SELECT statement III

Filtering Query Results with WHERE Clause I

Filtering Query Results with WHERE Clause II

Filtering query results with WHERE clause III

Aggregate Functions

Learning Outcomes

Subqueries in the SELECT Clause

Subqueries in the FROM Clause

Subqueries in the WHERE Clause

Subqueries ANY _ ALL Operators

Submit your Assignment

Learning Outcomes

Datasets

Basics of Joins

Inner Joins

Left Joins

Right Joins

Full Joins

Union and Union All

Learning Outcome

Datasets

SQL Data Cleaning (String and CONCAT() Function)

REPLACE() Function

UPPER() _ LOWER() Functions

LENGTH() Function

LTRIM(), RTRIM() and BTRIM() Functions

SUBSTRING(), LEFT() and RIGHT() Functions

Learning Outcomes

Date Function I

Date Function II

PostgreSQL Views

CASE Statements

Complete Your Payment!

Datasets

SQL Shell

Wrap up _ Capstone Project

SQL Feedback Survey

Submit your Project

Learning Slide

Learning Outcome

Welcome to PowerBI

Introduction to PowerBI

Introduction to Formatting [Must Watch]

Reinforce Your Learning

Learning Slide

Learning Outcome

Data Preparation and Transformation

Assessment

Copy of Live Lesson

Learning Slides

Learning Outcomes

Data Model and Dax

Learning Slide

Learning Outcomes

Data Visualisation [Creating Dashboard]

Learning Slide

Learning Outcomes

Creating Interactive Dashboards

Power BI Capstone Project

Feedback Survey

Submit your Project

Reinforce Your Learning

Welcome to the Jobberman x Utiva Employability Program

Sharpening Your Soft Skills

Welcome to the SkilledUp Life UK x Utiva Employability Program

Practice what you have learnt so far.

Feedback Survey

Welcome to your Virtual Projects Program!

Indicino Capstone Project

AGCC Capstone Project