-
Categories
Top Posts
- How to format dates that are over 1 year old to turn red in Excel using conditional formatting.
- How to Format Dates In Excel That Are Over One Year Old To Turn Red, Yellow If Eleven Months Ago, And Green If Between One and Ten Months Ago
- Access Input Mask Cheat Sheet
- How to Use Excel Traffic Lights with Conditional Formatting Dates
- Shrink to Fit Word Document on One Page
Tag Archives: excel
Fill in Blank Cells with the Values Above in an Excel List [Video]
This video shares a cool trick for Excel lists. Sometimes when you import an Excel file you get blank values that need to be filled in. This video will share with you how to save time in accomplishing the tasks. … Continue reading
Using Excel’s GETPIVOTDATA formula to build a report outside of a Pivot Table [Video]
This video post will share with you an Excel trick on using the GetPivotData formula.
Sort Rows By Color in Excel
Since Excel 2007, cells can be sorted by color. All you need to do is right click a cell that has the color fill or font color you desire to be on top. Then choose “Put selected color on top”. Below … Continue reading
Save Time opening up recent files in the BackStage View of Excel, Word, and PowerPoint 2010
The BackStage view in Office 2010 is awesome! Pin a recent file or folder to the list of recently opened items. Take a look at the following screenshots from PowerPoint, Word, and Excel. Notice the pins I clicked to promote … Continue reading
Easily Import an Excel Spreadsheet into an Access Database with the help of the wizard
1. Click the External Data tab, then click the Excel command within the Import & Link group. 2. Click browse and go and navigate to your Excel file that you want to import. 3. Click on the spreadsheet you want. … Continue reading
Use Data Bars and Icon Sets to Major League Baseball Standings using Excel 2010
I believe that one of the best tools available for visualizing data within an Excel spreadsheet is conditional formatting. This post will feature what you can do with data bars and icon sets. See my earlier my post on how … Continue reading
Create a Pie Chart in Excel
Step 1: Gather your data and enter it in a list format (without blank rows). Step 2: Click on a cell that is within the group you wish to chart, then click the Insert Tab–>Pie button. Pick a choice from 2D … Continue reading
4th of July Celebration in an Excel Spreadsheet
I set out to create an American flag in an Excel spreadsheet in celebration of the 4th of July. Download my 4th of July.xlsx Excel spreadsheet to see how it turned out. The command tool buttons I used to create the US … Continue reading
Find Duplicates in Excel Easily with Conditional Formatting
Whenever you think you might have some duplicate entries in Excel, run a quick check with Excel 2007/2010 conditional formatting. Step 1: Select the data Step 2: Click Conditional Formatting–>Highlight Cell Rules–>Duplicate Values… You will then have a chance to … Continue reading
Measure growth using a formula in Microsoft Excel
Want to track how well your business is growing? You can with a growth formula. To get started, enter data from two comparable periods. For example, you might want to see income growth from year to year, or new customers from month … Continue reading
Steve Chase Docs