How to Create a Drop-Down List in Microsoft Excel – TurnerTime tutorial
Watch the tutorial linked below: https://www.youtube.com/watch?v=7vCTWcTcC7M
How to Convert Number to Round Up and Display Two Decimal Places (Excel)
There may be times when a number (or result of a calculation) has more than two decimal places. You can tell excel to display only 2 decimal places, but the full number with all the decimal places will be displayed…
How to Use “Conditional Formatting” to Identify Past Due Dates (Excel)
You can set Excel up to use today’s date (or any date), to identify past due dates and change the color of the past due text to a different color. This process is showing on Excel 2016 but works on…
This post is only available to members.
How to Record and Use a Simple Macro (Excel)
A Macro is just a recording of keystrokes. It can be used for an unlimited amount of tasks. The best thing to remember when recording is the shorter the better. You will want to record smaller Macros that can be used in…
How to Force Text to Appear on a New Line Within a Cell (Excel)
When typing text into a cell in Excel you may have reason to start a new line. There is a keyboard shortcut to force the text on the next line in Excel. You can also separate existing text but putting the cursor…