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

Check out more MS Excel courses in India

Vataliya Soft-Tech Logo

Advanced Excel

Advanced Excel course is offered by Vataliya Soft-Tech. If you want to learn computer science perfectly and master in it so please come to our soft-tech.  We provide all computer science subjects with live project-making.

by Vataliya Soft-Tech [Claim Listing ]
Royal Education Sansthan Logo

Advance Office Foundation

Learn Microsoft Office 2013 and 2016 with this comprehensive course. Advance Office Foundation has made so Easy to help you learn all courses. You get our complete courses including Excel, Word, PowerPoint and Outlook. Watch, listen, and learn.

by Royal Education Sansthan [Claim Listing ]
Matha Education Logo

MS Office

MS Office course is offered by Matha Education. Matha Education Statebank is a place where people of different ages gain education. Which is established in the year 2001. Past from many years we have been bagging with highest result with Distinction in Dakshin Kannada in private SSLC & II PUC.

by Matha Education [Claim Listing ]
ICTCODES Logo

MS Excel Course (Intermediate And Advance)

This 30-hour course is designed for individuals who are already familiar with the basics of Excel and are looking to improve their skills and take their spreadsheet capabilities to the next level.

by ICTCODES [Claim Listing ]
DASVM Logo

Microsoft Visio

Visio is a drawing and diagramming program that includes a variety of pre-drawn shapes and picture elements that can be dragged and dropped onto the illustration. Users can define their own elements and place them onto the Visio palette.

by DASVM [Claim Listing ]

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