START HERE
WEBINARS
COURSES
BLOG
PODCAST
CONSULTING
ABOUT
STUDENT LOGIN
SEARCH
JOIN 75,000 EXCEL USERS WHO RECEIVE OUR FREE EXCEL LESSONS

LATEST POSTS
FORMULAS
Lookup
VLOOKUP INDEX INDEX/MATCH INDIRECT MATCH OFFSET SUM
Text
BETWEEN CLEAN CONCATENATE LEFT LEFT & FIND LEN PROPER REPLACE RIGHT SUBSTITUTE TEXT TRIM TRIM & SUBSTITUTE
Logical
IF IFERROR
Math
SUMPRODUCT AVERAGE MOD RAND ROUND SUBTOTAL SUMIF SUMIFS RANDBETWEEN OTHER MATH
Date & Time
DATEDIF EOM WEEKDAY
Other
ARRAY 3D Formulas Financial TIP
PIVOT TABLES
Customize Analysis Group Sort Calculated Fields & Items Filter Slicers Pivot Charts Conditional Formatting Other
CHARTS
Smart Art Column Line Pie Bar Area Scatter Bubble Sparklines Formatting Charts Excel 2016 Charts Infographic
POWER BI
Power Query Power Pivot
ANALYSIS
Conditional Formatting Data Validation Excel Tables Find & Select Sort & Filter Other
SHORTCUTS
Keyboard Tips and Tricks
MACROS
ADD-INS

aggregate

Create Index Columns Using Power Query

November 4, 2016

Continue reading

Create Pivot Columns Using Power Query

October 20, 2016

Continue reading

ABOUT ME

Hello, My name is John Michaloudis from MyExcelOnline. Click here to read my story!

Helpful Excel Resources

50 Things You Can Do With Excel Pivot Tables
Top Excel Formulas & Function Examples To Get Better At Microsoft Excel
Learn Excel VBA & Macros with Ryan Wells!
Free Excel Webinar Courses
What Microsoft Excel Version Do I Have?
(Christmas Special) 018: The Best Excel Tips of 2017 from 20 Excel Experts
(Christmas Special) 013: The Best Excel Tips of 2016 from 23 Excel Experts
Top 3 Excel Pivot Table Issues Resolved

Most Popular Posts

Create a Data Entry Form in Excel
Connect Slicers to Multiple Excel Pivot Tables
VLOOKUP Example: Vlookup with a Drop Down List
Advanced SUMPRODUCT Function: Sum Multiple Criteria
Named Ranges with Vlookup Formula
Sum a Range Using the INDEX Function
VLOOKUP with Multiple Criteria in Excel
Concatenate With A Line Break
Bubble Chart: 3 Variables On A Chart
100% Stacked Column Chart: Percentage Contributions
INDIRECT Function Using Sheet References

COME HANG OUT WITH ME

SEARCH EXCEL TUTORIALS

EXCEL WEBINARS

Pivot Table
Macros & VBA
Power Query & Data Cleansing

EXCEL COURSES

All Courses
Pivot Table
Macros & VBA
Pivot Table (16 CPE Credits)
Power Query & Data Cleansing

EXCEL BLOG

Formulas
Pivot Tables
Charts
Power BI
Analysis
Shortcuts
Macros
Add-Ins

PODCAST & MORE

All Podcasts
Consulting
Contact
Privacy Policy

FOLLOW ME

SEARCH EXCEL TUTORIALS