The 'Learn Excel Visually' Journey
I'm not exaggerating when I say that Excel is the most important computer software program today.
Excel is relevant for all aspects of a business and honestly, it's not hard to learn. Excel is a robust program but spreadsheets created by users are often fragile. Have you ever used Excel, submitted it and something was wrong, a slipped formulae or mistyped number? I know I have, countless times!
Apparently even smart people can have trouble mastering Excel! To be fair, you can't track where the data came from, there is no quick way to follow the flow of data in a spreadsheet, mistakes are easy to make, but they are also easy to fix - the success of a spreadsheet is in the design and documentation.
The Learn Excel Visually journey is here to take you through the functions and usability of Excel. take the steps to invest in yourself and develop your Excel skills; it will make you much more marketable to your current and future employer or business. Capture data efficiently, cleanse it, analyse it meaningfully and present it with visual oomph. In short, take this journey in order to champion your skills and increase your value.
Learn Excel Visually - Excel Intermediate Formulae (Data Tidying)
Safeguard your data. Get it spick, span and ready for inspection.
There will be many times when you're asked to collect data for something; it might be survey data, sales, timesheets, stock-take, just to name a few. Collecting data might come in many different forms, but one of the optimum ways to be able to work with your data is to input or import it into Excel. You may not always have control over how it's captured, but you can take control of the raw data when it's in a spreadsheet in order to make it work for you.
While it’s essential to ensure the completeness of the data but more important to keep the integrity of the data. We do this by removing elements which may impede analysis or affect the quality of the results. We need to ensure the most effective prep to allow the most reliable and meaningful analysis. Data tidying is not necessarily a one-off step; things may come to light or new data collected, but if you can do as much as possible up-front it keeps things simple as you go along.
This book takes through some data-tidying best practice and data-organising formulae; how to find text within a cell, how to split text or combine it, how to standardise the data; get rid of unwanted characters, spaces and inconsistencies. Remember the information within this book will facilitate your data cleanse, but it won't tell you exactly what to cleanse, everyone's data is different and everyone's purpose for having data is different. Know what you need to do and then let me help you do it with a sprinkling of best practice along the way. Read on to start the journey.
Formulae covered in this book are:
LEN
LEFT / RIGHT / MID
SEARCH / FIND
Find First Name - LEFT / SEARCH
Find Last Name - RIGHT / LEN / SEARCH
Find Middle Name - LEFT / MID / SEARCH / LEN
CONCATENATE
TRIM
DATES
IFERROR
The previous book on The 'Learn Excel Visually' Journey:
Learn Excel Visually - Excel Basic Formulae
Learn key formulae to analyse and present your data effectively.
The 'Learn Excel Visually' Journey - Excel Formula - Book 1
http://amzn.to/1CpzdfX