How-To
How-to Fix a FRUSTRATINGLY Annoying Excel Scroll Lock Issue
Find the quickest way to Stop this disgustingly horrible issue with Microsoft Windows and Microsoft Excel
EXPLORE THE LIBRARY
Tag: Tips and Tricks
Email
New Feature Excel Flash Fill Use it for Quick Data Retrieval and Formatting
Use a great new feature of Excel 2013 and Excel 2016 - Flash Fill - to save time getting your data from text strings. Read the article now and save a ton of time!
Align
Quickest Way to Select and Align Charts for an Excel Dashboard
Select and Align Charts for an Excel Dashboard Creating dashboards can take a lot of time. With this simple technique that I just learned, you can quickly select and align charts for your f
Chart
Create Dynamic Excel Chart Conditional Labels and Callouts
Learn this SIMPLE executive dashboard chart trick for conditional labels and callouts so you can QUICKLY identify individual data points.
How-To
Alternate Ways to Select Large and Non-Contiguous Ranges in Excel
Learn how to use alternate techniques to select very large ranges in Excel and also another way to select non-contiguous ranges.
Chart
How-to Copy a Chart and Change the Data Series Range References
Learn several techniquest to Copy a Chart and modify the copy of the chart to change the data series range references to a new area in your worksheet.
Chart
How-To Copy an Excel Chart on Same Worksheet with a New Data Reference
This quick tutorial will show you how-to copy an Excel Chart on Same Worksheet such that it uses a new data reference instead of the original reference.
Chart
Stop Excel Overlapping Columns on Second Axis for 3 Series
If you have 3 series in an Excel Column Chart and move one to the Secondary Axis, learn the trick on how to Stop Excel Overlapping Columns on Secondary Axis
Hour
Calculating Hours Difference of Time in Excel Spreadsheets
When working with Time in Microsoft Excel you may have noticed that there is a problem when you subtract certain numbers. Excel gives you an error, but it doesn’t look like an error. Excel
Array
Advanced Excel Summation Skills – Using ARRAY Formulas to Check for Multiple Criteria
In this post, I will show you another Excel summation technique that you can use to evaluate criteria and then sum the data based on that criteria. Three posts ago, you received a challenge