ExcelDemy
Excel Training, Services, Free Tutorial, Forum, Templates
- Website
- exceldemy.com · all feeds from this site
- Feed URL
https://www.exceldemy.com/feed/
Read it in your FeedListing reader
Or add to: Feedly Inoreader Raw feed
Latest posts
-
How to Build a Custom Data Entry UserForm in Excel VBA
In this tutorial, we'll show how to build a custom data entry UserForm in Excel VBA that validates user input and stores records in an Excel table.
-
Detecting Suspicious Expenses with Benford’s Law in Excel: A Real-World Case Study
Learn how to use Benford's Law in Excel to screen a real vendor-payment dataset for suspicious expenses, with first-digit formulas, a comparison chart, FILTER, and conditional formatting to find vendors worth a closer look.
-
7 Power BI Design Rules for Reports People Actually Read
In this tutorial, we will show 7 Power BI design rules for reports people actually read. The seven rules cover page layout, KPI placement, color consistency, slicers, chart readability, interactions, and mobile optimization.
-
How to Validate InputBox Entries in VBA
In this tutorial, we will show how to validate InputBox entries in VBA. You will be able to validate InputBox entries and handle common user input mistakes.
-
How to Analyze an A/B Test in Excel: From Raw Data to a Decision
In this tutorial, we'll show how to analyze an A/B test in Excel from raw data to a one-page decision summary you can hand to a manager.
-
Writing Complex Data Validation and Dependent Dropdown Rules with ChatGPT
In this tutorial, we will show how to write complex data validation and dependent dropdown rules with ChatGPT.
-
Power BI Premium vs. Pro vs. Fabric: Which License Do You Actually Need?
In this tutorial, we will explain the differences among Power BI Premium, Pro, and Fabric: which license do you actually need? This will help you determine which option fits your organization.
-
How to Use Named Ranges to Make Formulas Easier to Read and Maintain
In this tutorial, we will show how to use named ranges to make formulas easier to read and maintain. We will cover everything from the basics to advanced techniques like dynamic named ranges.
-
How to Build an Image & Media Asset Inventory Tracker in Excel
Managing a growing collection of digital media, family photos, or marketing assets can quickly become overwhelming without a structured system. Relying on disorganized folders makes it difficult to track which files are ready, which ones need editing, and which ones still…
-
Building a Robust Job Application Tracker in Excel
In this tutorial, we will build a robust job application tracker in Excel, using tables, drop-down lists, formulas, conditional formatting, filters, and charts.
-
Building LAMBDA and LET Functions with ChatGPT in Excel
In this tutorial, we will explore how to build LAMBDA and LET functions with ChatGPT in Excel. Let’s build both functions from scratch, refine them, and turn them into reusable custom formulas.
-
Writing Power Query M Code with ChatGPT
In this tutorial, we will show writing Power Query M code with ChatGPT and then apply that code in Excel or Power BI.
-
All About Excel Table Relationships
In this tutorial, we will cover all about Excel table relationships. Excel relationships are particularly useful for large datasets, PivotTables, reporting models, and workbook structures that resemble relational databases.
-
7 Excel Functions for Managing a Small Business Budget
In this tutorial, we will show 7 useful Excel functions for managing a small business budget.
-
Power BI Mobile: Designing Reports That Actually Work on a Phone
In this tutorial, we will show how to design reports that actually work on a phone in Power BI mobile. We will optimize the following sales dashboard for mobile viewing.