General Productivity

[lwp_divi_breadcrumbs _builder_version=”4.7.1″ _module_preset=”default” _i=”0″ _address=”1.0.0.0″ /]
How Do You Learn Computer Programming Quickly?

How Do You Learn Computer Programming Quickly?

If you don’t have a job as a programmer and want to learn fast, focus on active learning with lots of practice. Here is the path I recommend you take to fast-track the process: 1) Start with targeted, interactive lessons — short sessions of introductory and passive learning. 2) Passion projects — spend the bulk of your emphasis on longer sessions of challenging, passion-driven side projects.
3) Aim for things that you like to do or that will make your daily obligations easier. 4) Bring along a mentor or pay a freelancer to guide you. They will provide feedback and help you throw out lousy coding habits. Supplement with other sources to fill in the gaps. 5) Keep repeating steps 1 through 4 while applying for entry-level programming jobs.
6) Enroll in a short, targeted, software development path.

Stop Wasting Time Rewriting Formulas

Stop Wasting Time Rewriting Formulas

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...

How to Become an Advanced Excel User (or Excel Guru)

How to Become an Advanced Excel User (or Excel Guru)

Speed up your Excel Guru Journey using the following techniques:
1) User Traditional Methods like Excel Tutorials, Training Classes, and Textbooks
2) Combine Excel Projects with Existing Passions
3) Follow the Existing Excel Gurus – Online and in Person
4) Make Sure to Practice a lot – Most effective to Reverse Engineer Great Spreadsheets
5) Master the Shortcuts
6) Teach Others about Excel
7) Create an Excel Related Business

Latest Blog Posts

Tired of Nested IFs in Excel? Make this SWITCH!

Tired of Nested IFs in Excel? Make this SWITCH!

The Nested IF Nightmare Every Excel worksheet starts innocent enough. You open the formula box and create a simple “if this, then that” formula. The logic is clean, but you need to add one more condition. And then another one. Next thing you know, you’re drowning in...

Learn about SQL joins using Excel

Learn about SQL joins using Excel

Why do we join tables in SQL? Tables that logically represent information are the foundation of relational databases. The ancient rules of database normalization remind us to arrange database tables to reduce redundancy and increase flexibility. An adequately...

Super Bowl Squares Template

Updated for Superbowl 57 This Version is unlocked, so be careful with the formulas. You have to press F9 to Regenerate the squares because calculations are set to manual. This spreadsheet is for educational purposes only. Please check your local gambling restrictions...

How to Return Multiple Matches in one Cell Using a lookup?

VLOOKUP is great for looking up a value and returning another corresponding value. But what happens when the first match just isn't enough. I've been tasked with finding a way to put return not just the first but the second, and third match. At first, I tried to...

How to Delete every other Row in Excel

How to Delete every other Row in Excel

Have you ever needed to delete every other row in Excel? You are not alone.   There are a few ways to accomplish it. It's a pretty good candidate for a VBA solution, but I'm going to show you how to quickly delete every other row without using VBA or a plugin. I...