Microsoft Office Excel to manage application data

Mac Ossai 1 Reputation point
2022-05-04T06:30:13.853+00:00

I am trying to move all our processes from Google sheet to Microsoft Office Excel and i was wondering if Microsoft office excel can be used just like Google sheet?

Ideally, It should be easy to create/edit/update the sheet and can connect to APIS. Any advise will be appreciated.

Thanks

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,637 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ceasar Chen_MSFT 4,391 Reputation points
    2022-05-04T07:52:40.05+00:00

    Hi, @Mac Ossai
    Are you trying to search for specific values based on specific criteria?
    You can try to use filter function or VLOOKUP function.
    Select the column to be filtered, click the Data tab, and click Filter.
    198782-image.png
    To use the VLOOKUP function, you can refer to this link: https://support.microsoft.com/en-us/office/look-up-values-with-vlookup-index-or-match-68297403-7c3c-4150-9e3c-4d348188976b

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.