Here’s an example of what you will see when selecting your file of interest. This will be at the far right of the ribbon. Using the Home tab in the Editor, select New Source -> Excel to pick the file and spreadsheet (tab) you wish to explore. Here are the steps you can take, and what features are available.įrom the Data tab of Excel, click Data -> Launch Power Query Editor. While I primarily use Microsoft Excel’s Power Query Editor to put together a complicated table or report in a short period of time, I’ve learned that you can also use it to explore any data set. Board of Directors and Nominations & Elections Committee.Improving and Transforming IR in Postsecondary Education.Postsecondary Data Partnership Tutorials.AIR LEADs: Leadership with Evidence, Analytics, and Data.Statement of Aspirational Practice for IR.Duties and Functions of Institutional Research.

Tab will move on to the next part of the site rather than go through menu items. Enter and space open menus and escape closes them as well. Up and Down arrows will open main tier menus and toggle through sub tier links. Left and right arrows move through main tier links and expand / close menus in sub tiers. The following navigation utilizes arrow, enter, escape, and space bar key commands.

Power query mac 2021