Sales Excel Dashboard
An Excel sales dashboard which focuses on quarter and YTD data. It has a slicer and spins on a monthly combo box.
Read MoreUsing the Wildcard with SUMPRODUCT
The wildcard character and SUMPRODUCT are like oil and water, they just don’t gel well together. The beauty of SUMPRODUCT is somewhat tarnished with its inability to play nicely with the Wildcard * character. The focus of this article will be to demonstrate how to work around this constraint using a number of examples.
Read MoreExcel Dashboard by City
The following Excel dashboard is a trending dashboard which highlights some key organisational metrics by city. As the data is displayed by city I thought I might present the data with some infographics around the cityscape relevant to each city.
Read MoreExcel Timesheet Example
Creating an excel time sheet is easier with a template to start with. This blog post provides the template and the instructions for using it. Excel, Timesheet, template.
Read MoreWhen TRIM Doesn't Work in Excel
This article will focuses on what to do when the TRIM formula does not work as expected. It looks at alternatives to solve the problem.
Read MoreExcel Now Has 3D Pictures
Excel now has moveable changeable 3D image library just for you!!! Adding the library pictures to your reports is a simple task.
Read MoreUsing Index as a Dynamic Range
Creating a dynamic range formula without getting volatile. Using the INDEX formula in a creative way to make dynamic calculations.
Read MoreAdvanced Excel Skills
Excel advanced skills - what do you need to know to have advanced Excel techniques. The type of Excel skills that will help you be considered advanced amongst your peers. These Excel skills are a great place to start.
Read MoreExcel Dashboard Reports and Courses
Excel Dashboards can make life a lot easier when they are ready made. Take the design and structural setup out of the dashboard process and purchase these premium Excel Dashboards.
Read MoreConvert Formula to Relative or Absolute
Convert an Excel range from one reference to relative or absolute referencing.
Read MoreConvert Entire Excel Workbook to Values
Convert an entire workbook from formulas to numbers instantly.
Read MoreEvaluate with Excel to Extract Sequence
Use the Evaluate function in Excel to populate a cell from a number sequence.
Read MoreExtract the First Item from a Horizontal List
In Excel extract the left most item from a horizontal list using INDEX and MATCH.
Read MoreCreate Number Sequence with VBA Custom Function
An Excel custom function that allows sequental number sequences to be created.
Read MoreProtect a Worksheet, Use the Autofilter
Protect an Excel worksheet and use the auto filter. A how to guide.
Read MoreExcel VBA to Select Sheets
Excel VBA to select sheets and print out the selected sheets using PDF.
Read MoreNew Excel Dashboard Tools
This is a list of Excel dashboards - the best I have produced to date. These are time saving Excel tools which you can purchase from Eloquens.
Read MoreFeatured Posts
Recent Posts
Split File into Parts and Save to Directory April 20, 2024
Most Popular Author December 14, 2023
Creating an Excel Dashboard - A Guide with Templates December 8, 2023
Real Estate Excel Dashboard October 11, 2023
Updating Excel Dashboards September 29, 2023
TheSmallman in Another Top Blog Rank April 24, 2023
Project Tracking Dashboard March 25, 2023
Excel Unique Formula September 17, 2022
Horizontal Range to Vertical Range in Excel June 15, 2022
Hiding Rows Quickly with VBA May 20, 2022