Excel on Steroids

Comment

Comment by Gary Olynik on April 11, 2012 at 2:04am

Is there an easy way to expand a spreadsheet to the right?

I have a spreadsheet that totals cost codes for a construction client. It is broken down into sections and then does a grand total.  From time to time they need to add a column for a new invoice.

I want to insert a column...no problem, but is there a way that the totals for all the cost codes can easily be copied to the new column all at once?

Comment by Diane Koers on March 24, 2011 at 4:41pm

I get the error for any of the Excel on Steroids Vol 1, 2 or 3 ebooks. The error says "Server Error in '/' Application.". The link address is http://www.alchemex.com/DownloadDocumentation.aspx

Thanks! 

Comment by Tyrone Le Fleur on March 24, 2011 at 8:26am

Hi Diane

Can you let me know which  ebook you are having issue downloading.

Thank you.

Comment by Diane Koers on March 23, 2011 at 10:53pm

I'm trying to download the Excel Tips and Tricks ebooks, but it appears to be a broken link.

 

Thanks!

Diane Koers

Comment by Ruth Gray on November 8, 2010 at 12:42pm

Charles see the following link were your questions were answered. shout if you need any help
http://community.alchemex.com/forum/topics/pivot-tables-with-multiple

Comment by Charles Sivewright on November 7, 2010 at 5:43pm

Hi... I'm trying to create a pivot table with more than one (multiple) worksheet of "source data" - Could anyone point me in the right direction? - I seem to be going round & round in circles with Microsoft's "help" - many thanks - Charles

Comment by Charlene on September 13, 2010 at 9:49am

Hi everyone,

Please register for our next Excel webinars

1. Getting Started with Macros in Excel 14 September
https://www1.gotomeeting.com/register/609978400

2. Excel: Financial Functions
https://www1.gotomeeting.com/register/460346672

For our Webinar Calendar go to:
http://www.alchemex.com/Webinars.aspx

Have a great day!

Charlene Hattingh
(011) 304 1400

Comment by Les on August 31, 2010 at 10:36am

Hi Charles,

Please post any further questions re Excel in the Excel on Steroids forum area. I've sent a link through to you. Helps us in keeping all the questions in one location.

Regards,


Les

Comment by Charles Sivewright on August 31, 2010 at 10:35am

Thanks Kevin - I forgot to mention that I'm still on Excel 2003 - I've been playing around with it and have discovered how to get the value as opposed to the "count" - but now, when I want the "text" data to be reflected in the pivot table, I can't seem to get away from a numeric value as opposed to the text

Comment by Kevin Naidoo on August 31, 2010 at 10:21am

Open up the Pivot Table Field List, on the Values Tab, u will see "Count of....."
U click on that, select Value Field Settings, and then select SUM.
Hope this helps

• ‹ Previous
• 1
• 2
• Next ›
• Page