Search this site
  • Home
    • About Me
    • Publications
    • Online Resources
 
  • Home
    • About Me
    • Publications
    • Online Resources
  • More
    • Home
      • About Me
      • Publications
      • Online Resources

Online Resources

Excel 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


Power BI Resources

  • 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


Report abuse
Page details
Page updated
Google Sites
Report abuse