# Excel University: Online Microsoft Excel Training

> Become an Excel pro with Excel University\. Get work done faster with step\-by\-step tutorials, free resources, and more\. CPE classes available\!

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

## Pages
- [Store Multiple Values in One Cell in Excel \(Lists \& Nested Arrays\)](https://www.excel-university.com/yt_mt5nosfffj8/)
- [Formula vs PivotTable Reports](https://www.excel-university.com/reports/)
- [Fix Text Numbers in Excel: 3 Ways to Convert Text to Numbers](https://www.excel-university.com/yt_grbimdgiodk/)
- [Stop Hard\-Coding Numbers in Excel Formulas \(Use Input Cells\)](https://www.excel-university.com/yt_g5fvrsmorj0/)
- [Sum Faster in Excel: Shortcut, Tables, and Total Row](https://www.excel-university.com/yt_0woxdaoiwos/)

## Posts
- [Inputs in Cells: How to Stop Hard\-Coding Values in Excel Formulas](https://www.excel-university.com/inputs-in-cells-stop-hard-coding-values-excel-formulas/)
- [Sum Faster in Excel: Shortcut, Tables, and Total Row](https://www.excel-university.com/stop-typing-sum-alt-equals-autosum-shortcut/)
- [Build Live Filtered Lists in Excel \(FILTER \+ SORT\)](https://www.excel-university.com/excel-filter-sort-dynamic-reports/)
- [Add a Month with Power Query: Automate Your Monthly GL Consolidation](https://www.excel-university.com/add-a-month-power-query-monthly-gl-consolidation/)
- [2026 Scholarship Winners](https://www.excel-university.com/2026-scholarship-winners/)

## Videos
- [Chapter 23](https://www.excel-university.com/vol2/chapter-23/)
- [Chapter 3](https://www.excel-university.com/vol2/chapter-3/)
- [Chapter 10](https://www.excel-university.com/vol3/v3-chapter-10/)
- [Chapter 26](https://www.excel-university.com/vol3/v3-chapter-26/)
- [Chapter 25](https://www.excel-university.com/vol3/v3-chapter-25/)

## Articles
- [Get the Word Out](https://www.excel-university.com/articles/journal-of-acct/get-the-word-out/)
- [Be Excel\-lent](https://www.excel-university.com/articles/cal-cpa/be-excel-lent/)
- [Wireless Networks](https://www.excel-university.com/articles/oc-lawyer/wireless-networks/)
- [Technology Q \& A](https://www.excel-university.com/articles/oc-lawyer/technology-q-a-2/)
- [Secure Email](https://www.excel-university.com/articles/oc-lawyer/secure-email/)

## Categories
- [Excel](https://www.excel-university.com/category/excel/)
- [Functions](https://www.excel-university.com/category/functions/)
- [Features](https://www.excel-university.com/category/features/)
- [Techniques](https://www.excel-university.com/category/techniques/)
- [Training](https://www.excel-university.com/category/training/)

## Tags
- [Power Query](https://www.excel-university.com/tag/power-query/)
- [PivotTable](https://www.excel-university.com/tag/pivottable/)
- [VLOOKUP](https://www.excel-university.com/tag/vlookup/)
- [SUMIFS](https://www.excel-university.com/tag/sumifs/)
- [Conditional Formatting](https://www.excel-university.com/tag/conditional-formatting/)

## Volumes
- [Volume 2](https://www.excel-university.com/volume/vol2/)
- [Volume 3](https://www.excel-university.com/volume/vol3/)
- [Volume 1](https://www.excel-university.com/volume/vol1/)

## Publications
- [California CPA Magazine](https://www.excel-university.com/publication/cal-cpa/)
- [Journal of Accountancy](https://www.excel-university.com/publication/journal-of-acct/)
- [Orange County Lawyer Magazine](https://www.excel-university.com/publication/oc-lawyer/)
- [Calliope \(Wisconsin Institute of CPAs\)](https://www.excel-university.com/publication/calliope/)
- [On Balance \(WICPA\)](https://www.excel-university.com/publication/on-balance/)

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