Blog Feed
Tips for Creating Perfect Pivot Tables with a Macro
Once you've harnessed the power of PivotTables, you probably find yourself looking for ways to use them all the time. The same is true of macros – convenient shortcuts that make your life easier! But have you tried to combine the two? Unless you are turning the exact same format…
Read More
Creating a Graph with Mutiple Data Series in Excel Without a PivotChart
One of the most powerful advantages of a chart is its ability to show comparisons between data series, but you'll need to spend a little time thinking about what you want to show and how to organize it for excellent communication. Let's look at the ways that Excel can display…
Read More
A Great Way to Create an Excel Micro Timer
Professionals who are used to organizing their lives in Excel at some point wish Excel could include a timer to help keep track of common tasks. Tasks like tracking time spent on specific projects or monitoring hourly rate. A quick look, however, reveals that – unless you are an accomplished…
Read More
Three Excel Chart Add-Ins to Create Unique Charts and Graphics
There's no debating that Excel is a powerful, useful tool for gathering, analyzing and communicating all kinds of data. But even the biggest fan sometimes wishes for just a little bit more, especially when you want to create visual impact for your data in charts and graphics. Microsoft opened the…
Read More
Excel Standard Deviations and Error Bars for Better Graphs
It would be nice if all data was perfect, absolute and complete. But when it isn't, Excel gives us some useful tools to convey margins of error and standard deviations. If you work in a field that needs to reflect an accurate range of data error, then follow the steps…
Read More
How to Create a Leadership Development Program for your Business
The Leadership Development Factbook 2014: Benchmarks and Trends in U.S. Leadership Development, produced for Bersin by Deloitte reveals that Leadership continues to be the number one Human Capital concern for businesses[1]. As organizations struggle with leadership gaps at all management levels, the report shows businesses responding with more leadership development…
Read More
Personal Leadership Development Plan
You do what you plan. All of us, whether in business or everyday life, are more likely to accomplish a task if we first create a plan. Leadership and personal development coach, Michael Hyatt, shares that writing down those goals helps you clarify your intentions, motivates you to take action…
Read More
How to Develop Your Leadership Skills
Anyone who has worked for an organization can easily describe what they like and dislike about the leaders they encounter. However, turning those observations into the skills you need to become a good leader yourself can be much more difficult. For example, you admire your boss because she clearly communicates…
Read More
Create a Date or Time Chart in Excel with XY-Scatter Charts
When you have data that involves time information, you may need some special tricks to get Excel to help you create useful charts. Here are some tips for editing time and date data in an Excel chart. These features apply to Excel 2007-2013, though the specific steps will vary based…
Read More
Learn about the Excel Find Formula
Sometimes getting valuable or actionable information out of your data is a bit like going on a treasure hunt: You spend a lot of time solving puzzles and putting together a "map" of formulas that will hopefully lead you to the goldmine of information hidden inside. The FIND function, and…
Read More