Introduction to Excel

Excel is the most popular data-consuming application in today's business world. It is used to analyze data and present it in a graphical manner, making it easy to understand at a glance. In fact, most businesses and personal users would not be able to function properly in today's data-centric world without Excel; so, people with advanced Excel skills are highly sought after.

In Chapter 9, MS Access – Part 1, and Chapter 10, MS Access – Part 2, you learned how to migrate an MS Access database to MySQL and retrieve and use the data using VBA code and ODBC connections.

For Chapters 11 and 12, the assumption is that you are now familiar with MySQL and Workbench, having worked through the previous chapters, so references to them will be high-level only. We also assume that you have basic Excel skills. We will be connecting to the MySQL server in three ways: through Data Source Name (DSN)-less connections using VBA, an ODBC connection,...