GET ULTIMATE EXCEL

Recent Posts

Save Time and Money with Excel VBA Is Fun tips and tricks!

Email Magic in Excel!

Welcome To Free Practice Workbooks!

Free Excel Practice File Downloads

03 - 01 CASE WHEN Statements (Like IF THEN)

02 - 12 Custom Field Defaults, Create and Update Record TIMESTAMPS

02 - 11 Custom Rules with Check Constraints

02 - 10 Table Relationships, Foreign Keys And The EER Diagram

02 - 09 Using Multiple Columns For An Index (Compound, Composite Keys)

02 - 08 Using Indexes To Speed Up Searches

02 - 07 Edit Records With UPDATE Statement

02 - 06 What Is CRUD

02 - 05 Subqueries

02 - 04 Combining Data From Multiple Tables Using JOINS And UNION

02 - 03 Filtering Grouped Results Using HAVING Clause and Multiple Group By Criteria

02 - 02 Aggregate Functions and Grouping

02 - 01 Importing Multiple Tables At Once

01 - 09 Additional Important Built-In Functions

01 - 08 Calculated Fields, Concatenation, Aliases, Built-In Functions

01 - 07 Sorting Results By One or More Columns

01 - 06 Wildcards for Dynamic Filtering

01 - 05 Advanced Data Filtering Using AND, OR, IN, NOT, and Combined Operators

01 - 04 Filtering Results - WHERE, DISTINCT and LIMIT Commands

01 - 03 Entering In Sample Data and Importing Data

Lesson

01 - 02 Creating Your First Database and Table

01 - 01 Installing MySQL

Chapter 02 Download Kit

Intro to Userforms II (Plus Download Kit)

Intro to Essential Tools and ACL (Plus Download Kit)

Intro to the VBE: Toolbars, Menus and Hidden Features

Intro to Advanced Brower Control and Course Files

00 Intro - What You'll Learn and Download Files

02 The Range Object

01 Developer Ribbon

03 ActiveX Buttons

04 Checkbox and IF THEN Statements

08 Worksheet Selection Change

06 What Are Events

05 Cells Object and Loops

07 Worksheet Cell Change

09 Bonuses

01 - 05 A Year of Excel 365 for Twenty Bucks

02 - 03 Entering A New Text Expander Item

02 - 02 Installing FastKeys and First Example

02 - 01 Speed Typing with FastKeys

01 - 04 Getting Excel 2016 on Test Machine

01 - 03 Shrinking and Cloning a Virtual Machine

01 - 02 Using a Shared Folder on Virtual Machine

01 - 01 Testing with a Virtual Machine [with Resource Guide]

Get More Free Images (For Personal or Commercial Use)

How To Use and Tweak Tiling Patterns and Where To Get More for Free!

Shrink Image File Size (looks identical)

Converting PNG and other Formats to JPG, Gif or other (2 Methods)

Measuring Best Image Crop Size for a Userform Background (Free Script)

Shrink Images (dimension) Using Free Tool

Using Images Bonus Pack on Userform and 3 Sizing Modes

Using Images Bonus Pack on Worksheet (2 Methods)

06 - 29 Min, Max and Sum At The Top For Group Mode

06 - 28 Auto-Adding New Subtotals to Items When Group Mode Triggered

06 - 27 Trigger Events When Grouping - Add Divider Line Only In Group Mode

06 - 26 Special GroupBy Totals Only When Certain Columns Are Grouped

06 - 25 Concatenation Issues And Solutions

06 - 24 Getting Totals For Each Column At The Bottom

06 - 23 Multiple Totals In A Single Merged Cell

06 - 22 Multiple Totals In A Single Cell (SplitCell Property)

06 - 21 Using Subtotal and Grand Totals Together (Bonus Solutions)

06 - 20 Use Multiplication In Subtotal Calculations

06 - 19 Computing VAT or Income Taxes In Neighboring Columns

06 - 18 Formulas Including Immediate If Operator (SumIF in ExGrid)

06 - 17 Aggregate Functions Using Index Numbers Instead Of Lists

06 - 16 Excluding Items From Computation (Plus Expression Syntax 101)

06 - 15 Code Review - 2 More Examples

06 - 14 Locked Items On Top Or Bottom Of Grid (FreezePanes)

06 - 13 Simple SUM With No Child Items

06 - 12 Introduction To Aggregate (Sum, Count, Min, Max, Avg) Subtotals, Totals, Parent, Child, Leaf Items etc

06 - 11 Enabling and Manipulating the Popup Column Picker

06 - 10 Grouping Programmatically While Sort Bar Is Hidden

06 - 09 Disable All Or Certain Columns From Grouping

06 - 08 Getting A Taste For Grid Events - Auto Collapse Grouped Items

06 - 07 Grouping With An ADOR Recordset Dynamically

06 - 06 Simulated Grouping Versus True Groups (Code Example)

06 - 05 Filter Bar Hierarchy Inclusion Options

06 - 04 Creating Divider Lines

06 - 03 Making Items Unsortable

06 - 02 Various Lines and Styles For Child Items and Cells

06 - 01 Intro To Group and Aggregate - Hierarchy, Adding Sub Items

04 - Data Entry - How Can I Make Sure Dates Don't Re-Format As TEXT

03 - Data Entry - How Can I Update Gridlines Only To Current Record

02 - Data Entry - Should I put Default values in empty cells

01 - Webscraping Tools - OfficeScripts vs PowerAutomate vs Selenium

03 - Icons, Cursors and Image Tricks, Tips and Hacks

02 - How To Perform Math Operations In A TextBox Like A Cell

01 - Convert Text Numbers to True Numbers VBA Trick

03 - Website Automation With Excel and Selenium

02 - Update Powerpoint Data With Today's Date Using VBA

01 - Search A ListBox and Select Items Programmatically

Custom Function To Determine If Expiry Date Is Expired

Custom Function To Determine If Expiry Date Is Expired

Generating One Email To An Automated List (To, CC or BCC)

05 - Free Stuff and Bonus Questions From Comments

04 - Find, Zoom To and Read Today's Reading of the Day

03 - Beyond Data Validation... Force Cell Input To 'dd MMM yyyy'

02 - Sending an Excel PivotTable using Microsoft Outlook

01 - Introduction

Determining Whether Filters Are Applied And Getting Number of Visible Items

Allowing Case-Sensitivity and Other Filter Bar Prompt Options

Using Filter Bar Prompt Programmatically (2 Methods)

Specifying Columns To Be Used When Filtering With Filter Bar Prompt

Enabling The Filter Bar Prompt

Setting The Column Dropdown Filter's BackColor

Removing Or Customizing Description for Special Items in Column Filter

Using Custom Filter Descriptions In Column Filters

Setting Custom Captions for the FilterBar

Hiding the Filter Bar Description

Turning Off Filter Pattern For a Column

Remove All Items From Drop Down Filter So Only Pattern Search

Exclude Items From A Column Programmatically

Allow Excluding Items In Column Filter

Sorting Items In The Drop Down Column Filter List

Additional Column Filter Features and Customizations with FilterList Property

1 2 3 14

Excel VBA Is Fun

We believe Excel is one of the most versatile programs out there - and learning to program and automate it makes you very valuable!

You can prevent wasted time and errors, speed up tasks and become indispensable to your organization. 

See how our trainees have gotten raises, promotions and bonuses using their Excel Automation skills while building real problem-solving programs in Excel!
LEARN MORE
Copyright © 2022 ExcelVbaIsFun
X

Forgot Password?

Join Us

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram