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.
VBA
In today’s post, we’ll be diving into an exciting topic that springs up occasionally among Excel users: “How can you combine worksheets from different workbooks while keeping all the sheets separate in the resulting combined workbook?” Sounds tricky, doesn’t it? But don’t worry! We’ll be navigating through this method together. We’ll go step by step…
Selecting every other row in Excel can be helpful. Aside from making it easy to get rid of duplicate rows, it can also be a great way to highlight important information, make the data easier to read with formatting, and more. However … if you’ve ever tried to select every other row in Excel, you…
Do you use Excel frequently and find that you often have to repeat the same tasks over and over? If so, you can use Microsoft Excel macros to automate those tasks and cut down on how much time it takes to complete them! You can create a macro by recording your keystrokes and mouse clicks,…
Do you know the Excel basics, but want to become a pro? We’re outlining the six steps you can take to learn how to become proficient in Excel.