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,...
by Tito | Oct 10, 2020 | Excel2SQL, Popular
Let’s discuss why Excel Users should learn SQL to pull their own data. First, we will answer the basic question, What is SQL? SQL stands for Structured Query language. It is used to manage structured information in database tables. Structured data is formatted...
by Tito | Oct 3, 2020 | Excel2SQL, General Productivity, Popular
Export SQL Data to Excel from Microsoft SQL Server Let’s go over three ways to export an SQL Query to an Excel File Using MSSQL Despite the pushback from Database aficionados, sometimes it makes sense to export data from SQL to an Excel file. It really depends...
by Tito | Apr 16, 2020 | Excel
Vlookup has been a leading feature of Microsoft Excel for a long time. For many users, its the first function they think of when opening a spreadsheet. Excel has several types of Lookups but VLOOKUP is the most commonly used of the bunch. Let this page be your...
by Tito | Mar 21, 2020 | General Productivity
Stop Wasting Time Rewriting Formulas, Save everything in a Scriptionary When’s the last time you spent over fifteen minutes in Excel fumbling through the formula bar to recreate a formula you already know? The cycle of anger and blame begins as you think “Why didn’t...
