Excel Application Development
Excel Dashboard
Excel Formulas
Excel Options
Charts
Cloud
Maps
Hardware Reviews MS-Office Versions
Problems with Excel
Security
Shortcuts
Tips
- Excel recalculation performance optimization
- Error handling in Excel
- Version Control Software
- Excel application testing with randomized data
- PDF printing
- Interactive Documentation
Excel Dashboard
Excel Formulas
Excel Options
- How to enable Macros in Excel
- How to trust (enable programmatic) access to the VBA project object model
Charts
Cloud
- Amazon EC2: Excel 2007 running on Amazon's Elastic Compute Cloud (EC2) servers
- IEX: How to pull stock data into Excel
- TrueFX: Free streaming real-time & historical tick-by-tick Forex data
- ZuluTrade: Signal Provider performance analytics using Excel
- ZuluTrade: Performance metrics explained
Maps
- Google Static Map & Street View image API: Embed a static map or street panorama in Excel
- Choropleth Maps: Map visualization suitable for presenting data with a geographical dimension
- Map Shapes Explained
- ScreenTips and OnAction Macro for Choropleth Maps
- European Choropleth Map Demo
- Visible Text behind Shapes
- How to Group Shapes
- Overview of password protection in Excel
- Excel protection myths busted: 10 Tips For Working With Excel Protection
- Password to open file: Create strong passwords, recover your lost ones and security tips
- How to protect opening an Excel file: Command line encryption tool for Office files
- How to encrypt Excel workbooks without password: Exploit a known bug
- Worksheet & workbook protection up-to Excel 2010: Free VBA code to unprotect sheets
- Worksheet & workbook protection in Excel 2013: New sheet encryption algorithm
- How to upgrade sheet protection: Use Office 365 strong protection in Excel 2007-2010
- How to prevent protected Excel worksheets from being hacked
- VBA project protection: VBE password
- Security tip: How to protect Very Hidden sheets
- VBA security tip: Sheet VBA code can be read, even if VBE is locked
- Printable password log template: The best defense against hackers is paper
- Printable public WiFi password template
Hardware Reviews MS-Office Versions
- Excel 2013 tips
- Compatibility Between the 32-bit and 64-bit Versions of Office 2010-2016
- Which Office Excel version should be used? (Product Lifecycle)
- Is Excel 2013 backwards compatible with Excel 2010
- How to update Microsoft Office 2013 Service Pack 1
- Automation Error in Excel & Security Bulletin MS12-060
- MS14-082 Update breaks ActiveX controls in Excel
Problems with Excel
- How to diagnose and stop crashes in Excel
- Why an Excel file increased substantially in size all of the sudden
- Excel and VBA known issues (bugs)
- Excel workbook corruption detection, repair and recovery
- Case Study: Excel crashes when worksheet is activated
- How to identify Strict ISO 29500 XLSX Spreadsheets in Excel
Security
- Excel Apocalypse: Business continuity and resiliency plans for MS-Office / Excel
- Encrypted Drives: How to transport business data securely
Shortcuts
Tips
- How Excel determines Calculation Mode
- How to use Outlining (Groups) in a protected worksheet
- How to open multiple Excel instances
- How to copy an Excel Add-in from one computer to another
- How to adjust the width of scroll bars and size of worksheet tabs in Excel
- How to save an Excel workbook in binary XLSB file format
- Excel in a web page: How to embed Excel in a web page or use Excel in a browser
Case Studies
|
Sign up for our Newsletter! Join thousands of Excel professionals who receive exclusive updates for free add-ins, time-saving tips, Lab-X news & access to our members area. Please click here!
|
