Expert Excel Finance

Short-Term Expert Excel Finance

BDO LLP is executing the European Union-funded project of Institutional Strengthening of the State Audit and Administrative Control Bureau in Ramallah.

The project needs an IT Trainer , specialised in EXCEL Finance skills,  to be delivered in January 2015, in  cooperation with SAACB/ IT Expert of the Project.
The working language is Arabic. Fluency in English, spoken and written, is required.

Candidates must be experienced in Microsoft Excel.

Some of the topics to be dealt with are
-Formulas with Multiple Operators
-Inserting and Editing a Function
-Auto Calculate and Manual Calculation
-Defining Names
-Using and Managing Defined Names
-Displaying and Tracing Formulas
-Understanding Formula Error
-Using Logical Function (IF)/ Financial Functions (PMT)/ Database Function(DSUM)/ Lookup Function (VLOOKUP)/ Defined and Compatibility Function/ Financial Function/ Date & Time Function/ Math & Trig Function
-Statistical Function/ Lookup & Reference Function/ Database Function/Text Function
-Logical Function/ Information Function/ Engineering and Cube Function Working with Data Ranges
-Sorting by One Column /by Colors or Icons/ by Multiple Column/ by a Custom List
-Filtering Data
-Creating a Custom AutoFilter
-Using an Advanced Filter .Working with PivotTable
-Creating a PivotTable
-Specifying PT Data
-Changing a PT Calculation
-Filtering and Sorting a PT
-Working with PT Layout
-Grouping PT Items
-Updating PT
-Formatting a PT
-Creating a PivotChart
-Using Slicers
-Sharing Slicers Between PT . Analyzing and Organizing Data
-Creating Scenarios and Report
-Working with Data Tables
-Using Goal Seek
-Using Solver
-Using Text to Columns
-Grouping and Outlining Data Using Subtotals
-Consolidating Data by Position or Category
-Consolidating Data Using Formulas Working with the Web and External Data
-Inserting a Hyperlink
-Importing Data from Access Database or Text File  or Web
-Working with Existing Data Connections  Working with Macros
-Recording a Macro
-Playing and Deleting a Macro
-Adding a Macro to the Quick Access Toolbar
-Editing a Macro’s Visual Basic Code
-Inserting Copied Code in a Macro
-Declaring Variables and Adding Remarks to VBA Code
-Prompting for User Input
-Using the If…Then…Else Statement Customizing Excel Customizing the Ribbon
-Customizing the Quick Access Toolbar
-Using and Customizing AutoCorrect
-Changing Excel’s Default Options
-Creating a Custom AutoFill List
-Creating a Custom Number Format

Please send CV by email to:  [email protected].
Competition closes by 31 December 2014

جميع الحقوق محفوظة لموقع جوبس.