Advanced Excel

Introduction to Machine Learning with Google Sheets

In this article, we will show how to use machine learning with Google Sheets.

Creating Interactive Product Catalogs in Excel

Excel is a great tool for cataloging, as it uses dynamic formulas, drop-downs, filters, slicers, etc. In this tutorial, we will create interactive ...

Building a Sales Pipeline Forecasting Model with Excel

In this article, we will show how to build a sales pipeline forecasting model in Excel.

Building Complex Data Models and Relationships with Power Pivot

In this article, we will show how to build complex data models and relationships with Power Pivot with practical examples.

How to Build Real-Time Data Dashboards with Power Query

In this article, we will show how to build real-time data dashboards with Power Query.

How to Apply Excel’s IF Function in Complex Real-Life Scenarios

In this article, we will show how to apply Excel’s IF function in complex real-life scenarios with practical examples.

Excel VBA vs Google Apps Script: Pros, Cons, Use Cases

In this article, we will compare the pros, cons, and use cases of Excel VBA and Google Apps Script with practical examples.

Advanced Lookup Techniques Beyond VLOOKUP

Let’s show you the advanced lookup techniques beyond VLOOKUP by using XLOOKUP, and INDEX-MATCH-MATCH to leverage them effectively.

How to Create Interactive Dashboards with Form Controls in Excel

In this article, we will show how to create interactive dashboards with form controls in Excel.

How to Build Custom Add-ins for Enhanced Functionality

In this article, we will build custom add-ins for enhanced functionality.

Spreadsheet Optimization: Improving Performance of Large Workbook

In this article, we will explain how you can optimize spreadsheets to improve the performance of large workbooks.

Google Sheets API Integration for Automation

In this article, we will show you how to do Google Sheets API integration for automation.

Using Excel’s Scenario Manager for Financial Planning

In this article, we will show how to use Excel’s Scenario Manager for financial planning.

Implementing Monte Carlo Simulation Using Excel

In this article, we will implement a Monte Carlo Simulation using Excel.

Advanced Conditional Formatting with Formula-Based Rules

In this tutorial, we will show advanced conditional formatting using formula-based rules, which gives you far greater flexibility than standard ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo