Excel® Tips and Tricks

Category: Macros

Get the best in Excel® training anytime, anywhere.

Get Excel® Training

Excel Macro Tutorial for Beginners





Categories: Excel®, Macros

To follow using our example, download MacrosForBeginners.xlsx Once you get comfortable navigating Excel, it won’t be long before you start to hear about this wondrous feature called a “Macro” that can  leap tall projects with a single keystroke and make boring tasks go by faster than a speeding bullet. While Macros aren’t really the superman […]

Read More

Searching for Data in Excel





Categories: Excel®, Macros

Are you looking for the “peanut butter and chocolate” of workplace efficiency: how to combine the power of Macros with the convenience of search? As of Office 2013, Excel does not provide an easy way to include a variable search term in the execution of a series of tasks recorded in a macro. By easy, […]

Read More

Excel Macro to Delete Rows





Categories: Macros

In our fast-paced, technology-driven world, it doesn’t make sense to spend time clicking through rows and rows on a spreadsheet just to delete them. By using the power of Excel Macros, you can automate the process so that Excel will eliminate any and all flagged rows instantaneously. Let’s take a real-world example. Transfiguration, Inc., is […]

Read More