Susan Harkins

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

Use COUNTIF to count values in a range that meet a certain condition and return a specified number to the cell.

There are a few ways to count the number of items in an Excel list, depending on the data you have. In this tutorial, learn how to count items in Excel using the COUNTIF and SUBTOTAL functions.

You can easily apply left and right alignment formatting in Microsoft Word. This article covers how to do so without using a table.

You might have used reminders in Outlook before, but these tips may make you reconsider the way you use the feature.

Understanding Power BI relationships and how to create them ensures your visuals filter and slice the way you expect. Learn more about Power BI relationships here.

Don’t disappoint end users by leaving them out of the mobile world. Use Microsoft Power BI’s mobile layout feature to optimize dashboards for mobile devices.

These two measures make quick work of returning profit and calculating profit margin in your Power BI projects.

Especially when SharePoint lists need to be kept separate for security reasons, this Power Automate flow tutorial will help you keep both lists up-to-date.

Creating a visual that includes profit amount and profit margin is easy if you know the right DAX expressions to use in Power BI.

Having too many slicers is almost as bad as not having enough. When slicers are cluttering your Power BI dashboard, consider replacing them with parameters.

Triggering drill through in a Power BI visual isn’t obvious and might be totally missed. Instead, add a drill through button that displays drill through instructions.