Most people view Microsoft's Excel as a simple "spreadsheet program" that's rapidly being eclipsed by free web-based apps that run on any cheap laptop. Modern-day Excel is an advanced analytics tool that can push today's fastest hardware to their limits, and it's sexy enough that it rates its own eSports coverage. No joke--thousands tuned in live to watch the Financial Modelling World Cup that was broadcast by ESPN. Intrigued by the interest of "gamers" and curious to see just how hard advanced Excel users are pushing the application, PCWorld decided to interview spreadsheet superstar Jason Moore. Moore is the head of analytics and data at an investment firm, and semi-finalist who won cold, hard cash in December's Financial Modeling World Cup.
Excel spreadsheets do so much, from making lists to crunching numbers to acting as sophisticated flat-file databases. We're creating this guide to make sure you master all the essentials and more. We'll add to this guide over time, so bookmark it and come back to keep learning. Think of an Excel spreadsheet as an electronic flat-file database modeled after a bookkeeper's ledger. Excel's "spreadsheet" is like the ledger's page, and Excel's "workbook" grouping of spreadsheets is akin to an entire ledger.
The number of records (rows), fields (columns), and formulas can slow down performance considerably. Every time you add new records, then press the Enter key--or use features such as Sort, Format cells, or Insert/Delete Columns or Rows--Excel recalculates all those formulas. Install the Large Address Aware update to expand your 32-bit Excel's file size limit from 2GB to 4GB. For 32-bit Excel running in 32-bit Windows, the 2GB address space limit is increased to 3GB.
Graphics, charts, formulas, and features such as the spell checker, sorting, and printing also consume memory. For the many users still working with the 32-bit version of Excel, if your spreadsheets are less than 2GB and you're still receiving memory error messages, try closing all other programs that are running (including the Internet and your email program) to gain additional working memory. If the performance and memory tips above both fail to increase your system's performance or reduce the number of memory errors, then maybe it's time to switch to the 64-bit version of Excel. This version does not limit your file sizes, but instead enforces limits only by available memory and system resources. This means if your system has 8GB of memory, Excel can access all of that minus whatever the system uses. Install the Large Address Aware update to expand your 32-bit Excel's file size limit from 2GB to 4GB. If you're considering a change from Excel 32-bit to Excel 64-bit, here's what to keep in mind:
Windows 10 security: 'So good, it can block zero-days without being patched' Systems running the Windows 10 Anniversary Update were shielded from two exploits even before Microsoft had issued patches for them, its researchers have found. A newly discovered malware gang is using a clever trick to create malicious Excel files that have low detection rates and a higher chance of evading security systems. Discovered by security researchers from NVISO Labs, this malware gang -- which they named Epic Manchego -- has been active since June, targeting companies all over the world with phishing emails that carry a malicious Excel document. But NVISO said these weren't your standard Excel spreadsheets. The malicious Excel files were bypassing security scanners and had low detection rates.