Blog Feed
Excel PivotTable Formulas
It’s easy to create formulas with PivotTable data. The key is to remember that you are working with aggregate values, not individual ones. We’ll take a look at how to create a simple formula using something called a Calculated Field. And then, we’ll take a look at two common causes…
Read More
DOLs Final Rule for FLSA Overtime Exemption: Next Steps (Video)
Transcript What's an employer to do? December 1st, 2016, the final rule is going to kick in. And we all have to be ready. So let's say you've performed the internal audit in your organization, and you found out, uh-oh, we have some folks that don't qualify for the exemption.…
Read More
Interactive Excel Charts: Create a Chart Selector
More and more data has led to more and more opportunities to present it in visually understandable ways. However, it can get frustrating having to navigate through a large workbook, just to find the exact chart you need. In this tutorial, you’ll learn how to create an interactive chart selector.…
Read More
DOLs Final Rule for Overtime Exemption: The Duties Test (Video)
Do you know and understand the overtime exemption rule recently released by the Department of Labor? In this video, Lisa Smith gives an overview of which duties qualify an individual for exemption. Transcript Under the final rule that was issued May 18 of 2016, we know that the duties tests…
Read More
Leadership and Teamwork: Blending I and We
"There is no I in TEAM" is a popular expression, but great teams know that individual leadership is essential to effective teamwork. In fact, without effective leadership, teams often lose focus and direction, and work and morale suffer as a result. Different leadership approaches work equally well on teams. When…
Read More
External Leadership for Teams
When we talk about teamwork, we often focus on internal dynamics: goal setting, communication, leadership and process. It is equally important, however, to build team skills in political savvy and external awareness. These skills help the team scan their environment for new information, and prepare key stakeholders for future steps…
Read More
Five Communication Tips for Teams
Communication is a central activity for all teams. In this post, we review five practical communication tips that lead to better teamwork. Make it common practice to revisit the goal. Many team-focused articles talk about the importance of mission clarity and alignment, but too often, teams don't actually ask, "wait,…
Read More
Making the Most of the Excel Macro Recorder Feature
Did you ever think to yourself, “There should be a shortcut for that!” Well, even if there isn’t, there can be! All you may have to do is record a macro. A word of caution before we begin: The one thing you can be sure of, as new versions of…
Read More
Department of Labor Releases Final Rule for FLSA Overtime Exemptions (Video)
Is your company aware of the recent release of the final rule for overtime exemption? Be sure you are up to date with all the new FLSA updates. In this video, Lisa Smith goes into a brief overview of the ruling. Transcript As you probably know, the Department of Labor released…
Read More
PivotTable from a PivotTable
While it is not technically possible to pivot a pivot table, you can reduce the number of records to analyze by using some of the functionality available in Excel 2010 and later versions. Download Pivot Table from Pivot Table.xlsx to work along. The Steps To accomplish the goal of reducing…
Read More