article banner

Course Coverage

Our Courses

  • Using Custom & Conditional Formats
    • Creating a custom format
    • Create a custom number format
    • Conditional Formatting
    • Creating Conditional Formatting 
    • Editing Conditional Formatting 
    • Adding Conditional Formatting
    • Deleting Conditional Formatting from the selected range
  • Using Range Names
    • Using Range names
    • Creating range names
    • Using range names in formulas
    • Creating range names from headings
    • Deleting range names
  • Using Formulas & Functions
    • Text Function
    • Logical Functions
    • Date and Time Functions
    • Information Function
    • Database Functions
    • Math and Trigonometry Functions
    • Statistical Functions
    • Lookup and reference functions
  • Managing, Sorting & Filtering Tables
    • Creating Tables 
    • Naming the Tables
    •  Changing the Table style
    • Creating a total row
    • Creating a calculated column
    • using FIltering in Table
    •  Removing the duplicate record
  • Working with Charts
    • Creating a chart
    • Formatting a chart
    • Adding Labels 
    • Changing the chart type, Data source
  • Working with Pivot Tables
    • Creating Pivot tables
    • Adding Pivot table Report Fields
    • Refreshing Pivot table Reports
    • Changing the summary functions
    • Creating report filter page
  • Working with Shared Workbooks
    • Sharing a workbook
    • Opening and editing a shared workbook
    • Tracking changes
    • Resolving conflict in a shared workbook
  • Working with Multiple Workbooks
    • Linking workbooks
    • Editing the Link
    • Consolidating the workbooks
  • Protecting Your Worksheet and Workbook
    • Protecting your work sheet
    • Protecting range with password
    • Protecting your Workbook and Excel File

« Back

For more details please contact

Rohit Gupta

E: rohit.gupta1@in.gt.com Mob: +91 989 139 5363

Enquiry form