Blog – Launch Excel

Latest article

Posted July 28, 2018

Excel Tutorial: How to create Cascading Dropdowns

Summary: In this article we’ll learn how to create Cascading dropdowns in Excel. Excel dropdown lists are very useful especially when we want to create data entry forms. Excel functions used in [...]

By Victor Chan

In Excel Formulas, Excel Tips

Posted July 28, 2018

Excel Tutorial: How to create Cascading Dropdowns

By Victor Chan

In Excel Macros & VBA

Posted July 20, 2018

Excel VBA Tutorial: Get your personal macro code vault (aka Personal Macro Workbook)

Summary: Learn how to create your own Personal Macro Workbook. It acts like your personal code vault where you keep frequently used macros. Any macros in the Personal Macro Workbook can be called [...]

By Victor Chan

In Excel Macros & VBA

Posted July 5, 2018

Excel VBA Tutorial: Unlock the Secrets of Worksheet Code Names

Summary: Few Excel users know about Worksheet Code Names… in this article you will learn how they differ from plain old Worksheet Names and why you should start using Code Names where possible in [...]

By Victor Chan

In Excel Macros & VBA

Posted June 29, 2018

Excel VBA Tutorial: Understanding the difference between Range and Cells in Excel VBA

Summary: Learn the difference between using Range() and Cells() when referring to ranges with Excel VBA. With the help of sample code you’ll understand when to use Range() and when to use [...]

By Victor Chan

In Excel Macros & VBA

Posted June 12, 2018

Excel VBA Tutorial: Find the Last Cell, Row or Column on an Excel Worksheet

Summary: Learn four different ways to find the last cell, row or column in a worksheet using Excel VBA. The method to choose depends on your data layout, and if the sheet contains blank cells. [...]

By Victor Chan

In Excel Macros & VBA

Posted May 29, 2018

Sending e-mails from Gmail and Outlook using Excel VBA

Today we have a guest article from Perceptive Analytics. It explains how to send emails from Gmail and Outlook using Excel VBA. For instance, you might want to set up an automated email system to [...]

By Victor Chan

In Excel Macros & VBA

Posted February 20, 2018

Excel Tutorial: How to use VBA to delete filtered rows (fast!!) … but not delete hidden rows

A couple of weeks ago, I got a question from Svetlana on my YouTube channel. Svetlana has a worksheet with filtered data and wants to know how to delete visible filtered rows and leave hidden [...]

Click these links to

Get the Timeline Template »

Buy our popular Excel Timeline Template and Videos

Online Excel Resources »

Do you want to improve your Excel skills? Here are links to useful resources

Excel Consulting Services »

Let us help you develop, optimize and maintain your spreadsheets.

Join over 9,000 subscribers

GET BETTER AT EXCEL

Click to get free updates

Join over 9,000 subscribers

GET BETTER AT EXCEL

Click to get free updates

We are here to help! Check out

OUR MOST POPULAR RESOURCES

Get the Timeline Template »

Buy our popular Excel Timeline Template and
Videos

BUY

Online Excel Resources »

Do you want to improve your Excel skills? Here
are links to useful resources

GET ACCESS

Excel Consulting Services »

Let us help you develop, optimize and maintain your spreadsheets

Ha！Ha！ I tried many times learning from the book ExcelVBA Programming for Dummies, but I couldn't get it right. Watching this Video I can get done in a few trials. It works! TQ!

- VT Thiang

“I wish I knew about this earlier. I spent literally days cutting and pasting, so I could use data in a pivot table. Bravo!”

– Bjmsj

“Dude that was AWESOME! You gave me the ultimate weapon!”

– Milan

“Excellent demonstration thank you very much”

– Tolan

“Wow, you are a type of excel Jesus, thank you”

– Armoricalex

“Many thanks please make more excel videos!”

– ndelpurg

“You ROCK!! Thanks for the tips, and your time, I appreciate it.”

– Tom

“Thank you for your awesome video, your instructions were very clear.”

– Liztra

“Wow I’m really impressed of the power of macro’s. When my teacher tried to explain this to me, it was all Chinese for me. Your explanation is super!! Thanks a lot!!”

– Yannick