Formatting
Excel Formula Formatting Quick Tip
Learn the best Excel Formula Formatting technique so that you can quickly edit them in the future! You will use these simple techniques for all of your Excel Formulas going forward.
EXPLORE THE LIBRARY
Tips and Tricks
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.
Bar Chart
How-to Create a Stacked and Unstacked Column Chart in Excel
Stacked and Unstacked Column Chart in Excel Excel is awesome because, even when a certain chart type is not a standard option, there may be a way that you can create the type of chart that y
Chart
How-to Create a Dynamic Excel Chart of Last 3 Months Data Without Offset
Chart of Last 3 Months If you wanted to create a dynamic Excel chart of last 3 months of your data but didn’t know how to use or didn’t want to use the Excel Offset Function, then check out
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.
Challenge
Friday Challenge Answer – Find Unique Values from CSV List
Here is how you can quickly solve the most recent Friday Challenge: Find Unique Values from CSV List Before we begin, I am going to show you how to do this with some standard Excel features
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.
Challenge
How-to Easily Sum Across Excel Worksheet Tabs (Plus Friday Challenge)
Learn How you can Quickly and Easily Sum Across Excel Worksheets for the same Cells for every Excel Worksheets or Spreadsheet Tab