Topic Wiki

For cool Excel spreadsheet template to keep track of all Credit Card stuff, see here
« Last edited by shoobi on November 12, 2015, 11:24:07 PM »

Author Topic: Excel Help and Problems  (Read 80689 times)

Offline Zubda

  • DansDeals Copper Elite
  • *
  • Join Date: Apr 2018
  • Posts: 17
  • Total likes: 3
  • DansDeals.com Hat Tips 0
    • View Profile
Re: Excel Help and Problems
« Reply #1245 on: May 09, 2019, 12:32:24 AM »
I have zero previous experience with excel and want to learn the basics (and eventually more than that). What are good websites or courses to use?
Thanks
Exceljet.net

Offline Definitions

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: Jan 2018
  • Posts: 655
  • Total likes: 77
  • DansDeals.com Hat Tips 2
    • View Profile
Re: Excel Help and Problems
« Reply #1246 on: May 09, 2019, 09:55:03 PM »
Is there any ready made template for inventory management?

Need something simple. Master item list, received, shipped stuff, and current inventory.
Jack of all trades, master of none.

Offline thaber

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: May 2008
  • Posts: 2757
  • Total likes: 129
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Help and Problems
« Reply #1247 on: May 09, 2019, 11:56:03 PM »
Is there any ready made template for inventory management?

Need something simple. Master item list, received, shipped stuff, and current inventory.
Might want to use a database program instead. I had a Microsoft access database custom designed for me by some guy in the Phillipines

Offline Definitions

  • Dansdeals Platinum Elite + Lifetime Silver Elite
  • *****
  • Join Date: Jan 2018
  • Posts: 655
  • Total likes: 77
  • DansDeals.com Hat Tips 2
    • View Profile
Re: Excel Help and Problems
« Reply #1248 on: May 10, 2019, 02:59:04 AM »
Might want to use a database program instead. I had a Microsoft access database custom designed for me by some guy in the Phillipines
How much did it cost you?
Jack of all trades, master of none.

Offline Luvisrael

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Apr 2016
  • Posts: 1055
  • Total likes: 42
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: לבי במזרח
Re: Excel Help and Problems
« Reply #1249 on: May 14, 2019, 07:13:46 PM »
Any way to send a mass email to multiple email addresses on Spreadsheet to outlook?

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9266
  • Total likes: 285
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1250 on: May 14, 2019, 08:03:59 PM »
Any way to send a mass email to multiple email addresses on Spreadsheet to outlook?
I'm pretty sure you can do a mailmerge to email.

https://support.office.com/en-us/article/use-mail-merge-to-send-bulk-email-messages-0f123521-20ce-4aa8-8b62-ac211dedefa4
Workflowy. You won't know what you're missing until you try it.

Offline Luvisrael

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Apr 2016
  • Posts: 1055
  • Total likes: 42
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: לבי במזרח
Re: Excel Help and Problems
« Reply #1251 on: May 14, 2019, 08:21:40 PM »
I'm pretty sure you can do a mailmerge to email.

https://support.office.com/en-us/article/use-mail-merge-to-send-bulk-email-messages-0f123521-20ce-4aa8-8b62-ac211dedefa4
ok thanx. is there a simpler way to do it (e.g.) cut and paste email addresses

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9266
  • Total likes: 285
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Excel Help and Problems
« Reply #1252 on: May 14, 2019, 08:24:29 PM »
ok thanx. is there a simpler way to do it (e.g.) cut and paste email addresses
If you want to send the same message to all of them in BCC, you should be able to select the whole column of addresses, copy, and then paste them into the BCC box of an email
Workflowy. You won't know what you're missing until you try it.

Offline Luvisrael

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Apr 2016
  • Posts: 1055
  • Total likes: 42
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: לבי במזרח
Re: Excel Help and Problems
« Reply #1253 on: May 14, 2019, 08:32:31 PM »
If you want to send the same message to all of them in BCC, you should be able to select the whole column of addresses, copy, and then paste them into the BCC box of an email
thats what i am looking to do thanx!

Offline unavailable

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Dec 2013
  • Posts: 475
  • Total likes: 7
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Help and Problems
« Reply #1254 on: May 17, 2019, 12:04:41 PM »
hi
i have a price list for a bunch of items

under them a subtotal

now i want to add 20% fee, but only to certain items
then another fee 5% to other items 

something like this;


food    20
drink    10
ice cream 10

subtotal  40

20% fee  ??     what if only want the fee to be added to drinks
10 % fee  ??                   to others

Total     this i can do

thanks for your help

Offline yitzf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2568
  • Total likes: 11
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Help and Problems
« Reply #1255 on: May 20, 2019, 08:56:42 PM »
hi
i have a price list for a bunch of items

under them a subtotal

now i want to add 20% fee, but only to certain items
then another fee 5% to other items 

something like this;


food    20
drink    10
ice cream 10

subtotal  40

20% fee  ??     what if only want the fee to be added to drinks
10 % fee  ??                   to others

Total     this i can do

thanks for your help
Make some type of indicator in the next column. So for example next to the drinks you would enter A and next to the others you would enter B. Then after the subtotal use a sumif to add the A items and multiply that by 20%, then sumif the B items and multiply by 5%.

Offline unavailable

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Dec 2013
  • Posts: 475
  • Total likes: 7
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Help and Problems
« Reply #1256 on: May 23, 2019, 05:38:00 PM »
Make some type of indicator in the next column. So for example next to the drinks you would enter A and next to the others you would enter B. Then after the subtotal use a sumif to add the A items and multiply that by 20%, then sumif the B items and multiply by 5%.

thanks

this is the formula i wrote
=SUMIF(I5:I34,4,D5:D34*x.2)

it works without the *x.2, but then it gives me the total of the 'foods'.

with the *x.2 I get an error message

how can get it to calculate only 20%



Offline lubaby

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jun 2010
  • Posts: 4388
  • Total likes: 194
  • DansDeals.com Hat Tips 12
  • Gender: Male
    • View Profile
  • Location: New York
  • Programs: Hertz PC, National EE
Re: Excel Help and Problems
« Reply #1257 on: May 23, 2019, 05:51:06 PM »
thanks

this is the formula i wrote
=SUMIF(I5:I34,4,D5:D34*x.2)

it works without the *x.2, but then it gives me the total of the 'foods'.

with the *x.2 I get an error message

how can get it to calculate only 20%
*.2
Once the game is over, the king and the pawn go back in the same box.

Offline unavailable

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Dec 2013
  • Posts: 475
  • Total likes: 7
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: bp
Re: Excel Help and Problems
« Reply #1258 on: May 23, 2019, 05:53:53 PM »

=SUMIF(I5:I34,4,D5:D34*.2)

doesnt allow me.

Offline yitzf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2011
  • Posts: 2568
  • Total likes: 11
  • DansDeals.com Hat Tips 4
    • View Profile
Re: Excel Help and Problems
« Reply #1259 on: May 23, 2019, 06:08:07 PM »
=SUMIF(I5:I34,4,D5:D34*.2)

doesnt allow me.
The *.2 needs to be outside their parentheses