Hackers and Slackers
Hackers and Slackers

Hackers and Slackers

  • About
  • Series
  • Join
  • Donate
  • Log in
  • Subscribe
  • Python
  • Software
  • DevOps
  • Architecture
  • Data Engineering
  • Pandas
  • Data Analysis
  • SQL
  • Data Science
  • REST APIs
  • JavaScript
  • Flask
  • AWS
  • NodeJS
  • Google Cloud
  • Apache
  • Frontend
  • MySQL
  • Data Vis
  • NoSQL
Excel spreadsheet containing data

Excel Data Manipulation: a Guide For Everyone

Introduction to Excel Data Manipulation using TEXTJOIN and Macros.
Max Mileaf
Max Mileaf
May 16, 2018 • 3 mins
Excel
How I Stopped Worrying and Learned to Love the Formula

How I Stopped Worrying and Learned to Love the Formula

Learn to define and utilize Excel formulas.
Max Mileaf
Max Mileaf
May 17, 2018 • 3 mins
Excel
Excel Showdown: Index Match vs. The Lookups

Excel Showdown: Index Match vs. The Lookups

Learn to hate V-Lookups and H-Lookups in favor of Index Match.
Max Mileaf
Max Mileaf
May 18, 2018 • 1 min
Excel
The One Excel Formula to Rule Them All

The One Excel Formula to Rule Them All

Unlock the secrets of Excel's Index Match.
Max Mileaf
Max Mileaf
May 18, 2018 • 4 mins
Excel
Depiction of Pivot Tables within Excel

The Art of Excel Pivot Tables

Pivot complex Excel spreadsheets to summarize your data.
Max Mileaf
Max Mileaf
May 23, 2018 • 3 mins
Excel
Adventures in Excel: Power to the Pivot

Adventures in Excel: Power to the Pivot

Power up your Excel Pivot Tables with these pro moves.
Max Mileaf
Max Mileaf
May 24, 2018 • 6 mins
Excel
Doing the Excel Data Dance

Doing the Excel Data Dance

Taking a step back to reflect on the problems Excel intends to solve.
Max Mileaf
Max Mileaf
May 29, 2018 • 3 mins
Excel
Dealing with Dirty Data in Excel

Dealing with Dirty Data in Excel

Cleaning data Excel in the absence of tools designed to do so.
Max Mileaf
Max Mileaf
May 31, 2018 • 7 mins
Excel
Taking Out the Trash: Dirty Data in Excel

Taking Out the Trash: Dirty Data in Excel

Dealing With Dirty Data in Excel (continued).
Max Mileaf
Max Mileaf
Jun 5, 2018 • 4 mins
Excel
Getting Iffy With it: Conditional Statements in Excel

Getting Iffy With it: Conditional Statements in Excel

Effectively utilize conditionals such as IF statements in your Excel workflow.
Max Mileaf
Max Mileaf
Jun 10, 2018 • 4 mins
Excel
Page 1 of 2

Tags

Python Software DevOps Data Engineering Architecture Pandas Excel Data Analysis SQL Data Science REST APIs JavaScript Flask Code Snippet Corner AWS NodeJS Google Cloud Frontend MySQL Apache Data Vis BI NoSQL GraphQL Spark PostgreSQL ExpressJS ETL Pipelines Tableau PowerBI SQLAlchemy GatsbyJS Powerpivot Machine Learning Automation Big Data Atlassian Mapbox Golang Scraping JAMStack Data Warehouses Plotly Docker Concurrency Hashicorp Django ReactJS SaaS Products Frameworks Java FastAPI Terraform Microsoft

Newsletter

Create an account to receive occasional updates and interact with the community.

Series'

Data Analysis with Pandas 11
Build Flask Apps 11
Learning Apache Spark 6
Google Cloud Architecture 6
Mastering SQLAlchemy 4
GraphQL Tutorials 4
Welcome to SQL 4
Working with MySQL 4
Mapping Data with Mapbox 3
Web Scraping With Python 2
Python Concurrency with Asyncio 2
Getting Started with Django 2
Hackers and Slackers

Community of hackers obsessed with data science, data engineering, and analysis. Openly pushing a pro-robot agenda.

Navigation

    • About
    • Series
    • Join
    • Donate

Series'

  • Data Analysis with Pandas
  • Build Flask Apps
  • Learning Apache Spark
  • Google Cloud Architecture
  • Mastering SQLAlchemy
  • GraphQL Tutorials
  • Welcome to SQL
  • Working with MySQL
  • Mapping Data with Mapbox
  • Web Scraping With Python
  • Python Concurrency with Asyncio
  • Getting Started with Django

Authors

  • Todd Birchard
  • Matthew Alhonte
  • Max Mileaf
  • Ryan Rosado
  • Graham Beckley
  • David Aquino
  • Paul Armstrong
  • Dylan Castillo
©2023 Hackers and Slackers, All Rights Reserved.