Cell References In storytelling, a static character maintains the same persona from the beginning of the novel until the end. A good example would be the ultra-intelligent, pipe-smoking crime detective Sherlock Holmes. Conversely, a dynamic character is more malleable...
4 Most Useful Excel Functions Microsoft excel is a powerful tool used for data manipulation and organization. The mastery of its functions and formulas can help you exceed expectations and make you a Rockstar among your cubicle mates. However, new excel users may find...
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....
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,...
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 for...
Learn three ways to output your SQL queries to and Excel file
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...
