Automate Excel Without Macros

Many students come to us wanting to learn how to create macros in Excel to automate their spreadsheets.  However, they often don’t realize that formulas can be used to create most of the automation they want. Although we can use macros to automate steps, there are limits to macros (especially the simplistic ones that are … Continue reading Automate Excel Without Macros

Why Excel? Two unique scenarios

When you think of Microsoft Excel what comes to mind? Accounting spreadsheets? Using formulas to calculate numbers? Generally, we think of Excel only as a system to manage our numbers, but you might be surprised by some other things that you can do with this program. We are going to look at two uses for … Continue reading Why Excel? Two unique scenarios

Missing a Mouse? Use ALT – Excel

  If you’ve ever had a mouse go bad in the middle of a project, you probably called IT to bring you a new mouse.  Or if this happened at home, you drove to the store to get a replacement. Regardless of where it happens, it is Murphy’s Law that it will happen at the … Continue reading Missing a Mouse? Use ALT – Excel

Keep Decimals Out of the Equation with Data Validations in Excel

Using Data Validations in Excel can be very helpful, as validations make sure the data is entered correctly, and ensures all the intended functionality works according to plan. One possible validation scenario is the need for all numbers to be displayed as whole numbers. Follow these steps to ensure no decimals are included during data … Continue reading Keep Decimals Out of the Equation with Data Validations in Excel

Evaluating Formulas in Excel

If you build formulas with the help of the Function Library, a dialog box pops up, and helps you fill in the different areas with the correct information, then evaluates your formula as you move through the setup process. If you like to write your formulas without that help of the Function Library, then what … Continue reading Evaluating Formulas in Excel

Revolutionary Learning Experiences: Excel Automation

We have all had those “Aha” moments, when the blinders are removed, the light bulb goes on, and things become clear. These revolutionary learning experiences can radically change our entire approach to our jobs, or even life. Here we look a look at one approach to working with Excel that can revolutionize the way you … Continue reading Revolutionary Learning Experiences: Excel Automation

Go Further than Advanced in Excel

You know your way around a spreadsheet. You know how to set up your columns; you use some swanky shortcuts to reduce the time it takes you to input data; you have a utilitarian list of Excel functions at your disposal. But what if you could do more? What if you could become the ultimate … Continue reading Go Further than Advanced in Excel

Finding Worksheets in Excel

When working with Excel, especially if you are trying to fully automate a workbook, you can create many worksheets to keep from recreating the wheel.  Doing so often means navigating to various print jobs, and can be exhausting. You can search for your worksheets by clicking the left or right arrows, or the “…” that … Continue reading Finding Worksheets in Excel

Removing Duplicates in Excel

  Removing duplicate information can be both helpful and intimidating when working with many line items in Excel. Follow these steps to make the process easy : Ensure your data has column headers and that there are no blank columns or rows between data you want selected and checked. Click anywhere inside the data you … Continue reading Removing Duplicates in Excel

TEXTJOIN Function in Excel

Excel 2019 has many new features to offer users. Some of the features that were only offered in browser mode for Excel 2016, are now available for the Excel 2019 client application, i.e., available on your computer desktop. One such feature is the TEXTJOIN function. Some software requires that information be setup a certain way … Continue reading TEXTJOIN Function in Excel