Skip to content
Chronicles of Data Logo
  • ExcelExpand
    • All Excel Guides
    • Top Excel Resources – Blogs and Websites
  • SQLExpand
    • All SQL Guides
    • SQL Made Easy
  • VisualizationExpand
    • Google Looker Studio
  • Cloud EngineeringExpand
    • AWS
  • About
  • Contact Us
Chronicles of Data Logo
Concatenate in Excel
Excel

How to CONCATENATE in Excel – 2 Easy Formulas

Tom Jul 30, 2023
In this simple step by step guide you will learn how to easily use the formula for concatenate in Excel.There are a few different approaches

Read More »

Read More
Exponential Smoothing in Excel
Excel

Exponential Smoothing in Excel – Step by Step Guide

Tom Jun 30, 2023
Exponential Smoothing is a way of smoothing out time series data in order to more easily see trends. On top of this it then allows

Read More »

Read More
Quartiles in Excel
Excel

How to Find Quartiles in Excel – 1 Easy Formula

Tom Jun 25, 2023
Excel makes it super easily to find quartiles within a dataset thanks to a handy built in formula that does the work for us. This

Read More »

Read More
Standard Error in Excel
Excel

How to Calculate Standard Error in Excel – Step by Step

Tom Jun 24, 2023
This guide will run through 2 different approaches we can take in order to easily calculate standard error in Excel.

Read More »

Read More
Text to Rows in Excel
Excel

How to Split Text to Rows in Excel in 2 Easy Steps

Tom Jun 23, 2023
This guide will run through the quick and easy steps taken in order to split text into multple rows in Excel.

Read More »

Read More
Excel Forecast Function
Excel

Excel FORECAST Function – Extrapolate Data Easily

Tom Jun 19, 2023
In this article we will run through how to use the FORECAST function in Excel with an easy to follow step by step guide.

Read More »

Read More
Mean, Median and Mode in Excel
Excel

Calculate Mean, Median and Mode in Excel – 3 Easy Formulas

Tom Jun 14, 2023
This guide will run through the various simple formulas that can be used in Excel to calculate Mean, Median and Mode.

Read More »

Read More
Error Bars in Excel
Excel

Add Error Bars in Excel – Easy Step by Step Guide

Tom Jun 13, 2023
In this simple guide we will run through how add Error Bars to charts in Excel.

Read More »

Read More
Calculate Probability in Excel
Excel

How to Calculate Probability in Excel – Easy Formula

Tom Jun 12, 2023
This guide will run through how to calculate probability using the PROB formula in Excel.

Read More »

Read More
Excel T-Test
Excel

How to Perform a T-Test in Excel – 2 Easy Methods

Tom Jun 11, 2023
This quick and easy to follow guide will run through the steps taken in order to perform a T-Test in Excel in two ways –

Read More »

Read More
Excel Flash FIll
Excel

How to use Flash Fill in Excel to Automate Work

Tom Jun 10, 2023
This easy to follow guide will run through how to use the Flash Fill function in Excel to save a lot of time when cleaning

Read More »

Read More
Excel Data Analysis ToolPak
Excel

How to Enable the Data Analysis ToolPak in Excel

Tom Jun 6, 2023
In this quick and easy guide we are going to run through the steps that need to be taken in order to access the Data

Read More »

Read More
Moving Average in Excel
Excel

Calculate Moving Average in Excel (Easy Guide)

Tom Jun 5, 2023
In this easy step by step tutorial we will show you how to calculate a moving average in Excel, using both formulas and a built

Read More »

Read More
Create a Heat Map in Excel
Excel

How to Create a Heat Map in Excel (Quick and Easy)

Tom May 20, 2023
Heat Maps are a really handy visualization technique when looking at large tables of data to quickly and easily see which values are highest and

Read More »

Read More
Add a Checkbox in Excel
Excel

How to Insert a Checkbox in Excel (Easy Guide)

Tom Mar 13, 2023
When working with data in Excel, there are a lot of interactive elements we can play with. Maybe we have made a pivot table and

Read More »

Read More
Perform a Spell Check in Excel
Excel

How to Perform a Spell Check in Excel

Tom Mar 13, 2023
Working with spell checks in Excel tends to be a bit of a different process to other tools such as Microsoft Word, largely due to

Read More »

Read More
AWS Cloud Practitioner Exam
AWS

How to Pass the AWS Cloud Practitioner Exam

Tom Feb 28, 2023
I recently sat and passed the CLF-C01 Exam, receiving my AWS Cloud Practitioner Certification.Overall I spent around a month studying for it, with basically zero

Read More »

Read More
Secondary Axis in Excel
Excel

How to Easily Add a Secondary Axis in Excel Charts

Tom Jan 3, 2023
Creating visualizations in Excel can be really powerful, however when working with multiple metrics sometimes things can get a little bit unreadable. This is where

Read More »

Read More

© 2025 Chronicles of Data - WordPress Theme by Kadence WP

  • Excel
    • All Excel Guides
    • Top Excel Resources – Blogs and Websites
  • SQL
    • All SQL Guides
    • SQL Made Easy
  • Visualization
    • Google Looker Studio
  • Cloud Engineering
    • AWS
  • About
  • Contact Us
Search