by Tito | Jun 19, 2021 | Excel
There are plenty of websites that display stock tickers, technical information, and other important stock Information. Even though several websites do a fantastic job, sometimes you want to analyze them in your own little spreadsheet. Getting Stock Market Data into...
by Tito | Dec 22, 2020 | Excel2SQL
I hope you followed the previous tutorial where we checked Created some brand new database tables using Excel as a template. Let’s populate these tables with meaningful data. Okay, it might not be the most meaningful dataset since I just made this data up using...
by Tito | Dec 19, 2020 | Excel2SQL
Use the Excel Templates below to follow along with the Excel2SQL Tutorials. Feel free to download and modify these smooth templates to Create your own SQL...
by Tito | Dec 16, 2020 | General Productivity, Popular
How Do You Learn Computer Programming Quickly? Are you interested in becoming a programmer or software developer? What is the fastest route to becoming a competent coder? Here’s the short and sweet Excel Shortcut answer: Get a full-time job as a programmer if...
by Tito | Dec 15, 2020 | Excel, Excel2SQL
We will create some brand new tables in SQL Management Studio using Excel as a template in this tutorial. The sample data is a fictitious list of Experts and their areas of specialty. Below is a quick Description of our tables and a short sampling of each. This...