ÿþ<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <link rel="icon" type="image/gif" href="favicon.gif"/> <title>Learn More about QueryCell. Use the power of SQL in Excel</title> <meta name="description" content="Add QueryCell to Microsoft Excel and you can use SQL Selects, Joins and Group By s within Excel!" /> <meta name="keywords" content="Microsoft Excel, add-in, SQL, Group By, Order By, Select, Join, Inner Join, Outer Join" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta name="Robots" content="index,follow" /> <meta name="Robots" content="noodp" /> <style media="all" type="text/css">@import "css/all.css";</style> <SCRIPT LANGUAGE="JavaScript" SRC="js/PopupWindow.js"></SCRIPT> <script type="text/javascript" src="./highslide/highslide-with-gallery.packed.js"></script> <link rel="stylesheet" type="text/css" href="./highslide/highslide.css" /> <script type="text/javascript"> hs.graphicsDir = './highslide/graphics/'; hs.align = 'center'; hs.transitions = ['expand', 'crossfade']; hs.outlineType = 'rounded-white'; hs.fadeInOut = true; //hs.dimmingOpacity = 0.75; // Add the controlbar hs.addSlideshow({ //slideshowGroup: 'group1', interval: 5000, repeat: false, useControls: true, fixedControls: 'fit', overlayOptions: { opacity: .95, position: 'bottom center', hideOnMouseOut: true } }); </script> </head> <body> <div id="root-box"> <!-- root-box --> <div id="main-box" > <!-- main-box --> <div id="root"> <!-- root --> <!--<div style="margin-left:30px;"> <table> <tr> <td style="width:280px;"> <a href="http://www.amazon.com/gp/product/0470099518?ie=UTF8&tag=custome09-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=0470099518"><img border="0" src="images/Data-Analysis-Using-SQL-And-Excel.jpg"></a><img src="http://www.assoc-amazon.com/e/ir?t=custome09-20&l=as2&o=1&a=0470099518" width="1" height="1" border="0" alt="" style="border:none !important; margin:0px !important;" /> </td> <td style="width:280px;"> <a href="http://www.amazon.com/gp/product/0735640580?ie=UTF8&tag=custome09-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=0735640580"><img border="0" src="images/PowerPivot-For-Excel-2010.jpg"></a><img src="http://www.assoc-amazon.com/e/ir?t=custome09-20&l=as2&o=1&a=0735640580" width="1" height="1" border="0" alt="" style="border:none !important; margin:0px !important;" /> </td> <td style="width:280px;"> <a href="http://www.amazon.com/gp/product/B0026OR2TK?ie=UTF8&tag=custome09-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=B0026OR2TK"><img border="0" src="images/Excel-And-Access.jpg"></a><img src="http://www.assoc-amazon.com/e/ir?t=custome09-20&l=as2&o=1&a=B0026OR2TK" width="1" height="1" border="0" alt="" style="border:none !important; margin:0px !important;" /> </td> <td style="width:280px;"> <a href="http://www.amazon.com/gp/product/143545751X?ie=UTF8&tag=custome09-20&linkCode=as2&camp=1789&creative=9325&creativeASIN=143545751X"><img border="0" src="images/The-Language-Of-Sql.jpg"></a><img src="http://www.assoc-amazon.com/e/ir?t=custome09-20&l=as2&o=1&a=143545751X" width="1" height="1" border="0" alt="" style="border:none !important; margin:0px !important;" /> </td> </tr> <tr> <td colspan="4" style="font-size:12px;"> Books that you may find useful (Click for reviews and pricing on Amazon) </td> </tr> </table> </div> <hr style="width:780px;"/>--> <div id="header"> <!-- header --> <a href="index.html" title="QueryCell">SQL Query Add-In for Microsoft Excel</a> <h1>Add-In the power of SQL to Microsoft Excel<sup style="font-size:55%;">&#174;</sup></h1> </div> <!-- end header --> <div class="top-menu"> <!-- top-menu --> <ul> <li><a class="menu1" href="index.html">Home</a></li> <li><a class="menu2On" href="LearnMore.html">Learn More</a></li> <li><a class="menu3" href="BuyNow.html">Buy Now</a></li> <li><a class="menu4" href="TryNow.html">Try Now</a></li> <li><a class="menu6" href="Support.html">Support</a></li> <li><a class="menu7" href="About.html">About</a></li> </ul> </div> <!-- end top-menu --> <div class="learn-main" style="margin-left:20px;"> <!-- learn-main --> <!-- <div class="testimonial-box" style="color:#662222;margin-left:13px;"> QueryCell is temporarily unavailable for purchase awaiting Version 2.0 release later this year.<br/><br/> Please contact <a style="color: #D27302;" href="mailto:support@querycell.com">support@querycell.com</a> for all inquiries. </div>--> <div class="testimonial-box" style="margin-left:13px;"> &nbsp;&nbsp;"This is a tool any Power Excel User should check out...", <br/>&nbsp;&nbsp;"I can see this tool saving hours of time" &nbsp;-&nbsp;<a style="color: #D27302;" target="_blank" href="http://sqlrs.blogspot.com/2010/03/querycell-review-and-license-giveaway.html">BI/BPM - The SeeQueL</a>&nbsp;&nbsp;&nbsp; </div> <div class="center-box-orange-block-nf"> <p> <a name="morescreenshots"></a> <h2 class="orange-text">Additional Screenshots / Tutorials</h2> </p> <p> Additional Screenshots highlighting specific aspects of QueryCell are available.</p> <ul> <li><a style="color: #D27302;" href="SQLGenerator.html">Additional Screenshots/Tutorial for the SQL Insert Generator</a></li> <li><a style="color: #D27302;" href="TestData.html">Additional Screenshots/Tutorial for the Test Data Generator</a> </li> <li><a style="color: #D27302;" href="Visual-SQL-Query-Builder.html">Additional Screenshots/Tutorial for Visual Query Builder</a> </li> </ul> <p> <a name="articles"></a> <h2 class="orange-text">New To SQL ?</h2> </p> <p> Although QueryCell includes a Visual Query Builder so you can create queries without writing SQL code it's still useful to understand the underlying SQL. Here are some resources that may help SQL beginners.</p> <ul> <li><a style="color: #D27302;" href="SQLIntro.html">A beginners introduction to SQL</a> </li> <li><a style="color: #D27302;" href="SQL_Intro_Cheat_Sheet.html">A SQL Introduction Example Cheat Sheet</a> </li> </ul> <p> <a name="articles"></a> <h2 class="orange-text">Articles</h2> </p> <p> Additional information to help you use QueryCell is available.</p> <ul> <li><a style="color: #D27302;" href="DataSources.html">Connecting to External Data Sources (eg. SQL Server, Access, Oracle, Mysql, Firebird etc) </a> </li> <li><a style="color: #D27302;" href="GettingStarted.html">Getting Started with QueryCell</a></li> <li><a style="color: #D27302;" href="FAQ.html">QueryCell Usage FAQ</a> </li> <li><a style="color: #D27302;" href="likeOperator.html">Using the LIKE operator in your SQL</a></li> <li><a style="color: #D27302;" href="Excel-Into-Access.html">Excel Data into Access</a></li> <li><a style="color: #D27302;" href="Uninstall.html">How to Uninstall QueryCell</a> </li> </ul> <p> <a name="helpFile"></a> <h2 class="orange-text">QueryCell Help File</h2> <p>The QueryCell Help file is available online as web pages</p> <ul> <li><a style="color: #D27302;" href="./help/welcome.htm">Open QueryCell Help Online</a></li> <li><a style="color: #D27302;" href="./visual-query-help/index.html">Visual Query Builder Help Online</a></li> </ul> </p> <p> <h2 class="orange-text">QueryCell Reviews</h2> <ul> <li><a style="color: #D27302;" target="_blank" href="http://sqlrs.blogspot.com/2010/03/querycell-review-and-license-giveaway.html">BI/BPM - The SeeQueL</a></li> <li><a style="color: #D27302;" target="_blank" href="http://www.dailydoseofexcel.com/archives/2009/10/05/querycell/">Daily Dose Of Excel</a></li> <li><a style="color: #D27302;" target="_blank" href="http://excelicious.wordpress.com/2010/03/16/querycell-sql-in-excel/">Number Cruncher</a></li> </ul> </p> <p> <a name="Blog"></a> <h2 class="orange-text">Selectable  The QueryCell Blog</h2> <ul> <li><a style="color: #D27302;" target="_blank" href="http://www.querycell.com/blog/">Blog</a></li> </ul> </p> </div> <a name="moreimage"></a> <font class="orange-text">&nbsp;&nbsp;Overview Screenshots (Click to enlarge)</font> <br/><br/> <table width="100%" align="center"> <tr align="center"> <td align="center"> <div class="highslide-gallery"> <a href="./images/QC_ScreenShots/LM_SS1_900_600.png" class="highslide" onclick="return hs.expand(this)"> <img src="./images/QC_ScreenShots/LM_SS1_340_270.png" style="width:340px;height:270px;" alt="Highslide JS" title="Click to enlarge" /></a> <div class="highslide-caption"> QueryCell pane open in in Excel 2007. </div> <a href="./images/QC_ScreenShots/LM_SS2_900_600.png" class="highslide" onclick="return hs.expand(this)"> <img src="./images/QC_ScreenShots/LM_SS2_340_270.png" style="width:340px;height:270px;" alt="Highslide JS" title="Click to enlarge" /></a> <div class="highslide-caption"> The Regions Grid on the left and the SQL Template Library on the right can be minimized with a single click of the splitter bar. </div> <a href="./images/QC_ScreenShots/LM_SS3_900_600.png" class="highslide" onclick="return hs.expand(this)"> <img src="./images/QC_ScreenShots/LM_SS3_340_270.png" style="width:340px;height:270px;" alt="Highslide JS" title="Click to enlarge" /></a> <div class="highslide-caption"> Creating SQL Insert Statements for data is as simple as selecting the region of data you are interested and then selecting 'QC - SQL Inserts' from the right Click menu. </div> <a href="./images/QC_ScreenShots/LM_SS4_900_600.png" class="highslide" onclick="return hs.expand(this)"> <img src="./images/QC_ScreenShots/LM_SS4_340_270.png" style="width:340px;height:270px;" alt="Highslide JS" title="Click to enlarge" /></a> <div class="highslide-caption"> Create 1000s of rows of test / dummy data. Prototype more quickly. Test data columns of the 'Excel Source' type will source their data from excel data regions allowing the population of foreign keys! </div> <a href="./images/QC_ScreenShots/LM_SS6_900_600.png" class="highslide" onclick="return hs.expand(this)"> <img src="./images/QC_ScreenShots/LM_SS6_340_270.png" style="width:340px;height:270px;" alt="Highslide JS" title="Click to enlarge" /></a> <div class="highslide-caption"> QueryCell pane open in in Excel 2003. </div> </div> <!-- end gallery --> </td></tr> </table> <div class="center-box-orange-block-nf"> <p> <a name="morescreenshots"></a> <h2 class="orange-text">Mini Tutorials</h2> </p> <p> Additional Tutorials with ScreenShots</p> <ul> <li><a style="color: #D27302;" href="call-sql-server-stored-procedure-from-excel.html">Calling SQL Server Stored Procedures From Excel</a></li> <li><a style="color: #D27302;" href="Database-Inserts-Updates-Deletes-From-Excel.html">Running Database Inserts, Updates and Deletes from SQL</a> </li> <li><a style="color: #D27302;" href="Getting-Data-From-Access-Into-Excel.html">Getting Data From Access Into Excel</a> </li> <li><a style="color: #D27302;" href="How-To-Compare-SQL-Data-With-Excel-Data.html">How To Compare SQL Data With Excel data</a> </li> <li><a style="color: #D27302;" href="Microsoft-Access-into-Excel.html">Getting Microsoft Access Data Into Excel</a> </li> <li><a style="color: #D27302;" href="Named-Ranges-In-QueryCell.html">Excel Named Ranges In QueryCell</a> </li> <li><a style="color: #D27302;" href="Export-SQL-Server-Excel.html">Exporting SQL Server Data to Excel</a> </li> <li><a style="color: #D27302;" href="Excel-To-SQL-Server.html">Getting Excel Data Into SQL Server</a> </li> </ul> </div> </div> <!-- end learn-main --> </div> <!-- end root --> </div> <!-- end main-box --> <br/><br/> <div class="bottom"> <!-- bottom --> <a class="logo2" href="index.html">logo</a> <ul> <li class="none"><a href="index.html">Home</a></li> <li><a href="LearnMore.html">Learn More</a></li> <li><a href="BuyNow.html">Buy Now!</a></li> <li><a href="TryNow.html">Try Now</a></li> <li><a href="Support.html">Support</a></li> <li><a href="About.html">About</a></li> </ul> </div> <div class="bottom"> <ul> <li>Copyright Oak Focus Software / QueryCell 2010 (All Rights Reserved).</li> </ul> <ul> <li>Microsof Excel&#174; is a trademark of Microsoft Corporation.</li> </ul> <ul> <li>The QueryCell Product and its website are not associated with Microsoft Corporation</li> </ul> </div> </div> <!-- end root-box --> <!--</div> end root --> <!--</div> <!-- end main-box --> <!--</div> <!-- end root-box --> <script type="text/javascript"> var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www."); document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E")); </script> <script type="text/javascript"> try { var pageTracker = _gat._getTracker("UA-8826822-1"); pageTracker._trackPageview(); } catch(err) {} </script> </body> </html>