Hackers and Slackers Logo
AboutSeriesJoinSearchDonate
Search results
No results for 'undefined'
mobile-menu
Search results
No results for ''
Trending Searches
HomeAboutSearch
Tags
PythonSoftwareDevOpsData EngineeringArchitecturePandasData AnalysisData ScienceREST APIsSQLCode Snippet CornerFlaskJavaScriptAWSNodeJS
Series
Build Flask AppsData Analysis with PandasLearning Apache SparkGoogle Cloud Platform ArchitectureCreate a REST API in AWSWorking with MySQLGraphQL TutorialsHacking Tableau ServerMastering Python's SQLAlchemyMongoDB Atlas Cloud ArchitectureWelcome to SQL: Tutorials for NewcomersMapping Data with MapboxMicrosoft PowerPivotGetting Started with DjangoWeb Scraping With Python
Authors
Todd BirchardMax MileafGraham BeckleyDavid AquinoMatthew AlhonteRyan RosadoPaul ArmstrongDylan Castillo
JoinRSS Donate
Excel

Excel (page 1)

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

PowerPivot 3: Managing the Data Model
Powerpivot

PowerPivot 3: Managing the Data Model

Analyzing ginormous files with Microsoft PowerPivot.

Max
Max
04 June, 2019•5 min read
PowerPivot 2: What's the Deal with Delimiters?
Powerpivot

PowerPivot 2: What's the Deal with Delimiters?

Working with large flat files in PowerPivot.

Max
Max
30 May, 2019•6 min read
Power to the Pivot Redux: Enter PowerPivot
Powerpivot

Power to the Pivot Redux: Enter PowerPivot

Dipping into Microsoft's PowerPivot add-on for Excel.

Max
Max
25 May, 2019•4 min read
Create an Iterative List in Excel Without Any Real Coding
Excel

Create an Iterative List in Excel Without Any Real Coding

Roll On Through: This isn't standard programming... THIS IS EXCEL! We get creative in Excel by making FOR loops without using VBA.

Max
Max
11 September, 2018•3 min read
Dynamic Tension! Creating and Using Dynamic Named Ranges in Excel
Excel

Dynamic Tension! Creating and Using Dynamic Named Ranges in Excel

Dynamically load data in smart pivot tables.

Max
Max
30 August, 2018•7 min read
Importing Excel Datetimes Into Pandas, Part II
Code Snippet Corner

Importing Excel Datetimes Into Pandas, Part II

Import dates & times from Excel .xlsx files into Pandas!

Matthew
Matthew
13 August, 2018•2 min read
I Owe My Job to Mr. Robot
Excel

I Owe My Job to Mr. Robot

Entering the Dataverse.

Max
Max
13 August, 2018•8 min read
Importing Excel Datetimes Into Pandas, Part I
Code Snippet Corner

Importing Excel Datetimes Into Pandas, Part I

Parse dates and times from Excel .xlsx correctly when using Pandas.

Matthew
Matthew
13 August, 2018•1 min read
Page 1 of 3
Next
Hackers and Slackers

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

Trending Posts
Extract Nested Data From Complex JSONIntegrate Plotly Dash Into Your Flask AppScraping Data on the Web with BeautifulSoupSSH & SCP in Python with ParamikoMake Your First API Calls with JQuery AJAXQueries as Python Code with SQLAlchemy's Expression LanguageConfiguring Python Projects with INI, TOML, YAML, and ENV filesMaking API Requests with node-fetch

Tags

PythonSoftwareDevOpsData EngineeringArchitecturePandasExcelData AnalysisData ScienceREST APIsSQLCode Snippet CornerFlaskJavaScriptAWSNodeJSGoogle CloudMySQLApacheFrontendData VisNoSQLBIExpressJSGraphQLPostgreSQLSparkETL PipelinesTableauAtlassianBig DataGatsbyJSMachine LearningSQLAlchemy

Newsletter

Donations

@YogiFish
3

Thanks for sharing your knowledge. #StopTechCensorship

Someone
1

thanks

Gurudev Ilangovan
2

Super informative + Super fun!!

@witsuma
5

Thanks for amazing things for Flask!

Someone
5

Hey Todd, I keep coming back to your site - your articles are just so great. Thank you!

Hackers and Slackers Logo

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

PagesAboutSeriesJoinSearchDonateSign up
SeriesBuild Flask AppsData Analysis with PandasLearning Apache SparkWorking with MySQLEmbracing GraphQLMastering SQLAlchemyWelcome to SQLMapping Data with Mapbox
AuthorsTodd BirchardMax MileafGraham BeckleyDavid AquinoMatthew AlhonteRyan RosadoPaul ArmstrongDylan Castillo
©2020 Hackers and Slackers, All Rights Reserved.