How To Index

Listed below are all my "how to" articles explaining how to perform an action, how to use specific functions, how to create complicated formulas to perform a specific task, and how to create VBA macros to automate repetitive processes. See 76 of my best Excel Tips in my ebook, available in Kindle and PDF formats.

Actions: How To

• Count by increments
• Combine two cells
• Count unique values in a row or column
• Make a random list
• Check for duplicates entries
• Make a drop down list
• Insert the degree symbol
• Change the worksheet tab color
• Create bullet points
• Make horizontal rows into vertical columns manually
• Change the default number of sheets
• Align multiple charts
• Keep Excel drop down list arrows visible
• Hide gridlines in Excel
• Add checkboxes / add buttons / hide checkboxes / hide rows NEW!

Functions: How To

• Use the IF function
• Use the LEFT, RIGHT, LEN functions

Formulas: How To

• Make a contain formula
• Create a two variable lookup formula
• Compute the total number of configurations
• Create a week ending date formula
• Check for common mistakes (when a formula is not working properly)
• Use Nested IF formulas
• Count the remaining days until the end of the month
• Count characters in a string
• Transpose a row into a column with a formula
• Assign a letter grade to a number
• Find the most common name in a range
• Avoid displaying errors
• Skip the weekends date formula
• Dynamic Lookup (VLOOKUP and MATCH)
• Convert military time to regular time
• How to create a hyperlink formula to add subject to email

 

VBA Macros: How To

• Getting started with Excel macros <---Start here
• Automatically enable macros
• Create a pop-up message box
• Simple Excel macros to help you learn
• Copy a range
• Clear rows with a macro
• Email an Excel spreadsheet through a macro
• Organize your Excel macros
• Highlight duplicate rows without deleting them
• Save an Excel file through a macro
• Copy and Paste cell value only
• Capitalize letters in a name
• Create a delete button
• How to import data from one Excel file into another
• Make folders from spreadsheets with hyperlinks
• Increase macro speed NEW!
• How to add conditional formatting with a macro NEW!
• How to attach image to email from Excel NEW!

Video Tutorials: How To

• 11 Best Videos to Learn Excel
• Combine Excel sheets
• Make Alternating Row Colors
• How to enter and convert military time into regular time in Excel
• How to link a cell to a textbox
• 3 ways to cross out words in Excel 
• How to highlight duplicates - the quick and easy way 
• How to restrict a cell to only date values NEW!

Misc. How To

• Convert Excel to PDF file
• 20 Excel Shortcuts you need to know. Number 15 is my favorite.
• 11 Excel lessons from the best March Madness brackets
• Send emails with custom subject lines

Last updated: 3/22/22