Chapter 1 Introduction to Excel 2013
Chapter 2 Objectives
Chapter 3 Excel 2013 Application User Interface
Chapter 4 Excel 2013 Application User Interface contd
Chapter 5 Excel 2013 Application Window
Chapter 6 Excel 2013 Application Window Elements
Chapter 7 Ribbon Options
Chapter 8 Business Scenario
Chapter 9 Demo Summary
Chapter 10 Quick Access Toolbar
Chapter 11 Customize Quick Access Toolbar
Chapter 12 Business Scenario
Chapter 13 Demo summary
Chapter 14 Backstage View in Excel 2013
Chapter 15 New Features in Excel 2013
Chapter 16 Quiz
Chapter 17 Summary
Chapter 18 Thank You
Chapter 1 Create and Manage Workbooks and Worksheets
Chapter 2 Objectives
Chapter 3 Excel 2013 Workbooks
Chapter 4 Create a Blank Workbook
Chapter 5 Create a Workbook from a Template
Chapter 6 Open an Existing Workbook
Chapter 7 Business Scenario
Chapter 8 Demo Summary
Chapter 9 Native and Non native Files
Chapter 10 Connect Import External Files
Chapter 11 Connect Import External Files contd
Chapter 12 Business Scenario
Chapter 13 Demo summary
Chapter 14 Worksheet Operations
Chapter 15 Change Worksheet Tab Color
Chapter 16 Hide or Unhide Worksheets
Chapter 17 Business Scenario
Chapter 18 Demo summary
Chapter 19 Search and Replace Data
Chapter 20 Go To and Name Box
Chapter 21 Business Scenario
Chapter 22 Demo summary
Chapter 23 Insert Hyperlinks
Chapter 24 Business Scenario
Chapter 25 Demo summary
Chapter 26 Modifying Workbook Themes
Chapter 27 Modify Page Setup
Chapter 28 Insert and Delete Columns and Rows
Chapter 29 Modify Row Height and Column Width
Chapter 30 Hide or Unhide Columns and Rows
Chapter 31 Business Scenario
Chapter 32 Demo summary
Chapter 33 Insert Headers and Footers
Chapter 34 Insert Headers and Footers contd
Chapter 35 Business Scenario
Chapter 36 Demo summary
Chapter 37 Data Validation
Chapter 38 Data Validation contd
Chapter 39 Business Scenario
Chapter 40 Demo summary
Chapter 41 Enable Developer Tab
Chapter 42 Macro Security Options
Chapter 43 Record Macros
Chapter 44 Business Scenario
Chapter 45 Demo summary
Chapter 46 Backward Compatibility
Chapter 47 Workbook Views
Chapter 48 Use Zoom for Workbooks
Chapter 49 Freeze Panes
Chapter 50 Split Window
Chapter 51 Business Scenario
Chapter 52 Demo summary
Chapter 53 Show Formulas
Chapter 54 Business Scenario
Chapter 55 Demo summary
Chapter 56 Add Values to Workbook Properties
Chapter 57 Business Scenario
Chapter 58 Demo summary
Chapter 59 Save Workbooks in Alternate File Formats
Chapter 60 Set Print Area and Print Workbooks
Chapter 61 Business Scenario
Chapter 62 Demo summary
Chapter 63 Save Workbooks to Remote Locations
Chapter 64 Quiz
Chapter 65 Summary
Chapter 66 Thank You
Chapter 1 Create Cells and Ranges
Chapter 2 Objectives
Chapter 3 Cells and Ranges
Chapter 4 Create Data using FillSeries
Chapter 5 Business Scenario
Chapter 6 Demo Summary
Chapter 7 Create Data using AutoFill
Chapter 8 Business Scenario
Chapter 9 Demo Summary
Chapter 10 Customize AutoFill Options
Chapter 11 Business Scenario
Chapter 12 Demo Summary
Chapter 13 Paste Options
Chapter 14 Paste Special
Chapter 15 Format Cell Structure
Chapter 16 Business Scenario
Chapter 17 Demo Summary
Chapter 18 Merge and Center
Chapter 19 Business Scenario
Chapter 20 Demo Summary
Chapter 21 Format Cell Content
Chapter 22 Business Scenario
Chapter 23 Demo Summary
Chapter 24 Cell Styles
Chapter 25 Business Scenario
Chapter 26 Demo Summary
Chapter 27 Number Formats
Chapter 28 Format Painter
Chapter 29 Business Scenario
Chapter 30 Demo Summary
Chapter 31 Data Model with Advanced Conditional Format
Chapter 32 Data Model with Advanced Conditional Format contd
Chapter 33 Sparklines
Chapter 34 Business Scenario
Chapter 35 Demo Summary
Chapter 36 Create Named Ranges
Chapter 37 Business Scenario
Chapter 38 Demo Summary
Chapter 39 Data Group and Ungroup
Chapter 40 Subtotals
Chapter 41 Quiz
Chapter 42 Summary
Chapter 43 Thank You
Chapter 1 Create Tables
Chapter 2 Objectives
Chapter 3 Tables in Excel 2013
Chapter 4 Create and Format a Table
Chapter 5 Business Scenario
Chapter 6 Demo Summary
Chapter 7 Define Table Names
Chapter 8 Business Scenario
Chapter 9 Demo Summary
Chapter 10 Insert Table Rows and Columns
Chapter 11 Business Scenario
Chapter 12 Demo Summary
Chapter 13 Delete Table Rows and Columns
Chapter 14 Business Scenario
Chapter 15 Demo Summary
Chapter 16 Move Table Rows and Columns
Chapter 17 Business Scenario
Chapter 18 Demo Summary
Chapter 19 Convert to Range
Chapter 20 Business Scenario
Chapter 21 Demo Summary
Chapter 22 Remove Duplicates
Chapter 23 Business Scenario
Chapter 24 Demo Summary
Chapter 25 Design Table Styles
Chapter 26 Business Scenario
Chapter 27 Demo Summary
Chapter 28 Table Style Options
Chapter 29 Filter Tables
Chapter 30 Business Scenario
Chapter 31 Demo Summary
Chapter 32 Sort Table Data
Chapter 33 Business Scenario
Chapter 34 Demo Summary
Chapter 35 Quiz
Chapter 36 Summary
Chapter 37 Thank You
Chapter 1 Apply Formulas and Functions
Chapter 2 Objectives
Chapter 3 Formulas and Functions
Chapter 4 Cell References and Ranges in Formulas
Chapter 5 Cell References and Ranges in Formulas contd
Chapter 6 Business Scenario
Chapter 7 Demo Summary
Chapter 8 Formula Calculations Order
Chapter 9 SUM Function
Chapter 10 Business Scenario
Chapter 11 Demo Summary
Chapter 12 COUNT Function
Chapter 13 COUNTA Function
Chapter 14 Business Scenario
Chapter 15 Demo Summary
Chapter 16 AVERAGE Function
Chapter 17 MIN Function
Chapter 18 MAX Function
Chapter 19 Business Scenario
Chapter 20 Demo Summary
Chapter 21 Conditional Logic in Functions
Chapter 22 SUMIF Function
Chapter 23 SUMIFS Function
Chapter 24 Business Scenario
Chapter 25 Demo Summary
Chapter 26 COUNTIF Function
Chapter 27 COUNTIFS Function
Chapter 28 Business Scenario
Chapter 29 Demo Summary
Chapter 30 AVERAGEIF Function
Chapter 31 AVERAGEIFS Function
Chapter 32 Business Scenario
Chapter 33 Demo Summary
Chapter 34 LOWER PROPER UPPER and CONCATENATE Functions
Chapter 35 TRIM Function
Chapter 36 Business Scenario
Chapter 37 Demo Summary
Chapter 38 LEFT Function
Chapter 39 RIGHT Function
Chapter 40 mid Function
Chapter 41 Business Scenario
Chapter 42 Demo Summary
Chapter 43 Quiz
Chapter 44 Summary
Chapter 45 Thank You
Chapter 1 Create Charts and Objects
Chapter 2 Objectives
Chapter 3 Introduction to Charts
Chapter 4 Create Charts
Chapter 5 Create Charts contd
Chapter 6 Create Charts contd
Chapter 7 Business Scenario
Chapter 8 Demo Summary
Chapter 9 Format Charts
Chapter 10 Format Charts contd
Chapter 11 Business Scenario
Chapter 12 Demo Summary
Chapter 13 Move and Resize Charts
Chapter 14 Business Scenario
Chapter 15 Demo Summary
Chapter 16 Recommended Charts
Chapter 17 Business Scenario
Chapter 18 Demo Summary
Chapter 19 Introduction to Objects
Chapter 20 Insert Picture Objects
Chapter 21 Business Scenario
Chapter 22 Demo Summary
Chapter 23 Insert Other File Formats as Objects
Chapter 24 Business Scenario
Chapter 25 Demo Summary
Chapter 26 Add Textboxes
Chapter 27 Business Scenario
Chapter 28 Demo Summary
Chapter 29 Add SmartArt
Chapter 30 Business Scenario
Chapter 31 Demo Summary
Chapter 32 Quiz
Chapter 33 Summary
Chapter 34 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