Around 150 out of 14000+ features are used in Office. Most think that the other features are for someone else. In fact, they are for YOU! Find out how by reading this blog.
If you get a feeling that you are helping the app instead of the app helping you, the diagnosis is clear – the method you are using is Inefficient!
You are using Office extremely inefficiently. This is GOOD news. Why? Because now you are aware.
Knowing a problem is the first step towards solving it.
Next step: Read this blog!
Starting a new video series on Power BI. Here is the first video: Power BI Data Import.
We spend lot of time in data cleaning. But there is no simple definition of exactly what clean data means. Therefore, I created a simple 10 item checklist. If all 10 items are correct, data is clean. Simple and easy to use.
10 rules for Clean data
Remember, here we are talking about input data – not output (reports).
- Each column must have a heading
- No blank headings
- No duplicate headings
- No formulas in headings
- No merged cells
- Each column must have ONE meaning
- Each column must have ONE type of data
- No subtotals or grand totals
- Formatting should not be used instead of data
- Data must grow vertically, not horizontally
Convert clean data to a Table
If you are using Excel, as soon as data is cleaned, convert it into a Table. Why? Here are the benefits of using Excel Tables – 13 articles.