Account Receivable Specialist

The accounts payable specialist works within the Accounting Department and contributes to the management and profitability of the company resources through the verification, reconciling, analyzing, and processing of payables.

• Receive, process, verify and reconcile invoices.
• Research, track and resolve discrepancies.
• Handle supplier communications.
• Filing of invoices.
• Work with co-workers in operations to receive approval for invoices.
• Carry out other duties as assigned.
VLookup Function, Pivot Tables, Access Database tables

Please include a link to your CV and list your salary requirements in the initial ---------- using the diagram below, which is a sales report, please answer the following questions:
a. What formula would you use to receive the sales total?
b. How would you create a pivot table to display the total sales by month?
c. Using a vlookup formula in column F, what would be the formula to display Jan. sales for the employee Tom?
d. To display all the employee names in column B in column F as the first three characters, what formula would be used?
e. How do you place a filter on the header lines on row 2?