ExcelMan

Don’t do your Excel work, automate it! Course link in bio. Also: free cheat sheets | reference guides | YouTube tutorials

[ExcelMan @ExcelManLondon]

* FREE * - 3 Excel cheat sheets by ExcelMan
https://t.co/C4q4EsPn9a

[ExcelMan @ExcelManLondon]

@msexcel PowerQuery

[ExcelMan @ExcelManLondon]

How to automate your #Excel report updates in a single click without code. Checkout my course. #Automation

[ExcelMan @ExcelManLondon]

The reaction you have when you see someone else's #Excel formatting. Ergh brother, what's that?

[ExcelMan @ExcelManLondon]

Doughnut chart with dynamic icons in #Excel #dataviz

[ExcelMan @ExcelManLondon]

How to sort pivot table values in #excel ? Master Pivot Tables with this hidden gem.

[ExcelMan @ExcelManLondon]

Don't Fear the Future! #excel isn't going anywhere!

[ExcelMan @ExcelManLondon]

Secret technique using the T function to dynamically get different value fields from a pivot table using the GETPIVOTDATA function in #excel 📈

[ExcelMan @ExcelManLondon]

Get data out of #excel 's Pivot Table using the GETPIVOTDATA function, rather than XLOOKUP.

[ExcelMan @ExcelManLondon]

Free #Excel weekly training on TikTok live starting this Thursday. Go to my TikTok bio to register. This week is shortcuts and function fundamentals.

[ExcelMan @ExcelManLondon]

How many times is "that's what she said" said in the office? Use #excel 's COUNTIF with wildcards to unlock the data.

[ExcelMan @ExcelManLondon]

Master COUNTIFS with Office Script and analyze data like a Dunder Mifflin pro. Find out which character appears the most in each season! #excel

[ExcelMan @ExcelManLondon]

Dunder Mifflin's data needs a hero! Counting like Dwight? We got you. Level up your #excel with COUNT & COUNTIF. #excelfunctions

[ExcelMan @ExcelManLondon]

A PowerBI developer's daily struggle to show off all Power BI's fancy features...but the final request: "Cool, can you just export that to #Excel ?" #CatMeme

[ExcelMan @ExcelManLondon]

Unsure how to handle your duplicates? This video shows 2 conditional formatting methods! Learn how to easily colour-code ALL duplicates for quick identification, and discover a trick to highlight ONLY the additional duplicates, leaving the first instance untouched. #excel

[ExcelMan @ExcelManLondon]

Want to style your #excel slicers beyond the basics? This quick video follows up on our last post, showing you how to customize the layout of your slicers, change their colours, and apply different styles for a sleek and professional look!

[ExcelMan @ExcelManLondon]

Struggling with slow filtering using dropdowns? Uncover the power of slicers in #Excel ! This quick video demonstrates how to insert slicers, how to single and multi-select items and clear filters!

[ExcelMan @ExcelManLondon]

When you use #Excel conditional formatting, do the lonely trend arrows floating far away from your numbers confuse your readers? There's a better way! This quick video shows a simple trick using numerical formatting, where the trend arrows are right next to your numbers!

[ExcelMan @ExcelManLondon]

Tired of fighting with Power BI? Excel's got your back with warm, fuzzy features like conditional formatting, combo charts and more!
@northvalleygrp
#work #Excel #PowerBI

[ExcelMan @ExcelManLondon]

Struggling to sort a list where names are combined? This quick Excel trick sorts by LAST NAME ONLY, even if it's mixed with the first name.
#Excel

[ExcelMan @ExcelManLondon]

Ever wanted to rank data within categories in Excel, but stumbled upon the missing RANKIF function? This post unveils the secret weapon: SUMPRODUCT. #excel