This introduction to using Pivot Tables in Excel shows how to analyze monthly income and expenses by account, category, date, etc. Download the example spreadsheet to follow along. By guest author and Microsoft MVP, John MacDougall.
Guest
How to Make a Dynamic Geographic Heat Map in Excel
As an alternative to Power Map or 3D Maps, learn how to create a geometric heat map in Excel using shapes and a simple VBA macro. Guest post by Onur Yilmaz of Someka.net.
Case Study – Using Simple Tools for Project Management
What’s Your Project Management Style Do you have a proven process for project management and business success? Think about the tools you have in place to drive and track your business activities, projects and staff toward the common goal. Are you maximizing your time and capitalizing on activities that make sense? Hoping for the best [...]
6 New Awesome Chart Types in Excel 2016
Six awesome new charts! Learn how to create a histogram, box and whisker plot, waterfall, treemap, sunburst, and pareto chart in Excel 2016. By guest author, Kasper Langmann, from Spreadsheeto.com.
Sparklines in Excel – Mini Graphs that Make Data Analysis Fun
Sparklines are little in-cell charts that can help you analyze your data. This article shows examples of the three types of sparklines available in Excel 2010 and 2013.
40 Free Tools to Help Your Family Get Organized
An extensive list of family organizational tools created by Vertex42.com that you can use in your family life to stay on top of every aspect of your day, week, month, and beyond.
42 Effective Ways to Save Money
To help those who are using Vertex42’s budget templates and money management tools, we’ve compiled a huge list of effective ways to save money and help you stick to your family budget.
How to Create the Perfect Business Card
Tips for designing and creating the business card that will work for you, with a few visual examples.
Budgeting Tips for the New Year
Have you made your new year’s financial resolutions? Many people pledge to do better with their finances around this time of year, but they just don’t know where to start. By guest author, Philip Taylor.
Biweekly Mortgage Payment Plans Uncovered
Find out the inside scoop on biweekly mortgage payment plans, how to choose a service provider, and some of the fees to watch for.