ahmadbbaihaqi/awesome-excel

Kumpulan ilmu penting soal excel

Awesome Excel 💚

{Awesome Works in Progress}

Old Labs - Awesome MSO

---

Top YouTube Channels 📺 (Excel)

• 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

Twitter

• Microsoft Excel 🐤

Tutorials

• 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

Help

• What version of Office am I using?

Formulas

• Formula tutorial step-by-step (Microsoft)
  • More Excel Resources
• Excel functions (by category)
• Excel Function List - exceljet.net
• Announcing LAMBDA: Turn Excel formulas into custom functions

Charts

• 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

PivotTable and PivotChart

• 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)

Misc

• 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
  • Huge List of Unicode Symbols

Statistics and Data Analytics

• Linear regression analysis in Excel
• How to use Excel in seasonal forecasting
• Create a forecast in Excel for Windows - Microsoft Office

ToolPak

• Use the Analysis ToolPak to perform complex data analysis - microsoft.com

RegressIt

• RegressIt - regressit.com | Free Excel add-in for linear regression and multivariate data analysis

Macro adn VBA

• 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.

Performance

• Improving calculation performance

Add-ins

• Fuzzy Lookup Add-In for Excel

Exams (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

Why Excel❓

• 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

---

Power Suite (Modern Excel) ⚡

Power Query (Get and Transform Data)

• 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

Power Pivot

• 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

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)
  • Excel Power Tools (Western Carolina University)
• Power BI
  • Awesome Power BI - Resources and References

Power View

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

---

Data Mining Model (Excel)

• 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.