Excel Pro Tips
How to Change Case in Excel Without Formula (3 Different Ways)
Learn how to change case in Excel without formulas using VBA macros, Power Query, or Word’s Change Case tool for quick text formatting.
Read article
Author & Spreadsheet Consultant
Ramisa Anjum
39 Articles PublishedPublishing since
Ramisa Anjum is pursuing a Computer Science and Engineering degree at North South University, building strong analytical and technical skills. With 3+ years of hands-on Excel and Google Sheets experience, she specializes in advanced text functions, complex logical formulas, lookup systems, macro automation, data cleaning, and instructional modeling. She has created structured datasets and enjoys simplifying complex tasks through formulas and automation.
Editorial Review
Articles Published by Ramisa Anjum
Articles by Ramisa Anjum are developed under the guidance of ExcelInsider’s core training program and are technically reviewed by Nehad Ulfat, lead spreadsheet consultant, to ensure accuracy and user-centric value.
Excel Pro Tips
How to Convert Minutes to Hours and Minutes in Excel
Learn how to convert minutes to hours and minutes in Excel using time formatting, TEXT, INT & MOD functions, or VBA for quick conversion.
Read article
Excel Pro Tips
How to Combine Duplicate Rows and Sum the Values in Excel
Learn how to combine duplicate rows and sum values in Excel using Pivot Tables, SUMIFS, Power Query, or VBA for quick data management.
Read article
Excel Pro Tips
How to Find Duplicate Values in Excel Using VLOOKUP
Learn how to find duplicate values in Excel using VLOOKUP across sheets, workbooks, and understand its limitations for duplicate detection.
Read article
Excel Pro Tips
How to Remove Duplicate Rows Based on One Column in Excel
Learn how to remove duplicate rows based on one column in Excel using built-in tools, VBA, Power Query, and conditional formatting tips.
Read article
Excel Pro Tips
How to Convert Excel to PDF Without Losing Formatting
Learn how to convert Excel to PDF without losing formatting using built-in tools, print settings, VBA macros, and free online converters.
Read article
Excel Pro Tips
How to Save Multiple Excel Sheets as One PDF (4 Easy Ways)
Learn how to save multiple Excel sheets as one PDF using built-in options, print settings, VBA automation, or without any coding at all.
Read article
Excel Pro Tips
How to Link PowerPoint to Excel for Dynamic Data Updates
Learn how to link PowerPoint to Excel for dynamic data updates using live links, embedded objects, VBA macros, and avoid linking errors.
Read article
Excel Pro Tips
How to Create PowerPoint Slides Automatically from Excel
Automatically create PowerPoint slides from Excel using VBA, Python, ChatGPT, and tools like SlideSpeak. Avoid common automation pitfalls.
Read article
Excel Pro Tips
How to Convert a Number to Words in Excel in Rupees
Convert numbers to words in Indian Rupees format in Excel using the LAMBDA function or a VBA macro with easy, step-by-step guidance.
Read article
Excel Pro Tips
How to Change Uppercase to Lowercase In Excel (5 Easy Ways)
Learn how to change uppercase to lowercase in Excel using the LOWER function, Word, VBA, Power Query, or by keeping only first letter capital.
Read article
Excel Pro Tips
How to Convert Decimal Time to Hours and Minutes in Excel
Learn how to convert decimal time to hours and minutes in Excel using TEXT, INT, MOD functions, division by 24, VBA code, or Power Query.
Read article