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

Using Google Forms for Data Entry and Google Data Studio for Querying

In this article, we will show how to use Google Forms for data entry and Google Data Studio for analyzing and visualizing the collected data.

Building a Sales Pipeline Forecasting Model with Excel

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

How to Create an App From Your Google Sheets Using Google Apps Script

In this article, we will show how to create a web app using Google Sheets Apps Script.

Building a Dynamic Resource Allocation Tool in Google Sheets

In this article, we will build a dynamic resource allocation tool in Google Sheets.

10 Excel Templates That Every Small Business Needs

In this article, we will list 10 Excel templates that every small business needs.

Create a Web App with Google Sheets API and a Simple Frontend

In this article will show how to build a web app with a simple frontend using Google Sheets API.

Building a Customer Feedback Analysis Dashboard in Google Sheets

In this article, we will show how to build a customer feedback analysis dashboard in Google Sheets.

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.

Creating Custom Functions for Financial Modeling and Analysis in Excel

In this article, we will show how to create custom functions for financial meddling and analysis in Excel.

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.

7 Excel Chart Types You Probably Didn’t Know Existed

In this article, we will uncover 7 Excel chart types you probably didn’t know existed.

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.

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo