AGGREGATE Function

May 20, 2016 | Functions, Misc Functions

The AGGREGATE Function The AGGREGATE function is a very powerful function for summarizing an array of data. It combines 19 different ways to summarize data into one function! While it is a powerful function, my favorite reason for using AGGREGATE is its ability to SUM...

3 Most Common Financial Reporting Errors

Apr 12, 2016 | Accounting Topics

Three Most Common Reasons for Restating Financial Statements I just finished reading an interesting article in the Wall Street Journal on financial reporting. Did you know that over 650 companies filed financial revisions or restatements last year? In most cases, it...

Gantt Chart for Project Scheduling in Excel

Sep 22, 2015 | Charts

Gantt Chart using Excel A Gantt Chart is used in project scheduling.  It takes each activity and provides a sideways bar to visually show when that activity occurs within the total project.Excel can be used for Gantt Charts using the IF function, the AND function and...

Grouping Data by Date

Jul 24, 2015 | Copying and Moving

Techniques for Grouping Data by Date in Excel If you have a large data set that includes transaction dates, you may want to aggregate amounts by certain dates.  The problem is that you have a separate date for each day of the year.  This makes any meaningful analysis...