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

Excel/PBI/PPT guide

How to Use Countif in Excel

Guide
July 21, 2023
Learn how to use the Countif function in Excel to quickly and easily count cells that meet specific criteria.
Learn more
A spreadsheet with cells highlighted to demonstrate how to use the countif function in excel

How to Use Subtotal in Excel

Guide
July 21, 2023
Learn how to use the Subtotal function in Excel to quickly calculate subtotals for your data.
Learn more
A spreadsheet with a highlighted subtotal row

How to Use an Absolute Reference in Excel

Guide
July 21, 2023
Learn how to use absolute references in Excel to make your formulas more accurate and efficient.
Learn more
A spreadsheet with a highlighted cell showing an absolute reference

How to Use Map in Power BI

Guide
July 21, 2023
Learn how to effectively use maps in Power BI with our comprehensive guide.
Learn more
A map with a magnifying glass hovering over it

How to Use Rankx in Power BI

Guide
July 21, 2023
Learn how to use Rankx in Power BI to rank data based on specific criteria.
Learn more
A computer screen showing a power bi dashboard with rankx in action

How to Use Tooltips in Power BI

Guide
July 21, 2023
Learn how to enhance your Power BI reports with tooltips.
Learn more
A computer screen with a tooltip box hovering over a power bi dashboard

Power BI How to Make a Variable a Row in a Table

Guide
July 21, 2023
Learn how to transform your Power BI data by making a variable a row in a table.
Learn more
A table with a variable represented as a row

I Have My Data Present in Power BI , How to Write Sql Queries to That Data

Guide
July 21, 2023
Learn how to write SQL queries for your data present in Power BI.
Learn more
A computer screen with a power bi dashboard on it

How to Use Link Buttons in Power BI

Guide
July 21, 2023
Learn how to effectively use link buttons in Power BI with our step-by-step guide.
Learn more
A computer screen with a power bi dashboard with a link button highlighted