heavy excel use

Status
Not open for further replies.

Ovidiu_3

Prominent
May 23, 2017
1
0
510
Due to time passing some past topics are irrelevant now.
So please , I need I powerfull laptop for processing in excel.
I' using DELL- E7440 i5 4310U, Cpu 2GHz 2.60 Ghz, RAM 8 Gb, 150 GB SSD. but is running slow on heavy conditions in excel (*like using many if functions )
So please advise with some powerfull laptops
 
Solution
Generally speaking, if you are working with very large Excel files that are dependent on many functions and / or macros, then you will need a laptop with a quad core CPU. A quad core i5 CPU would work, but a quad core i7 CPU is more ideal because it has Hyper Threading which Excel will use to make calculations. Note that very large Excel files will also need a lot of RAM. I have worked with 40GB Excel files in the past for a short time, but the PC only had 16GB of RAM. It was doable, but having 32GB of RAM would have been much better because it means less RAM caching between the hard drive and physical RAM.

The following Lenovo IdeaPad 700 sells for $620. It has a quad core i5-6300HQ and 8GB of RAM. It supports up to 16GB of RAM and it...
Generally speaking, if you are working with very large Excel files that are dependent on many functions and / or macros, then you will need a laptop with a quad core CPU. A quad core i5 CPU would work, but a quad core i7 CPU is more ideal because it has Hyper Threading which Excel will use to make calculations. Note that very large Excel files will also need a lot of RAM. I have worked with 40GB Excel files in the past for a short time, but the PC only had 16GB of RAM. It was doable, but having 32GB of RAM would have been much better because it means less RAM caching between the hard drive and physical RAM.

The following Lenovo IdeaPad 700 sells for $620. It has a quad core i5-6300HQ and 8GB of RAM. It supports up to 16GB of RAM and it also has a m.2 slot which allows you to install a m.2 "gum stick" SSD for additional storage in the future.

https://www.amazon.com/Lenovo-700-15-6-Inch-1920x1080-i5-6300HQ/dp/B01MAY1EGS/ref=sr_1_3?s=electronics&ie=UTF8&qid=1495564859&sr=1-3&keywords=Lenovo+Ideapad+700-15ISK


Here's the i7-6700HQ version selling for about $1,080, but at least it comes with 16GB of RAM and 128GB SSD in addition to the hard drive. It is a rather steep price increase though over the i5-6300HQ version though. You can purchase an 8GB DDR4 RAM stick for around $60 and a 128GB m.2 SSD sells for about $90. So adding them to the i5 version of the laptop will bring up the price to roughly $770. That means going from the i5-6300HQ to the i7-6700HQ will basically cost you an extra $310.

https://www.amazon.com/Lenovo-Ideapad-i7-6700HQ-GeForce-80RU00N3US/dp/B01LNOECEQ/ref=sr_1_4?s=electronics&ie=UTF8&qid=1495565656&sr=1-4&keywords=Lenovo+Ideapad+700+i7
 
Solution
Status
Not open for further replies.