Be a Microsoft Excel Professional

What you learn during the training?

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

Do you wish to learn Microsoft Excel?