Skip to content
ExcelRow ExcelRow
  • Menu
  • Home
  • Functions
  • Pivot Table
  • Dashboard
  • How to
  • Contact us
  • Login
    dashboard

    Advance of Index Match

    Posted on February 9, 2023February 9, 2023 by SaeedBaba

    Index Match for Complex Lookups INDEX function Returns a value or reference of the cell at the intersection of a particular row and column, in a given range. MATCH function returns the relative position of an item in an array that matches a specified value in a specified order. In the previous article, you got […]

    Continue reading →
    Posted in dashboard Leave a comment
    dashboard

    Basic of Index Match

    Posted on February 8, 2023February 9, 2023 by SaeedBaba

    What is INDEX function in Excel? It Returns a value or reference of the cell at the intersection of a particular row and column, in a given range. Example 1: How many ways are to use the INDEX function? we can use two ways to use index function: 1 . Array form Returns the value […]

    Continue reading →
    Posted in dashboard Leave a comment
    dashboard

    Keyboard Shortcuts for Dashboard Design

    Posted on February 8, 2023February 9, 2023 by SaeedBaba

    list of shortcuts when designing reports or dashboards in Excel: To do this Press Copies selected cells CTRL + SHIFT + C  Paste Plain Text  CTRL + SHIFT + V selects all cells CTRL + A opens the Format Cells window CTRL + 1 repeats your last command or action F4 Draw a Straight Line […]

    Continue reading →
    Posted in dashboard Leave a comment
    Excel Functions
    • Database functions
    • Date and Time
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical functions
    • Lookup and reference
    • Math functions
    • Statistic Functions
    • Text functions
    Recent Posts
    • Xlookup multiple columns in Excel
    • Vlookup limits in Excel
    • Vlookup exact match only in Excel
    • Number stored as text vlookup in Excel
    • Count between two numbers in Excel
    • Counting cells in Excel
    • Square a number in Excel
    • Calculate tenure in Excel
    • Fiscal year formula in Excel
    • Countif conditional formatting in Excel
    About Us

    ExcelRow is a website for training and learning Excel skills. We want you to know the latest Excel skills and the most up-to-date news related to the world of Excel.

    Our team includes the most skilled Excel people who have gathered together for the satisfaction and learning of our contacts and audience.

    We bring more than 15 years of experience working with Excel to help you get the most out of your projects.

    Our ultimate goal is to create a platform for practical and in-depth learning of Excel in the simplest possible way and to have a positive impact on the lives of people who are with us.

     

    Contact us | About us | Terms and Condition
    Copyright 2023 © Excelrow.com
    • Home
    • Functions
    • Pivot Table
    • Dashboard
    • How to
    • Contact us
    • Login
    • Newsletter

    Login

    Lost your password?