Detailed description is Online and Offline classes on MS Excel for Managers, Team Leads and students Today in every corporate Company, Excel is required to improve your tasks, whether it is reporting or Data Presentation. Following topics (but not limited to) will be covered in session:-. Topics Covered. *Creating a List . *Using a Data Form . *Adding Records Using a Data Form . *Finding Records Using a Data Form . *Deleting Records Using a Data Form . *Sorting Records in a List . *Using AutoFilter in a List . . WORKING WITH CHARTS . . *Creating a Chart with the Chart Wizard . *Moving a Chart . *Resizing a Chart . *Changing a Chart Type . *Editing Chart Text . *Modifying Chart Options . *Formatting Category & Value Axis Data . *Formatting a Data Series . *Changing a Chart’s Source Data . . WORKING WITH GRAPHICS . . *Using the Drawing Toolbar . *Formatting Objects . *Inserting WordArt . *Inserting an Organization Chart . *Modifying an Organization Chart . WORKGROUP COLLABORATION . *Web Page Preview . *Converting Worksheets into Web Pages . *Inserting Hyperlinks . *Viewing & Editing Comments . . IMPORTING & EXPORTING DATA . . *Importing External Data into Excel . *Importing Text Data into Excel . *Importing Data from a Database . *Exporting Data from Excel . *Publishing Worksheets & Workbooks to the Web . . FORMATTING NUMBERS . . *Creating Custom Number Format . *Using Conditional Formatting . *Removing Conditional Formatting . . WORKING WITH RANGES . . *Naming a range . *Using a Named Range . *Deleting a Named Range . *Using the VLOOKUP Function . . CUSTOMIZING EXCEL . . *Creating a Macro . *Running a Macro . *Editing a Macro . *Adding a menu to the Menu Bar . *Adding a Commands to a Menu . *Adding Buttons to a Toolbar . . DATA ANALTSIS TOOLS . . *Tracing Formula Precedents . *Tracing Cell Dependents . *Tracing & Fixing Errors . *Creating a Pivot Table . *Rearranging a Pivot Table . *Filtering Pivot Table Data . *Creating a Pivot Chart . . SUMMARIZING DATA . . *Adding Subtotals to a List . *Nesting Subtotals . *Applying Advance Filters . *Adding Group & Outline Criteria to Ranges . *Using Data Validation . WHAT–IF DATA ANALYSIS . . *Using Goal Seek . *Using Solver . *Creating & Displaying Scenarios . . WORKGROUP COLLABORATIONS . . *Locking/Unlocking Cells in a worksheet . *Protecting a Worksheet . *Protecting a Workbook . *Creating a Shared Workbook . *Tracking Changes to a Workbook . *Accepting & Rejecting Changes to a Workbook . *Password Protecting a Workbook . *Merging Workbooks.
Established in the recent years expert in excel noida india in north-goa, goa in india.
This well-known establishment acts as a one-stop destination servicing customers both local and from other parts of the city...
Frequently Asked Questions About This Location
Qus: 1). what is the mode of payment accepted ?
Ans: Cash , Credit Card and Wallets
Qus: 2). What are the hours of operation ?
Ans: Open all days mostly from 9:30 to 8:30 and exceptions on Sundays. Call them before going to the location.