Excel Pro Tips
How to Use IF Statement in Excel Conditional Formatting
Learn how to use the IF statement in Excel conditional formatting with helper columns, direct formulas, and VBA to highlight results.
Read article
Blog
1285 articles
Excel Pro Tips
Custom Format to Add Text after Number in Excel
Learn how to add text after numbers in Excel using custom formats, conditional suffixes, scaling, symbols, and VBA alternatives.
Read article
Excel Pro Tips
How to Use Conditional Formatting Based on VLOOKUP in Excel
Learn how to use conditional formatting with VLOOKUP in Excel to highlight values, compare targets, and explore XLOOKUP, MATCH and VBA.
Read article
Excel Pro Tips
How to Make Yes Green and No Red in Excel (5 Examples)
Make Yes green and No red in Excel using conditional formatting, filters, VBA Editor, or Office Scripts for highlights easily.
Read article
Excel Pro Tips
How to Remove Conditional Formatting in Excel
Learn how to remove conditional formatting in Excel using Clear Rules, Quick Analysis, Paste Special, Clear Format, or VBA automation.
Read article
Advanced Excel
How to Import Table from Website to Excel (3 Different Ways)
Learn how to import tables from websites into Excel using the Data tab, VBA automation, or manual copy paste methods easily.
Read article
Advanced Excel
How to Create QR Codes in Excel (3 Effective Ways)
Learn how to create QR codes in Excel using the IMAGE function, Office add-ins, or automated VBA to quickly generate scannable codes.
Read article
Advanced Excel
How to Generate EAN-13 Barcode in Excel (3 Suitable Ways)
Learn how to generate an EAN-13 barcode in Excel by installing a font, using the IMAGE function, or applying external add-ins.
Read article
Excel Pro Tips
How to Insert a Watermark in Excel (3 Easy Methods)
Learn how to insert a watermark in Excel by adding an image via Header & Footer, using WordArt text, or inserting a background image.
Read article
Excel Pro Tips
How to Create a Custom Footer in Excel (3 Suitable Ways)
Learn how to create a custom footer in Excel by using Page Layout view, customizing via Page Setup, or adding one with a VBA macro.
Read article
Excel Pro Tips
How to Insert Logo in Excel Header (with Easy Steps)
Add a logo to an Excel header by opening Header & Footer view, selecting a section, inserting the image, confirming it, adjusting the size.
Read article
Excel Pro Tips
How to Save Excel as PDF in Landscape Orientation
Save Excel as a landscape PDF by adjusting page layout, defining print area, configuring sheet options, and exporting from print preview.
Read article