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
Online Marketing Courses in Pune
Online Marketing Courses in Delhi
Online Marketing Courses in Noida
Online Marketing Courses in Patna
Online Marketing Courses in Ranchi
Digital Marketing Training in Pune
Digital Marketing Training in Delhi
Digital Marketing Training in Noida