# Xelplus \- Leila Gharani: Bestselling Excel and Power BI Courses

> Discover top\-rated XelPlus courses to master Excel, Power BI, data analysis and automation\. Earn certifications to showcase your expertise\.

Generated by Yoast SEO v28.7, this is an llms.txt file, meant for consumption by LLMs.

## Pages
- [Courses](https://www.xelplus.com/courses/)
- [Homepage](https://www.xelplus.com/)
- [For Business](https://www.xelplus.com/business-customers/)
- [Contribute to Your World](https://www.xelplus.com/contribute-to-your-world/)
- [About Me](https://www.xelplus.com/about-leila-gharani/)

## Posts
- [Combine Multiple Excel Files into One with Power Query](https://www.xelplus.com/combine-multiple-excel-files/): Combine multiple Excel files from a folder into one table with Power Query\. Download the practice files and follow along step by step\.
- [PowerPoint Morph Transition: 3 Practical Examples](https://www.xelplus.com/powerpoint-morph-transition/): Use PowerPoint Morph to zoom into a picture, spotlight one person and animate a timeline\. Download the free PowerPoint template with all three examples\.
- [Excel Lists in Cells: Put Multiple Values in One Cell](https://www.xelplus.com/excel-lists-in-cells/): For 40 years, an Excel cell held one value\. Now it can hold a list\. Learn Ctrl\+J, HAS, HASANY, HASALL and FLATTEN, plus how GROUPBY works with lists\. Free workbook included\.
- [How to Find Hardcoded Numbers in Excel Formulas](https://www.xelplus.com/find-hardcoded-values-excel/): Go To Special won't find numbers hidden inside formulas\. Use FORMULATEXT with REGEXTEST and conditional formatting to highlight them\.
- [AI Prompts for Excel Data Analysis: How to Get Results You Can Trust](https://www.xelplus.com/ai-excel-prompts/): Sort, remove duplicates, done? On large data, Power Query can quietly keep the wrong record and never warn you\. Here's why it happens and the one\-line fix\. Free workbook included\.

## Courses
- [Copilot at Work \- Microsoft 365 Copilot](https://www.xelplus.com/course/copilot/): Put Microsoft 365 Copilot to work in Excel and beyond\. Learn to clean up data, build reports, and tackle everyday tasks with practical lessons that take you from start to finish\.
- [Windows 11 Essentials for Work](https://www.xelplus.com/course/windows-essentials-for-work/): Windows 11 productivity course: Learn shortcuts and tools that save busy professionals 20\-30 minutes every day\.
- [Power Pro Bundle](https://www.xelplus.com/course/power-excel-bundle/): 10x your productivity in Excel 💪 by mastering Excel's Power Tools in ONE convenient \(cost savings\) bundle\. 
Learnings apply to Power BI as well\.
- [Power Query Challenge Pack](https://www.xelplus.com/course/power-query-challenge-pack/): You learned Power Query\. Still get stuck? 
Time for real practice\.
- [Master Excel Power Query \- Beginner to Pro](https://www.xelplus.com/course/excel-power-query/): Power Query is the most underused tool in Excel\. Build the monthly cleanup once, then just refresh\. One member took a monthly report from 7 days down to 2 hours\.

## Categories
- [Excel](https://www.xelplus.com/tutorials/excel/)
- [Dashboards, Charts \& Features](https://www.xelplus.com/tutorials/excel/dashboards-charts-and-features/)
- [Formulas](https://www.xelplus.com/tutorials/excel/formulas/)
- [Power Excel](https://www.xelplus.com/tutorials/excel/power-excel/)
- [VBA \& Scripts](https://www.xelplus.com/tutorials/excel/vba-scripts/)

## Tags
- [Charts](https://www.xelplus.com/tag/charts/)
- [INDEX function](https://www.xelplus.com/tag/index-function/)
- [Conditional Formatting](https://www.xelplus.com/tag/conditional-formatting/)
- [Dynamic Arrays](https://www.xelplus.com/tag/dynamic-arrays/)
- [FILTER function](https://www.xelplus.com/tag/filter-function/)

## Optional
- [Sitemap index](https://www.xelplus.com/sitemap_index.xml)