Data Analysis Made Easy

Carefully considered guides to help improve your data analysis.

What is Data Gatekeeping

A guide for how to implement processes that disseminate data

universal analytics key features blog post feature image

5 ways Universal Analytics improved web performance analysis

An outline of the impact universal analytics had on the way transactional website performance was captured and reported.

IFERROR vs ISERROR

A guide to the differences between IFERROR and ISERROR Excel Functions

How to create nested IFs in Excel blog post feature image

How to use nested IFs

A step-by-step guide for using Nested IFs

How to use sumifs function blog post feature image

SUMIFS. The People’s favourite Function

An introductory guide to the SUMIFS Function

Let’s talk COUNT Functions

4 need to know count functions explained in this guide

Join the mailing list to stay updated

[mailpoet_form id="3"]

How to use left and right functions blog post feature image

How to use the LEFT and RIGHT Functions

An Introductory Guide to Left and Right Functions

How to display the calendar month of a date

This guide will show you how to display the calendar month of a date using with an Excel formula

Using array constrains with countif function blog post feature image

How to use array constraints with the COUNTIFS Function

An advanced guide to using COUNTIFS to get more from your data

How to use subtotal function blog post feature image

Adding Subtotals to your data

A step-by-step guide to adding subtotals to your data summaries

SUMIFS. The People’s favourite Function

An introductory guide to the SUMIFS Function

IFERROR vs ISERROR

A guide to the differences between IFERROR and ISERROR Excel Functions

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyse and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.

Necessary

Always Enabled

Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.

Cookie	Duration	Description
cookielawinfo-checkbox-advertisement	1 year	Set by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Advertisement" category .
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
CookieLawInfoConsent	1 year	Records the default button state of the corresponding category & the status of CCPA. It works only in coordination with the primary cookie.
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.

Functional

Performance

Analytics

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.

Cookie	Duration	Description
_ga	2 years	The _ga cookie, installed by Google Analytics, calculates visitor, session and campaign data and also keeps track of site usage for the site's analytics report. The cookie stores information anonymously and assigns a randomly generated number to recognize unique visitors.
_ga_EQQNC0TZ45	2 years	This cookie is installed by Google Analytics.
_gat_gtag_UA_206306690_1	1 minute	Set by Google to distinguish users.
_gid	1 day	Installed by Google Analytics, _gid cookie stores information on how visitors use a website, while also creating an analytics report of the website's performance. Some of the data that are collected include the number of visitors, their source, and the pages they visit anonymously.

Others