38 month ago
kayodeok : Connect Excel to Mysql Database - The following will connect Excel to a Mysql database, then import a table into Excel
# copy
39 month ago
kayodeok : Microsoft Excel Team Blog - A discussion of what's new in Excel 12
# copy
39 month ago
kayodeok : Microsoft Office versus Open Office shootout - "As nice as Open Office Excel is for a free application, it doesn't even come close to the performance and usability of Microsoft Office Excel"
# copy
40 month ago
kayodeok : Excel Xml Writer: Library to Generate Excel XML Workbooks in .NET - This library allows you to generate Excel Workbooks using XML, it is built 100% in C# and does not requires Excel installed at all to generate the files. It exposes a simple object model to generate the XML Workbooks
# copy
40 month ago
kayodeok : Large spreadsheet: 262,144 Rows and 18,278 Columns - Want more rows, more columns? Think Excel is too small; Only 65,536 rows and 256 columns?
# copy
40 month ago
kayodeok : Latent Power of Excel - Similar to how AJAX is exposing the latent power of todays browsers, there's a lot of latent power in Excel to produce a much richer analytical experience. It takes a change in mindset for us all to benefit
Philippe Janvier : Latent Power of Excel - "How to use Excel to visualize Tiger Woods' (and his competitors') distance and accuracy over time". [via] #
# copy40 month ago
kayodeok : Regular Expressions in Excel and VBA - Now that VBScript supports regular expression, it is possible to dramatically enhance the search and replace capability of both VBA and Excel
# copy40 month ago
kayodeok : mnot’s Web log: Adding Semantics to Excel with Microformats and GRDDL - Excel can be used as an incredibly powerful, flexible editor/browser for tabular data, which can be made available and reusable through microformats techniques
# copy40 month ago
kayodeok : Daily Dose of Excel: Pattern Matching - Using Regular Expressions in Excel Spreadsheets
# copy
40 month ago
deusx : Backup Del.icio.us with Excel - "If you have Excel 2003 and use the social bookmarking tool Del.icio.us, you can backup your bookmarks in Excel."
kayodeok : Backup Del.icio.us with Excel - If you have Excel 2003 and use the social bookmarking tool Del.icio.us, you can backup your bookmarks in Excel
# copy
41 month ago
kayodeok : Excel Watch: Facts, rumors, and speculation about the next version of Microsoft Excel - The purpose of this blog is to provide a central source for information about the next version of Excel, currently known only as Excel 12
# copy
41 month ago
kayodeok : Super-Easy Guide to the Microsoft Office Excel 2003 Object Model - Learn how easy it is to use the Excel object model to customize the way you work with Excel. Lessons include creating subroutines, the basics of objects, methods, and properties, and using dialog boxes
# copy
41 month ago
kayodeok : Free Excel Spreadsheets - Free Financial Management Spreadsheets
# copy
41 month ago
kayodeok : Microsoft Excel Templates: Personal Financial Tools - "Microsoft offers a bunch of Excel templates that could help keep your finances in order or calculate "what ifs" - like a checkbook register, a 401(k) planner, a family monthly budget, a college costs estimator and a buy versus lease car calculator. Usefu
# copy43 month ago
kayodeok : AJAX Spreadsheet - This spreadsheet "mimics the basic functionality of local spreadsheet, and even has some calculating fields (ie. if you change one cell, multiple dependent cells values will update)"
# copy
43 month ago
kayodeok : Ed Bott: Tip of the day: My three favorite Excel shortcuts - For Quick Formatting, type "Ctrl + 1"; for Fractions such as 3/8, type "0 3/8", for Fractions such as 12 3/8, typing 12 3/8 works. To Zoom Out, hold the Ctrl Key and spin the mouse wheel down, to Zoom in, hold the Ctrl Key and spin the mouse wheel up
# copy
43 month ago
kayodeok : Excel Tips and Techniques - Debra Dalgleish's Excel Tips and Techniques
# copy
43 month ago
kayodeok : Importing stuff into your Outlook Calendar (or Tasks) from Excel - How to import todo lists from Excel into Outlook Tasks
# copy
45 month ago
Jeremy Zawodny : Yahoo Local Search In Excel - Yahoo Local Search In Excel: good stuff if you're an excel geek who doesn't like using the phone book
kayodeok : Yahoo Local Search In Excel - Using Excel 2003 to retrieve Yahoo Local Search results from the Yahoo Local API
# copy45 month ago
kayodeok : Frequently Asked Questions About Microsoft Excel - Your most nagging questions about the world's most popular spreadsheet: Answered, at long last
# copy
