Video Archives - Page 4 of 13 - Excel TV

Archive Blog Archives

Dynamic Labels – Excel Dashboards Tips

Many a times we want to include chart titles in our dashboards, but we don’t since they are not dynamic. If your user changes some filters, you would want your pivot chart titles to update automatically. Well, there is a way to actually do that, to make these chart labels truly dynamic. And Excel MVP […]

Continue reading

Excel File Naming Conventions – Name Style Rules

Naming your Excel files is something which doesn’t get any coverage of any of the Excel blogs out there. And many, if not most, people do not feel that file names are something to put a thought into. But time and again we are lost looking for a spreadsheet that we really need or are […]

Continue reading

How to Deliver Excel Training

This episode is around discussing tips on delivering Excel training. In our panel of experts we have Oz du Soleil, Jordan Goldmeier and Rick Grantham. And they are joined by our special guest Keidra Chaney. Keidra has 7 years of experience training people in Analytics at various levels. Let’s get on with it! 1 – […]

Continue reading

NPV Calculator and IRR Formula in Excel

Excel makes it possible for simple buy / not-buy or do / not-do financial decisions very easy to arrive at. The underpinning concept behind making such decisions is that a dollar tomorrow is worth lesser than a dollar today. That’s right, it’s because of the additional return you can get by “investing” a dollar today. […]

Continue reading

Command + T To Cycle Through Excel Cell References On A Mac

As frequent Excel users, we know the importance of absolute and relative references. On Windows operating system, one can use the F4 key to turn cycle through absolute and relative references, and everything in between. But there are a lot of users who use Excel on MAC and are clueless about how to access the […]

Continue reading

Data Parsing in Excel Using LEN and SUBSTITUTE function – HOT Tips

Analyzing and parsing data in Excel is really a tedious task. If it is not done smartly, then we end up in doing lot of mess. For example, say you have list of email addresses in Excel and you want to extract the extensions of those email addresses. Most of us think of using Text […]

Continue reading

Documenting Complex Excel Formulas with Mike “ExcelIsFun” Girvin

As Excel experts, we are constantly in need of using complex formulas to get tasks done faster and elegantly. But this can prove to be troublesome for the users if they want to understand the formulas or change something in them. One solution is to use comments extensively, but they can become messy really quickly. […]

Continue reading

Data Validation with Wingdings

Did you know you can indicate whether the user of your file is putting in the right information or not? And that too without using ‘Data Validation’ tool or ‘Conditional Formatting’? Sounds unbelievable, but it could definitely be done. And the advantages are straight-forward as well. Firstly, you do not have to use volatile conditional […]

Continue reading

Relationships Between Linked Tables in Excel

Microsoft launched PowerPivot as a separate add-in for Excel 2010. And since then it has become an integral part of any data analyst’s toolkit. The immense “power” of this tool comes from the fact that it can aggregate data from related but distinct tables into one pivot table. Don’t worry if you’re slightly confused, Oz […]

Continue reading

Creating Random Data in Excel using RANDBETWEEN and CHOOSE

Many times we are in need of random data. Suppose, if you are doing some tutorial on Excel formulas, then we need to have random data in your Excel sheet. There are many situations in the same way and when we are in need of some random data, we generally use some websites that helps […]

Continue reading

Excel MVP Program – Excel Community Involvement

This episode sheds light on why people do or should get involved with Excel’s online communities and what has Microsoft’s MVP program achieved. Our special guest for this episode is Kari Finn, Manager of MVP Community at Microsoft. What are we waiting for? 1 – Sharing Excel Expertise Online Being good at a particular technology […]

Continue reading

Power Query Book Author Ken Puls – Excel Expert Interviews

This week’s special guest is Ken Puls. He’s a Certified Management Accountant who also runs ExcelGuru.ca. His recent accomplishments include a book on Power Query titled “M is for (Data) Monkey” and a video training endeavor “Power Query Training” which offers an online workshop for first-time Excel users and a digital version of the book. […]

Continue reading

Excel Power User’s eBook Released – Excel News 2016-03

Excel.TV News & Articles Chris Newman of TheSpreadsheetGuru.com joins Excel Expert Interview with Excel TV host Rick Grantham and cohosts Excel Author Szilvia Juhasz and Microsoft Excel MVP Jordan Goldmeier on Excel TV. Excel expert Oz explains us how to use Table as structured reference to summarize data. Our very own Oz du Soleil, an […]

Continue reading

Chris Newman of TheSpreadsheetGuru.com – Excel Expert Interviews

Chris Newman of TheSpreadsheetGuru.com  joins Excel TV host Rick Grantham and cohosts Excel Author Szilvia Juhasz and Microsoft Excel MVP Jordan Goldmeier on Excel TV. What Is Chris Macro? Rick: Chris Newman AKA Chris Macro AKA Mr. TheSpreadsheetGuru, I have to ask you, where did the Chris Macro name come from? Chris: Chris Macro was a […]

Continue reading

Excel Tips – Tables and Structured References

Excel Tables arranges data in a structured way in rows and columns. When you have data as output of some analysis then showing it in Excel Table is my suggestion. It makes us easy to work on that data to further process our analysis. In this tutorial Excel expert Oz explains us how to use […]

Continue reading
>