Creating Excel Templates

Creating an Excel template allows a person to reuse a workbook setup over and over, without the need to recreate the wheel every time, nor continuously to clean out old information. By using a template, your workbook is ready and waiting for you to enter data; everything else will happen automatically, when you automate your … Continue reading Creating Excel Templates

Recorded Macros vs. Coded Macros

In the world of Microsoft, macros are the way many users automate various steps of their daily processes. There are two basic types of macros, recorded and coded. Recorded macros are what most users are familiar with. as they are simple to create and simple to use.  Coded macros are less common, as require knowledge … Continue reading Recorded Macros vs. Coded Macros

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