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

Akiko Callnet Logo

MS-Office

Microsoft Office includes- MS-Word, MS-Excel, MS PowerPoint, and MS-Outlook. Microsoft Word is a component of the Microsoft Office suite of productivity software, Microsoft Excel enables users to format, organize, and calculate data in a spreadsheet.

by Akiko Callnet [Claim Listing ]
SAFE Computer Academy Logo

Advance Excel

Advance Excel course is offered by SAFE Computer Academy. Knowledge of IT is essential in today’s world. No matter which career you choose, you need a strong foundation in IT & computers. Explore this new and exciting world with SAFE.

by SAFE Computer Academy [Claim Listing ]
ICIT Computer Institute Logo

Advance Excel

This course will take you on a structured and thorough journey that will teach you how to turn ‘buckets of data’ into sound, well-supported business decisions, create stunning charts to communicate these business decisions and make you one the most valuable people in your business.

by ICIT Computer Institute [Claim Listing ]
  • Price
  • Start Date
  • Duration
Sami Infotech Logo

MS Office

Are you interested in learning MS Office skills to enhance your proficiency and productivity? Our MS Office course in Navi Mumbai is designed keeping in mind your specific learning needs. Get ready to unlock your potential with our expert guidance.

by Sami Infotech [Claim Listing ]
Dreamer Infotech Logo

MS Excel (Advance)

Advanced Excel courses with certification can be a fantastic investment for anyone looking to upscale their career in the IT sector. Invest your valuable time in the right place by acquiring in-demand skills, learning from experienced industry experts, and receiving career guidance and support.

by Dreamer Infotech

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