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

UPTEC Logo

MS Office And Tally Prime Including GST

This Course is enriching the aspirants with Basic IT skills and implementation of Accounting concepts through Tally Prime. This course is good for the candidates having manual accounting background or studied Commerce during their studies.

by UPTEC [Claim Listing ]
Trilok Computer Education Logo

Certificate In Microsoft Office

Certificate in Microsoft Office course is offered by Trilok Computer Education. Change higher education financing your future, you can rely on the our team to deliver a personal environment tailored specifically for you.

by Trilok Computer Education [Claim Listing ]
Trinity Technologies Logo

MS Office Training

The powerful software in Microsoft Office 2013 remains in Microsoft Office 2016, including features and shortcuts for the things you do most often, like creating professional-looking presentations, working on spreadsheets or word processing.

by Trinity Technologies [Claim Listing ]
MCIT (Madhur Computers & Institute of Technology) Logo

MS Word

MS Word course is offered by MCIT (Madhur Computers & Institute of Technology). After completing our courses students become IT professionals, who are well equipped with knowledge and necessary skills and are able to solve the real problems related to Information Technology.

by MCIT (Madhur Computers & Institute of Technology) [Claim Listing ]
JIIT Academy Logo

MS Word

MS Word course is offered by JIIT Academy. JIIT Academy’s motto is to provide Computer, Technical, and Vocational Education & Training at the most affordable fee, to impart the functional knowledge and skills needed in the community, society, and professions.

by JIIT Academy [Claim Listing ]

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