Showing posts with label data analysis. Show all posts
Showing posts with label data analysis. Show all posts

08 February, 2022

Conditional Formatting in Excel: All you need to know

This is about visual identification and/or formatting (differentiation) of our data sets based on our questions (conditions), in order to: 

  • mark/reveal some data of interest, present them
  • take some action (e.g. find errors, correct, sort, delete, evaluate), or
  • find out some trends and patterns, compare.

Here is the Conditional Formatting main menu (on the left) + More Rules dialog:

04 January, 2022

Template for Basic Data Summary/Analysis

If you have collected and organized some data in table(s) or list(s), the first thing you might need could be to get quick general analysis/evaluation of that data - before going any further with some math, statistical or graphic analysis.

The following example provides easy solution, kind of a template, for that preliminary summary and basic analysis.

Here's just illustrative table of random data. Let's say you want to know "everything" about this set of values.

29 August, 2021

Data Analysis: UPDATE on CoVid-19 Coronavirus Pandemic

Three months later... This is the update of my analysis posted in May this year.

The following is based on information provided by Coronavirus update as of 29 August 2021.

The table below provides list of countries with the highest number (so far) of lives lost per 1000 people living in those countries.  On the right side it shows also countries with a low number (but not the lowest) of deaths attributed to the CoVid-19.

It looks like there is a striking increase of deaths among Peruvians, and a relatively low number of deaths per 1000 residents in Iraq, among others.

The following chart illustrates just the left-hand side of the data table...

20 August, 2021

Custom Excel Worksheet / Workbook Design

Have a specific problem in using Excel?

Maybe I could help...

The tools Excel provides for its users allow creating the abundance of solutions for entering, analysing, presenting and storing of datasets. However, this usually requires more or less in-depth knowledge of the software. Sometimes you may need to create a specific solution to a complex computational task, but your experience isn't sufficient to do that. In such situations you may need to look for help. I could be able to provide some no-obligation advice or assistance in solving your problems related to organizing your data and analysing them according to your needs. You could probably save some time, improve your design, etc..

Define your specific problem or your custom design needs and let me know about them using the Contact box located at the right side of this page. I may be able to provide some assistance in design details and analysis of data or actually design a spreadsheet for you.

Here are just couple of examples, fragments of worksheet designs, I've created some time ago for my own needs.