Excel In-Cell Charts
Excel In Cell Charts aren’t actually charts at all, insofar as you won’t find them in the Charts menu in Excel. They’re actually a formula that you can insert in… Read more »
Author Archives: excelgoodies
Excel 2016 updated with new PowerPivot features
Microsoft’s Excel 2016 remains the premier spreadsheet solution for anyone who needs a powerful tool for analyzing and presenting complex data. While limited spreadsheet viewing and editing is available in… Read more »
Top 10 Most Useful Excel Formulas
SUM, COUNT, AVERAGE SUM allows you to sum any number of columns or rows by selecting them or typing them in, for example, =SUM(A1:A8) would sum all values in between… Read more »
Applying Filters to your PowerPivot Data Model
Within the PowerPivot Data Model editor, you can also filter the data that is returned to Excel through the filtering option. HOW TO DO IT To can add a filter… Read more »
Using PowerPivot to Create Dynamics AX Dashboards
PowerPivot gives you all of the capabilities that the Pivot Tables have, plus more. With PowerPivot you can create pivot tables and charts, and also dashboards with multiple panels showing… Read more »
VBA Code Bank – Convert Excel to XML
We can use VBA to convert and Save the Excel File as XML file. This can be used in Excel 2003,2007,2010,2013. Example to illustrate the concept: use the following Excel… Read more »
VBA Code Bank – Get the Name of all SubFolders for an Outlook Folder
In this post, I am going to show you how to pull out the outlook’s subfolders name to Excel. When you use VBA in an Office Application, in this example… Read more »
Best Hidden Tricks in Microsoft Excel
Most of us are probably familiar with Excel, but not knowing the shortcuts and tricks can turn any simple spreadsheet into a long drawn-out process. We have put together some… Read more »
Secret Evaluate Function
Suppose you receive a spreadsheet with calculations, but the calculations are stored as text, for display purposes only, and not used to actually derive answers. Without wanting to reinvent the… Read more »
How to Add Notes to Powerpoint Slides using VBA
This snippet converts the TextBoxes / Shapes with Text that are available in PowerPoint Slide to Notes Section. Sub Export_TextBoxes_AsNotes() Dim oPPT As Presentation Dim oSlide As Slide Dim oSlideShape… Read more »