• Excel Tutorials

    Become an expert at handling Excel spreadsheets. With our hands-on tutorials, learn how to use beginner-to-advanced Excel formulas and functions like VLOOKUP, INDIRECT, INDEX, and MATCH to upgrade your Excel skills.

    Featured Articles

    VLOOKUP COLUMN and ROW: Handle Large Data Tables Easily

    Excel Tutorials

    VLOOKUP COLUMN and ROW: Handle Large Data Tables Easily

    VLOOKUP COLUMN and ROW. In this lesson you will learn how to use COLUMNS and ROWS as a counter in lookup functions in large tables.

    5 min read
    VLOOKUP and MATCH: Useful Excel Functions Combination

    Excel Tutorials

    VLOOKUP and MATCH: Useful Excel Functions Combination

    Article by Ned Krastev by Ned Krastev 2 min read
    INDEX and MATCH: Application of the Excel Functions Separately and Combined

    Excel Tutorials

    INDEX and MATCH: Application of the Excel Functions Separately and Combined

    Article by Ned Krastev by Ned Krastev 7 min read

    All Articles

    10 Excel Project Ideas for Your Data Science Portfolio

    Excel Tutorials

    10 Excel Project Ideas for Your Data Science Portfolio

    Article by Saadan Mir by Saadan Mir 5 min read
    VLOOKUP COLUMN and ROW: Handle Large Data Tables Easily

    Excel Tutorials

    VLOOKUP COLUMN and ROW: Handle Large Data Tables Easily

    5 min read
    VLOOKUP and MATCH: Useful Excel Functions Combination

    Excel Tutorials

    VLOOKUP and MATCH: Useful Excel Functions Combination

    Article by Ned Krastev by Ned Krastev 2 min read
    INDIRECT Excel Function: How to Apply and Combine with VLOOKUP

    Excel Tutorials

    INDIRECT Excel Function: How to Apply and Combine with VLOOKUP

    Article by Ned Krastev by Ned Krastev 5 min read
    INDEX and MATCH: Application of the Excel Functions Separately and Combined

    Excel Tutorials

    INDEX and MATCH: Application of the Excel Functions Separately and Combined

    Article by Ned Krastev by Ned Krastev 7 min read

    Ready to Start Learning?

    Choose your career track, build in-demand skills, and land a job in data science.

    Start Now
    The logos of technologies like Python, R, SQL, ChatGPT, Tableau, Power BI, and SQL displayed for decorative purposes.