NorthStar Analytics
Pricing

HiDocs High-Quality Ghost Documentation Theme

Ayşe Ayaz

Ayşe Ayaz

55 articles
How to create a dashboard in Power BI?

How to create a dashboard in Power BI?

With Power BI, we can offer interactive dashboards with data from different databases. The dashboard consists of boxes from reports…

Learn more
How to Use REGEXMATCH Function in Google Sheets?

How to Use REGEXMATCH Function in Google Sheets?

Searching within tables is a common task when working with Google Sheets. With the REGEXMATCH function, we can easily find…

Learn more
How to Use VLOOKUP Function in Google Sheets?

How to Use VLOOKUP Function in Google Sheets?

When working with Google Sheets, we can have multiple tables, multiple sheets, or multiple workbooks. Among these, we may need…

Learn more
How to Use the UNIQUE Function in Google Sheets?

How to Use the UNIQUE Function in Google Sheets?

When working with Google Sheets, we may have written the same data in our worksheet more than once. If there…

Learn more
How to Use COUNTIFS Function in Google Sheets?

How to Use COUNTIFS Function in Google Sheets?

Searching worksheets can be done manually with little data. If you have a large table in your worksheet, if you…

Learn more
How to Use SUMIFS Function in Google Sheets?

How to Use SUMIFS Function in Google Sheets?

Mathematics is pretty easy when working with Google Sheets. Addition, subtraction, multiplication. While performing operations on these, the functions work…

Learn more
How to Use ROUND Function in Google Sheets?

How to Use ROUND Function in Google Sheets?

When working with Google Spreadsheets, our tables can have decimals. Working with them is pretty easy in Google Spreadsheets. However,…

Learn more
How to Use SPARKLINE Function in Google Sheets?

How to Use SPARKLINE Function in Google Sheets?

When working with Google Sheets, we sometimes show our table with the help of graphs for ease of reading. Graphs…

Learn more
How to Use IMPORTXML Function in Google Sheets?

How to Use IMPORTXML Function in Google Sheets?

With Google Spreadsheets, we can easily retrieve data from the pages we browse on the internet. We can take data…

Learn more
How to Use IMPORTRANGE Function in Google Sheets?

How to Use IMPORTRANGE Function in Google Sheets?

When working with Google Sheets, we can have multiple tables, multiple sheets. We may need to use the same data…

Learn more
How to Use IMAGE Function in Google Sheets?

How to Use IMAGE Function in Google Sheets?

When working with Google Sheets, we can easily add images to our sheet. We can fit it inside the cell…

Learn more
How to Use GOOGLEFINANCE Function in Google Sheets?

How to Use GOOGLEFINANCE Function in Google Sheets?

With the GOOGLEFINANCE function, we can easily transfer our data from the Google finance web application to our worksheet. We…

Learn more
How to Use IMPORTHTML Function in Google Sheets?

How to Use IMPORTHTML Function in Google Sheets?

When working with Google Sheets, we may want to import tables or lists from the pages we browse the internet…

Learn more
How to Use DATE Function in Google Sheets?

How to Use DATE Function in Google Sheets?

We can combine the dates written separately as the month, year, day in Google Spreadsheets, rotate the instant date, and…

Learn more
How to Use COUNTIF Function in Google Sheets?

How to Use COUNTIF Function in Google Sheets?

When working with Google Sheets, we may sometimes need to search within the table. We may need repetitive data. For…

Learn more
How to Use COUNTA Function in Google Sheets?

How to Use COUNTA Function in Google Sheets?

We may be working with very large worksheets in Google Sheets. There may be missing data in our table. Or…

Learn more
How to Use COUNT Function in Google Sheets?

How to Use COUNT Function in Google Sheets?

When working with Google Sheets, we may wonder how many cells with numerical data we have. Let's get the products…

Learn more
How to Use AVERAGE Function in Google Sheets?

How to Use AVERAGE Function in Google Sheets?

One of the functions that we use frequently in daily life is averaging. Especially if we are dealing with sales…

Learn more