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
    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?