TechRepublic

How to create a sorted unique list in an Excel spreadsheet

How to create a sorted unique list in an Excel spreadsheet Your email has been sent Microsoft 365's UNIQUE() function is a great reason to upgrade. Combine UNIQUE ...
TechRepublic

How to create a YOY comparison chart using a PivotChart in Excel

How to create a YOY comparison chart using a PivotChart in Excel Your email has been sent Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in ...
Ars Technica

Creating a SQL Database for an absolute beginner

I don't know if this is the right place for this question or not but I'm hoping someone can point me in the right direction. I have a project in mind that requires a database and I would like to begin ...
Redmond Magazine

Launching a PowerShell Script from Excel, Part 1: Create the Way

Microsoft recently announced that they are adding a feature to Excel that will allow Python code to be embedded and used for advanced analytics. That made me wonder if it might be possible to create ...