Excel KPI Dashboard: How to Monitor Your Sales to Reach Your Targets
Excel Formulas: Doing a Multiple Criteria Lookup to Merge Two Tables Using Index Match
WordPress and Excel: The connection
Assumptions and Potential Limitations: In this post all of the setup was done using a Windows 7 OS and Microsoft Excel 2010.
Microsoft Excel is an amazing tool for manipulating and organizing data. Excel makes it easy to analyze data which helps in making intelligent and factual business decisions. Our personal, blog, business and e-commerce websites all use databases that contain goldmines of data and information. I’ve investigated and found a fairly quick and painless way to access and extract (in real time) our database tables and fields into Excel. Using the method outlined below you can easily connect to your CMS (i.e. Joomla), blogging (i.e. WordPress), E-commerce (i.e. Magento) or literally any other database that you have stored on your webserver.