Certificate Course in Advance Excel
Accelerate your Career. Stay Ahead of the Curve
Jointly Delivered by eduplusnow and Industry Expert
WEEKEND (SAT - SUN)
Upcoming Batch Details
Date :07th Aug 2021-14th Aug 2021
Batch Type :Saturday-Sunday
About Advanced Excel
Advanced Excel training will expertise individual in spreadsheet capabilities, spreadsheet operations using tools, functions, diagrams etc.
In detail coverage of Excel functions, reports, Lookups ,pivot tables etc.
Who Should Enroll?
- Ideal for any Graduate, professionals from Banking, MIS, Back office, fiance MBA in any domain.
- There are no pre requisites for Advance Excel training.
- 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
- 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
- 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..
Periodic assessment and case studies evaluations by the edu plus now and Industry Expert have been built in throughout the duration of the course.
Awarded by edu plus now
What our learners have to say about us!
Our Alumni work at
Course Fees : 8,000 (+GST)
- Options Settings And Configurations
- Working with Functions in Excel
- Working with Data using excel
- Using Excel As A Database
- Macros and Templates in excel
- Collaboration Tools
- Tables in excel
- Charting with Excel
*Alumni of Eduplusnow, VIT, VIIT, VU Will Get Special Discount, To Grab your Discount coupon Please Contact +918956167195.
Why edu plus now
Learn industry-relevant skills that’ll make your resume stand out and ensure you’re ready to tackle the job market.
Access online learning resources anywhere, anytime to gain valuable skills and transform your life in meaningful ways.
Connect with experts and qualified instructors from reputed universities to stay on top of the ever-evolving future of work.
Adavanced study plans
Learn complex technical skills with videos, quizzes and assignments to develop your career and build towards a degree.
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.
Take advantage of a complete in-built environment for programming and get hands-on experience to solve real-world problems practically.
About the Organization
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.