Donate

Recent Posts

• Join Types in Power Query – Part 2: Lookup Dashboard
• Join Types in Power Query – Part 1: Join Types
• Why You Should Know Power Query – Part 3: Merge
• Why You Should Know Power Query – Part 2: Split
• Why You Should Know Power Query – Part 1: Fill

Recent Comments

• Gašper Kamenšek on Turning Product Descriptions into a list of attributes with Power Query
• Gašper Kamenšek on Scroll trouble in Excel (scrolling beyond your data)
• Gabriela D on Scroll trouble in Excel (scrolling beyond your data)
• Mark on Turning Product Descriptions into a list of attributes with Power Query
• Gašper Kamenšek on Excel FILTER Function – The Function that does Everything

Archives

• March 2022
• February 2022
• January 2022
• November 2021
• September 2021
• July 2021
• June 2021
• April 2020
• March 2020
• September 2019
• August 2019
• October 2018
• June 2018
• May 2018
• April 2018
• March 2018
• February 2018
• January 2018
• June 2017
• February 2017
• November 2016
• June 2016
• May 2016
• April 2016
• March 2016
• January 2016
• November 2015
• June 2015
• May 2015
• April 2015
• March 2015
• February 2015
• January 2015
• December 2014
• November 2014
• October 2014
• September 2014
• August 2014
• July 2014
• June 2014
• May 2014
• March 2014
• October 2013
• July 2013
• June 2013
• May 2013
• April 2013
• March 2013

Categories

• 3D Map
• Array Functions
• Calendar
• Cell Format
• Charts
• Conditional Formatting
• Conferences
• CSV
• Data Model
• Data Types in Excel
• Data Validation
• Dynamic Arrays
• Dynamic Ranges
• Excel
• Excel 365
• Excel Conferences
• Excel Facts
• Excel Functions
• Excel Shortcuts
• Excel Tools
• Lists in Power Query
• M
• Pivot Table
• Power BI
• Power BI Designer
• Power BI Desktop
• Power Map
• Power Query
• PowerPivot
• R Academy
• R Language
• Uncategorized
• VBA
• Xcessories

Meta

• Log in
• Entries feed
• Comments feed
• WordPress.org

Follow Us

Tags