Chronicles of Data - Page 6 of 6 - Analytics and Data Science Tips

Normalise in Excel

How to normalize data in Excel using STANDARDIZE

by Tom
October 6, 2020December 11, 2022
Excel

Excel CEILING

How to use the Excel CEILING function

by Tom
October 5, 2020December 11, 2022
Excel

SQL Aggregate Functions

SQL Aggregate Functions Explained

by Tom
October 3, 2020November 19, 2022
SQL, SQL Made Easy

SQL Wildcard Characters

SQL Wildcard Characters Explained

by Tom
October 3, 2020November 19, 2022
SQL, SQL Made Easy

SQL Primary Key

SQL Primary Key Explained

by Tom
September 25, 2020November 19, 2022
SQL, SQL Made Easy

SQL Operators

SQL Operators Explained

by Tom
September 23, 2020November 19, 2022
SQL, SQL Made Easy

SQL Select Distinct

SQL SELECT DISTINCT Explained

by Tom
September 23, 2020November 19, 2022
SQL, SQL Made Easy

VLOOKUP In Excel

How to easily merge data in Excel with a VLOOKUP

by Tom
September 13, 2020December 11, 2022
Excel

What is SQL

What exactly is SQL? A simple summary

by Tom
September 12, 2020November 19, 2022
SQL

Why Excel users should learn SQL

Why Excel users should learn SQL

by Tom
September 12, 2020November 19, 2022
SQL, Excel