Articles
- Add a Power Query icon to the quick access toolbar
- Adding security to a PowerBI report
- Build a date from text month and year
- Cap percentages
- Checkboxes in cells
- Column Auto-size
- Common VBA
- Common VBA functions
- CONCAT
- Connect to SharePoint from Power BI Desktop
- Copy Formulas without changing the cell references
- Create a Bullet Graph
- Create a calendar table
- Create a new table from an existing table
- Data comparison take 1
- Data comparison take 2
- Data comparison take 3
- Data comparison take 4
- Data comparison take 5
- DAYS
- Delete all partitions
- Delete Styles with VBA
- Dropdown lists
- Dynamic text
- Excel Quick Tips
- Expand date ranges
- Filter rows with zeros
- Folder structure tips
- FORMULATEXT
- Get data from a single cell to fill a column
- Get the IP address of a computer
- Get_the file location dynamically
- HTML Tags
- IFNA
- IFS
- Import incremental data
- ISFORMULA
- Link a personal macro to the Excel ribbon
- Macro absolute and relative references
- Mailto and Teams links
- Make a source file relative
- Manually add data to a table
- MarkDown CheatSheet
- Matrix layout
- MAXIFS and MINIFS
- Merge vs. Append
- Numbers with leading zeros in CSV files
- NUMBERVALUE
- Organise DAX functions
- Quick Assist
- Quickly highlight unique or duplicate values
- Quickly select differences in a list
- Refresh Power Query
- Relative references
- Rename columns based on position
- Running PeopleSoft queries from Excel links
- Running Xero reports from Excel links
- Setup PowerBI to refresh from a OneDrive folder
- Setup PowerBI to refresh from OneDrive
- SHEET
- Show items with no data and hide zeros
- Sort by a column not used in Power BI visual
- SVG used on site
- SWITCH
- TEXTJOIN
- Things to set-up on every report
- Turn off date hierarchy
- Two way lookups
- VSTACK