Top 40 of the best Excel shortcuts you need to know
Almost everyone uses Excel in some form or fashion in the modern workforce, but many of us may be wasting a little too much time trying to format those pesky… Read more »
Author Archives: excelgoodies
Add Scroll bar to an Excel Chart
Scroll bars or Sliders on an Excel Chart are a great addition if you are building interactive Excel Reports and Dashboards. This guide will walk you through the steps in… Read more »
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 »
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 »