Have Questions? 
help@excelvbaisfun.com
Excel Ninja Pro
All Access

Recent Posts

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

06 - 02 Cleaning Invalid Date Formats

06 - 01 Fixing Dates and Times

05 - 03 XLOOKUP Function

05 - 02 Index, Match Functions

05 - 01 Lookup, VLookup and HLookup Functions

04 - 06 Adding Leading Zeros to Number Field

04 - 05 Does a Cell Contain Certain Text

04 - 04 Combining Columns and Making Mini-Report Summaries

04 - 03 LEFT, RIGHT, LEN, MID Functions

04 - 02 REPLACE and SUBSTITUTE functions

04 - 01 FIND and SEARCH functions

03 - 06 Change Language Trick for Huge List Instantly

03 - 05 Data Validation Tricks

03 - 04 Converting Text Numbers to Real Numbers, Numbers to Percent

03 - 03 Highlight Duplicates in 1 or More Columns

03 - 02 Unstack Data To Single Rows

03 - 01 Rotate Cell Data with Transpose (2 Methods)

02 - 07 Dealing with Trailing Minus and Debit-Credit Symbols

02 - 06 HIghlight or Remove Error Cells

02 - 05 Using Filter To Ensure Consistent Naming, Spelling and Grammar Tool

02 - 04 Finding and Replacing Mistakes, Advanced Wildcards Trick

02 - 03 Fill Blank Cells with Zero (or anything else)

02 - 02 Delete Rows That Have Blank Cells

02 - 01 Delete Blank Rows or Columns

01 - 08 Separate One Column into Many Columns

01 - 07 Importing A Text Document into Excel (3 methods)

01 - 06 Excel A.I. to Split Columns & Correcting Flash Fill

01 - 05 Removing Duplicates and Getting a Unique List Instantly

01 - 04 Make Text UPPER, lower or Proper Case

01 - 03 Remove Extra Spaces or Bad Characters

01 - 02 Remove All Formatting Instantly

01 - 01 Formatting Messy Data the Easy Way

01 - 00 Intro and Resources

Reisha Got Her Dream Job + Gets To Make Reports All Day! - FULL INTERVIEW

Ronald Saves His Company 4,100+ Hours/ Year! - FULL INTERVIEW!

Dave Quits His Job to License His Excel Program - FULL 2 HR INTERVIEW!

UserForm Series

ActiveX and Form Controls Series (Buttons, Dropdowns, Listboxes, etc)

Excel VBA Tips and Tricks Series

Lesson

Worksheet Event Series

Excel VBA Basics Series

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

03 ActiveX Buttons

04 Checkbox and IF THEN Statements

00 Intro - What You'll Learn and Download Files

01 Developer Ribbon

02 The Range Object

07 Worksheet Cell Change

05 Cells Object and Loops

06 What Are Events

09 Bonuses

08 Worksheet Selection Change

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

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 © 2024 ExcelVbaIsFun
X

Forgot Password?

Join Us

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