Microsoft Excel

Advanced Knowledge of Excel 

Visual Basic

VBA (Visual Basic for Applications is a special programming Language that allows an advanced Microsoft users to create customized programs within  Excel and Access. This program is not an add-on , but part of these programs

Power Pivot

Power Pivot is an add-in for Microsoft Excel that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build Pivot Tables and Pivot Charts. 

Power Query

Power Query is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Power Query is one of the Excel add-ins provided as part of Microsoft Power BI self-service solution. This solution can be used in conjunction with Power Pivot

Excel Flow

  • YouTube Social  Icon

These combined products can result in stunning Reporting dashboards