1. Home
  2. Resources
  3. General Guides
  4. Excel/PBI/PPT guide

Excel/PBI/PPT guide

How to Use Goal Seek in Excel

Guide
July 21, 2023
Learn how to use Goal Seek in Excel to solve complex problems and achieve your desired results.
Learn more
A spreadsheet with a highlighted cell showing the goal seek feature

How to Use Sumifs in Excel

Guide
July 21, 2023
Learn how to use Sumifs in Excel with this comprehensive guide. Discover how to add up values based on multiple criteria and improve your data analysis skills.
Learn more
A spreadsheet with a highlighted cell showing the result of a sumifs formula

How to Vlookup in Excel

Guide
July 21, 2023
Learn how to use the Vlookup function in Excel with our step-by-step guide.
Learn more
A laptop with an excel spreadsheet open

How to Use R in Power BI

Guide
July 21, 2023
Learn how to enhance your data visualization skills with Power BI by incorporating R programming language.
Learn more
A computer monitor with a power bi dashboard and a graph created using r

How to Use Filled Map in Power BI

Guide
July 21, 2023
Learn how to create visually appealing and informative maps in Power BI using the Filled Map feature.
Learn more
A map with various regions filled in with different colors

How to Use Dax in Power BI

Guide
July 21, 2023
Learn how to utilize Dax in Power BI with this comprehensive guide.
Learn more
A computer screen showing a power bi dashboard with a dax formula being used

How to Use Filter Top 4 Revnenue Generated Provinces in Power BI

Guide
July 21, 2023
Learn how to effectively use the filter feature in Power BI to identify the top 4 revenue generated provinces.
Learn more
A map of four provinces with arrows pointing to the highest revenue-generating provinces

How to Visualize Mapping Data in Power BI

Guide
July 21, 2023
Learn how to effectively visualize mapping data in Power BI with our comprehensive guide.
Learn more
A map with data points represented by colorful icons

Power BI How to Create Split Screen in Query Editor

Guide
July 21, 2023
Learn how to split your screen in Power BI's Query Editor with our step-by-step guide.
Learn more
A computer screen with two separate sections