Data Analyst and Technical Consultant

Tag: excel

VBA Starter Kit

VBA Starter Kit

VBA is a programming language used in Excel to record routine tasks and procedures.  By creating a short script you can automate adding new data to a sheet, performing calculations and create custom functions.

Five handy addons for Google Sheets

Five handy addons for Google Sheets

If you’re new to Google Sheets there are some quick addons you can use to add functionality and make it feel more like Excel

Transpose data in Excel

Transpose data in Excel

If you have a worksheet with data in columns that you want to rotate so it’s rearranged in rows, you can use the Transpose feature. It lets you quickly switch data from columns to rows or vice versa

Visualisation: Dashboard Design

Visualisation: Dashboard Design

Presenting data and focusing on design when creating a dashboard seems easy enough but there are some simple things you can do to make the message clearer and quicker for the user to understand.

More Logical Excel Functions

More Logical Excel Functions

Here are five logical functions to use in Excel that will help you answer questions based on one or more conditions

Pivot Tables

Pivot Tables

Pivot tables allow you to organise and summarise your data without changing the source data itself.