ADVANCE EXCEL QUALITY TRAINING && COACHING IN ELEGANT IT SE IN INDIA

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