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...
by Tito | Nov 20, 2020 | Excel2SQL
Change is part of life and our data is extremely susceptible to these changes. Can Microsoft Excel Keep up with all of the changes to your data? Maybe it’s time to use SQL to update your data. Let’s discuss updating data in an effective way. Up until now, many...
by Tito | Oct 29, 2020 | General Productivity
The ability to format and manipulate Excel character strings is extremely important for data analysis. SQL String functions are useful for querying and manipulating data. Luckily for you, this article will solidify your string function knowledge in both applications....
by Tito | Oct 16, 2020 | Excel2SQL
Most of my readers are heavy Excel users. Today we will transition our strong Excel foundation into learning another complementary tool, SQL Databases. Here are a few components that are fundamental to Databases and SQL. Tables – Other concepts could come first,...
