Thursday, October 11, 2012

 Tip: Create Target Line In Chart

Regardless of organization type departments within it have goals to be met. Many of these goals involve surpassing revenue forecasts, containing costs and minimizing defects just to name a few. Using a chart to monitor these goals is common. However, one small addition to your chart can create a world of difference for all viewers of the document. Create a visible target line within your chart to quickly communicateif goals are being met. Very often people use a line from thes Shapes tool to create such a target line, but another alternative is available.

Read More - http://www.excellentones.com/resources/Target%20Line%20Charts.html

Function: INT

In many instance figures developed in Excel contain trailing digits after the decimal point. In some cases only the integer is needed. Excel has a function called INT which can be used to eliminate these trailings digits.

Read More - http://www.excellentones.com/resources/INT.html

Free Upcoming Event

Title: The Power of Microsoft Excel Pivot Tables

Date: Thursday February 7th, 2013

Time: 6:00pm - 7:00pm

Location: Brooklyn Public Library - Business & Career Library

280 Cadman Plaza W. at Tillary St.

Brooklyn, NY 11201

Cost: Free

Stay tuned on Facebook for details!

Facebook Posts

Video Tutorial: Resizing multiple columns and rows in Excel

Video: Brooklyn Chamber of Commerce Tech. Conference 2011, Seminar "Time Is Money: 3 Microsoft Excel Tools to Improve Productivity", short interview after event. Courtesy Krossview Productions Inc.

Video: The year was 1987, Bill Gates introduces Microsoft Excel to the world

Like Us on Facebook - http://www.facebook.com/ExcellentOnesConsulting