2016 New Year’s Resolution

My professional goal in 2015 was to up my JavaScript skills. I focused on developing a much deeper understanding of the language and mastering its concepts. I feel good about the progress I made. While I still use (and love) jQuery, it’s no longer a crutch to mask my understanding of the language. In 2016 my JavaScript goal remains, but I am going to narrow my focus to a specific stack.

Right now there is so much innovation with JavaScript that it can feel overwhelming. It seems like every day there is a new framework, library or and build tool that the community clamors about. There is too much noise. The noise breaks focus, which impedes learning and hurts productivity. From an idealistic standpoint the stack should depend on the project. But for me, that’s just not practical. Time is the ultimate constraint, and I’d rather not spend it becoming a master of nothing.

Over the last couple months, I’ve done a fair amount of research and learning about different JavaScript technologies. Understanding their core methodologies has helped me isolate those that I feel have the most potential and will be the most fun to learn. So, in 2016 I’ve decided to focus on the following:

Each of these layers in the stack will come with a ton of new things to learn. By no means do I expect to become an expert by year’s end. I do expect however to be proficient with them, and I’m pretty excited about that!

Happy New Year 🙂

Merge Two Excel Spreadseets With Ablebits Merge Tables Wizard

If data migration is even tangentially related to your job, you use Excel. With all the web apps and tools at our disposal today, Excel is still (by far) the most powerful tool when working with large data sets. It’s capabilities, functions and speed have made it a cornerstone of data migration.

That said, unless you have a decent knowledge of Visual Basic for Applications (VBA), Excel can be limiting. Time and time again you will find Excel functions lacking in key areas. But, there is light at the end of tunnel! That light is provided by the Ablebits Ultimate Collection for Excel, a package of insanely useful Excel utilities for all things data.

While the purpose of this post is not to review the Ultimate Collection, I wanted to quickly highlight my satisfaction with their Excel extensions. As I say in the screencasts below, the Ablebits Ultimate Collection has literally saved me hundreds of hours of drone work on various projects. Below I’ll show you how to use the Merge Tables Wizard to add and update data across two different spreadsheets in Excel.

Add Missing Data From One Excel Spreadsheet to Another

Update Existing Data From One Excel Spreadsheet to Another