The Magic of PivotTables
Excel PivotTables: It’s a polarizing term. People who use PivotTables absolutely love them. For those who don’t, the term is mysterious and encourages the fear of powerful features that are the domain of geeks and Excel junkies, and out of reach to the common man. But nothing could be further from the truth.
Why You Should Take This Course:
If you’ve never created, or don’t regularly use PivotTables in your work, let me show you that you are missing out on one of the most useful, impressive and easy-to-use tools in Microsoft Excel.
Excel PivotTables are an amazingly powerful feature that can be used to very quickly summarize and slice and dice data with ease. And contrary to many users’ fears, they are actually VERY easy to use once you’ve been shown how.
So why don’t you let me do just that? In this one hour video training course, I will teach you how to build your first PivotTables. You’ll see first hand just how easy they are to create, how fast they work, and how easy it is to change them to display your data the way you want to see it.
...
Knowledge Base Articles By Category
Recent Forum Posts
Picking up multiple xml files on JSON web service
Solved it myself:
conor Yesterday, 06:05 PMYou must concatenate the text to the web address string, so:
filename as text
Source = (Web.Contents("https://reports.sem-o.com/documents/"&filename)),...