Links
Excel Custom Icons for Conditional Formatting
Andrew Excel shows you how to create custom icon sets for conditional formatting.
Improving Stacked Bar Charts in Excel
Depict Data Studio has some great advice on making your stacked bar charts easier to understand!
15 Must-Know Excel Shortcuts
Spreadsheets Made Easy shows you some Must-Know shortcuts in Excel!
Transpose Function in Excel
Hot Key Excellence explains the Transpose function.
Blanks vs Nulls in Power Query
Excel Guru talks about the difference between blanks and nulls in Power Query.
Excel Macro Button With Arguments
Excel Off the Grid shows you how to use macro buttons with arguments.
Importing and Exporting between SharePoint and Excel
How To Excel shows you how to import/export data between Excel and Sharepoint. This is great for collaborating with many users!
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!
UNIQUE Formula in Excel to Find Distinct Items
MrExcel shares details on the UNIQUE function to find distinct items within a list.
Techniques to Minimize Excel Frustration
Engineer Excel wants to help you avoid frustration in Excel!
Using Picture Transparency in Excel
MrExcel shares some tips about how you can use picture transparency in Excel.