Certificate Course in Advance Excel

Accelerate your Career. Stay Ahead of the Curve


Jointly Delivered by eduplusnow and Industry Expert


executive2

datascience3

Classroom and Online Course

24 hours

WEEKDAY BATCH (MON - FRI)


24 hours

WEEKEND BATCH (SAT - SUN)




About Advanced Excel

Advanced Excel training will expertise individual in spreadsheet capabilities, spreadsheet operations using tools, functions, diagrams etc.


Course Features

In detail coverage of Excel functions, reports, Lookups ,pivot tables etc.


Tools Covered


excel-logo

Syllabus


Advanced Excel
  • Main Features and advantages of Excel – Overview
  •  Workbook, worksheets structure
  •  Options settings and configurations
  • 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
  • Using Excel as a database
  • Sorting Data
  • Custom sorts
  •  
  • Filtering using AutoFilter
  •  
  • The Advanced Filter tool
  • Data consolidation
  •  
  • Linking to another workbook
  •   
  • Linking to an external database
  •   
  • Getting data from the web
  •  Selecting the data to chart
  •  Creating a chart
  •  Choosing the right chart for the job
  •  Moving and re-sizing charts
  •  Customizing charts
  •  Saving and copying a chart's design
  •  Creating an Excel table
  •  Table formatting
  •  Adding rows and columns
  •  Automatic calculation in tables
       
  •  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
  • 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
  • Concept and advantage of templates
  • Creating template
  • Using the template
  • Difference between Addins and Templates
  • Creating a AddIn
  • Using a AddIn
  • Concept and importance of Macro
  • Creating a macro
  • Running existing macros
  • Attaching Macro to Keyboard keys, Tool bar, Menu Bar or button-click
  • VBA Code overview

Learning Outcomes

  • By attending Advance Excel training at eduplusnow you will become master Microsoft excel from begineer to advanced with common excel functions, Vlookups, Index, Match Fuctions and many more..

Assessment

Periodic assessment and case studies evaluations by the edu plus now and Industry Expert have been built in throughout the duration of the course.

datascience18

Awarded by edu plus now


What our learners have to say about us!


Our Alumni work at


*Alumni of Eduplusnow, VIT, VIIT, VU Will Get Special Discount, To Grab your Discount coupon Please Contact   +918956167195.

Course Fees

INR 8,000 (+GST)

INR 5,000 (+GST)

"If a group of four or more participants enroll with us, a concession of 10% will be awarded to each one of them. For more details Contact us."    +91 8956167195


Interested in This Program?






Location

Vishwakarma Institute of Technology, 666, Upper Indiranagar, Bibwewadi, Pune, Maharashtra, INDIA - 411 037


Why edu plus now


whyepn1

Industry-Ready Courses

Learn industry-relevant skills that’ll make your resume stand out and ensure you’re ready to tackle the job market.

whyepn2

Flexible Learning

Access online learning resources anywhere, anytime to gain valuable skills and transform your life in meaningful ways.

whyepn3

Qualified Instructors

Connect with experts and qualified instructors from reputed universities to stay on top of the ever-evolving future of work.

whyepn4

Adavanced study plans

Learn complex technical skills with videos, quizzes and assignments to develop your career and build towards a degree.

whyepn5

Focus on target

Select the best online courses in India that are not only informative and helpful to your long-term career goals but also help close the skill gap in the industry.

whyepn6

Knowledge Platform

Take advantage of a complete in-built environment for programming and get hands-on experience to solve real-world problems practically.

About the Organization


datascience23

edu plus now is an online educational platform that was launched in 2019 to bridge the skill gap between classroom learning, real business challenges and to help students achieve their career potential.


Aimed at providing learners with essential technical skills, edu plus now courses are created to be the perfect amalgamation of inputs from industry experts and highly-qualified professors from the country’s top educational institutions. This allows individuals and companies to close the skill gap quickly, innovate faster and achieve their key objectives. At edu plus now, we believe in preparing students for success in a changing world by providing online courses that pave the path for a successful career. Built under the aegis of the Vishwakarma Group, the online education platform provides flexible learning that fits a learner’s schedule.

×

Call Me Back

Get Free Career Advice By Putting Your Mobile Number Below, Our Counselor will get back to you
+91
OR

You can Directly Contact Our Counselor On Below Help-Line

Note: You will receive a call between Mon-Fri from 9AM - 9PM.