
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 »
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 »
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 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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »