Oz has dedicated this episode to explaining the importance of ‘understanding data’. It is ...
- Home
- |
- Author: Jamani Arsalan
In this episode, Oz discusses the dos and don’ts of a sticky situation: when ...
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! ...
Isn’t it just frustrating to receive a copy-paste summary table that requires analysis? Yes, ...
There is always a set of problems we repeatedly run into as data analysts. ...
What to do when you are offered ghost peppers or Trinidad scorpion peppers? Which ...
Updating spreadsheets can be a pain, especially when you have to change all the ...
Surprisingly, tables are the most misunderstood and, hence, underused feature of Excel. While some ...
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, ...
You need to know when to be a contrarian: someone who breaks the rules, ...
We all know that for some problems, Protect Sheet tool under the REVIEW tab ...
We all aware of harnessing the power of VBA to dynamically sort dashboards based ...
Troubleshooting Excel workbooks of others can be mind-numbing, if not excruciating. There are various ...
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 ...
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. ...
It all started in 1978-79 with the introduction of VisiCalc. Or did it? It’s ...
It has been 30 years since Excel’s initial release, yet it is still relevant, ...
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 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 ...
It’s time to be brutal! And political-themed dashboards will take the brunt of it. ...
Many a times we want to include chart titles in our dashboards, but we ...
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 ...
Excel makes it possible for simple buy / not-buy or do / not-do financial ...
As frequent Excel users, we know the importance of absolute and relative references. On ...
As Excel experts, we are constantly in need of using complex formulas to get ...
Did you know you can indicate whether the user of your file is putting ...
Microsoft launched PowerPivot as a separate add-in for Excel 2010. And since then it ...
This episode sheds light on why people do or should get involved with Excel’s ...
This week’s special guest is Ken Puls. He’s a Certified Management Accountant who also ...
This episode’s special guest is an Excel expert, consultant, blogger and book author. Yes, ...
ModelOFF is a, annual, two-hour, online contest in which thousands of people from over ...
Excel consultants know that requirements gathering exercises can look deceptively simple. Whether that be ...
Excel is a data analysis and visualization tool. But is this all there is ...
Sometimes we have analyze or sort through data all of which is in a ...
When dealing with a small but complex set of calculations, it is very tempting ...
Most of us employ Excel to analyze data in search of some insights. For ...
People who work with PowerPivot a lot know the importance of dates to analytics. ...
Let’s say we just got handed a report in Excel and have been asked ...
We, as data analysts and Excel experts, are always trying to hunt down new ...
In high-pressured meetings with Chief Executives, no one would want to be seen as ...
What if there is a way to define new formulas in Excel without using ...
There might be times when you need to shuffle a list of distinct items. ...
Most, if not all, pieces of analyses in Excel employ the IF function numerous ...
We all know that VLOOKUP works to the right (of the column with the ...
Whoever has been tasked with making a dashboard ever knows that there are three ...
Done with your analysis and now you want to move your data somewhere ...
Clean presentation is one of the marks of an Excel expert. If you know ...
We all are aware of the basic methods of referencing worksheets in our VBA ...
Whenever one talks about the use of Excel in business intelligence (BI) and business ...
Being Excel gurus in your offices or Excel consultants to many different companies, you ...
We know that human error often messes up complicated calculations or elegant models set ...
Given a rich data set, making pivot tables and charts is amongst the first ...
Sparklines allow quick and easy visualization of data. These charts do not require you ...
You might be interested in starting up your own Excel blog for whatever reasons. ...
There are times when there is a need to cut down on the available ...
Have you ever tried to form a band but found it difficult to figure ...
Tired of googling how to convert inches into meters or how many liters a ...
In the post-apocalyptic world, can you visualize how much time would you have before ...
The analytics landscape is changing at a fast pace in this ‘bring-your-own-tools’ world. The ...
Getting stuck with having to learn new software for complex problems affects all of ...
Most of you must be familiar with Solver. It’s a built-in tool in Excel ...
After having written thousands of lines of codes over multiple sheets or modules, it ...
Have you ever wondered how to sort lists using 2nd word in each cell? ...
In this episode we discuss how to start your own Excel consultancy. If you ...