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...
by Tito | Nov 23, 2019 | Excel
I want to share a really helpful concept with my Excel Shortcut readers. It’s called Spreadsheet Shareability and it will definitely help you get recognition as an Excel Pro within your Organization. Have you noticed that certain Spreadsheets are shared and/or...
