Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool. Take your analytics to the next level with Excel.
{Awesome Works in Progress}
- ExcelIsFun - Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to practice and pdf notes to summarize concepts.
- MrExcel.com - Learn a new Excel tip every weekday from MrExcel.
- TeachExcel - Excel help and tutorial videos.
- Excel Campus - Jon - Excel Campus is here to help you learn Excel and save you time with your everyday tasks.
- I didn’t know Excel could do THAT - Bob Umlas
- Kevin Stratvert
- Excel Tutorial for Beginners ~20min
- MyOnlineTrainingHub
- Official Website - Microsoft
- GCF ⭐ - Free online learning at GCF Global
- Learn Excel with CFI - Everything you need to become an Excel power user.
- Cascading Dropdown List
- How to Create Dependent Cascading Drop-down Lists - Excel Campus
- Making a cascading (dependent) Excel drop down list - Ablebits
- Applying the Pareto Principle in Financial Analysis - Dobromir Dikov
- Excel ribbon: quick guide for beginners - ablebits.com
- Custom Excel number format - ablebits.com
- Excel video training 🌟
- Import and analyze data 🌟
- Create a named range from selected cells in an Excel worksheet
- Name cells and ranges in Excel 📺 ~2min
- Formula tutorial step-by-step (Microsoft) ⭐
- Excel functions (by category)
- Excel Function List - exceljet.net
- Announcing LAMBDA: Turn Excel formulas into custom functions
- Create a PivotTable to analyze worksheet data ⭐
- 101 Advanced Pivot Table Tips And Tricks You Need To Know (How to Excel, October 2017)
- Refresh Pivot Tables Automatically When Source Data Changes (Excel Campus, Jon Acampora)
- Panel Charts in Excel - Jon Peltier | Microsoft Reactor
- A classification of chart types - Jorge Camoes
- Flow Chart Shows You What Chart to Use - Andrew Abela
- Choosing a good chart ⭐ - extremepresentation.typepad.com
- Step-by-step guide to build a bullet chart in Excel - corporatefinanceinstitute.com
- Anatomy of an Excel chart 2016 - exceljet.net
- Available chart types in Office ⭐ - microsoft.com
- Create and share a Dashboard with Excel and Microsoft Groups ⭐
- Interactive Excel Web App Dashboard 📺 - MrExcel.com
- Linear regression analysis in Excel
- How to use Excel in seasonal forecasting
- Create a forecast in Excel for Windows - Microsoft Office
- Fuzzy Lookup Add-In for Excel
- RegressIt - regressit.com | Free Excel add-in for linear regression and multivariate data analysis
- ToolPak
- Use the Analysis ToolPak to perform complex data analysis - microsoft.com
- Excel VBA Beginner Tutorial 📺 - (Learnit Training, November 2019)
- Excel Macros & VBA - Tutorial for Beginners 📺 ~50min - Kevin Stratvert
- Convert numbers into words - Excel doesn’t have a default function that displays numbers as English words in a worksheet, but you can add this capability by pasting the following SpellNumber function code into a VBA (Visual Basic for Applications) module.
Extracts data from various sources. The user can cleanse and format the data and save this procedure; the procedure can then be repeatedly performed each time the data is refreshed.
- Getting Started with Get & Transform in Excel
- Shape data (Power Query)
- Power Query 101 - UEFA European Football Championship case.
- What Is Power Query? - howtoexcel.org
- About Power Query in Excel ⭐
- Handle large datasets in a highly compressed format, manage relationships, perform complex calculations, and display output from different tables into a single-view PivotTable.
- Get started with Power Pivot in Microsoft Excel
- Start the Power Pivot add-in for Excel
- Powerful data analysis and data modeling in Excel
- 10 Ways to Improve Power Pivot Performance
- Data Mining 2012 with Microsoft Excel 2010 and PowerPivot - learn.microsoft.com
Power Map, our popular 3-D geospatial visualization add-in for Excel 2013, is now fully integrated into Excel. We’ve also given this feature a more descriptive name, “3D Maps". You'll find this functionality alongside other visualization features on the Insert tab. learn more
- Get started with Power Map
- Use 3D Maps in Excel - Create Beautiful Map Charts - Computergaga
- Power Tools (All)
- Power BI
- Awesome Power BI - Resources and References
Power View is an interactive data exploration, visualization, and presentation experience that encourages intuitive ad-hoc reporting.
In Excel for Microsoft 365 and Excel 2021, Power View is removed on October 12, 2021. As an alternative, you can use the interactive visual experience provided by Power BI Desktop)
- Power View: Explore, visualize, and present your data
- Charts and other visualizations in Power View
- Working with a matrix in Power View
- Tiles in Power View
- Enable Power View
- Flash, Silverlight, and Shockwave controls blocked in Microsoft Office
- Excel 2016 and 2019 cheat sheet - Get to know the key features in Microsoft Excel 2016 and Excel 2019 for Windows.
- Create a form with Microsoft Forms
- Excel Templates - Excel-Skills.com
- How to Insert a Symbol in Excel
- MO-200: Microsoft Excel (Excel 2019)
- 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation
- 77-728: Excel 2016 Expert: Interpreting Data for Insights
- Creating a Data Mining Model - Microsoft Docs
Data mining was deprecated in SQL Server 2017 Analysis Services and now discontinued in SQL Server 2022 Analysis Services.
- Versions of Excel Explained
- Seven reasons why excel is still used by half a billion people worldwide
- 27 Microsoft Excel Experts Predict The Future Of Excel In BI
Archived Excel Repository - Awesome MSO