Implementing Business Rules through Advanced Transformations In this article, I’ll continue from the article [Power Query – Transformations] and illustrate… Read more Excel Power Query – Transformations (Advanced)
Category: excel-analysis
Excel Power Query – Transformations
Implementing Business Rules through Transformations In this article, I’ll continue from the article Excel Power Query – Introduction and illustrate some… Read more Excel Power Query – Transformations
Excel Power Query: Introduction
Leveraging Power Query to harness your data. The Power Query Add-On provides power capabilities to connect to multiple data sources,… Read more Excel Power Query: Introduction
Excel: Charts
Intuitively describing data patterns. When conducting statistical studies it is as important to present the results in an intuitive manner… Read more Excel: Charts
Excel: Averages
Describing Central Tendency of Data Descriptive statistics is concerned with describing important aspects of set of measurements, organizing and summarizing… Read more Excel: Averages