Help & Support Knowledge Base

Article #7
Excel Tips


SHEET USED AS EXAMPLE FOR THIS ARTICLE List of buyers with the number of items purchased: Pivot Tables Pivot tables provide a powerful interface to summarise info into groups.
  • Open File
  • Move cell cursor inside the data block
  • Click "Data "
  • Click "PivotTable and PivotChart reports"
  • Click Finished Drag from "Field List" and drop in "row fields" Drag from "Field List" and drop in "column fields" Drag the numeric value from "Field List" and drop in "Data Items" Optional: Drag the other fields from "Field List" en drop in "page fields" The rows/columns and pages can be manipulated in any way for different reports. AutoFilter AutoFilter is 'n powerful tool to see only a subset of all the data based on some criteria
  • Open a file
  • Move cell cursor inside the data block
  • Click "Data "
  • Click "Filter"
  • Click "AutoFilter" Subtotals Subtotals is a powerful tool to group rows based on a change in value
  • Open a file
  • Move cell cursor inside the data block
  • Sort on the column you want to use as main field
  • Click "Data "
  • Click "Subtotals"
  • Select the columns to use for your summary and page breaks. =oOo= "KOPER" and "BUYER" substituted interchangeably "GETAL" and "QTY" substituted interchangeably

  • This article is NOT verified or spellchecked



    Please click the link below to read the related article.

    Export invoices to Pastel
    Update from an e-mailed UFZ file
    Network setup
    Printer setup
    DEBTOR SYSTEM
    Excel Tips
    MEAT Processing Overview
    Adding Event Expenses or Income
    Change RMLA Rates
    How to make a backup
    How to get the Beta release
    Create an event with lots from another event
    How to clear all bids, buyers and prices
    Automatically invoice buyers/sellers
    Important VAT Notes
    How to Update to the newest version
    Sending us a FXE
    How to do Multi-Owner Purchases
    How to install FlexiAuction from a CD (New Customer)
    How to move FlexiAuction to another computer
    Start capturing lots
    Adding a new event
    How to Capture a lot
    How to add a customer
    Assigning buyer numbers
    Entering the lot prices
    Multiple Buyers
    Changing date and currency format
    Changing invoice variables
    Balancing an auction
    Invoice Buyers and Sellers
    SUBJECT TO CONFIRMATION
    Reprinting Invoices
    Making changes to multiple lots
    Shuffle Lots
    Invoice payment CONTRAs
    Main window
    Login
    Settings
    Customers
    Requirements
    Events
    Items/Stock
    Users/Clerks
    Definitions
    Change Log
    Working with SA Studbook assistant
    Maintain Your Website
    Creating pages on your website
    Importing Lots From Excel
    Working with the Store
    Agents
    Agent Commission
    CRM GUIDE
    Delete Generated Files
    Setting up Your email in FlexiAuction
    How to Stop/Start SQL Server
    How to setup you domain at HETZNER
    Transaction Summary
    Printing cheques on a dot-matrix printer
    Change Paytype on issued invoices
    Warehouse
    Stock Keeping module
    License Verification Code
    Change company details for document printing




    FLEXIAUCTION AUCTIONEERING SOFTWARE
    Thank you for visiting our website. Copyright © 2005. All rights reserved.
    Wibakor CC 1997/035379/23 T/A FLEXIAUCTION