Jamani Arsalan, Author at Excel TV - Page 5 of 5

All posts by Jamani Arsalan

How To Drill Down in Pivot Tables Using Quick Explore

Given a rich data set, making pivot tables and charts is amongst the first tools we use to start analyzing that data. But what normally gives insight is how one drills down into the data: to find out hidden patterns or correlations or check for anomalies. Observing a striking phenomenon and then finding out the […]

Continue reading

How to Build Sparkline Charts in Excel – MS Excel Tutorials

Sparklines allow quick and easy visualization of data. These charts do not require you to go through the hassle of formatting chart axes. As shown in the picture on the right, Sparkline charts fit in a single cell. This allows for easy treatment and formatting, as will be explained below. They are also a cool […]

Continue reading

Tips For Starting An Excel Blog – Video Discussion with Excel Bloggers

You might be interested in starting up your own Excel blog for whatever reasons. But what would it be about? Our team of experts is here to deal with this topic and address your anxiety. Excel Blog Content Your blog can talk about features of Excel that you like and features that you do not. […]

Continue reading

Excel Chart Drop Down – Video Tutorial & Sample Download

There are times when there is a need to cut down on the available data to have a focused view or to make a decision. Or, we might want to create a live tool, such as that for a Dashboard. These are mainly achieved through solutions implemented in VBA in Excel. But … VBA is […]

Continue reading

Factorials In Excel – How To Calculate

Have you ever tried to form a band but found it difficult to figure out what possible combinations could be made? Well, the example seems a bit stretched. But we do face problems regarding arrangements and combinations in our everyday life. From choosing which friends to go to a concert with (since you were only […]

Continue reading

Convert Function In Excel – Video Tutorial

Tired of googling how to convert inches into meters or how many liters a gallon equates to? It is high time to stop being overwhelmed whenever you next face a unit conversion! And Excel is here to help. Szilvia Juhasz (aka XSzil) is there to teach us the ins and outs of this ‘where-were-you-all-my-life’ function. […]

Continue reading

Graph A Timeline In Excel – Video Tutorial & Download

In the post-apocalyptic world, can you visualize how much time would you have before the Grim Reaper shows on your doorstep? Well, you don’t have to worry about it now. Also, given that Oz du Soleil is here, you do not have to worry about making timelines. Oz is taking us through an exploratory (and […]

Continue reading

Role of Excel Users in Business – Excel Topic

The analytics landscape is changing at a fast pace in this ‘bring-your-own-tools’ world. The universe of data technologies has grown exponentially complex over the last few decades, particularly so after the introduction of Big Data concepts. In such a world, where does the role of an Excel user lie? Makes becomes of people like you […]

Continue reading

What Have You Conquered with Excel – Excel Topics

Getting stuck with having to learn new software for complex problems affects all of us. But have you ever wondered if a tool you’re already comfortable with could have helped you out? Yes, I’m referring to Excel. Knowing the possibilities of Excel can significantly alter the way we work. Our in-house experts have gathered here […]

Continue reading

Solver Samples already included in Excel – Excel Tips

Most of you must be familiar with Solver. It’s a built-in tool in Excel which helps you solve optimization problems like maximization of profit, minimizing cost of transportation, minimum cost staff scheduling etc. These problems are so widely encountered that people have made and taught specific samples to use when solving a specific type of […]

Continue reading

Finding VBA Definitions – Excel Tips

After having written thousands of lines of codes over multiple sheets or modules, it is already hard enough to remember which sub-procedure does what. On top of that, what if you want to use a particular sub-procedure but you don’t remember where it is defined? Surprisingly, you DO NOT have to Ctrl+F it in every […]

Continue reading

Cleaning Name Suffixes with Array Formulas

Have you ever wondered how to sort lists using 2nd word in each cell? Sounds a bit tricky, doesn’t it? But don’t you worry, Oz du Soleil is here to help. He uses a neat trick to sort out full names by the last names. The approach is interesting and can be modified to achieve […]

Continue reading

How to Start an Excel Consulting Business with Excel MVP Kevin Jones

In this episode we discuss how to start your own Excel consultancy. If you want to have your very own firm, what should be your first steps? And has the nature of problems clients need help with changed over the past decade? Join our in-house experts Jordan Goldmeier, Oz du Soleil and Rick Grantham and […]

Continue reading

Watch Excel TV LIVE

That’s Right, LIVE. Right here. We broadcast 20 times a year, 5 times a quarter. Usually every other Tuesday night at 9:05pm Eastern time. But instead of trying to remember which week and which time… just check this page and watch it right here. Episode 31 Dick Moffat from Dick Moffat’s Spreadsheet Blog https://dmoffat.wordpress.com/ The […]

Continue reading

ZACK BARRESSE & JON PELTIER – IN FOCUS – EXCEL INDUSTRY NEWS – WEEK ENDING 2014-07-08

News & Posts in the Excel Community Our expert guest from last week, Zach Barresse, has sent the Excel industry into a state of excitement. Along with Kevin Jones, he’s out with a book on Excel Tables. It’s a complete guide for creating, using and automating lists and tables. Jon Peltier has released Advanced Chart […]

Continue reading
1 3 4 5
>