Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

Macro

Insert and Name Sheets from Cell Values

By Jeff Lenning | February 24, 2020 |

In this post, I’ll share a short snippet of VBA code that creates new worksheets based on the names stored in cell values. This can be helpful when you have a list of departments, and want to create one worksheet for each department. Or a list of accounts, or employees, or regions, and so on.…

Read More

Learn Macros with the VBA Pro Guest Lecture

By Jeff Lenning | May 4, 2017 |

I’m happy to announce the immediate availability of Excel University’s newest guest lecture: VBA Pro by Jon Acampora. Earn 16 CPE hours while learning how to have macros do your work for you…what could be better? Macros offer the biggest opportunity for automation in Excel, and can help you get your work done faster. And…

Read More

Clear the Input Cell Style for Printing

By Jeff Lenning | February 16, 2017 |

I really like to highlight input cells by applying the Input Cell Style. I also like to try to place all of the input cells for a workbook on a single worksheet. That way, it is easy to update the input cells, and since they aren’t on any of the sheets I need to print,…

Read More
Data preview by Jeff Lenning

Get & Transform: An Alternative to Reformat Macros

By Jeff Lenning | June 16, 2016 |

Excel 2016 includes a set of features called Get & Transform. In previous versions of Excel, these capabilities were included in the Power Query Add-In. In this post, we’ll see how a Get & Transform Query can be used as an alternative to a VBA macro. Overview Here is the scenario. We export data out of…

Read More
Record Excel Macro by Jeff Lenning

Macro Toolbox

By Jeff Lenning | February 18, 2016 |

When storing utility macros, Excel users often elect to save them in the Personal Macro Workbook. The advantage is that the macros are available whenever Excel is running. The disadvantage is that if you switch or upgrade computers, you may forget to take a backup of the Personal Macro Workbook and thus lose your macros. In…

Read More