Advance Excel Level 5: Financial and Non-Financial Tools And - TopicsExpress



          

Advance Excel Level 5: Financial and Non-Financial Tools And Techniques Introduction Advance Excel 5 is name of course designed and delivered at Research Analytics International (Private) Limited. This number “5” means that this is the last advance level of Excel being designed and delivered. This course is designed both for accounting and non-accounting professionals. It is best for people engaged in Program Management, Research and Development, Data Analysis and related tasks, M&E, Finance and Accounts, Market Research, Students, Customer Care, Record Keeping and Decision Makers based on data. It is open for corporate as well as non-profit sector. The training will cover Excel versions from 2007 to 2013. The contents of the course are given below: Contents Advance Excel 5 Financial and No Financial Tools and Techniques Summarizing Data Using Formulas: v Defining Names to Cell & Ranges for Better & Quick Calculations v Understanding Single & Multiple Conditional Summing & Counting v Unhide the Power of Excel Array Formulas v Build formulas containing relative, absolute, and mixed references v Working with various financial functions Advanced Sorting Techniques & Subtotalling: v Complex Horizontal & Vertical Sorting v Excel Subtotal Formula -Nesting Subtotalling & Grouping Consolidate and Process Multidimensional Worksheets: v Data Consolidation by Range & By Category v Data Consolidation Using 3D Formulas Excel Database Operations & Management: v Working with Tables & Understanding Table Nomenclature v Data Extracting Using Advanced Filter Techniques v Complex Calculation Using Database Formulas v Data Integrity Using Data Validation v Working With Form Scrutinizing Data Anomalies with Conditional Tests: v Highlight Data Using Conditional Logic v Understanding New Conditional Formatting Features v Using Form Control with Conditional Formatting Condensing and Refining Data with Pivot Tables and Pivot Charts: v Analyzing Data by Creating Dynamic Pivot Reports v Consolidate Multiple Data Ranges & Analysis Using Pivot Consolidation v Turn Bad Data into Good Data through Pivot Table v Integrating Macros with Pivot Table v Understanding Pivot Charts Creating Interactive Data Reports with Excel Charts (Dashboard Reports): v Understanding Chart’s Fundamentals v Working with Excel Built in Charts v How to Create Excel Non v Native Charts for Data Analysis v Creating Eye Catching Dynamic & Interactive Charts Optimizing Solutions with What-If Analysis: v Building Investment Models Using Data Table v Determining Profits with Goal Seek v Comparing And Contrasting Data Sets with Scenario Manager v Building Scenario Reports Automating Your Work Using Macros: v Understanding VBA Environment v Absolute & Relative Recording v Creating UDF (User Defined Functions) Using the Auditing tools for eliminating errors: v Use the auditing tools to avoid errors in financial models. v Trace formula dependents and precedents. v And trace errors, Circular reference and evaluate formulas. Dashboard and Reporting Functions: v Advance Charts and Techniques v Dashboard and Advance Reporting/Modelling How to register: Registering with us is quite simple. You either have to send us an email, give us a call or simply write some words on ‘Contact Us’ page at our website. We will be sending you the registration form along with other details. For final confirmation letter, please ensure that you have submitted fee before the last date of registration. Registration can also be done online at researchanalyticsintl.org/course_register.php. Important Dates: Training on “Advance Excel 5” will be held on April 16-17, 2014 (Last date 12 April 2014). The final agenda and venue details will be shared with all registered participants (who paid their fees). Training will held in RAI office if number of participants will be less than 10 and will held in a local hotel if number of participants will be more than 10. Training fee and discounts: Training fee for one participant for two days attendance is Rs. 16,954/= The Fee include trainer fee, material, certificates, venue cost, tea and lunch for participants. Discount is available in the following form: 1. 10% discount for two to four participants from same organization 2. 10% discount in case of registration in more than one training courses (at same time) 3. 20% discount for five or more participants from same organizations 4. Local organizations, women and students are entitled for 10% discount The fee can be paid by the following methods: 1. Online Deposits at UBL (1155)—School Road, Islamabad Branch: Acc # 000203686098 2. Cross Cheque: Account Title: “Research Analytics International” 3. Pay order/demand draft for “Research Analytics International” For more upcoming trainings, please visit researchanalyticsintl.org/trainings.php. We also provide in-house trainings to development and corporate sector. Contact details and inquiries Research Analytics International (Private) Limited 407, 4th Floor, Royal Centre, 106-West, Fazl ul Haq Road, Blue Area, Islamabad Tel: +92 51 4311633 / 2806093 Web: researchanalyticsintl.org; facebook/raipvt Emails: [email protected], [email protected]
Posted on: Thu, 27 Mar 2014 16:39:30 +0000

Recently Viewed Topics




© 2015