Excel Pro Tips
How to Make a Bulleted List in Excel (5 Simple Tricks)
Learn how to make a bulleted list in Excel using shortcuts, CHAR function, symbols, custom formatting, and SmartArt options easily.
Read article
Excel Pro Tips
555 articles
Excel Pro Tips
How to Transpose a Matrix in Excel (3 Suitable Ways)
Learn how to transpose a matrix in Excel using Paste Special, the TRANSPOSE function, and Power Query with easy step-by-step methods.
Read article
Excel Pro Tips
How to Calculate Inverse Matrix in Excel (3 Different Ways)
Learn how to calculate an inverse matrix in Excel using the MINVERSE function and VBA with step-by-step guidance and examples.
Read article
Excel Pro Tips
How to Group Rows and Add Subtotals in Excel (3 Examples)
Learn how to group rows and add subtotals in Excel using the Subtotal feature, SUBTOTAL function, and create multi-level summaries easily.
Read article
Excel Pro Tips
How to Create a Button Without Macro in Excel
Learn how to create a button without macro in Excel using shapes and the Developer tab for easy sheet navigation.
Read article
Excel Pro Tips
How to Create a Table of Contents for Tabs in Excel
Learn how to create a Table of Contents for tabs in Excel using HYPERLINK, context menu, Power Query, buttons, and VBA.
Read article
Excel Pro Tips
How to Break Links When Source Not Found in Excel
Learn how to break links when source not found in Excel using Workbook Links, Find and Replace, paste values, and VBA methods.
Read article
Excel Pro Tips
How to Create a Search Box for Multiple Sheets in Excel
Learn how to create a search box for multiple sheets in Excel using FILTER, VSTACK, ActiveX controls, and dynamic formulas.
Read article
Excel Pro Tips
How to Do Matrix Multiplication in Excel (3 Suitable Ways)
Learn how to do matrix multiplication in Excel using MMULT, SUMPRODUCT, and TRANSPOSE functions with clear examples.
Read article
Excel Pro Tips
How to Combine Date and Text in Excel (4 Suitable Methods)
Learn how to combine date and text in Excel using CONCAT, ampersand, TODAY, and TEXTJOIN functions with clear examples.
Read article
Excel Pro Tips
How to Bold Text in a Concatenate Formula in Excel
Learn how to bold text in a concatenate formula in Excel using VBA to format specific words or the entire result easily.
Read article
Excel Pro Tips
How to Concatenate String and Integer in Excel Using VBA
Learn how to concatenate string and integer in Excel using VBA with ampersand and addition operators easily.
Read article