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

Excel/PBI/PPT guide

How to Use Formulas in Excel

Guide
July 21, 2023
Learn how to simplify your Excel tasks by mastering the use of formulas.
Learn more
A computer screen showing an excel spreadsheet with a formula being entered

How to Use Concatenate in Excel

Guide
July 21, 2023
Learn how to use the CONCATENATE function in Excel to combine text from multiple cells into one.
Learn more
A spreadsheet showing how to use the concatenate function

How to Use Irr in Excel

Guide
July 21, 2023
Learn how to efficiently use the IRR function in Excel with our step-by-step guide.
Learn more
A spreadsheet with a highlighted cell showing the use of an irr formula

How to Use Quick Measure in Power BI

Guide
July 21, 2023
Learn how to use Quick Measure in Power BI with our step-by-step guide.
Learn more
A power bi dashboard with a highlighted quick measure feature

How to Use Measures in Power BI

Guide
July 21, 2023
Learn how to effectively use measures in Power BI to analyze and visualize your data.
Learn more
A dashboard with various charts and graphs

How to Use Performance Analyzer in Power BI

Guide
July 21, 2023
Learn how to effectively use the Performance Analyzer feature in Power BI with our step-by-step guide.
Learn more
A computer monitor with a graph of performance data on it

How to Update Data in Power BI Online

Guide
July 21, 2023
Learn how to update data in Power BI Online with this comprehensive guide.
Learn more
A computer screen with a power bi dashboard updating in real-time

How to Use Scheduled Refresh in Power BI

Guide
July 21, 2023
Learn how to use the powerful feature of Scheduled Refresh in Power BI to keep your data up-to-date and ensure your reports are always accurate.
Learn more
A computer monitor displaying a power bi dashboard with a refresh icon

How to Use 2 Conditions in If Function Power BI

Guide
July 21, 2023
Learn how to use two conditions in the IF function in Power BI with this comprehensive guide.
Learn more
A computer monitor with a power bi dashboard showing two conditions side-by-side