Free official resources

All links below were checked and loaded successfully on October 14, 2026.

Excel

• XLOOKUP function (Microsoft Support): https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929
• Dynamic array formulas and spilled array behavior (Microsoft Support): https://support.microsoft.com/en-us/office/dynamic-array-formulas-and-spilled-array-behavior-205c6b06-03ba-4151-89a1-87a7eb36e531
• LAMBDA function (Microsoft Support): https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67
• Office Scripts in Excel (Microsoft Learn): https://learn.microsoft.com/en-us/office/dev/scripts/overview/excel

Power Query and Power BI

• Power Query documentation (incl. M language reference): https://learn.microsoft.com/en-us/power-query/
• Power BI training hub (Microsoft Learn learning paths): https://learn.microsoft.com/en-us/training/powerplatform/power-bi
• Star schema guidance for Power BI: https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
• DAX reference: https://learn.microsoft.com/en-us/dax/
• PL-300 Power BI Data Analyst certification (free practice assessment + study guide): https://learn.microsoft.com/en-us/credentials/certifications/data-analyst-associate/

Power Automate

• Power Automate documentation: https://learn.microsoft.com/en-us/power-automate/
• Learning path: Automate a business process using Power Automate: https://learn.microsoft.com/en-us/training/paths/automate-process-power-automate/
• Integrate Power BI data alerts with Power Automate: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-flow-integration

Python

• The Python Tutorial (official): https://docs.python.org/3/tutorial/index.html
• pandas Getting Started tutorials: https://pandas.pydata.org/docs/getting_started/intro_tutorials/index.html
• openpyxl documentation: https://openpyxl.readthedocs.io/en/stable/
• python-docx documentation: https://python-docx.readthedocs.io/en/latest/

AI and Data Security

• Get started with Copilot in Excel (Microsoft Support): https://support.microsoft.com/en-us/office/get-started-with-copilot-in-excel-d7110502-0334-4b4f-a175-a73abdfc118a
• Copilot for Power BI overview (requirements, incl. sovereign cloud note): https://learn.microsoft.com/en-us/power-bi/create-reports/copilot-introduction
• Controlled Unclassified Information (CUI), National Archives CUI program and Registry: https://www.archives.gov/cui

Domain (EVM)

• Earned Value Management (EVM), DAU Acquipedia article (links to related EVM terms and the EVM 101 course): https://www.dau.edu/acquipedia-article/earned-value-management-evm