{Awesome Works in Progress}
Old Labs - Awesome MSO
- 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
- Official Website - Microsoft
- GCF ⭐ - Free online learning at GCF Global
- Learn Excel with CFI - Everything you need to become an Excel power user.
- 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
- Interactive Excel Web App Dashboard (Video) - MrExcel.com
- Excel ribbon: quick guide for beginners - ablebits.com
- Formula tutorial step-by-step (Microsoft)
- Excel functions (by category)
- Excel Function List - exceljet.net
- Announcing LAMBDA: Turn Excel formulas into custom functions
- 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
- 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)
- 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
- Linear regression analysis in Excel
- How to use Excel in seasonal forecasting
- Create a forecast in Excel for Windows - Microsoft Office
- Use the Analysis ToolPak to perform complex data analysis - microsoft.com
- RegressIt - regressit.com | Free Excel add-in for linear regression and multivariate data analysis
- 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.
- 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
- 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
- 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
- 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
- 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.