Have you ever spent endless time adjusting and re-adjusting the column width in Excel to show all the content of columns? Or perhaps you had to make all the columns and rows the same even width and height for a uniform appearance of some important report that you have been working on?
Well, Excel has built-in features that make this a snap and you should always use Excel in an ergonomic way to save you precious time. Here is a quick 4-minute video to show you how to do this in Excel quickly and hassle free:
Subscribe to my mailing list today and you will receive actionable and practical Excel how-to information and receive email notifications whenever I publish a new video on my youtube channel.
This is a long video but I really wanted to try and make my steps and explanations as clear as possible to follow. I hope that you will this video informative and helpful in your endeavor to develop an Excel tool to export, insert and update SQL database data using Excel. Please leave comments below and let me know what you thought of the video and if you have any questions.
This will be the first part of my video training series where I will teach you how to Export and Update SQL Server table data using Excel in a step by step approach. In this first video I will show you how to add a button in Excel with VBA code behind the button that will export SQL data from an SQL table out of the AdventureWorks2014 sample SQL Server database.Continue reading
In recent years most businesses have started to take business analysis to the next level by adopting various data visualization and analytics solutions, methodologies and technologies. Solutions like Tableau, PowerBI, SSRS, InetSoft and QlikView, to mention only a few, are widely used as data visualization tools.
However, many businesses struggle with these solutions because it either becomes costly or because they simply do not have the people with the necessary skills in-house to implement these solutions effectively.
From my own experience most of these products have impressive capabilities, however the learning curve is steep. You see companies send their employees out on a 2-5-day course to learn these tools hands-on. However, so much information is conveyed, and people need to digest it. They do some quick exercises based on ideal demo data and they get a certificate for successfully completing the course and once they return to their post at work, guess what? …Continue reading
Excel spreadsheets facilitate the overall bigger picture of the data on hand, all in one familiar sheet, and gives the user “data situational awareness”. Therefore it is easier for the user to make data cleaning and standardizing easier because the user can consider all the data in the same context.
It enables the data project owner to share spreadsheets with other individuals, in different departments, to review and edit the data in familiar Excel within their specific area of focus and data knowledge, without having to be logged into a specific software program.
Enables separation of data cleanup work from specific software program user login sessions.
The Excel approach eliminates multiple GUI steps to view, edit or add data.
Excel makes it easier to do data batch validation before actually posting data back, or inserting new data into database.
The use of copies of an Excel file for before and after serves as a simple archiving and backup solution of original data and data revisions. It adds a lot of flexibility.
Makes it easy to copy data from source to destination databases.
Flexibility and versatility of Excel functions for ad hoc data sort, filter, find and replace, cut or copy and paste, Excel data validation features, the sky is the limit!