Excel Pro Tips
How to Find Nth Occurrence of a Character in String in Excel
Learn how to find the Nth occurrence of a character in an Excel string using formulas, Excel 365 functions, and VBA with examples.
Read article
Blog
1285 articles
Excel Pro Tips
How to Capitalize All Letters in Excel Without a Formula
Learn how to capitalize all letters in Excel without formulas using Flash Fill, fonts, Word formatting, or VBA automation methods.
Read article
Advanced Excel
How to Print Barcode Labels in Excel (2 Effective Ways)
Learn how to print barcode labels in Excel using mail merge or direct methods, plus fixes for blurry, misaligned, or unreadable barcodes.
Read article
Advanced Excel
How to Create & Use Code 128 Barcode Font in Excel
Learn how to create and use Code 128 barcode fonts in Excel, install fonts, encode with VBA, use IMAGE API methods, and choose subsets.
Read article
Advanced Excel
How to Create Code 39 Barcode Font in Excel (3 Suitable Ways)
Learn how to create Code 39 barcode font in Excel using free fonts, VBA automation, IMAGE API, and MOD 43 check digits step by step.
Read article
Advanced Excel
How to Add Barcode Font in Excel (4 Different Ways)
Learn how to add barcode fonts in Excel using Code 39, VBA encoders, IMAGE APIs, and third-party generators easily.
Read article
Excel Functions & Formulas
How to Log Transform Data in Excel (6 Suitable Ways)
Learn how to log transform data in Excel using LOG, LN, VBA, Power Query, and charts for clearer analysis and insights.
Read article
Excel Pro Tips
How to Create a Lookup Table in Excel (5 Different Examples)
Learn how to create a lookup table in Excel using XLOOKUP, VLOOKUP, INDEX-MATCH, LOOKUP, and drop-down lists for fast data use.
Read article
Excel VBA
VBA For Each Row in Range: What Is It & How to Use?
Learn what VBA For Each Row in Range means and how to use it with syntax and examples to loop, format, copy, and delete rows efficiently.
Read article
Excel VBA
How to Find Last Row with Data in Range with Excel VBA
Learn how to find the last row with data in a range using Excel VBA methods like End, Find, SpecialCells, and tables.
Read article
Excel VBA
How to Fix "Constant Expression Required" Error in VBA
Learn how to fix the Constant Expression Required error in VBA using proper constants, Redim, ParamArray, and defaults smartly.
Read article
Excel VBA
How to Select Range Based on Cell Value with Excel VBA
Learn how to select Excel ranges with VBA based on cell values, rows, tables, multiple criteria, logic, Find, and SpecialCells.
Read article