Be a Microsoft Excel Professional

What you learn during the training?

Chapter 1 Manage And Share Workbooks In Ms Excel 2013

Chapter 2 Objectives

Chapter 3 Share Workbooks

Chapter 4 Shareworkbooks (Contd.)

Chapter 5 Business Scenario

Chapter 6 Demo Summary

Chapter 7 Track Changes

Chapter 8 Highlight Changes And Comments

Chapter 9 Business Scenario

Chapter 10 Demo Summary

Chapter 11 Accept And Reject Changes

Chapter 12 Business Scenario

Chapter 13 Demo Summary

Chapter 14 Formula Errors

Chapter 15 Error Tracing

Chapter 16 Business Scenario

Chapter 17 Demo Summary

Chapter 18 Quiz

Chapter 19 Summary

Chapter 20 Thank You

Chapter 1 Apply Custom formats and layouts

Chapter 2 Objectives

Chapter 3 Create Custom Conditional formats

Chapter 4 Conditional Formatting Rule Types

Chapter 5 Business Scenario

Chapter 6 Demo Summary

Chapter 7 Formatting cells Using Formulas

Chapter 8 Formatting Celis Using Formulas (contd.)

Chapter 9 Business Scenario

Chapter 10 Demo Summary

Chapter 11 Manage Conditional Format Rules

Chapter 12 Manage conditional format Rules (contd.)

Chapter 13 Business Scenario

Chapter 14 Demo Summary

Chapter 15 Create Advance Filters by Search

Chapter 16 Business Scenario

Chapter 17 Demo Summary

Chapter 18 Create Advance Filters Using Values

Chapter 19 Business Scenario

Chapter 20 Demo Summary

Chapter 21 Create Advance Filters by Colors

Chapter 22 Business Scenario

Chapter 23 Demo Summary

Chapter 24 Modify Worksheets with Accessibility Tools

Chapter 25 Modify Worksheets with Accessibility Tools (Contd.)

Chapter 26 Business Scenario

Chapter 27 Demo Summary

Chapter 28 Display Data in Multiple international Formats

Chapter 29 Business Scenario

Chapter 30 Demo Summary

Chapter 31 Proofing in other languages

Chapter 32 Proofing in Other languages (Contd.)

Chapter 33 Business Scenario

Chapter 34 Demo Summary

Chapter 35 Use international symbols

Chapter 36 Use international Symbols (contd.)

Chapter 37 Business Scenario

Chapter 38 Demo Summary

Chapter 39 Manage body and heading fonts

Chapter 40 Manage body and Heading fonts (contd.)

Chapter 41 Business Scenario

Chapter 42 Demo Summary

Chapter 43 Quiz

Chapter 44 Summary

Chapter 45 Thank You

Chapter 1 Create Advanced Formulas in Excel 2013

Chapter 2 Objectives

Chapter 3 LOOKUP Functions

Chapter 4 VLOOKUP Function

Chapter 5 Syntax Arguments in VLOOKUP Function

Chapter 6 Business Scenario

Chapter 7 Demo Summary

Chapter 8 HLOOKUP Function

Chapter 9 Syntax Arguments in HLOOKUP Function

Chapter 10 Business Scenario

Chapter 11 Demo Summary

Chapter 12 LOOKUP Function

Chapter 13 Syntax Arguments in LOOKUP Function

Chapter 14 Business Scenario

Chapter 15 Demo Summary

Chapter 16 TRANSPOSE Function

Chapter 17 Business Scenario

Chapter 18 Demo Summary

Chapter 19 TODAY and NOW Functions

Chapter 20 Business Scenario

Chapter 21 Demo Summary

Chapter 22 DAY MONTH and YEAR Functions

Chapter 23 Business Scenario

Chapter 24 Demo Summary

Chapter 25 HOUR MINUTE and SECOND Functions

Chapter 26 Business Scenario

Chapter 27 Demo Summary

Chapter 28 DATEVALUE and TIMEVALUE Functions

Chapter 29 Business Scenario

Chapter 30 Demo Summary

Chapter 31 CONCATENATE Function

Chapter 32 WEEKDAY and WEEKNUM Functions

Chapter 33 Syntax Arguments in WEEKDAY and WEEKNUM Function

Chapter 34 Business Scenario

Chapter 35 Demo Summary

Chapter 36 WORKDAY and WORKDAY INTL Functions

Chapter 37 Business Scenario

Chapter 38 Demo Summary

Chapter 39 NETWORKDAYS and NETWORKDAYS INTL Functions

Chapter 40 Business Scenario

Chapter 41 Demo Summary

Chapter 42 Quiz

Chapter 43 Summary

Chapter 44 Thank You

Chapter 1 Create Advanced Charts

Chapter 2 Objectives

Chapter 3 Trendlines

Chapter 4 Linear Trendline

Chapter 5 Logarithmic Trendline

Chapter 6 Polynomial Trendline

Chapter 7 Power Trendline

Chapter 8 Exponential Trendline/p>

Chapter 9 Moving Average Trendline

Chapter 10 Business Scenario

Chapter 11 Demo Summary

Chapter 12 Chart Elements

Chapter 13 Filters in Charts

Chapter 14 Dual Axis Charts

Chapter 15 Business Scenario

Chapter 16 Demo Summary

Chapter 17 Create Custom Chart Templates

Chapter 18 Business Scenario

Chapter 19 Demo Summary

Chapter 20 Quiz

Chapter 21 Summary

Chapter 22 Thank You

Chapter 1 Create and Manage PivotTables

Chapter 2 Objectives

Chapter 3 PivotTables

Chapter 4 Create PivotTables

Chapter 5 Create PivotTables contd

Chapter 6 Create PivotTables contd

Chapter 7 Create PivotTables contd

Chapter 8 Business Scenario

Chapter 9 Demo Summary

Chapter 10 Recommended PivotTables Button

Chapter 11 Business Scenario

Chapter 12 Demo Summary

Chapter 13 Format Pivot t

Chapter 14 Business Scenario

Chapter 15 Demo Summary

Chapter 16 Modify Field Headers

Chapter 17 Business Scenario

Chapter 18 Demo Summary

Chapter 19 Change the View of Data

Chapter 20 Group Records

Chapter 21 Business Scenario

Chapter 22 Demo Summary

Chapter 23 Calculated Field and Calculated Item

Chapter 24 Calculated Field and Calculated Item contd

Chapter 25 Business Scenario

Chapter 26 Demo Summary

Chapter 27 Slicers

Chapter 28 Slicers contd

Chapter 29 Business Scenario

Chapter 30 Demo Summary

Chapter 31 View Chart Animations

Chapter 32 Business Scenario

Chapter 33 Demo Summary

Chapter 34 Install PowerPivot Add in

Chapter 35 Business Scenario

Chapter 36 Demo Summary

Chapter 37 PowerPivot

Chapter 38 PowerPivot contd

Chapter 39 Business Scenario

Chapter 40 Demo Summary

Chapter 41 PowerPivot Relationships

Chapter 42 Create Relationship between Tables

Chapter 43 Create Relationship between Tables contd

Chapter 44 Business Scenario

Chapter 45 Demo Summary

Chapter 46 Edit and Delete Relationship

Chapter 47 Business Scenario

Chapter 48 Demo Summary

Chapter 49 Create PowerPivot Hierarchy

Chapter 50 Business Scenario

Chapter 51 Demo Summary

Chapter 52 Modify PowerPivot Hierarchy

Chapter 53 Business Scenario

Chapter 54 Demo Summary

Chapter 55 Quiz

Chapter 56 Summary

Chapter 57 Thank You

Do you wish to become MS Excel professional?