Relevante Invites you for its upcoming Webinar on “Excel Advanced Formulas”

Discussion in 'Access Table Design' started by Relevante Inc, Apr 20, 2011.

  1. Date: May 18th 2011

    Overview:

    Learn to take a general ledger extract and create a dynamic income
    statement that changes with the click of a button. The case will take
    you through and explain the advanced functions:

    Objectives also include:
    • Learn how to clean-up, break out and combine your data using
    • Text to Columns
    • Left, Right, & Mid functions
    • Concatenate
    • Trim & Clean
    • Year, Month, & Text functions.

    • Automate and make dynamic reports using
    • lookup, vlookup, and hlookup
    • Sumif
    • GetPivotData
    • Create drop down selection boxes
    • Error handling statements.

    Participants will get “1.5 Computer Science” CPE Credits.

    For more information visit:
    http://www.relevante.com/htmls/educational_events/05182011.html
    You can also E-Mail at:
     
    Relevante Inc, Apr 20, 2011
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. candy

    Data moving on its own

    candy, Oct 3, 2003, in forum: Access Table Design
    Replies:
    2
    Views:
    104
    Candy
    Oct 3, 2003
  2. Tina

    How do you write formulas in Access?

    Tina, Mar 7, 2006, in forum: Access Table Design
    Replies:
    8
    Views:
    84
  3. AEA

    creating advanced? table relationships

    AEA, Apr 29, 2006, in forum: Access Table Design
    Replies:
    9
    Views:
    141
  4. mohideen cassim

    COULD YOU EXPLAIN THE SWITCHBOARD AND ITS FUNCTION

    mohideen cassim, Sep 12, 2007, in forum: Access Table Design
    Replies:
    2
    Views:
    162
    Dennis
    Sep 13, 2007
  5. JohnReed
    Replies:
    0
    Views:
    102
    JohnReed
    Jul 8, 2008
  6. Relevante Inc
    Replies:
    0
    Views:
    287
    Relevante Inc
    Apr 12, 2011
  7. Relevante Inc

    Invitation to join (Relevante India LinkedIn Group)

    Relevante Inc, May 6, 2011, in forum: Access Table Design
    Replies:
    0
    Views:
    308
    Relevante Inc
    May 6, 2011
  8. Relevante Inc
    Replies:
    0
    Views:
    373
    Relevante Inc
    Jul 27, 2011
Loading...