Online Resources

General

• PDF: Excel 2016 Quick Reference card: https://www.customguide.com/cheat_sheets/excel-2016-quick-reference.pdf

• PDF: Excel the Smart Way (51 Excel Tips ebook) by Sumit Bansal: https://trumpexcel.com/wp-content/uploads/2015/11/Excel-The-Smart-Way-51-Excel-Tips-Ebook.pdf

Pivot Tables

• Video: Learn Pivot Tables in < 20 minutes by Paula Guilfoyle: https://theexcelclub.com/learn-excel-pivot-tables-in-less-than-20-minutes/

• Video Series: Microsoft's Create a Pivot Table training: https://support.office.com/en-us/article/video-create-a-pivottable-and-analyze-your-data-7810597d-0837-41f7-9699-5911aa282760

News

• Spreadsheet error: www.accountingweb.co.uk/business/financial-reporting/worlds-largest-weed-business-makes-blazing-spreadsheet-error

• Getting Started Guide from Microsoft: https://docs.microsoft.com/en-us/power-bi/desktop-getting-started

• Video by Nitin Paranjape: Power BI Desktop for Beginners: https://www.youtube.com/watch?v=h6AIAxMEDiw

  • Link to data file used in video: http://bit.ly/nitincsv1

• Visualization Types: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a

• Color formatting and axis properties: https://docs.microsoft.com/en-us/power-bi/visuals/service-getting-started-with-color-formatting-and-axis-properties

• KPI visualization type in Power BI: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi