Hackers and Slackers
Hackers and Slackers Mobile

Hackers and Slackers

  • About
  • Series
  • Join
  • Donate
Sign in Subscribe
  • Python
  • Software
  • DevOps
  • Architecture
  • Data Engineering
  • Pandas
  • Data Analysis
  • Data Science
  • REST APIs
  • SQL
  • JavaScript
  • Flask
  • AWS
  • NodeJS
  • Google Cloud
  • Apache
  • MySQL
  • Frontend
  • Data Vis
  • NoSQL
  • Spark
  • Home
  • 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
  • Series
  • Tags
    • Python
    • Software
    • DevOps
    • Data Engineering
    • Architecture
    • Pandas
    • Data Analysis
    • Data Science
    • REST APIs
    • SQL
    • JavaScript
    • Flask
    • AWS
    • NodeJS
    • Google Cloud
    • MySQL
    • Apache
  • Tags
Sign in Subscribe

Excel

Pro-mode Excel secrets, macros, and magic. The kind of industry knowledge to put junior finance guys out of business.
Your Invitation to the Excel Pivot Party

Your Invitation to the Excel Pivot Party

Becoming well-versed in pivot tables to the point where it’s a problem.
Max Mileaf's Avatar
Max Mileaf snacks
Jul 21, 2018 • 4 mins
Excel
Knife slicing through data

Slicing Excel: The Way of The Knife

Slicing your Excel data to be presentable for the less tech-savvy.
Max Mileaf's Avatar
Max Mileaf snacks
Jul 5, 2018 • 5 mins
Excel
Using Excel On a Laptop In A Dark Lonely Room

Yes...If(And)): Excel’s Mighty “IF” Statement

A deep dive into Excel’s implementation of IF statements and their significance.
Max Mileaf's Avatar
Max Mileaf snacks
Jun 20, 2018 • 4 mins
Excel
An Unimaginably Boring Illustration of Excel Usage

Getting Iffy With it: Conditional Statements in Excel

Effectively utilize conditionals such as IF statements in your Excel workflow.
Max Mileaf's Avatar
Max Mileaf snacks
Jun 10, 2018 • 4 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's Avatar
Max Mileaf snacks
Jun 5, 2018 • 4 mins
Excel
An Absolute Mess of Excel Data

Dealing with Dirty Data in Excel

Cleaning data Excel in the absence of tools designed to do so.
Max Mileaf's Avatar
Max Mileaf snacks
May 31, 2018 • 7 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's Avatar
Max Mileaf snacks
May 29, 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's Avatar
Max Mileaf snacks
May 24, 2018 • 6 mins
Excel
Depiction of Pivot Tables within Excel

The Art of Excel Pivot Tables

Pivot complex Excel spreadsheets to summarize your data.
Max Mileaf's Avatar
Max Mileaf snacks
May 23, 2018 • 3 mins
Excel
Galaxy Brain Transcending Reality By Using Excel

The One Excel Formula to Rule Them All

Unlock the secrets of Excel's Index Match.
Max Mileaf's Avatar
Max Mileaf snacks
May 18, 2018 • 4 mins
Excel

Tags

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

Newsletter

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

Great!

Check your inbox and click the link to complete the subscription.

Error

Loading...

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.

Pages

  • About
  • Series
  • Tags
  • Join
  • Donate
  • Sign in
  • Subscribe

Authors

  • Todd Birchard
  • Matthew Alhonte
  • Max Mileaf
  • Ryan Rosado
  • Graham Beckley
  • David Aquino
  • Paul Armstrong
  • Dylan Castillo

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
©2025 Hackers and Slackers, All Rights Reserved.