Archives for: June 2014

Excel Lovers are Increasing Day-by-Day

Tutorial, Trainings, Commerical ad
Hi there,   This proves that the starvation of learning Excel is becoming very huge on day to day interms of percentage. So, to make our facilities available for more number of Excel Lovers we are introducing a commercial ad with promo code to avail 50% discount. This promo code is valid till the subscribers who stands with in 2500 members. After reaching this target number of participants we will close it without any notifications. more »

Convert an Excel Chart into a .GIF File

excel_usage, charts
Hi there,   Convert an Excel Chart into a .GIF File more »

How to Apply Uniform Size to Multiple Charts?

charts, Excel Tips
Hi there, In this post, we will learn about how to apply uniform size to multiple charts for a data (same or different). In this example, we have "Monthly Paper Book Sales" for Excel, Word and Access. Now, apply the charts using "Recommended Charts" in Charts Group. Here I am referring to Excel Version 2013. If you are not reached to this version, nothing to worry just select the appropriate charts that you like, for that matter. Say you have to create three charts. (per this example here). more »

FORECAST FORMULA

Formulas, How-to's
Hi there,   This formula is basically used when a company requires to forecast their business for coming year or for future years from now. It is also called as prediction of company's growth or company's KAZANAAA...(wealth). SYNTAX: FORECAST(x,known y's, known x's) in other words more »

What is a Dashboard?

Learn Dashboarding
Hi there,   Dashboard, this is a very common name in reporting field. However very few of them know exactly What is a Dashboard!. After this post, hope every one can proudly answers to this question in the working environment. This question is very co… more »

INDEX / MATCH works well with Cell Reference

Formulas, Arrays
Hi there,   We have received a client invoice from Dummy client and the invoices is worth of $237. To recalculate the sum of values we use SUM function. Similarly, to find the average we use AVERAGE function, this is common. But how to find the result for selected range of cells as a dynamic SUM or dynamic AVERAGE? RANGE OF CELLS: Here in the example database, we have a range of invoiced amounts in C7:C18. To SUM this values we can use SUM(C7:C18). This is our routine method of doing the SUM function. What if we require a sum of values for a specific range of cells or average of specific range of cells? Yes, this is the biggest challenge here. more »
Contact / Help. ©2019 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / Evo Factory.