Month: October 2018
REPT Function to Repeat in Excel
Excel Solutions shares a little known formula that helps you repeat strings – REPT.
Custom Tab for Macros in Excel
Contextures has a custom tab to display all of your macros!
Use VBA to Control Header in Excel
Leila Gharani shows you how to use VBA to control the Header in your Excel file.
Techniques to Minimize Excel Frustration
Engineer Excel wants to help you avoid frustration in Excel!
UNIQUE Formula in Excel to Find Distinct Items
MrExcel shares details on the UNIQUE function to find distinct items within a list.
Using Picture Transparency in Excel
MrExcel shares some tips about how you can use picture transparency in Excel.
Scatter Plot Tutorial
Able Bits has a great tutorial on how to create scatter plots in Excel.
2018 College Football Helmet Schedule Spreadsheet
Excel Spreadsheets Help shares a spreadsheet that contains the college football schedule, indicated by helmets. I’m posting it a bit late, but give it a look!
ExcelGuru Challenge #3: Completed in Style!
Oz responds to Excel Guru’s challenge with his own unique style.
Protect Your Worksheets
Everyday Office shows you how to protect the integrity of your worksheets when other users need to enter data.
Random Values or Text in Excel
ExcelJet shows you a few ways to generate random values or text within Excel.
Inspect Excel Formulas With F9
Excel Exercise shows you a very useful way to inspect your formulas!