Spreadsheet Skyscrapers vs. Spreadsheet Sprawl

Member price:


Your price:

$ 99.00


11 am PT / 12 pm MT / 1 pm CT / 2 pm ET
*approximate length: 45 minutes to 1 hour

Presenter: David Ringstrom, CPA

In this presentation Excel expert David H. Ringstrom, CPA shows you how to overcome spreadsheet sprawl by orienting your data into skyscrapers instead. Invariably spreadsheet users tend to orient data going across columns, but doing so inadvertently hijacks your experience in Excel and makes it harder to analyze data. You'll see how to reorient existing spreadsheets, such as by using the Unpivot feature in Power Query to reorganize your data vertically versus horizontally, which then unlocks a host of Excel features you can use to work more effectively.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 (formerly Office 365) version of Excel. David draws your attention to any differences in the older versions of Excel (2021, 2019, 2016 and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Microsoft 365 is a subscription-based product that provides new feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don't change. Perpetual licensed versions have year numbers, such as Excel 2021, Excel 2019, and so on.

Who should attend:  Practitioner seeking to use Microsoft Excel more effectively

Topics covered:

  • Creating a self-updating list of worksheets in any workbook with Power Query
  • Eliminating total rows after unpivoting data in Power Query
  • Exploring the Queries & Connections task pane that shows data connections used within a given workbook
  • Introducing the Power Query feature in Excel
  • Navigating purposefully through worksheets by way of clickable hyperlinks
  • Navigating through workbooks and identifying non-blank worksheet cells with the Navigation task pane in Microsoft 365
  • Transforming reports that are dozens or more columns wide into filterable rows by way of the Unpivot command in Power Query
  • Using INDIRECT to create a single formula that can retrieve data from any worksheet in a workbook by simply copying and pasting

Learning objectives:

  • State which menu the Unpivot Columns command appears on in Power Query
  • Recall the locations where the Filter command appears in Excel's menu interface
  • Identify the items that can be added to a PivotTable from the PivotTable field list

Level: Intermediate

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 25 years of consulting and teaching experience. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively.

Our site uses cookies to improve your visiting experience. Please view our Cookie and Privacy Policy.
Got it