Archive for Agio Academy

How to Use the DAX CALCULATE Function in Excel

Data Analysis Expression (DAX) language is integral in Power Pivot, Power BI, and Analysis Services in Microsoft Excel. These DAX formulas combine operators, functions, and values to execute complex calculations and data queries in tabular models. CALCULATE is one of the most important DAX functions to simplify scenarios with custom data filters.

How to Make a Custom Spell Check List in Excel

Excel spelling check is useful for catching typos before you send worksheets to clients and stakeholders. However, the program often marks specialized terms like client, company, and product names as incorrect.

How to Use People Graph in Excel

Infographics present data in an engaging and straightforward format that makes it easy to understand. Microsoft Excel 2013 introduced People Graph to help users display data related to numbers of people. What is People Graph in Excel?

How to Create a Target Line in Excel Charts

When you put data into an Excel spreadsheet, the program provides multiple options for displaying your data. One of those options is a bar graph, a chart that presents data along the X and Y axis.

Best Add-ins for Word

If you want Microsoft Word to do more, add-ins can help. Add-ins for Word expand the program’s functionality and interact with the data in a Word document, taking on tasks that Word can’t do alone. 

Best Add-ins for Excel

Excel is an excellent tool for organizing data and numbers, but this spreadsheet program can’t do everything on its own. Excel add-ins enhance functionality, giving you more ways to analyze your data.

Best Free Windows Apps

A collection of Microsoft Windows PC applications can help you take your work productivity to the next level. Open-source communities often roll out simple yet high-performance solutions that can save you time and slash your budget.

Best Add-ons for PowerPoint

The Microsoft PowerPoint presentation deck has become an industry standard for delivering images and the written word in an organized and attractive format. Developers have taken advantage of this proven popularity.

How to Prepare for a PCI Audit

Review our PCI audit checklist to ensure you meet PCI compliance requirements. For more information on how to prepare for a PCI audit, contact Agio today.

How to Create a PivotTable for Multiple Sheets in Excel

A PivotTable in Excel creates a single table of information from two or more tables in separate sheets or files. You can use PivotTables to see all your data together and gain new insights.

Common HIPAA Violations

If healthcare organizations fail to follow the Health Insurance Portability and Accountability Act, the consequences can be severe. Learn about common HIPAA violations so your company can avoid them and stay compliant.

How to Stay PCI-Compliant

To achieve PCI compliance, companies must follow several standards to process card payment information safely. Follow this checklist to ensure your business can protect patients’ data against a breach.