| Module1:Introduction to Excel: |
| ♦ Introduction to Excel interface |
| ♦ Understanding rows and columns, Naming Cells |
| ♦ Working with excel workbook and sheets |
| Module2:Formatting excel work book |
| ♦ New, Open, Close, Save, Save As |
| ♦ Formatting Text: Font Size, Font Style |
| ♦ Font Color, Use the Bold, Italic, and Underline |
| ♦ Wrap text, Merge and Centre |
| ♦ Currency, Accounting and other formats |
| ♦ Modifying Columns, Rows, & Cells |
| Module3: Perform Calculations with Functions |
| ♦ Creating Simple Formulas |
| ♦ Setting up your own formula |
| ♦ Date and Time Functions, Financial Functions |
| ♦ Logical Functions |
| ♦ Lookup(V-Lookup and H-Lookup) and Reference Functions |
| ♦ Mathematical Functions |
| ♦ Statistical Functions, Text Functions |
| ♦ Working with Templates |
| Module 4: Managing Tables |
| ♦ Creating Tables |
| ♦ Naming the Table |
| ♦ Changing the Table Style |
| ♦ Creating a Total Row |
| ♦ Creating a calculated column |
| ♦ Using Filtering in Table |
| ♦ Removing the Duplicate Record |
| Module 5: Sort and Filter Data with Excel |
| ♦ Sort and filtering data |
| ♦ Using number filter, Text filter |
| ♦ Custom filtering |
| ♦ Removing filters from columns |
| ♦ Conditional formating |
| Module 6: Create Effective Charts to Present Data Visually |
| ♦ Inserting Column, Pie chart etc. |
| ♦ Create an effective chart with Chart Tool |
| ♦ Design, Format, and Layout options |
| ♦ Adding chart title |
| ♦ Changing layouts |
| ♦ Chart styles |
| ♦ Editing chart data range |
| ♦ Editing data series |
| ♦ Changing chart |
| ♦ Saving chart as template |
| ♦ Summarizing data using spark line |
|
| Module 7: Analyze Data Using Pivot Tables and Pivot Charts |
| ♦ Understand PivotTables, Create a PivotTable |
| ♦ Framework Using the PivotTable and PivotChart |
| ♦ Create Pivot Chart from pivot Table |
| ♦ Inserting slicer |
| ♦ Creating Calculated fields |
| Module 8: Protecting and Sharing the work book |
| ♦ Protecting a workbook with a password |
| ♦ Allow user to edit ranges |
| ♦ Track changes |
| ♦ Working with Comments |
| ♦ Insert Excel Objects and Charts in Word Document and Power point Presentation |
| Module 9: Use Macros to Automate Tasks |
| ♦ Creating and Recording Macros |
| ♦ Assigning Macros to the work sheets |
| ♦ Saving Macro enabled workbook. |
| Module 10: proofing and Printing |
| ♦ Page setup, Setting print area, Print titles |
| ♦ Inserting custom Header and Footer |
| ♦ Inserting objects in the header and footer |
| ♦ Page Setup, Setting margins, Print Preview, Print |
| ♦ Enable back ground error checking |
| ♦ Setting AutoCorrect Options |
| ♦ Remove the appropriate check marks to disable any unwanted features |
|
+60377730654