Elegant rows

Advance Excel Trainers required in elegant it services in marathahalli • Exploring the Excel window • Getting help • Navigating workbooks • Navigating a worksheet Part 2: Entering and editing data • Entering and editing text and values • Entering and editing formulas • Working with pictures • Saving and updating workbooks Part 3: Modifying a worksheet • Moving and copying data • Absolute and relative references • Inserting and deleting ranges, rows, and columns Part 4: Using functions • Other useful functions Part 5: Formatting worksheets • Formatting text • Formatting rows and columns • Setting alignment • Applying borders to ranges • Using the Paste Special option • Removing a border • Conditional formatting • Copying formats and applying table formats • Using Find and Replace to change cell formats Part 6: Printing • Preparing to print • Page Setup options • Printing worksheets • Working with the print area Part 7: Creating charts • Chart basics • Using an embedded chart • Modifying charts • Changing a chart type • Applying Quick Layouts and Quick Styles • Formatting chart elements • Modifying an embedded chart • Printing charts Part 8: Managing large workbooks • Viewing large worksheets • Hiding and Unhiding columns and worksheets • Printing large worksheets • Using multiple worksheets • Previewing and printing multiple worksheets Advance Excel Course Syllabus Part 1: Work with Data •Text to Column •Group & Ungroup Your data •Using Subtotal •Conditional formatting Part 2: Work with Data - 2 •Remove Duplicates • Finding Unique Records • Unique records through criteria • Named Ranges • Drop Down • Data Validation Part 3: Presenting & Protecting the Date •Pivot Table •Charts •Goal Seek & Data Table •Scenario Manager & Solver •Protect & Un Protect work sheet / work book Part 4: Function & Formulas •Logical Functions •Text Functions •Date & Time Functions •Lookup Functions •Advance Sum Functions •Advance Count Functions •Validation Functions Part 5: Macros •What is a Macro ? •Creating Excel Macro •Running and Editing the Macro •Automating Tasks with Macro Thanks&Regards Elegant IT Services, #nd Floor,Aswath Nagar Varthur main road,Near Railway Fly Over Maratha halli,Land mark: Chemmunar Jewellers,

Advance Excel Quality training && coaching in elegant it services • Exploring the Excel window • Getting help • Navigating workbooks • Navigating a worksheet Part 2: Entering and editing data • Entering and editing text and values • Entering and editing formulas • Working with pictures • Saving and updating workbooks Part 3: Modifying a worksheet • Moving and copying data • Absolute and relative references • Inserting and deleting ranges, rows, and columns Part 4: Using functions • Other useful functions Part 5: Formatting worksheets • Formatting text • Formatting rows and columns • Setting alignment • Applying borders to ranges • Using the Paste Special option • Removing a border • Conditional formatting • Copying formats and applying table formats • Using Find and Replace to change cell formats Part 6: Printing • Preparing to print • Page Setup options • Printing worksheets • Working with the print area Part 7: Creating charts • Chart basics • Using an embedded chart • Modifying charts • Changing a chart type • Applying Quick Layouts and Quick Styles • Formatting chart elements • Modifying an embedded chart • Printing charts Part 8: Managing large workbooks • Viewing large worksheets • Hiding and Unhiding columns and worksheets • Printing large worksheets • Using multiple worksheets • Previewing and printing multiple worksheets Advance Excel Course Syllabus Part 1: Work with Data •Text to Column •Group & Ungroup Your data •Using Subtotal •Conditional formatting Part 2: Work with Data - 2 •Remove Duplicates • Finding Unique Records • Unique records through criteria • Named Ranges • Drop Down • Data Validation Part 3: Presenting & Protecting the Date •Pivot Table •Charts •Goal Seek & Data Table •Scenario Manager & Solver •Protect & Un Protect work sheet / work book Thanks&Regards Elegant IT Services, #nd Floor,Aswath Nagar Varthur main road,Near Railway Fly Over Maratha halli,Land mark: Chemmunar Jewellers, Bangalore - .Ph: -/87

Real Time Training Oracle Apps Tech,Oracle Apps Tech elegant it services • What is ERP? • Comparison of Oracle Apps with other ERPS • Types of Roles, Types of projects, AIM documents • Oracle Apps structure, database structure and 3-tier architecture Application Object Library(AOL) • Concurrent program with parameters, Creating Value sets • Menu construction, Defining concurrent program • Levels of Oracle Applications, Creating users, WHO columns, Creating responsibilities • Scheduling concurrent program, Creating request group, Creating request set Multi Org Concepts • What is Multi Org and why we need • Multi Org Tables • Multi Org Views Module Overviews • Inventory Module flow with base tables • Accounts Payable module flow with base tables • Accounts Receivable module flow with base tables • Order Management module flow with base tables • Purchasing order module with base table • General Ledger module with base tables • HRMS module with base table Reports • Report development process, Report registration process • Bind parameters, lexical parameters, reports with value set, Building report manually • Using repeating frames, Summary columns, Standard report customization Interfaces • Introduction to Interfaces, working with Out Bound Interfaces, using UTL_FILE package • Inbound Interface process, Working with SQL*Loader tool • Different option in SQL *Loader tool, bad file, discard file • Using Interface table approach • Using API Approach Conversions • Introduction to conversions, Creation of staging table • Developing the validation package, explaining the real time project code. • Completing the conversion task, Differences between Inbound interfaces and Conversions Forms • Form development process using TEMPLATE.FMB, Form registration process • Form personalization • Form Customation Using Custom.pll Workflows • Workflow Customization process steps Alerts • Overview on alerts • Creation of alerts • Types of alerts XML Publisher • Introduction to XML publisher, Report development process • Creating reports for multiple rows, Creating Data definitions, Creating templates, Multi Layout Reports • XML publisher Barcode Report(Advance) • XMLP Bursting Concept (Advance) Flex fields • Creating DFF, Creating KFF Functional Cycles • P2P Cycle(Procure to Pay Cycle) • O2C Cycle(Order to Cash Cycle) Thanks&Regards Elegant IT Services, #nd Floor,Aswath Nagar Varthur main road,Near Railway Fly Over Maratha halli,Land mark: Chemmunar Jewellers, Bangalore -