Leila Gharani
@LeilaGharani
Followers
15,978
Following
93
Media
439
Statuses
618
#Excel #PowerBI Instructor, Microsoft MVP, Online Instructor, VBA, Data Visualization & Dashboard Enthusiast, MA Economics, Addicted to Learning.
Austria
Joined January 2016
Don't wanna be here?
Send us removal request.
Explore trending content on Musk Viewer
Dinero
• 181400 Tweets
DeNiro
• 145689 Tweets
Meyer Habib
• 135321 Tweets
Begoña Gómez
• 131016 Tweets
Lego
• 94736 Tweets
Sura
• 91647 Tweets
Blanche
• 82321 Tweets
Cannon
• 79144 Tweets
Guiraud
• 66891 Tweets
Angela Rayner
• 60951 Tweets
Meloni
• 54654 Tweets
Washed
• 54061 Tweets
Julie
• 49187 Tweets
Diane Abbott
• 42535 Tweets
#خادم_الحرمين_الشريفين
• 36987 Tweets
Riot
• 30107 Tweets
Dick Schoof
• 26875 Tweets
Faker
• 25628 Tweets
Ahri
• 23459 Tweets
De Luca
• 21895 Tweets
Juvinao
• 14206 Tweets
LOBA COM IFOOD
• 13203 Tweets
HMRC
• 12753 Tweets
Werner
• 12631 Tweets
Nunes
• 12386 Tweets
It's happening!
Python inside Excel is coming - no setup required! It's right there in the menu 🥳
Is this for the everyday data analyst?
Take this tour with me and see what's possible:
#Python
#TechNews
#Microsoft
#EXCEL
#anaconda
9
82
338
🤔 What is Power BI?
You see, there is a reason why companies are investing more and more in Power BI projects.
Actually, there are FOUR reasons why Power BI is preferred to the competition.
The video covers it all in plain English:
#PowerBI
#Microsoft
2
59
261
Excel's What-if Analysis Data Table allows you to quickly create simulations. This video gives a simple example of how you can create a Data Table.
Have you ever used this feature? It's nothing new. Has been there for years.
#excel
#tutorial
#Microsoft365
5
51
255
Behind-the-scenes of my upcoming YT video 🤪
It wasn't planned. Jordan Goldmeier was in town and we were talking about consulting, retainers, content and different ways of making money with
#Excel
skills.
So we decided to put it in a video.
In the video, I rated the difficulty
8
17
139
Quick preview on what Power Query can do for you.
Are you currently using PQ at work?
#MsExcel
#powerquery
#onlinecourse
7
16
113
Microsoft has a set of free useful tools that make your Windows experience so much better.
Not many people know if it and honestly the name doesn't do it justice.
It's like your Swiss Army knife for Windows:
#powertoys
#freeapps
#Microsoft
#Windows
3
21
110
When I speak to controllers about the charts they use in corporate reports, I usually get: "Just column, bar and line charts - 𝙗𝙪𝙩 𝙄 𝙬𝙞𝙨𝙝 𝙄 𝙘𝙤𝙪𝙡𝙙 𝙘𝙧𝙚𝙖𝙩𝙚 𝙘𝙝𝙖𝙧𝙩𝙨 𝙡𝙞𝙠𝙚 𝙏𝙝𝙚 𝙀𝙘𝙤𝙣𝙤𝙢𝙞𝙨𝙩"
And here it is! 𝟯
#charts
𝗳𝗿𝗼𝗺 The Economist
2
15
109
FINALLY! We get the Excel Functions We've Been WANTING!
These are for EVERYONE including Excel newbies.
Complex data analysis just became a piece of cake!
Are you as excited as I am?
#msexcel
#Excel
#Office365
5
16
98
There are some things we wished we could do in Excel.
Did you know you have access to absolutely FREE add-ins which can improve your reporting, data analysis and make your life a LOT easier? Check out my top 6 here:
#MsExcel
#Excel
#tutorials
2
23
92
Refueling is automatic when driving, but we often forget to recharge during work, especially in busy times. I learned this the hard way while building XelPlus. More insights here:
Many thanks to
@Forbes
,
@meganjbruneau
and
@dreamyhumans
for bringing
1
12
89
The YouTube Silver button has arrived! Thank YOU for supporting my channel by subscribing, commenting and watching!
#YouTubeCreatorAwards
17
0
82
Excel's new LET function can make your formulas easier to read. PLUS it can improve the performance of your formulas so they run faster.
Is that really the case? And when should you use this function? Find out:
#MsExcel
#tutorials
#excel
3
11
82
Creating Excel Dashboards can be very time consuming. But the visual representation of the data is just as important.
Check out these 4 Report design tips:
#MsExcel
#Excel
#tutorials
7
12
77
Thank you Microsoft! It's an honor to be featured!
March is
#WomensHistoryMonth
. It’s a time to remember the important role that women play in all aspects of society. A few of our
#OfficeInsiders
share their thoughts with us in honor of WHM:
@LeilaGharani
3
8
39
10
1
77
148 videos + 36 articles + 235 downloadable files = Ultimate Power Query Course =
Explore Excel's "Power" dimension so you can replace your manual and boring tasks with the click of the “refresh” button.
#MsExcel
#powerquery
5
10
74
Forget VLOOKUP - I hate to say it...but Forget INDEX MATCH. XLOOKUP will RULE!
I’m excited to announce XLOOKUP -- the successor to VLOOKUP, the most iconic spreadsheet function of all time.
35
435
1K
6
15
69
These simple Pivot Table techniques are used by advanced Excel users. They will take your data analysis to the next level!
#msexcel
#excel
#tutorials
#Office365
3
12
66
If you work in Accounting or you are a Finance professional, make sure you know these Excel formulas. They'll make your work life a LOT easier and they work in all Excel versions:
#msexcel
#excel
#Accounting
#Tutorials
3
11
67
I was surprised that VLOOKUP wasn't THE most common interview question for business analyst roles!
This video covers Excel questions people got who interviewed for Data Analyst, Business Analyst, Finance role and also senior positions:
#excel
#interview
2
10
65
Excel Pivot Tables might seem complex BUT they are one of Excel's EASIEST features to work with.
In 10 minutes I cover what you need to know to get started. You might discover hidden productivity tips as well:
#MSExcel
#ExcelTips
#tutorials
4
10
65
Office Scripts are the new way of automating boring tasks in Excel.
You can now attach these scripts to buttons and run them in Excel Desktop, Excel on Teams and Excel on the web. Check out this tutorial to find out how it works:
#Office365
#excel
0
6
64
Free POWER BI Course Preview is HERE!
It's only available for a short time:
Do you want to learn Power BI?
Now is your chance. Join the free preview and get your hands dirty with Power BI. After all it's the future.
#PowerBI
#microsoft
#learning
5
13
61
"Ideas" in Excel will provide you with immediate insights about your data. You can even directly ask it questions about your data using conversational language. It's the new
#ArtificialIntelligence
feature built into Excel:
#MsExcel
3
13
63
Drop-down lists are great. But lists with too many options can get annoying. Let's create multiple "searchable" drop-down lists - No VBA needed:
#MsExcel
#Excel
#Office365
3
13
61
Did you know you can create a fully customized email with an Excel FORMULA?!
You can even use cell references for mailto, subject and Cc and make it as dynamic as you need. This video will give you some ideas:
#excel
4
9
57
Creating a Pivot Table from multiple sheets is a task we all come across at some point. Don't use formulas to combine the data. Use one of the two methods shown here instead:
#excel
#offic365
#powerquery
#tutorial
3
5
57
When you need to quickly combine data from multiple sheets and a deadline is approaching....
#Excel
#Office365
#Productivity
#officework
3
6
56
It's an honor to be featured! Thank you
@OfficeInsider
!
Meet Leila Gharani (
@LeilaGharani
), a Microsoft MVP, content creator & Office Insider. We caught up with Leila to discuss her career in tech, what she thinks of the Office Insider program and more, in the August
#OfficeInsider
spotlight. Read More:
4
7
49
6
4
57
Learn how to use Microsoft To Do to get organized and never forget a task:
#tutorials
#Microsoft365
3
7
56
Did you ever need to convert a PDF document to Excel? You've probably noticed copy and paste doesn't work so well. There is a better way!
It even comes with a side benefit:
#MsExcel
#tutorial
#powerquery
#excel
6
7
53
Learning Power BI can be overwhelming! If you'd like a quick & free hands-on tutorial this is it.
You can download the practice files and follow along with me:
#powerbi
#BusinessIntelligence
#Microsoft
#MicrosoftEDU
2
7
53
Can you create barcodes in Excel by using a few Excel features?
I tested it with a scanner and it works (check out minute 4:20):
#MsExce
#Excel
#tutorials
5
7
52
Can you export your emails to Excel?
Actually it's very easy. The option is already in Excel. You create the connection once and then refresh your Excel table and get the latest emails in your sheet:
#outlook
#msexcel
#powerquery
#tutorials
6
9
51
Here's my list of the MOST USEFUL Excel Functions you need to know in 2021. That is if you have Excel for Microsoft 365 or are using Excel on the Web (which you can do with a free Microsoft account as well).
#excel
#msexcel
#tutorials
#microsoft365
1
8
53
Do you write IF functions in Excel?
What about the IFS function?
Does it really make writing nested IF functions easier? Let's find out:
#MsExcel
#excel
#tutorials
3
10
53
Most of us take notes in one way or another.
But are your notes readily available when you need them? Check out this video to start using OneNote effectively:
#onenote
#microsoft365
#Tutorials
3
13
53
Finding an Excel formula solution to get MULTIPLE matches for a lookup value is not easy if you don't have the new Microsoft 365 Filter function. Here's a complete guide, no matter which version you have:
Thanks to Bob Umlas for the suggestion.
3
12
49
How to properly use Microsoft Forms and connect the results automatically to Excel. You can add drop-downs, date pickers, number checks, star ratings, Likert scale, etc...
4
10
51
If you want to help your audience make sense of your Excel chart quickly, consider color coding it.
Quickly learn how to apply Conditional Formatting to your chart to show different colors for positive and negative deviations. Bonus tip included:
#excel
0
11
53
Did you know you can create a calendar in Excel with a single formula?
Is it a crazy formula?
It's actually quite simple:
#msexcel
#tutorials
#excel
2
5
51
Finally we get searchable drop-down lists in Excel with ZERO effort!
Thank you
@msexcel
Team!
Now we just need to make dependent drop-down lists easier....
#excel
#Office365
#Microsoft365
#news
4
13
52
Is there a "Bulk import PDF Files" button in Excel?
Yes. It's just called something else.
Have you used it?
#Excel
#powerquery
#tutorial
2
7
48
This is the last video in 2019!
Thank you for your support and wish you a great start for 2020!
8
3
48
Here's a quick trick that lets you combine two tables together and repeat the values of the second table inside the first table. You don't need copy paste. Nor do you need formulas. Guess what you need?
#Excel
#Office365
#tutorials
#powerquery
5
7
48
Starting point -> Large csv File,
Ending point -> Dynamic Map chart.
What's in between? Check out the full video:
#MsExcel
#tutorials
#powerquery
2
7
48
Finding useful websites can be tough.
In this video, I share 10 websites you REALLY need to check out! Some have been life-changing for me, some are great time savers, and some are just fun:
#websites
#usefulapps
#tech
#techtips
2
3
48
This is my
#MVPSummitMug
starting day 2 of
#MVPSummit
. This goes to
@WeAreHWF
for their focus on education, child protection and community development.
#MVPBuzz
1
3
49
Creating a PowerPoint presentation is time consuming!
These 5 hacks will make it a breeze:
#PowerPoint
#Microsoft365
#tutorials
1
9
45
The new Excel TEXTSPLIT function has some 🔎 hidden functionality . You can add in multiple delimiters, split words into rows and even combine it with other functions to internally sort text:
#Excel
#Office365
#tutorials
#msexcel
3
4
48
Have you updated your
#Excel
options?
Or did you just go with the default?
We tend to forget Excel has options you can tweak to better support your workflow.
#msexcel
#Office365
4
8
46
For decades Excel VBA has been the best choice for automation topics in Excel. But are Office Scripts here to replace VBA? Is VBA still relevant in 2021? In this video I'll share my thoughts about this topic:
#msexcel
#excel
#office365
#vba
#learning
1
10
47
We're looking for an experienced
#VideoEditor
! (full-time & remote).
We've had great success finding amazing people from our community. Now our
#editing
team needs to expand!
Apply today for our Video Editor role - link is here:
#HIRINGNOW
1
9
45
Sometimes you need to combine text and numbers in Excel:
It might be for dynamic headers or chart titles. Check out this video for simple ways, including a bonus trick not many people know of.
#excel
#msexcel
#office365
#tutorial
1
7
45
Working with time in Excel (for example summing time or calculating hours worked) can get tricky.... But it doesn't have to be:
#MsExcel
#Excel
#powerquery
1
9
45
Do you want to get started with Excel Macros & VBA? If you're not sure, and have 10 minutes to spare, check out this tutorial 👇🏼.
It shows a real world example of a simple macro in action:
#tutorial
#excel
#Office365
1
9
44
How would you bulk rename files on your computer?
What if you needed to rename files based on a logic - for example replace ID in the file name with its description?
Here's one way and it requires no "programming".
#Office365
#Excel
#PowerAutomate
2
4
44
How familiar are you with Excel Cell Modes?
Believe it or not, you've been using cell modes your entire Excel life, you just may not have realized it fully...
#MsExcel
#Excel
#Tutorials
5
10
44
Here are some cool PowerPoint features you might have missed: Did you know you can create your slides automatically from a Word document? Or add a live video feed to your slide?
This gives you a quick update:
#PowerPoint
#Office365
#HowTo
0
8
42
With this free Visio add-in for Excel, you can quickly create a flow chart or an organization chart in Excel.
No more SmartArt or manually drawing shapes - link it to data and just refresh the chart!
@msvisio
#Excel
#microsoft
1
11
44
Consolidating data from multiple Excel files requires you to have identical table headers or exact column order, otherwise you can run into the missing data problem. You CAN automate this process - it just needs a little tweak...
#Excel
#powerquery
3
3
42
TOO MANY EMAILS?
Manage your inbox so you can be more productive and less stressed! Here are some strategies and Outlook techniques you can use to get control over your inbox:
#Outlook
#email
#tutorials
2
4
43
Add this interactive report to your Excel dashboard if you want to make an impression!
It's interactive so the user can decide which TOP records they'd like to see:
#MsExcel
#microsoft365
5
12
43
Discover the 10 most useful features of Windows 10 (my favorite tips and tricks):
#Windows10
#Office365
5
10
42
With Recursive LAMBDAS in Excel, you can now loop through a list with ZERO coding. Imagine the possibilities! Here is one example for multiple word replacements:
#MsExcel
#Excel
#lambda
#tutorials
1
8
41
OneNote has a few hidden but very useful features. Here's my list of the top 5 surprising tips about OneNote that are easily missed:
#Tutorials
#OneNote
#Microsoft365
1
6
42
Check out this Power Query Hack that gets you two things:
1. A free video library (includes 300 tutorials)
2. A trick you can use to get a "hyperlink" data type in Power Query.
#learning
#powerquery
#msexcel
#office365
3
5
41
Generating Random data is often needed for testing or if you need to share a file with someone who shouldn't see your actual data. This tutorial shows different methods to generate random numbers in Excel (including no repeats).
#excel
#office365
1
7
40
🤔 What do you do when you're presenting a chart to the higher-ups and someone asks:
"Show me the Details behind that?"
You're lucky if it's a
#PowerBI
report:
#learning
#Microsoft
0
7
39
Conditional formatting in Excel can be tricky when you use the formula feature. How can you properly use conditional formatting to highlight a row based on another cell's value?
Check out the tutorial:
#MsExcel
#excel
#tutorials
1
3
41
Can you create a Word Cloud in
#PowerPoint
?
Add a live interactive quiz or a poll?
Yes, you can! You just need the help of free add-ins which you can directly install from the PowerPoint itself.
Here's a list of my favorite ones:
#Office365
2
7
39
🆕 A new feature is coming to Teams!
Excel LIVE allows you to share files in a Teams meeting like never before.
What's the difference with the standard window sharing?
Check out the video:
Let me know what you think.
#Excel
#MicrosoftAmbassador
#Microsoft
2
2
40
Sometimes being able to get more done just comes down to using simple tools like this one.
AutoHotKey is a free app that works on Windows. It lets you create your own shortcuts and automations:
#Productivity
#autohotkey
#windows
1
4
40
Quickly create interactive Excel Dashboards with radio buttons:
Did you know you can switch charts based on selection? You can even adjust the chart size if you have different number of categories for each chart.
#excel
#office365
#msexcel
0
6
39
Microsoft recently released Office 2021!
Is it worth upgrading from Office 2019 or 2016? Check out the new functionalities you get - especially if you use Excel!
#Excel
#office2021
#Microsoft
3
9
38
Discover the Roadmap to Engaging PowerPoint Presentations.
It’s one thing to have to sit through a boring presentation. It’s quite another to give a boring presentation:
#PowerPoint
#Presentations
2
7
38
My Top 10 Essential Outlook Tips:
My favorite is number 8!
What's yours?
#outlook
#emails
#tutorials
1
6
38
1
5
38
How can you calculate percentile and percentile rank in Excel? There's a simple function you can use. In this tutorial I cover what percentile is, the difference to percentage and how you can use it in your reporting.
#Excel
#Microsoft365
#Statistics
2
2
37
Did you know, you can create tasks in Planner directly from Excel? You can even allow the user to select the deadline of the task and the bucket the task should land in. There is no VBA or "coding" here:
#excel
#tutorial
#PowerAutomate
1
5
36
1
6
37
Do you often answer similar emails in Outlook?
Did you know you can save your replies as templates so you can use them whenever you need? You can do that directly in Outlook. Check out the video:
#tutorial
#Productivity
#email
#Microsoft365
1
8
37
How can you separate words in Excel? Split information in a single column into multiple columns? Extract numbers from the middle of a text string?
Discover the Easy (formula-free) way:
#MsExcel
#tutorials
#powerquery
1
4
37
This is my list of top 10 Excel Features (so not functions, just features) which are specially useful if you work in accounting:
#excel
#msexcel
#Accounting
#tutorials
0
5
36