Artificial intelligence (AI) technology advancements have improved efficiency in different work environments. This has ...
- Home
- |
- Category: Excel Tips & Tricks
Have you ever encountered a problem in Excel where a column of numbers or ...
Are you tired of manually editing your Excel spreadsheet data? Do you want to ...
Excel is an incredibly powerful tool, allowing users to organize and manipulate data in ...
Microsoft Excel is a powerful tool used for organizing, analyzing, and manipulating data. While ...
Are you tired of staring at a boring Excel spreadsheet? Do you want to ...
Excel is a powerful spreadsheet software that has been around for decades and is ...
We all use Excel Spreadsheet and Microsoft Word document every time and we use ...
Introduction Welcome back to another episode of Excel.TV where Oz du Soleil shares his ...
Howdy Folks. It's great to be back. One of our most popular blog posts ...
Turn any image into an Excel file? Ever think about turning your face or ...
Introduction This week, we take a departure from our normal Excel tips and focus ...
How to Make Excel Faster Friday Fire is back with an all new episode ...
This is our second year doing our reader survey. Late in 2017 we asked ...
Oz has dedicated this episode to explaining the importance of ‘understanding data’. It is ...
As you know, Excel.TV has partnered with Logitech to let you know all about ...
In this episode, Oz discusses the dos and don’ts of a sticky situation: when ...
Hi there, it’s Jordan — back again to talk about the Logitech CRAFT keyboard, ...
Rick: Next up is our special guest Jon Acampora. You may remember Zack Barresse ...
Nick Green of EchoXL.com joins Excel TV host Rick Grantham and cohost Microsoft Excel ...
Hello Excel.TV fans! As you know, Rick and I have been working super hard ...
Rick: Welcome to our special guest straight out of Canada, Mr. Ken Puls of ...
The theme of today’s episode is about finding better ways to get the job ...
Today we have a live coverage all the way from our reporter Carl Pepperseed! ...
There is always a set of problems we repeatedly run into as data analysts. ...
If we think about how Excel gurus solve problems in Excel, clearly the technical ...
This week’s episode is around fail-safes, that is, preparing for the worst! Of course, ...
Bill Jelen Microsoft Excel book author and Mr. Excel blog joins Excel TV host ...
You need to know when to be a contrarian: someone who breaks the rules, ...
Happy New Year everyone. It’s that time of year. The gyms are packed. 2016 ...
Howdy everybody. Happy New Year. It’s noon, so I’m awake now. 2016 was quite ...
When I teach how to develop dashboards in Excel, I'm often asked if the ...
We all know that for some problems, Protect Sheet tool under the REVIEW tab ...
Troubleshooting Excel workbooks of others can be mind-numbing, if not excruciating. There are various ...
This is our first year doing a reader/viewer survey. I figured it would be ...
This week’s episode is dedicated to the rarely missed, often forgotten and historically unnecessary ...
In many situations, particularly when it comes to inventory management, there is a need ...
The 2016 Presidential Election Map is Now Available This was first created 4 years ...
Written by Bjoern Stiel APIs are the lifeblood of the internet, providing access to ...
How a person approaches Excel project work is heavily ingrained in his or her ...
Keyboard shortcuts, quite surprisingly, are a blessing and a menace at the same time. ...
Microsoft Excel allows us to show any complex data in an easy way. You ...
It all started in 1978-79 with the introduction of VisiCalc. Or did it? It’s ...
John Michaloudis of MyExcelOnline.com joins Excel TV host Rick Grantham and cohost Microsoft Excel ...
It has been 30 years since Excel’s initial release, yet it is still relevant, ...
Imagine a situation where in you applied some border, changed font color, did something ...
Join us on Tuesday August 16th for our upcoming webinar series with Excel TV ...
Analytics Landscape Even though the Analytics landscape is growing increasingly complex, imagining a future ...
For all the gaming aficionados out there, this week’s topic will surely hit it ...
We all know that Excel Ribbon has tabs like Home, Data, review, Insert and ...
We all know that Modern Excel is impacting our everyday lives. But the question ...
Welcome to Excel Podcast 101! In this week’s episode we will cover everything you ...
Naming your Excel files is something which doesn’t get any coverage of any of ...
This episode is around discussing tips on delivering Excel training. In our panel of ...
As frequent Excel users, we know the importance of absolute and relative references. On ...
Did you know you can indicate whether the user of your file is putting ...
Many times we are in need of random data. Suppose, if you are doing ...
This episode sheds light on why people do or should get involved with Excel’s ...
Each month, we’ll introduce you to up-and-coming and new-to-the-scene Excel and data analysis blogs. ...
Are you fond of using Dashboards in Excel? I know you would say “Yes” ...
Excel is a data analysis and visualization tool. But is this all there is ...
As we kickoff this new year of Excel.TV, we’re proud to pioneer the new ...
Ginger Grant, an Excel Trainer, blogger and PASS Business Analytics Conference speaker focusing on ...
Have you ever faced problems while making copy of buttons in Excel? We normally ...
Paige Takes Us Into Her World Paige Worthy is based in Chicago and is ...
In this universe of crowded excel shortcuts, let me share with you five less-known ...
Have you ever thought to change text color and font in Excel? Till now, ...
In previous episode Excel Author Jordan Goldmeier challenged you on ColorIndex property. Did you ...
Have you answered the previous Excel challenge on Financial question in Excel? In this ...
EDIT: Unfortunately, the deal has ended. I’m writing this from my car on my ...
In a previous tip, I had complained about form control option buttons. I had ...
It’s time! Excel in the Wild has started. We’re taking conversations about Excel and ...
So let’s take a look at your standard form control option buttons. In the ...
Just In Time for Excel Black Friday Shopping Frenzy!!! Join Excel TV host Rick ...
Join Jon, Jordan and Rick in a game of “Wait Wait Don’t Excel me!” ...
Whenever one talks about the use of Excel in business intelligence (BI) and business ...
Jordan Asks A Question Without Knowing The Answer? Jordan starts out the segment by ...
Being Excel gurus in your offices or Excel consultants to many different companies, you ...
Google Is Your Friend Never thought I would type those words. 🙂 Excel MVP ...
One of the benefits of being Bill Jelen (Mr Excel) is that people send ...
Using Ampersand Formula In ExcelExcel MVP Jordan Goldmeier notes that although this quick tip ...
Excel Games Excel TV co-host Szilvia Juhasz is known for her creativity and talent. ...
Unfulfilled Promises? And the Sad Reality of Forgotten Bloggers There was blog post by ...
Have you ever tried to form a band but found it difficult to figure ...
The analytics landscape is changing at a fast pace in this ‘bring-your-own-tools’ world. The ...
This doesn’t have to be difficult. It doesn’t have to be hard. No need ...
Getting stuck with having to learn new software for complex problems affects all of ...
Before the memories of the PASS Business Analytics Conference 2015 completely fade away, I ...
In our last episode, Jordan asked… “Before they were called Excel Tables, what name ...
Ever taken over someone’s spreadsheet? Sure you have. And I’m not talking about those ...
At the PASS Business Analytics Conferences, I spoke about building better Excel models. Some ...
2015 PASS BA ConferenceThe PASS BA Conference will be held on April 20-22, 2015 ...
Not long ago, Microsoft had an update to Excel that broke a lot of ...
In this episode we discuss how to start your own Excel consultancy. If you ...
How Do You Solve Problems? What are the intangibles? Passion? Learning a foreign language? ...
If you’re in the Ohio Miami Valley, then don’t miss my Advanced Excel for ...
In a previous episode, Mr Excel joined us and during the discussion, he offered ...
Hello All! Hope you all are doing well. Excel MVP Jordan Goldmeier is back ...
Excel Trivia Four Excel MVPs test their Excel knowledge in this competition. Excel trainer ...
Excel Debate Rick took the week off. And when the cat is away, the ...
When I first started this blog, I thought to myself: VBA is wonderful and ...
I’m often asked this question, so I’ve decided to give my thoughts on ...
Is it OK to just be good enough at a tool? (heh, heh… he ...
You would think this would be an easy one. Just hit wikipedia, right? But ...
ModelOff 2014 came to a close on the evening of Sunday 7DEC, and Diarmuid ...
Back to regular life… We had such a great time at ModelOFF, it’s hard ...
I am sitting in the Modeloff FINALS Ceremony. First things first… Smart group of ...
Today is the day of the final test for the sixteen competitors. Rick took ...
Quick question… What self-described introvert is headed to #Modeloff, gets upgraded to first class, and ...
It’s 12:14am and I’m up preparing for the 2014 ModelOff that’s happening this weekend in ...
Hello everyone! I’m releasing chapter 3 from my new book, Advanced Excel Essentials, for free! ...
In Chapter 1 of Advanced Excel Essentials, which does Jordan argue that you should ...
If you have watched any Excel.TV episodes, then you are very aware of my ...
Take your Excel skills to the next level! Advanced Excel Essentials can be ...
What is Monte Carlo Simulation?Monte Carlo Simulation is a process of using probability curves ...
Welcome back friends! MVP Jordan Goldmeier has got an awesome Excel challenge for you ...
This week MVP Jordan Goldmeier is back with an interesting Excel challenge. We all ...
Add-Ins are a great way to increase Excel’s firepower. Add-Ins not only add additional ...
Drop down lists in Microsoft Excel are great for ensuring that you enter accurate ...