How to Use Pivot Table in Excel

How to Use Pivot Table in Excel

Release Date: 07/18/2024
Version: 8.6 & Up

In this video, we demonstrate a powerful feature in Excel called the "Pivot Table." While this subject is not directly related to Elliott Business Software, we do have a Report Desk feature that can export Elliott data to an Excel spreadsheet. Sometimes it is desirable to transform the Excel spreadsheet produced by Report Desk into a Pivot Table for better viewing.

Here is the YouTube Link: https://youtu.be/89ExPkUPbGk

We hope you find the presentation helpful. 



EMK/RSS

    • Related Articles

    • How to Access Elliott's Data by Using Query in Microsoft Office Excel 2019

      Release Date: 06/30/2020 Version: 7.x & Up Elliott's data is based on the PSQL database engine. In Excel, you can access the PSQL database through an ODBC interface with the Microsoft "Query" function. The following procedure outlines how you can do ...

    • Microsoft Query Is Missing on Excel After Office 365 Update

      Release Date: 06/07/2024 Version: N/A Q: We use Microsoft Query extensively to retrieve data from Elliott database. After the last update for Office 365, my Microsoft Query is missing on Excel. How can I recover this feature? A: The solution is to go ...

    • Converting Elliott Internal Date to Conventional Date Format in Excel

      Q - If I retrieve Elliott's data in Excel through ODBC, the date column is retrieved in an 8-digit numeric format like:20161231, where the first 4 digits are the years, the following 2 digits are the month, and the last two digits are the day of the ...

    • Use Report Desk and Receive Message - Unable to Connect to Data Table NSCTLFIL_2

      Release Date: 09/25/2021 Version: 8.6 & Up Q - When I used Report Desk for the first time, I received the message "Unable to connect to data table NSCTLFIL_2". See sample screen below: A - This may be caused by two things: Your Elliott database is ...

    • When and How to Use DDF2BTR.EXE Utility

      Release Date: 03/03/2016 Version: 8.0 & up Q - In Elliott V8.0, I see a new EXE program, DDF2BTR.EXE, in the <ElliottRoot>\Bin folder. What is the purpose of this program and how do I use it? A - Actually, you can find the DDF2BTR.EXE utility in the ...