MyOnlineTrainingHub
@OnlineTrainingH
Followers
10,763
Following
744
Media
548
Statuses
1,333
I teach Excel & Power BI career transforming skills. 1M+ students globally. Follow me for Excel & Power BI Tips and Tricks.
Sunshine Coast, Australia
Joined April 2010
Don't wanna be here?
Send us removal request.
Explore trending content on Musk Viewer
Al Smith
• 382136 Tweets
Monsalve
• 230792 Tweets
Cuba
• 196271 Tweets
Catholic
• 175219 Tweets
#bebekkatilleri
• 124183 Tweets
Boric
• 107054 Tweets
Jesus is Lord
• 95959 Tweets
#النصر_الشباب
• 89314 Tweets
سالم
• 85809 Tweets
Andrew Garfield
• 83206 Tweets
Perez
• 82328 Tweets
Ginés
• 71782 Tweets
Peterson
• 69968 Tweets
Franco
• 61474 Tweets
#TUDUMNaLata
• 60976 Tweets
Lewis
• 44894 Tweets
Geoff
• 39735 Tweets
ebony
• 35537 Tweets
Sprint
• 31903 Tweets
Furkan
• 31204 Tweets
自民党本部
• 20775 Tweets
首相官邸
• 18324 Tweets
Verstappen
• 17246 Tweets
Tanaka
• 15131 Tweets
تاليسكا
• 15117 Tweets
Checo
• 13811 Tweets
Spider-Man 2
• 13079 Tweets
Norris
• 12247 Tweets
Lando
• 11836 Tweets
Pinned Tweet
EVERYTHING in Power BI Desktop
Download the free hi-res CHEAT SHEET + QUICK START VIDEO and build your first Power BI report here:
🚀Skills that get you noticed and promoted!
#PowerBI
#DataVisualization
#BusinessIntelligence
#DataAnalysis
1
129
568
FINALLY, Python in Excel is now generally available to ALL Microsoft 365 Enterprise and Business users on Windows.
Get started with this cheat sheet containing everything you need to know.
Download the hi-res version and see the step-by-step video here:
0
127
577
Interactive PivotTable Profit and Loss. Get a copy of the template and step by step video tutorial here:
2
162
532
Excel PivotTable Cheat Sheet
EVERYTHING you need to know to build a PivotTable in one page!
Download the hi-res PDF here:
Follow for more like this each week!
#Excel
#cheatsheet
#PivotTables
#ExcelTips
3
102
505
4
133
470
Power Query Cheat Sheet
Automate the BORING tasks & 10x Productivity with Power Query. Automate gathering and cleaning data with an easy-to-use graphical interface.
🔽Download in hi-res here:
Follow me for more like this.
#Excel
#PowerQuery
#exceltips
2
113
456
🚀 Master Excel's Dynamic Arrays with our cheat sheet! Covers FILTER, UNIQUE, SORT, SORTBY, SEQUENCE, RANDARRAY, # Operator, and
#SPILL
! ERROR.
🔗Download in hi-res:
How have Dynamic Arrays changed your Excel work? Share below! 👇
#Excel
#CheatSheet
0
66
351
Power BI vs Excel?
Most people know one better than the other and then they try and tell you which is best.
I know both inside out. Millions have learned how to use Excel and Power BI watching my video tutorials. Here is my unbiased comparison.
#powerbi
#excel
#dashboards
2
97
347
✨Excel Number Formatting Secrets
Transform your spreadsheets from amateur to pro with custom number formats.
🏆 Get more examples, example file and hi-res PDF available to download here:
🎯 FOLLOW me for more.
#Excel
#ExcelTips
4
64
305
16 Reasons Why Your Excel is SLOW!
Slow Excel files can be a headache for anyone who uses spreadsheets regularly. These are the most frequent causes of slow Excel files.
Get the solutions here:
#Excel
#ExcelTips
0
54
186
7 ways to Find and Remove Duplicates
Duplicate data often leads to compromised data integrity. Remove, identifying or highlight duplicates.
▶️Watch the video and 📷download the hi-res cheat sheet:
#ExcelTips
#MicrosoftAmbassador
#Productivity
2
44
185
Find Excel Errors Hack
Use the Find tool to generate a list of errors in your file. Use the built in hyperlinks to jump to the error and fix them.
❓How do you usually validate your data and find errors?
#Excel
#MicrosoftAmbassador
#exceltips
3
58
179
Are your
#Excel
files slow? Fix them with one click with this new tool from Microsoft!
#MicrosoftAmbassador
#ExcelTips
#ExcelTricks
Follow me for more tips like this.
Share this tip and spread the Excel love.
Skyrocket your career with my courses
1
36
172
Cross Highlight in Excel like Power BI - download template and step by step video here:
#Excel
#MicrosoftAmbassador
#exceltips
#exceltricks
#exceltraining
#excelpro
#exceltutorial
#excel_learning
1
31
166
Better than V/XLOOKUP!
FILTER is the new must-know function for extracting data based on criteria.
⬇️Download the hi-res cheat sheet and watch the FILTER function video here:
#ExcelTips
#FILTERFunction
#DataAnalytics
0
50
163
Excel Keyboard Shortcut Periodic Table now available for both 🍎MAC & 🪟Windows.
10x your Productivity with these keyboard shortcuts:
🙏 Help me spread this free resource: please like, share and comment.
#exceltips
#keyboardshortcuts
2
50
157
When you press CTRL+SHIFT+A after entering a function, but before completing any arguments, Excel enters the syntax for the function. Check out the video
#MicrosoftAmbassador
#Excel
#ExcelTips
#ExcelTricks
1
26
135
FINALLY! The new GROUPBY & PIVOTBY functions are generally available to all 365 users.
🔗 Download hi-res cheatsheet, practice file and watch the video here:
These functions are like PivotTables, but more flexible and often faster.
#excel
#pivottables
0
19
137
Master Excel Array Shaping Functions
Transform the way you handle complex data tasks in Excel with the new array shaping functions.
Download & watch the deep dive video here:
🎯 FOLLOW me for more.
#Excel
#ExcelTips
#MicrosoftAmbassador
1
32
120
PivotTable Formatting Cheat Sheet
No more UGLY PivotTables!
Create PivotTables that don’t look like PivotTables with these 12 PivotTable Formatting tips and tricks.
Download in hi-res here:
#Excel
#MicrosoftAmbassador
#pivottables
0
16
90
NEW Python in Excel Formula Editor
Writing Python in Excel is now super easy with the Python Formula editor.
Get up and running with Python in Excel here:
#PythonInExcel
#Excel
#Python
0
17
73
Easier than PivotTables!
Pros use this technique to filter and analyse data instead of PivotTables.
✅It avoids file bloat
✅It's dynamic, no need to refresh.
✅It's interactive.
Check out these real world examples in the video here:
#Excel
3
11
68
56 FREE Power Query tutorials - Beginner to Advanced by Microsoft MVP, Mynda Treacy.
Includes videos, example files and step by step written instructions - Save $'000!
Get them here:
#ExcelTips
#Excel
#PowerQuery
#PowerBI
1
18
59
Save countless hours with these 7 PivotTable techniques!
Whether you're analyzing sales data or crunching budget numbers, these techniques will change the way you Excel.
Check out the video and get the practice file here:
#Excel
#PivotTable
0
9
54
ADVANCED PivotTable Grouping
**I had fun recording this video. It’s very different to my usual videos. You’ll have to watch to see what I mean** 😉 Check out the video here:
#Excel
#PivotTables
#MicrosoftAmbassador
0
9
53
Power Query vs Power BI
A lot of people get confused between these two tools, but they are very different.
❓Which one do you think is most important? Let me know in the COMMENTS.
🎁Please SHARE & LIKE this post and spread the knowledge.
#Excel
#PowerQuery
#PowerPivot
#PowerBI
2
12
51
19 Excel Formulas with 1 Function!
I like to call this the the Swiss Army Knife of functions. It’s so versatile it can replace these 19 Excel functions in one fell swoop.
▶️ Check out the video:
🔖FOLLOW me for more tips like this.
#Excel
#ExcelTips
0
4
50
Hidden
#Excel
Fill Series Shortcut!
#MicrosoftAmbassador
#exceltips
#exceltricks
#MicrosoftExcel
#excelskills
Our YouTube channel:
Our Courses:
Our Excel Help Forum:
0
18
49
Excel Fun Unleashed! ✨🚀
Tired of bland Excel tabs? Let's spice them up! 🌶️ Press Windows Key + 😉 for emojis in tab names. A vibrant, efficient touch!
🔍 Navigate faster
🗣️ Personalize sheets
🎨 Add color with the View tab's Navigation pane
Follow for more tips!
#ExcelTips
0
4
38
Excel descriptive statistics 3 ways:
1. The fast, easy way
2. The dynamic way
3. The comprehensive and advanced way
They all have their pros and cons.
▶️ Watch the video here:
#excel
#statistics
#MicrosoftAmbassador
0
7
37
Avoid Calc. ERRORS - Scale Numbers in Excel the RIGHT WAY - $K, $M, $B
Scaling numbers to thousands, millions, billions etc. in Excel is often done the wrong way leading to spreadsheet errors with huge ramifications. Learn the right way to scale numbers.
0
6
37
8 Advanced PivotTable Tricks - Free Cheat Sheet
⬇️ Download your FREE hi-res copy and see the step-by-step video here:
Master these tricks and customize your PivotTables like a pro.
#ExcelTips
#Excel
#PivotTable
1
11
35
High-income Excel skills worth learning in 2024
🔗 Download the FREE hi-res cheat sheet, practice file and step-by-step video here:
Excel isn’t just a spreadsheet tool - it’s a career accelerator.
#Excel
0
5
35
DON'T angle chart labels, EVER! It's a terrible user experience! If you have long labels use these techniques instead.
#MicrosoftAmbassador
#Excel
#ExcelTips
#ExcelTricks
YouTube
Courses
Excel Forum
0
11
35
REVEALED: 7 Excel tricks that breathe life into dull spreadsheets.
Ever seen an Excel file that made you go "Wow"?
These aren't your typical formatting tips.
They're hacks that turn boring data into eye-catching visuals.
Watch here:
#Excel
0
2
30
Excel Slicer Custom Sorting Hacks - Masterclass!
Improve the useability of your reports with these tricks to custom sort Excel Slicer buttons, enabling them appear in a specific order that suits your needs.
See the step by Step video here:
#exceltips
0
3
28
10 PivotTable Hacks You Won’t Believe!
Dive into secrets that transform your data analysis.
From filtering dates with ease to deep dives with a click.
Ready to level up?
Watch the full video and unleash your data's potential:
#Excel
#PivotTables
1
6
28
Data analysis is the must-have skill for career growth in 2024.
🔗 Get the hi-res 6-step cheatsheet, video and practice file here:
- Make decisions faster.
- Spot trends your competitors miss.
- Automate tedious tasks.
- Become the go-to problem solver.
1
5
28
Stop copying formulas!
ELIMINATE Copying Formulas with NEW Excel Functions. Check out the video here:
These functions fundamentally change the way we write formulas that calculate across columns and down rows.
#Excel
#productivity
#formulas
0
2
28
In a world driven by money, managing personal finances can be a challenge.
But it's essential for financial success.
It takes discipline to use money properly.
Learn how to use Excel for personal finance and take control of your budget and finances:
1
4
26
The hidden way PivotTables work, the limitations this imposes, and how to get around them:
🎓 LEARN MORE in my Excel courses:
🔔 FOLLOW if you’d like more tips and tutorials like this.
#excel
#microsoftambassador
#pivottables
1
2
27
Top Functions for Data Analysts Cheat Sheet
Download the free 5 page hi-res PDF with hyperlinks here:
🎁 COMMENT, SHARE & LIKE this post and spread the Excel love.
🔖FOLLOW me for more tips like this.
#Excel
#MicrosoftAmbassador
0
2
25
Struggling with Excel PivotTables?
Meet GROUPBY & PIVOTBY, Excel's newest functions!
Say goodbye to headaches and hello to increased productivity with easy data grouping and aggregation using formulas alone:
#MicrosoftExcel
#ExcelTips
#ProductivityBoost
1
5
26
Create QR codes in bulk directly in Excel. No third-party tools needed.
🔗 Get the hi-res cheatsheet, video, and example file here:
Grab your guide now and start creating in minutes.
#Excel
1
5
25
In celebration of Spreadsheet Day 2022, we take a look at a quirky use of
#Excel
to help make a birthday cake for my son!
#MicrosoftAmbassador
#exceltips
#exceltricks
#excel_learning
#excelskills
3
5
22
New
#PowerQuery
Custom Data Types will simplify the way you work in
#Excel
! It's a truly revolutionary improvement to how we store data in cells!
@msexcel
1
8
24
🚀 Elevate your Excel game!
4 amazing ways to use Excel's new in-cell checkboxes: Task Lists, Progress Tracking, Dynamic Charts, Filtered Lists, and more! 📊
👀 Watch the full guide here:
👍 Please like & RT to share the Excel love!
#Excel
#ExcelTips
0
5
24
I don’t use OFFSET anymore! 😱
The problem with OFFSET is it’s volatile. I use another function instead.
Check out the video for step by step instructions and get the example file here:
#Excel
1
1
22
Sloppy Excel formatting? It's costing you more than you think.
🔗 Download the hi-res cheat sheet and watch the video here:
Excel pros know presentation is half the battle.
Avoid these common mistakes and level up your spreadsheets.
#Excel
#ExcelTips
0
5
22
NEW
#Excel
evaluate formula tooltip currently available to Microsoft 365 users on Beta channel. It saves pressing F9 to evaluate components of a formula while in edit mode or the formula bar.
#MicrosoftAmbassador
Music: Dance Monkey by Tones and I acoustic cover by Habana Music
0
7
19
Using List Functions in Power Query to do Exact Lookup and Approximate Match Lookup is easier and faster to use than table merges.
#PowerQuery
#Excel
#PowerBI
0
3
19
Who needs PivotTables when you have
#Excel
CUBE Functions? Get started with CUBE Functions the EASY way:
#MicrosoftAmbassador
0
2
19
Ever stared at an Excel sheet and thought,
"Where do I begin?" 🤔
Excel can be overwhelming, but analyzing data is simpler than it seems.
Break it down step-by-step, and you'll master it in no time.
See for yourself how easy it can be:
#DataAnalysis
0
2
16
Struggling with time-consuming Excel tasks?
My latest video reveals top 10 Excel productivity hacks for work!
From quick navigation tips to advanced data analysis.
Watch now:
❓What Excel task slows you down the most?
#ExcelTips
#ProductivityTips
0
1
16
9 super exciting NEW
#Excel
functions for shaping arrays:
#MicrosoftAmbassador
#exceltips
#exceltricks
#excel_learning
0
3
16
EXCEL PYTHON KEYBOARD SHORTCUTS
Now that we can write Python in Excel, you’ll find some keyboard shortcuts super handy.
Learn how to use Python in Excel:
#Excel
#Python
#MicrosoftAmbassador
0
6
16
Gathering data is crucial for project insights.
Spreadsheets are lifesavers, but raw data?
Not exactly thrilling, right?
That's where dashboards shine!
Check out my latest video on crafting interactive Excel dashboards:
#ExcelTips
#ExcelDashboard
0
4
15
0
1
16
Held back by poorly designed reports?
Wow your boss with engaging interactive dashboards in under 20 minutes.
Download the file and elevate your data skills.
Watch now:
#excel
#dashboards
1
3
15
Excel + ChatGPT Automation - No more annoying Merge & Center!
Use this shortcut written by ChatGPT to Center Across Selection instead.
#Excel
#MicrosoftAmbassador
#chatgpt
#ExcelTips
#VBA
1
5
16
Report errors got you red-faced?
We've all been there, caught off-guard during presentations.
This week's video dives into Excel data cleaning for seamless data analysis
We address duplicates, formatting, and many more.
❓Ever had a data "oops" moment?
1
0
16
Sick of wasting hours on Excel tutorials with nothing to show for it?
It's time to stop spinning your wheels.
These simple changes will finally make all those hours pay off—fast.
Once you try it, your Excel learning will never be the same.
#Excel
0
3
16
This is the biggest change to
#Excel
EVER. The new Dynamic Array functions will fundamentally change the way we work with formulas.
0
5
14
Excel like NEVER before!
This week's video is fun and entertaining and along the way you’ll learn some Excel tips and techniques without even realising it.
▶️Check it out here:
#Excel
#MicrosoftAmbassador
#exceltips
0
3
15
Essential
#Excel
Data Entry Shortcuts Not Many People Know.
#MicrosoftAmbassador
#ExcelTips
#ExcelTricks
Follow me if you’d like more tips like this.
Our YouTube channel
Our Courses
Our Excel Help Forum
0
1
15
Check for scheduling conflicts with this easy
#Excel
formula that identifies overlapping dates and times.
#MicrosoftAmbassador
0
2
15
I'm excited to share that our humble YouTube channel, consisting mostly of Excel tutorials, has tipped over the 500k subscriber milestone! Thank you for your support and encouragement. It's been a journey to say the least.
#Excel
#MicrosoftAmbassador
5
3
15
Is the HYPE about
#PowerQuery
justified? Some say they've reduced a 3 hour task down to 3 seconds with Power Query. Check out this video to see if it can do that for you too.
@msexcel
0
5
15
Power BI vs Excel Dashboards, and the winner is...
In this video I give an unbiased comparison between the two tools for building dashboards.
#PowerBI
#Excel
#Dashboards
@msexcel
0
10
15
1
6
14
UNLIMITED Multi-level Excel dropdown lists that update themselves? It's possible.
Discover two methods that grow with your data. Including one that uses the CELL function in an unusual way.
Watch here:
#Excel
#ExcelTricks
0
3
14
There's an Excel tool I use every day that'll make your life so much easier.
It's not a formula or a macro. It's even better.
Sounds too good? See why I can't work without it:
#Excel
0
0
14
Essential Excel Functions for Financial Modeling.
Check out the comprehensive video and download the Excel example file here:
#Excel
#MicrosoftAmbassador
#financialmodeling
1
3
14
1
3
14
✨New AI Excel Web Scraping
NEW and improved features of Excel's Power Query Web Connector uses AI to find the data you want on a web page.
🎥 watch here:
🔖FOLLOW me for more tips like this.
#Excel
#powerquery
#microsoftambassador
0
0
14
NEW Python in Excel - PYTHON + EXCEL + ChatGPT = Easy!
Use Python in Excel natively using libraries like Pandas, NumPy, Matplotlib and more to do data analysis and create amazing Python charts. Step by step here:
#Excel
#Python
#MicrosoftAmbassador
1
1
13
The AMAZING
#Excel
FILTER function can lookup and return multiple matches with multiple columns of data, and with a trick it can even rearrange column order:
0
2
14
Excel isn't just spreadsheets; it's your career accelerator.
Master 3 skills that enable you to slash workloads, save thousands, & become indispensable.
Watch now & elevate your career:
#Excel
#productivitytips
0
5
12
Import data from a picture to
#Excel
. Works with pictures from a file, or the clipboard, and loads it to the spreadsheet.
#MicrosoftAmbassador
0
5
12
🆓10x your Productivity with this Periodic Table of Excel Keyboard Shortcuts + 239 Keyboard Shortcut PDF:
🙏 Help me spread this free resource: please like, share and comment.
#excel
#keyboardshortcuts
#exceltips
2
3
13
ChatGPT + Excel = Ultimate Efficiency
Picture seamless formula creation and shortcuts that transform your workflow.
Dive into the most popular AI tool for game-changing Excel secrets and time-saving tricks:
#MicrosoftExcel
#ExcelTips
#ChatGPT
0
0
12
Supercharge Your Excel Skills Like Thor!
Discover why 99% of Excel users might be missing out on their full potential with a dive deep into the world of Excel's logical tests!
Check out the video:
#Excel
#MicrosoftAmbassador
#ExcelTips
0
0
11
#Excel
headaches?
Are You Making This Mistake?
Discover 5 data layout MISTAKES and the correct layout to enhance your Excel efficiency.
Streamline tasks, boost productivity.
Watch and learn:
#Productivity
0
3
12
WOW! Excel Scroll & Sort Tables.
Dashboards have limited space, which is why tables that allow you to scroll, and sort are super handy.
▶️Watch the video:
⬇️Download Free Template & Step By Step Instructions
#excel
1
3
12
SUMPRODUCT: Beyond SUMIFS & COUNTIFS!
It's easy to think SUMPRODUCT is redundant now that we have SUMIFS, COUNTIFS etc., but that would be a mistake because can do things you can’t do with the 'IFS library of functions.
Check out the video:
#Excel
0
1
12
#Excel
Text Functions Cheat Sheet – Like You’ve NEVER Seen Before!
Have some fun mastering Excel text functions with this cats, dogs and ducks cheat sheet
Note: you can’t actually use images in the functions. It's just a fun way to explain how they work
#MicrosoftAmbassador
0
4
12
10 telltale signs that show you’re a chart amateur and how to take your chart game pro:
#Excel
#charts
#MicrosoftAmbassador
#exceltips
3
1
10
