Brochure
Enquire- Main Features and advantages of Excel –Overview
- Workbook, worksheets structure
- Options settings and configurations
- Home
- edu plus now
- Courses
- Advanced Excel
Advanced Excel
BY
edu plus now
Build your competence with the advanced-level concepts of Microsoft Excel by learning about the spreadsheets and ...Read more
Online
11 Days
₹ 8000
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
Weekends
|
Course overview
The ‘Advanced Excel’ certification is designed to deliver insights on the concepts and features of Microsoft Excel software. The course discusses different aspects of spreadsheet functions and spreadsheet operations with the help of advanced tools and techniques. This online course is provided by the education provider platform Edu Plus Now in association with the Indian Statistical Institute. The course study is organized for the students for a period of three days.
The industry-based curriculum in this course is provided to the candidates of the program and is guided by academically and professionally qualified course instructors. The online classes are aided with online learning methodologies such as recorded lectures, interactive sessions, and domain-oriented projects with assignments for evaluation.
The ‘Advanced Excel’ online certification program equips students with theoretical and practical conceptual clarity, professional understanding of MS Excel, and the students are given course completion certificates by the end of the course.
The highlights
- Online mode
- Live sessions
- Eleven days program
- Expert faculty
- Career assistance
- Course completion certificate
Program offerings
- Online sessions
- Live classes
- Recorded lectures
- Course modules
- Projects
- Assignments
- Course certificate
Course and certificate fees
Fees information
₹ 8,000
The ‘Advanced Excel’ certification fee is paid online as part of the registration process to get access to the course curriculum to start the program.
Advanced Excel fee structure
| Head | Amount in INR |
Course Fee | Rs. 8,000 + GST |
certificate availability
Yes
certificate providing authority
edu plus now
Who it is for
The ‘Advanced Excel’ online certification program is directed at individuals and professionals in the role of management of information systems and other aspects of the business. The course equips the students with knowledge for effective functioning as data analysts, managers, and MIS(management of information systems) executives.
Eligibility criteria
Certificate qualifying details
The participants of the ‘Advanced Excel’ program will qualify for the course certificate after completing the course study.
What you will learn
Technical skills
Knowledge of excel
The ‘Advanced Excel’ certification syllabus is structured for the candidates of the program to gain skills and knowledge on the concepts of MS Excel with an understanding of the functions, the excel reports, Vlookups, index, match functions, and pivot tables with effective tools and diagrams. The learners in this course will be able to strengthen their foundation in the knowledge of processes involved while working with MS Excel.
The syllabus
Basic Excel Environment
Introduction to Excel
Working with Functions
Using of Functions
- Using the Paste Function tool
- Cell Ref/Freezing Concept
- Using Named Ranges in Formulas
- Naming a Single Cell
- Naming a Range of Cells
- Naming Multiple Single Cells Quickly
- Using Formulas That Span Multiple Worksheets
- Using the IF Function Using AND/OR Functions
- Using the SUMIF, AVERAGEIF, and COUNTIF Functions
- Using the LOOKUP Function
- Using the VLOOKUP Function
- Using the HLOOKUP Function
- Using the CONCATENATE Function
- Using the TRANSPOSE Function
- Using the PROPER, UPPER, and LOWER Functions
- Using Max, Min, Large, Small
- The TRIM Function
- Text To Column
- Using Date Functions
- Using the NOW and TODAY Functions
- Conditional Formatting
Working with Data
Using Excel Data
- Using Excel as a database
- Sorting Data
- Custom sorts
- Filtering using AutoFilter
- The Advanced Filter tool
Working with External Data
Working with External Data
- Data consolidation
- Linking to another workbook
- Linking to an external database
- Getting data from the web
Charting with Excel
Creating a Chart
- Selecting the data to chart
- Choosing the right chart for the job
- Moving and resizing charts
- Customizing charts
- Saving and copying a chart’s design
Tables
Creating Table
- Creating an Excel table
- Table formatting
- Adding rows and columns
- Automatic calculation in tables
Collaboration Tools
Working Tools
- Protecting a workbook
- Protecting worksheets and cells
- Adding comments to cells
- Sharing workbooks
- Tracking changes
- Auditing Workbooks
- Viewing formulas
- Tracing precedents and dependents
- Error checking
Pivot Table
Creating Pivot Table
- Golden Rule of Pivot
- Create Pivot Table
- Create multiple pages
- Classic pivot table
- Consolidate
- Merging Summary data from different sheets
- Merging Summary data from different files
- Merging non-summary data
Templates
Creating Templates
- Concept and advantage of templates
- Creating template
- Using the template
AddIns
Working on Addins
- Difference between Addins and Templates
- Creating an Addin
- Using an Addin
Macros
Introduction of Macros
- Concept and importance of Macro
- Creating a macro
- Running existing macros
- Attaching Macro to Keyboard keys, Toolbar, Menu Bar or button-click
- VBA Code overview
Admission details
The students who wish to join 'Advance Excel’ online classes should register for the course online through the website.
Step 1: Find the course page using the link, https://www.eduplusnow.com/course-details/certificate-course-online-advance-excel-course
Step 2: Choose the ‘Enroll Now’ option.
Step 3: Enter the relevant details.
Step 4: Make the course payment and complete the registration.
Filling the form
The ‘Advance Excel’ certification by Edu Plus Now provider platform requires the students to fill in their details such as name, phone number, and email address on the registration form to register themselves for the course.
How it helps
The ‘Advance Excel’ certification benefits the candidates of this online program by providing them insights and knowledge of the basics to the advanced concepts of Microsoft Excel with its functions. The working professionals of this program are given the advantage of studying in separate batches according to their schedules.
FAQs
Which online platform offers the ‘Advance Excel’ online course?
The course is provided by the education platform Edu Plus Now.
How long is the duration of the ‘Advance Excel’ course classes?
The classes are conducted for eleven days.
What background knowledge is required to apply for the ‘Advance Excel’ certification?
There are no prerequisites for this program.
When will I get the course certificate for the ‘Advance Excel’ training?
You can get the course certificate after completing the course.
When do I have to log in to get access to the ‘Advance Excel’ online certification classes?
The students of this course are required to register for the course and learn through the recorded lectures and other interactive activities of the course.
Articles
Popular Articles
prev
next
Latest Articles
prev
next
