Advance Excel

by ITC Claim Listing

Advanced Excel is defined as Highly proficient with Microsoft office and particularly Excel In another, it required a greater skill set.

$2500

Contact the Institutes

Fill this form

Advertisement

ITC Logo

img Duration

45 Days

Course Details

Advanced Excel is defined as Highly proficient with Microsoft office and particularly Excel In another, it required a greater skill set.

 

Course Content:

1: Working With Multiple Worksheets and Workbooks

  • Topic A: Use Links and External References
  • Topic B: Use 3-D References
  • Topic C: Consolidate Data

 

2: Using Lookup Formulas and Formula Auditing

  • Topic A: Use Lookup Functions
  • Topic B: Trace Cells
  • Topic C: Watch and Evaluate Formulas

 

3: Sharing and Protecting Workbooks

  • Topic A: Collaborate on a Workbook
  • Topic B: Protect Worksheets and Workbooks

 

4: Automating Workbook Functionality

  • Topic A: Apply Data Validation
  • Topic B: Search for Invalid Data and Formulas with Errors
  • Topic C: Work with Macros

 

5: Creating Sparklines and Mapping Data

  • Topic A: Create Sparklines
  • Topic B: Map Data

 

6: Forecasting Data

  • Topic A: Determine Potential Outcomes Using Data Tables
  • Topic B: Determine Potential Outcomes Using Scenarios
  • Topic C: Use the Goal Seek Feature
  • Topic D: Forecasting Data Trends
  • Jaipur Branch

    111, 62, Kumbha Marg, Sanganer, Sector 11, Jaipur

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy