Advanced Excel Training Institute :

Advanced-Excel-Training

Microsoft Excel Training

Session1(5 hours)

part1.The Basics

1.Creating a New Workbook
2.Using Excel Menus
3.Entering Values in a Worksheet and Selecting a Cell Range
4.Saving a Workbook & Re-opening a saved workbook

part2.Formatting a Worksheet

1.Creating Headers, Footers, and Page Numbers
2.Adjusting Page Margins and Orientation
3.Formatting Fonts & Values
4.Adjusting Row Height and Column Width
5.Changing Cell Alignment
6.Adding Borders
7.Applying Colors and Patterns
8.Using the Format Painter
9.Using AutoFormat
10.Merging Cells, Rotating Text, and using AutoFit
11.Using AutoFill

part3.Managing your workbooks

1.Switching Between Sheets in a Workbook
2.Inserting and Deleting Worksheets
3.Renaming and Moving Worksheets
4.Protecting a Workbook
5.Hiding Columns, Rows and Sheets
6.Splitting and Freezing a Window
7.Inserting Page Breaks

Session2(5 hours)

part4.Editing a Workbook

1.Entering Date Values and using AutoComplete
2.Editing, Clearing, and Replacing Cell Contents
3.Cutting, Copying, and Pasting Cells
4.Moving and Copying Cells with Drag and Drop
5.Collecting and Pasting Multiple Items
6.Using the Paste Special Command
7.Inserting and Deleting Cells, Rows, and Columns
8.Using Undo, Redo, and Repeat
9.Checking Your Spelling
10.Finding and Replacing Information
11.Inserting Cell Comments

part5.Formulas
1.Creating a basic Formula and Advance Formula
2.Calculating Value Totals with AutoSum
3.Editing& Copying Formulas
4.Fixing Errors in Your Formulas
5.Formulas with Several Operators and Cell Ranges
part6.Working with the Forms Menu

1.Sorting, Subtotaling & Filtering Data
2.Copy& Paste Filtered Records
3.Using Data Validation

Session3(5 hours)

part7.Creating & Working with Charts

1.Creating a Chart
2.Moving and Resizing a Chart
3.Formatting and Editing Objects in a Chart
4.Changing a Chart Type and Working with Pie Charts

part8.Data Analysis & Pivot Tables

1.Creating a PivotTable
2.Specifying the Data a PivotTable Analyzes
3.Updating a PivotTable
4.Formatting and Charting a PivotTable

part9.Automating Tasks with Macros

1.Recording a Macro
2.Playing a Macro and Assigning a Macro a Shortcut Key
3.Adding a Macro to a Toolbar
4.Introduction to VBA macro
5.Editing, writing VBA code

About Ascent Advanced Excel Training Institute:

Ascent Advanced Training Institute Providing high quality training at affordable fees is our core value. We offers classroom on niche technologies which are in high demand. All our trainers are IT professionals with rich experience. We work with our students in developing the right skills they need to build their career in present competitive environment. We have flexible batch times to suit the timings of graduating students and working professionals.
Ascent Advanced Training Institute In Bangalore Excellent Trainers and Fabulous Lab this is what you can expect from us.Free training materials, Free Career consulting, Career guidance by experienced IT professionals, Pleasant and modern training rooms.

Best Training Institute In Bangalore
User Rating
3 based on 6 votes
Open chat
How can i help you today?
Please share your (Name, Mobile Number, Email ID, Course Interested, Preferred Branch) to assist you better.
Powered by