Skip to content

prp1277/Excel

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

92 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

The resources in this repository have been collected over my years of working in Microsoft Excel.

Table of Contents

csv-datasets

Datasets curated from my Business Intelligence classes at Rockhurst University.

Excel-JS

Sample scripts to run using the Script-Labs Excel Add-In.

img

Images to add to posts etc.

PDF-Guides

Guides from blogs, books and other sources that I have used or referenced.

PowerQuery

  • Queries - #M code used behind the scenes
  • QueryWorkbooks - The workbook containing the #M

Shortcuts&Formulas

Excel shortcuts to help you stop using your mouse.

Templates

My Personal Macro Workbook and UI Add-In

VBA

  • MacroWorkbooks - Workbooks containing the macros
  • Scripts - The VBA in the actual workbooks

Releases

No releases published

Packages

No packages published

Contributors 4

  •  
  •  
  •  
  •  

Languages