- Calculating data with advanced formulas
- Organizing Worksheet and Table data
- Presenting Data using Charts
- Analyzing Data using pivot tables and pivot charts
- Inserting graphic Objects
Working with Advanced Excel 2013
Join the Working with Advanced Excel 2013 course and master Microsoft Excel’s advanced features to increase your ...Read more
Online
28 Hours
₹ 3200 4400
Quick Facts
particular | details | ||||
---|---|---|---|---|---|
Medium of instructions
English
|
Mode of learning
Self study, Virtual Classroom
|
Mode of Delivery
Video and Text Based
|
Frequency of Classes
Weekdays, Weekends
|
Course overview
The Working with Advanced Excel 2013 online course by NIIT includes a combination of practical learning and business concepts theory. It aims to make you proficient in advanced Microsoft Excel 2013 features for analysing and computing sophisticated data. You will learn how to share worksheets and collaborate Excel data with other applications.
During the Working with Advanced Excel 2013 certification programme, you will become adept at implementing advanced analysis techniques to complicated data sets. You will also explore the automation of some everyday tasks. Plus, you will explore the latest technologies like Extensible Markup Language (XML) and business process automation for structuring workbooks.
NIIT’s Working with Advanced Excel 2013 training is designed to make you skilled at charting data, planning budgets and recording expenditures. The course has 28 hours of live content, real-time doubt clarification, faculty connect, learning resources, and case study-based practice exercises. You will also earn an NIIT certificate after completing the course.
Also Read:
Microsoft Excel Certification Courses
The highlights
- 28-hours programme
- Expert faculty
- Practical oriented curriculum
- Both weekend, and weekday batches
- Online course
- Certification available
- An offering of NIIT
- Live online classes
- Instructor-led learning
Program offerings
- Expert instructor
- Live online classes
- Practical exercises
- Learning resources
- Roleplays
- Niit certificate
- Case studies
- Peer connect
- Instructor-led learning
- Hands-on practice
- Learner dashboard
Course and certificate fees
Fees information
Fee | Amount in INR |
Programme fee | Rs. 4,400 |
Discounted Fee | Rs. 3,200 |
GST charges | 18% |
certificate availability
Yes
certificate providing authority
NIIT
Who it is for
The Working with Advanced Excel 2013 online course is meant for graduates and undergraduates who want to learn advanced MS Excel features considering the fact that they have some basic knowledge of Excel.
Eligibility criteria
You need some basic working knowledge of MS Excel before joining the Working with Advanced Excel 2013 programme.
Certificate qualifying details
You will be eligible for the Working with Advanced Excel 2013 certification only after completing the course in full.
What you will learn
After the completion of the Working with Advanced Excel 2013 training, you will be able to:
- Use charts to present data
- Importing and exporting data
- Develop skills in functions, pivot table, graphics object, and analysing data
- Insert graphic objects in Excel
- Use XML to structure workbooks
- Compute data with advanced formulae
- Scrutinise data using pivot charts and pivot tables
- Audit worksheets efficiently
- Automate important business operations
The syllabus
Working with data in advanced Excel
Working with workbook and worksheets
- Customizing and Enhancing workbooks and the Excel environment
- Streamlining workflow
- Collaborating with others
- Auditing worksheets
- Analyzing data
- Working with multiple workbooks
- Importing and Exporting data
- Using Excel with the web
Automation in Excel
- Structuring workbooks with XML
- Automating business operations
- Manipulating the Excel environment
Admission details
Step 1 – Open the Working with Advanced Excel 2013 course page by clicking here: https://www.niit.com/india/short-term-courses/information-technology/working-advanced-excel-2013.
Step 2 – Click on the ‘Enroll Now’ button to open a registration window.
Step 3 – Enter the required info, agree to the terms, and hit ‘Register’.
Step 4 – After registration, you will reach the payments page. Select your location and pay the course fee to join the Working with Advanced Excel 2013 programme by NIIT.
Filling the form
You need not fill any application form to enrol in the Working with Advanced Excel 2013 programme. Simply visit the NIIT Digital portal, create an account and pay the fee to get admission. You need to enter your full name, mobile number, OTP, and email ID while signing up.
How it helps
The Working with Advanced Excel 2013 certification course follows an instructor-led learning method. You get live access to online classes conducted by expert faculty with the flexibility of choosing your location.
You will become skilled at MS Excel to explore job roles in administration, back office, etc. Moreover, you will receive the Working with Advanced Excel 2013 certificate as a testimony of your skills. This certification will add immense value to your resume and LinkedIn profile.
Instructors
FAQs
How long is the Working with Advanced Excel 2013 course?
The course has 28 hours of content.
Who is the course instructor?
Venkat Rao Yamana, a Lead Specialist at NIIT, is the Working with Advanced Excel 2013 programme instructor.
Are there any prerequisites for enrolment?
You just need to have a fundamental working knowledge of MS Excel to join the Working with Advanced Excel 2013 training.
Will I receive hands-on training to build Excel skills during the Working with Advanced Excel 2013 course?
Yes, you will get dedicated machine room hours to practice theory on MS Excel to real-life skills.