All Categories ​>​ ​Excel Functions

Excel Functions

BCE Support Contact Details

BCE Support - Contact Details. The BCE support contact number is 0330 343 0056 Customers may access the Support Portal using the following link: https://customers.oneadvanced.com/ Note: Users are req…

Updated 2 years ago by David Rustell

BCE Excel Functions - Introduction, Setup and Configuration

BCE Excel Functions. Introduction. BCE Excel functions link BCE with Excel to allow data to be extracted directly into Excel for both data analysis and reporting. Using a library of data functions, a…

Updated 2 years ago by David Rustell

Using BCE Excel Functions

Introduction. This is a brief guide to using BCE Excel Functions and covers the following topics: Selecting BCE Excel functions. Example BCE Excel function. List General Ledger Accounts. BCE Excel sa…

Updated 2 years ago by David Rustell

Excel data drill down

Data drill down. BCE Excel functions are supported from BCE v1.8.0 using local and online editions of Excel. A data drill down option allows the underlying data to be inspected from highlighted cell…

Updated 2 years ago by Ben Buck

BUDGET Functions

BCE Excel functions are supported from BCE v1.8.0 using local and online editions of Excel. This section describes the Excel functions which allow you to get budget information. BCE.BUDGET.CODE (budg…

Updated 2 years ago by David Rustell

GL ACCOUNT Functions

BCE Excel functions are supported from BCE v1.8.0 using local and online editions of Excel. This section describes the Excel functions which allow you to get financial account information. BCE.GL.ACC…

Updated 2 years ago by Ben Buck

GL ACTUAL Functions

BCE Excel functions are supported from BCE v1.8.0 using local and online editions of Excel. BCE.GL.ACTUAL.PERIOD (account_code, year, period). Returns the total of all financial transactions for the…

Updated 2 years ago by David Rustell

BCE Excel Functions - Templates

BCE Excel functions are supported from BCE v1.8.0 using local and online editions of Excel. Introduction. The following BCE Excel function templates are provide for reference and can be downloaded an…

Updated 2 years ago by David Rustell

Privacy info

Privacy info for Excel functions. The add-in does NOT collect, store, or transmit any information that can be used to identify you. The add-in does NOT collect any information about how the add-in is…

Updated 2 years ago by Ben Buck

Powered by HelpDocs (opens in a new tab)