## Count Dates

### 28 06 2020

## Vertical and Horizontal Line

### 28 06 2020

## 20% of the Formulas give 80% of the Results

### 15 06 2020

Answer to Which 20% Excel formulas give 80% of the results for data science and BI analysis? by Duncan Williamson https://www.quora.com/Which-20-Excel-formulas-give-80-of-the-results-for-data-science-and-BI-analysis/answer/Duncan-Williamson-1?ch=99&share=bd0b812a&srid=2m1N

## Quora Questions

### 05 11 2019

I write answers on various Excel topics at http://www.quora.com and this page provides links to some of my answers. They are not normally massively complex questions but I answer the ones that I think might be interesting to my visitors and readers. The pages are probably in reverse order: lastest pages first; but that should not matter!

Update 5th December 2019

How do I convert F to C in Excel?

How can you take a profit and loss statement in CSV format and easily load it into PowerBi?

Why does Microsoft Office make it so difficult to guarantee your work is saved?

How do I extract consecutive capitalized words from a body of text in Microsoft Excel?

Why doesn’t Excel recognise comma separated values as separate and filterable?

How do you graph 10,000 data in an Excel chart?

What is paste special in Excel?

What is the x-intercept and y-intercept of two lines x-3y=7 and 2x-5y=4?

https://www.quora.com/How-do-I-make-a-line-graph-in-PowerPoint/answer/Duncan-Williamson-1

**How can one have two things on the same axis in Excel?**

This page is on my facebook page and not Quora! The page shows a Power BI image of the flight path of LY1747 of El Al … it is unusual, to say the least. https://www.facebook.com/william.williamson.144/videos/1600460606762146/

**What are some real life examples and applications of multiple regression?**

**Which duplicate does Excel remove?**

**How do I paste a chart from one Excel to a blank Excel?**

**What are the most unused excel formulas?**

**Journalizing records data chronologically in accounting. What is the explanation of it?**

## FUNCTIONS … top 100

### 22 12 2018

I just came across a couple of pages on hbr.org that you need to know about and forgive me if these are behind a paywall: I subscribe to the HBR so I went straight to every page.

Firstly, *10 Excel Functions Everyone Should Know* by Adam Lacey and Deborah Ashby. I prefer DGET to their INDEX-MATCH function but otherwise, this is a good start to learning the top 10. Top 10 Excel Functions

Then there is a REALLY useful PDF file *The Definitive 100 Most Useful Excel Tips* at https://excelwithbusiness.com/blog/definitive-100-most-useful-excel-tips/

Finally and following on from the 100 must useful Excel tips, Marc Zao-Zanders gives us this, *A 2×2 Matrix to Help You to Prioritise the Skills to Learn Right Now*, here: https://hbr.org/2017/09/a-2×2-matrix-to-help-you-prioritize-the-skills-to-learn-right-now This 2×2 matrix puts the 100 tips on a grid/graph to illustrate four quadrants:

- Decide whether you need to learn it
- Learn it as the chance arises
- Schedule a block of time for learning it
- Learn it right away

Marc says this, “You’ll find the quickest wins in the bottom-right quadrant, which we’ve labeled “Learn it right away.” In here we have time-saving shortcuts that can be applied frequently, like Ctrl-Y (redo) and F2 (edit cell) and a nice combination formula that cleanses your spreadsheet of errors (IF(ISERROR)).” Of course, IF(ISERROR) is way out of date and should be replced by IFERROR()

Duncan Williamson

22nd December 2018