Blog Feed
Tips for Data Management in Excel
Becoming an Excel expert is more than learning functions and cobbling together formulas. A significant part of using Excel to its full potential is knowing the art of data management. This includes everything from knowing how to set up your worksheets to managing data entry to good maintenance practices. Here…
Read More
Excel What-if Analysis: Goal Seek
Ever find yourself wondering if Excel could help you answer the question: "What values would I need to get a known result?" The What-if Analysis features, available in Excel 2010 and up, give you the tools to do just that. Unlike functions and formulas that take given values and return…
Read More
Excel What-if Analysis: Scenarios
If you think of Excel as just a database for storing dead data, you will be pleasantly surprised to learn about Excel's What-if analysis tools. Excel offers several features that allow a user to make predictions, or evaluate outcomes based upon variable inputs. In this article, we are going to…
Read More
Excel Macro Tutorial for Beginners
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…
Read More
Use Multiple Worksheets to Create 3D Excel Charts
A 3D Excel formula allows you to calculate cells across multiple worksheets. It is incredibly useful for creating a summary sheet to share data with others. You can then share the results visually with the help of a 3D Excel Chart. Download and follow along with 3D Excel Charts.xlsx. Step-by-Step:…
Read More
6 Ways to Be More Productive
The best way to manage our time in the workplace isn't necessarily to have a more comprehensive schedule, but instead to have a smarter schedule. The real trick is to make sure you have the energy and attention to deal with all your tasks. Here are some tips to help…
Read More
How Can You Manage Your Time Better?
One of the best approaches to time management is to acknowledge that no one can do everything. Yet, many time management trainers still focus on schedules and productivity instead of prioritization, energy and coping with distractions. The truth is that time is limited and you are a finite resource. The…
Read More
Time Management Without the Clock
We all want to be productive in the workplace, right? This means days filled with tasks that are all considered “top priority.” If you’re like me, you may be good at creating task lists, but do you know how much time to devote to each task? If I’m so organized,…
Read More
Can You Permanently Save a Macro in Excel for Use in All Workbooks?
Have you ever lost your macro or decided it is just too useful for only one workbook? You can save your macro in PERSONAL.xlsb to apply the macro to all workbooks that you open and use on your computer. (Macros stored in personal.xlsb will not be available on other computers.)…
Read More
Excel Macro: Relative Reference
Excel records Macros in absolute mode by default. In absolute mode, a Macro will start working in the same cell it was in when it was recorded. If, when it was recorded, A1 was the active cell, then it will return to A1 and begin working from there no matter…
Read More