Author Topic: microsoft word-excel- office  (Read 121423 times)

Offline HowYaDoin

  • Dansdeals Platinum Elite + Lifetime Gold Elite
  • ******
  • Join Date: Jan 2013
  • Posts: 895
  • Total likes: 26
  • DansDeals.com Hat Tips 1
    • View Profile
Re: microsoft word-excel- office
« Reply #260 on: September 01, 2014, 04:28:34 PM »
I need microsoft office for windows 8.1 any possibility of getting it for $50 or less

Offline Sport

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 2365
  • Total likes: 103
  • DansDeals.com Hat Tips 1
    • View Profile
Re: microsoft word-excel- office
« Reply #261 on: September 02, 2014, 02:26:34 PM »
Im ( probably not even) a novice excel user so not sure if this is possible. I have a report of customers over the past year telling me how much they spent each year. I have many repeat customers and each year is in its own row. Im trying to compress the information into one row per customer. So say Joe S. spent $100 in 2012, $75 in 2013 and $125 in 2014, right now each year is on its own row with all Joe S's information is there a way for me to keep all of Joe S's info on one row and have a column for each year?
 

Offline DanH

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Oct 2011
  • Posts: 2181
  • Total likes: 26
  • DansDeals.com Hat Tips 2
    • View Profile
Re: microsoft word-excel- office
« Reply #262 on: September 03, 2014, 02:34:41 PM »
Im ( probably not even) a novice excel user so not sure if this is possible. I have a report of customers over the past year telling me how much they spent each year. I have many repeat customers and each year is in its own row. Im trying to compress the information into one row per customer. So say Joe S. spent $100 in 2012, $75 in 2013 and $125 in 2014, right now each year is on its own row with all Joe S's information is there a way for me to keep all of Joe S's info on one row and have a column for each year?
Transpose?
http://office.microsoft.com/en-001/excel-help/switch-transpose-columns-and-rows-HP010224502.aspx
For tech help feel free to Telegram me @DanTechSupp

Offline Sport

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 2365
  • Total likes: 103
  • DansDeals.com Hat Tips 1
    • View Profile
Re: microsoft word-excel- office
« Reply #263 on: September 03, 2014, 07:46:56 PM »
Transpose?
http://office.microsoft.com/en-001/excel-help/switch-transpose-columns-and-rows-HP010224502.aspx
Thanks, but I dont think this is what I am looking for. I probably was not clear, right now on my spreadsheet I have an entire row (with all the customers info)  for each year that a customer made a payment, the only diffrence between each row is the payment for that year, (the rest of the row is general information like address, phone etc.) I would like to have each customer only have one row with a seprate column for the each years payment.

Offline noturbizniss

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2012
  • Posts: 7118
  • Total likes: 140
  • DansDeals.com Hat Tips 4
  • Gender: Male
    • View Profile
  • Location: North Jersey
Re: microsoft word-excel- office
« Reply #264 on: September 03, 2014, 08:36:27 PM »
Thanks, but I dont think this is what I am looking for. I probably was not clear, right now on my spreadsheet I have an entire row (with all the customers info)  for each year that a customer made a payment, the only diffrence between each row is the payment for that year, (the rest of the row is general information like address, phone etc.) I would like to have each customer only have one row with a seprate column for the each years payment.
Make a list of all the customers and remove duplicates (on the data tab of the ribbon), then make a table from that using sumifs function. See attached file.
READ THE DARN WIKI!!!!

Chuck Norris...
...can still do FT method
...READS THE WIKI!!!

Offline Sport

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 2365
  • Total likes: 103
  • DansDeals.com Hat Tips 1
    • View Profile
Re: microsoft word-excel- office
« Reply #265 on: September 03, 2014, 08:53:01 PM »

Make a list of all the customers and remove duplicates (on the data tab of the ribbon), then make a table from that using sumifs function. See attached file.
Awesome, thanks this looks like it'll work.

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7647
  • Total likes: 301
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: microsoft word-excel- office
« Reply #266 on: September 03, 2014, 08:59:24 PM »
Thanks, but I dont think this is what I am looking for. I probably was not clear, right now on my spreadsheet I have an entire row (with all the customers info)  for each year that a customer made a payment, the only diffrence between each row is the payment for that year, (the rest of the row is general information like address, phone etc.) I would like to have each customer only have one row with a seprate column for the each years payment.
Pivot table.

Offline noturbizniss

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2012
  • Posts: 7118
  • Total likes: 140
  • DansDeals.com Hat Tips 4
  • Gender: Male
    • View Profile
  • Location: North Jersey
Re: microsoft word-excel- office
« Reply #267 on: September 03, 2014, 09:02:59 PM »
Pivot table.
Also works, but then needs to be manually refreshed every time. Also, op said he was a novice if that and when I first started I had no idea how to user pivot tables so I wanted to keep it simple
READ THE DARN WIKI!!!!

Chuck Norris...
...can still do FT method
...READS THE WIKI!!!

Offline Sport

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 2365
  • Total likes: 103
  • DansDeals.com Hat Tips 1
    • View Profile
Re: microsoft word-excel- office
« Reply #268 on: September 03, 2014, 09:20:49 PM »

Pivot table.
Also works, but then needs to be manually refreshed every time. Also, op said he was a novice if that and when I first started I had no idea how to user pivot tables so I wanted to keep it simple
yes, exactly, thanks CBC but I was going to ask what a pivot table is.

Offline noturbizniss

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2012
  • Posts: 7118
  • Total likes: 140
  • DansDeals.com Hat Tips 4
  • Gender: Male
    • View Profile
  • Location: North Jersey
Re: microsoft word-excel- office
« Reply #269 on: September 03, 2014, 09:44:47 PM »
yes, exactly, thanks CBC but I was going to ask what a pivot table is.
Probably one of the most useful and easiest tools in excel. Really needs a demonstration to see the full power.
READ THE DARN WIKI!!!!

Chuck Norris...
...can still do FT method
...READS THE WIKI!!!

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 13002
  • Total likes: 3475
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: microsoft word-excel- office
« Reply #270 on: September 03, 2014, 09:46:28 PM »
Probably one of the most useful and easiest tools in excel. Really needs a demonstration to see the full power.
access too!
Workflowy. You won't know what you're missing until you try it.

Offline an613

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Apr 2010
  • Posts: 319
  • Total likes: 2
  • DansDeals.com Hat Tips 1
    • View Profile
Re: microsoft word-excel- office
« Reply #271 on: September 03, 2014, 09:51:53 PM »
Probably one of the most useful and easiest tools in excel.

+1. IMHO, worth taking the time to learn at least the basics of it

Offline Sport

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 2365
  • Total likes: 103
  • DansDeals.com Hat Tips 1
    • View Profile
Re: microsoft word-excel- office
« Reply #272 on: September 03, 2014, 10:07:10 PM »
Probably one of the most useful and easiest tools in excel. Really needs a demonstration to see the full power.
Any good youtube tutorials for this?

Offline churnbabychurn

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2012
  • Posts: 7647
  • Total likes: 301
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Lakewood
Re: microsoft word-excel- office
« Reply #273 on: September 03, 2014, 10:30:26 PM »
Any good youtube tutorials for this?
its actually pretty intuitive. There are plenty of yt videos....
A good way to learn: Copy your data into a new workbook and play with it..

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 13002
  • Total likes: 3475
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: microsoft word-excel- office
« Reply #274 on: September 04, 2014, 01:04:40 AM »
play with it..
ahhh, the best way to learn almost anything!
Workflowy. You won't know what you're missing until you try it.

Offline DK23

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Nov 2013
  • Posts: 441
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: microsoft word-excel- office
« Reply #275 on: September 05, 2014, 11:47:01 AM »
Learn Pivot Tables they are great!

Offline Sport

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 2365
  • Total likes: 103
  • DansDeals.com Hat Tips 1
    • View Profile
Re: microsoft word-excel- office
« Reply #276 on: September 11, 2014, 04:10:57 PM »
Anybody have experience with this excel training course http://www.groupon.com/deals/goskills ?
Is it worth it?

Offline aygart

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2008
  • Posts: 18895
  • Total likes: 14972
  • DansDeals.com Hat Tips 14
    • View Profile
    • Lower Watt Energy Brokers
  • Programs: www.lowerwatt.com
Re: microsoft word-excel- office
« Reply #277 on: September 11, 2014, 06:23:28 PM »
There are tons of online excel courses for free on places like udemy
Feelings don't care about your facts

Offline etech0

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 13002
  • Total likes: 3475
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: microsoft word-excel- office
« Reply #278 on: September 11, 2014, 06:40:12 PM »
There are tons of online excel courses for free on places like udemy
Yup. And if you want to know how to do something, chances are there's a youtube video about it.
Whenever you're bored, google "excel tips" or "excel tricks" or the like and see what cool things you find.
Workflowy. You won't know what you're missing until you try it.

Offline Sport

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2013
  • Posts: 2365
  • Total likes: 103
  • DansDeals.com Hat Tips 1
    • View Profile
Re: microsoft word-excel- office
« Reply #279 on: September 11, 2014, 09:50:25 PM »

Yup. And if you want to know how to do something, chances are there's a youtube video about it.
Whenever you're bored, google "excel tips" or "excel tricks" or the like and see what cool things you find.
Even for a complete novice like myself?