jtknowles

124 Added | 8 Magazines | 12 Likes | 20 Followers | @jtknowles | Keep up with jtknowles on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “jtknowles”

How to create an annotated line graph in Google Sheets

This post looks at how to create a more advanced line graph in Google Sheets, with comparison lines and annotations, so that the viewer can absorb …

Animated GIF

The Meaning of Underscores in Python

The Meaning of Underscores in PythonThe various meanings and naming conventions around single and double underscores (“dunder”) in Python, how name …

Python Programming

Program an SMS Bot Using Python and Twilio

This winter I went to Utah with some friends, and explored some of the most remote and beautiful places in the world. I hiked through Star Wars looking terrains, and was in awe at the bright red canyons. However, there was one problem: we were in such remote places, the cellular connection was …

Python Programming

20 Tools To Help You Create Beautiful Color Palettes

Colors not only reflect your ideas, virtues and add a great visual effect but highly influence human emotions and behavior. However, choosing the right color palette for your project, website or business can be a difficult task.<p>Lucky for you, today I’m sharing a list of 20 tools to help you create …

UI Design

Here are 200 Excel shortcuts that'll make your life a lot easier

Each workbook acts as its own separate window on your PC or Mac, while each worksheet acts as a tab within a workbook with separate cells.<p>This section of the Excel Guide offers all shortcuts you need to open, navigate between, and control all of these options.<p><i>Courtesy of GoSkills.</i>

Analytics

20 jQuery Modal Popup and Alert Boxes You Should Use

Today’s article sums up 20 excellent<i> jQuery modal dialogs plugins</i> that you can use to successfully display various modal windows, such as alerts, …

Web Design

$0 Design Tools to Help You Create Your Next Project

Creating a well-designed site, product, or project usually isn’t cheap. You know you want to make something that looks good–but how do you do it if …

Web Design

Microsoft Excel — Rules for Designing Excel Workbooks? — Part 2

<b>#2 — Print macro buttons</b><p>In this post and future posts, I will be exploring selected items from the list below and <b>HOW I implement them in my Excel</b> …

Accessories

How to Create a Dynamic Named Range

How many times have you wanted to add things to a list in Excel without needing to change formulas or update cell references? Named Ranges are …

Excel: Working with Tables

Introduction<p>With the release of Excel 2007, Microsoft has introduced a new concept of working with tables of data. This new functionality is (not …

Microsoft Excel — How Are Your Excel Skills? (UPDATED)

Review this questionnaire to get a sense!<p>UPDATED 5/18/17<p>I recently learned that this post was not collecting information properly. Not sure why, but …

Microsoft Excel — Introduction to Power Query Excel Add-In

Part of the Microsoft Power BI Suite #Data #Analytics<p>Introduction<p>I recently came across an excellent overview article posted on LinkedIn about …

Microsoft Excel — Easily Create an Interactive Executive Resource Dashboard

The higher up you move in an organization, or the higher up you provide information, two things quickly become obvious — information needs to be <b>easy</b> …

Top 20 Excel Limitations that might Frustrate You!

November 6, 2016<p><b>362</b> Views <b>2 comments</b><p>Excel is obviously one of the most important products in the world. It is very helpful in managing, analyzing …

Analytics

STOP IT! 3 Things I STOPPED Doing in Microsoft Excel to Boost Productivity

I recently watched Bob Newhart’s <b>“Stop It”</b> skit on YouTube. Anyone who is a Bob Newhart fan may remember this, where he explains to a patient how to …

Microsoft Excel: Data Analysis; Getting Started with Pivot Tables

Pivot tables are an essential tool for working with and quickly extracting information and insights from a pile of data. However, pivot tables are …

5 Habit Changing Flowcharts You Can Make in a Few Minutes

Advertisement<p>Flowcharts are powerful tools. You can use them to streamline your work and your life 5 Creative Flowchart Examples to Streamline Your …

Making BCG Matrix in Excel – How To

BCG matrix is a strategic decision making technique that helps in resource allocation among different cost centers or cost objects by categorizing or …

Data Visualization

This reversible Micro USB cable is impossible to plug in wrong

I have never nerded out so hard over a USB cable the way I am over Winnergear's MicFlip reversible Micro USB-to-USB Type-A cable.<p>Charging cables …

Want to Be Happier? Science Says Do These 5 Simple Things Every Day

Is it possible to improve your happiness simply by doing these things for only two minutes per day? Yes, says a Harvard-trained happiness researcher and best-selling author.<p>Can you improve your happiness simply by breathing for two minutes a day? Apparently so, says Shawn Achor, Harvard-trained …

Happiness

11 basic Excel tricks that will change your life

Microsoft Excel is an amazing piece of software, and even regular users might not be getting as much out of it as they can. Improve your Excel efficiency and proficiency with these basic shortcuts and functions that absolutely everyone needs to know.<p>Of course you can move from cell to cell with …

Analytics

10 Open-Source JavaScript Data Chart Libraries Worth Considering

The beauty of modern web design can be found in the widespread advancement of visual and dynamic effects. CSS3 has taken the design world to another …

Data Visualization

The Dirty Secret About CPR in the Hospital (That Doctors Desperately Want You to Know)

A few things have changed in medicine over the last few decades. Okay, a lot has changed, and most of it good. But along with the improvements in patient care there has been an exponential increase in expectations. We've somehow gone from "your loved one has a life threatening illness and we will …

Medicine

How To Create A Dynamic Range Using The OFFSET Function In Excel

By onApril 11, 2016 in COUNT, OFFSET<p>In this tutorial we are going to look at two ways of creating a dynamic range of data. We are summing up sales …

8 Time-Saving Excel Shortcuts Worth Memorizing [Infographic]

Need help navigating Excel? Check out these time-saving Excel shortcuts guaranteed to make your life easier.

How to Create Custom Functions in Google Sheets

Advertisement<p>Have you ever wished your spreadsheet was as smart as you? Well, it may never be quite that smart, but with a little help from Google …

How to Quickly Create a Waffle Chart in Excel

Have you heard of the Waffle Chart (also called the square pie chart)? I have seen these in a lot of dashboards and news article graphics, and I find …

Top 10 Cheat Sheets to Help You Master Microsoft Office

Microsoft Office is still the most popular office suite used by companies and individuals across the world. These Word, Excel, PowerPoint, and …

Software