top of page
Search
Spreadsheet Nation
Oct 6, 20211 min read
Sort by Custom Color List
Sort you data by multiple colors.
49 views0 comments
Spreadsheet Nation
Oct 2, 20211 min read
Dynamic Drop-Down List
Create a drop-down list that changes.
90 views0 comments
Spreadsheet Nation
Apr 29, 20201 min read
Custom Sort
Learn how to create a custom sort for your data.
32 views0 comments
Spreadsheet Nation
Mar 7, 20201 min read
Date Formats in Excel
Display the date in different ways in Excel.
32 views0 comments
Spreadsheet Nation
Nov 15, 20191 min read
MID Function
Learn how to return text from the middle of a text string.
45 views0 comments
Spreadsheet Nation
Nov 1, 20191 min read
Excel Find and Select Blanks
Find and Select blank cells in a data set.
61 views0 comments
Spreadsheet Nation
Oct 28, 20191 min read
Print Titles
Print column and row titles on each page when printing out a spreadsheet.
13 views0 comments
Spreadsheet Nation
Oct 5, 20191 min read
Excel Combo Chart
Add a secondary axis to graphs with a Combo chart.
28 views0 comments
Spreadsheet Nation
Sep 27, 20191 min read
Excel Drop-Down Lists
Create a drop-down list in a cell.
22 views0 comments
Spreadsheet Nation
Sep 20, 20191 min read
Remove Duplicates
Remove duplicate items in a list.
25 views0 comments
Spreadsheet Nation
Sep 13, 20192 min read
Time Calculations
Calculate the difference between two times with Excel
32 views0 comments
Spreadsheet Nation
Sep 4, 20192 min read
Freeze Panes
Make a row and/or column stay in place when scrolling in Excel or Google Sheets.
17 views0 comments
Spreadsheet Nation
Sep 3, 20193 min read
Excel Auto Fill Options
Make Excel fill out data automatically based on patterns.
32 views0 comments
bottom of page