David

101 Added | 5 Magazines | 13 Likes | 1 Following | 47 Followers | @davejramos | Fixed Income Data Analyst

How to return the last value in an Excel data range

When you need to see the last value in an Excel Table or data range, these formulas will get the job done. This walk-through details the necessary …

Databases

You've been using Excel wrong all along (and that's OK)

Microsoft doesn't mind if you stop using Excel for the wrong things, as it's been building replacements to compete with the tools trying to replace …

Analytics

What Do Developers Need to Know to Develop Web Apps?

To gather insights on the state of web application development today, we spoke with 12 executives who are familiar with the current state of the …

Two ways to speed up Excel macros

When it comes to executing actions and performing tasks, faster is always better. Learn two tricks that will make your Excel macros more …

Cybersecurity

How to work faster by making the Windows key a habit

The Windows key has been around for more than 20 years, yet many users don't appreciate its time-saving value. These handy shortcuts will speed your …

Tutorials

I grew up in the Westboro Baptist Church. Here's why I left

What's it like to grow up within a group of people who exult in demonizing ... everyone else? Megan Phelps-Roper shares details of life inside …

Religion

How APIs will make your next fridge — or even your next car — free

We are in the fourth industrial revolution, where software can replicate value at zero-marginal cost and where data is the new oil. You may remember this story about Microsoft versus IBM in 1981, where IBM let Microsoft manage the operating system (DOS) thinking that the future was selling …

Internet of Things

Getting Started with Python [Part 1]

by Jen UnderwoodPython is a splendid, flexible, open source language that is easy to learn, easy to use, and has powerful libraries for data analysis …

Python Programming

How AI Is Already Changing Business

<b>Erik Brynjolfsson,</b> MIT Sloan School professor, explains how rapid advances in machine learning are presenting new opportunities for businesses. He breaks down how the technology works and what it can and can’t do (yet). He also discusses the potential impact of AI on the economy, how workforces …

Artificial Intelligence

Free Online Classes & Nanodegrees

"My Nanodegree program increased my discipline and self–esteem, and I'm not afraid to change career fields anymore."

MOOCs

Making neural nets uncool again

Our courses (all are free and have no ads):<p>Deep Learning Part 1: Practical Deep Learning for Coders<p>Deep Learning Part 2: Cutting Edge Deep Learning …

Machine Learning

How to Remove an Excel Spreadsheet Password in 6 Easy Steps

How to Remove an Excel Spreadsheet Password in 6 Easy Steps.<p><i>This post we show how to remove an Excel spreadsheet password in 6 easy to follow steps.</i> …

Python for Scientists and Engineers

<b>Python for Scientists and Engineers is now free to read online. The table of contents is below, but please read this important info before.</b><p>Python for …

Machine Learning

7 sweet Python IDEs you might have missed

The current state of IDEs built for Python is an embarrassment of riches. Six products made the cut in the last rundown, but there were many more …

Programming

Six Cool Things You Can Do With Python

Python has taken over the developing space. In fact, it’s everywhere. Ask any coder and they’ll tell you that it’s easy to learn and it's often the …

Python Programming

Keep This Python Cheat Sheet on Hand When Learning to Code

Python is one of the best programming languages to learn first. As you get started, this one-page reference sheet of variables, methods, and …

Why INDEX MATCH is Better Than VLOOKUP

<i>To learn more about Excel, go to the organized listing of all my Excel tutorial posts or review the most popular Excel books on Amazon</i><p>When deciding …

Stop Wasting Time in Excel for Data Management- Focus on R

If you have spoken with a data scientist in the past few years, you’ve probably heard him or her talk about “R.” R is a statistical programming …

Could the future of Android be Windows?

The many failings of Google's operating system have already been fixed in Microsoft's Windows 10 Mobile ecosystem. Could Redmond possibly have the …

Microsoft Office

Microsoft Professional Program in Data Science

If you’re good with Excel, this is the coding language you should tackle first

<i>The Insider Picks team writes about stuff we think you'll like. Business Insider has affiliate partnerships so we may get a share of the revenue from your purchase.</i><p>Francisco Osorio/FlickrCoding is a valuable skill to have, whether for personal or professional purposes.<p>With that said, not all coding …

Sql
Analytics
Analytics

Keyboard Shortcut to Jump to Any Row or Column

<b>Bottom line:</b> In this post I explain how to create a custom keyboard shortcut to jump to any row or column. This solution uses a simple macro, and is …

How to autocomplete when typing in Excel drop down list?

If you have a data validation drop down list with large values, you need to scroll down in the list just for finding the proper one, or type the …