Excel Notes Section

Books

PowerQuery

• BIij - M is for (Data) Monkey $15

PowerPivot

• Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016 2nd Edition by Rob Collie, Avichal Singh
• The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI (Business Skills) 1st Edition by Alberto Ferrari, Marco Russo
• Microsoft Excel 2013 Building Data Models with PowerPivot (Business Skills) 1st Edition by Alberto Ferrari, Marco Russo
• Learn to Write DAX ($15 ebook)
  NOTE: The author is a contributor to PowerPivotPro.com
• excelaratorbo.com link
• Dashboarding and Reporting with Power Pivot and Excel [eBook] by Kasper de Jonge
  MrExcel.com link

Excel Localised Date (e.g. French-English)

• Option 1
  SuperUser.com - Excel OS regional dates

• Option 2
  an option that I didn't use
  Microsoft Answers - Excel issuewith regional dates

• Option 3
  Simply use the excel formulae YEAR(), MONTH(), and DAY() and excel will translate them!
  on StackOverflow

Other

Add notes to your formulae:

Add a space then +N(“your comment here”) to leave comments by your formulas, either for your own reference or to help other people understand your spreadsheet. Comments don’t appear in the cell but do show up in the Formula bar, and they’re searchable too.

Gizmodo post - 18 tricks to make yourself a microsoft excel master