Search any Excel feature
START HERE
WEBINARS
Functions & Formulas Macros & VBA Pivot Tables
COURSES
Excel Academy $1 Trial
BOOKS
BLOG
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 WORKDAY
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
PODCAST
CORPORATE
MEMBERS
YouTube
Facebook
Twitter
LinkedIn
Pinterest
Google Play
App Store
SEARCH
Privacy Policy
Cookie Policy

+120,000

DOWNLOAD OUR FREE
101 EXCEL TEMPLATES

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 WORKDAY
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
SEARCH

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
50 Things You Can Do With Excel Power Query
Free Excel Webinar Online Training Courses
023: Top Microsoft Excel Tips & Tricks of 2018!

Microsoft Excel Online Course Training

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

Get $10 OFF Our Most Popular Excel E-Books…

EXCEL WEBINARS

Functions & Formulas
Pivot Table
Macros & VBA

EXCEL COURSES

MyExcelOnline Academy
Corporate Training

EXCEL BLOG

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

PODCAST & MORE

All Podcasts
Books
Consulting
Contact
Privacy Policy
Cookie Policy

FOLLOW ME

SEARCH EXCEL TUTORIALS

This website uses cookies to ensure you get the best experience on our website. Cookie Policy Got It!

Privacy & Cookies Policy

Necessary

Necessary

Always Enabled

This is an necessary category.

Uncategorized

Functional

Analytics

Advertisement

Performance

Save & Accept