Skip to content

Excel Notes Section

Books

PowerQuery

  • http://www.excelguru.ca/content.php?293-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
  • https://exceleratorbi.com.au/learn-to-write-dax/
  • Dashboarding and Reporting with Power Pivot and Excel [eBook] by Kasper de Jonge
    http://www.mrexcel.com/store/index.php?l=product_detail&p=301

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

  • Option 1
    https://superuser.com/questions/730371/how-to-prevent-excel-to-use-the-os-regional-settings-for-date-patterns-in-formul

  • Option 2
    an option that I didn't use
    https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_windows8/excel-datevalue-text-issue-with-regional-settings/d6d94c5b-c07a-4981-8a98-a217fb269eb2?auth=1

  • Option 3
    Simply use the excel formulae YEAR(), MONTH(), and DAY() and excel will translate them!
    on StackOverflow: https://superuser.com/a/1250251/771143

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.

https://gizmodo.com/18-tricks-to-make-yourself-a-microsoft-excel-master-1787629290