Programme Highlights

Certification

Get a Certification from us which will be very helpful for your job in future.

Free Study Material

We provide practical oriented study material considering the market standards.

Practical Assignments

Practical assignments at the end of every session which will help you to understand course.

Advance Ms Excel Training

Now a days, many jobs require Advanced Excel skills. Virash Training Institute provide that advanced skills to students or Working professionals so that they utilize that features taught in an office environment with maximum efficiency.

This course is designed for the intermediate student who are already familiar with the basics of Microsoft Excel version and wants to gain more advanced skills to put to work in a business environment or for personal use. This course goes in-depth, using step-by-step instructions to teach advanced techniques to broaden all students' knowledge and use of the program.

Our course helps students to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks.

Course Highlights

Advance excel help in improving productivity by collecting volumes of data from multiple sources, include in-store transactions, online sales.

Excel spreadsheet are commonly use across business to display financial information and other data which are relevant for business.

Objective

  • Perform Logical function using single and multiple criteria function
  • Using Data table. Data forms, Depreciation Functions
  • Creating charts with use of all functions related to charts
  • Sorting and Sub-Totaling
  • Track Changes

Scope

This Advanced Excel Course will empower the participants to be able to do the following:

  • Performing complex calculations more efficiently, using various Excel functions
  • Organizing and analyzing large volumes of data
  • Creating MIS reports
  • Designing and using templates
  • Consolidating and managing data from multiple workbooks

Candidate should be familiar with the basic operations in Microsoft Excel, such as simple calculations, formatting and printing.

Certificate on Advance MS Excel Course Completion.

Learning Process

CONCEPT LEARNING

PRACTICAL IMPLEMENTATION

PRACTICAL ASSESSMENT

COURSE CERTIFICATION

Course Syllabus

  • Spreadsheet basics
  • Creating, editing, saving and printing spreadsheets
  • Working with functions & formulae
  • Graphically representing data: Charts & Graphs
  • Analyzing data: Data Menu, Subtotal, Filtering Data
  • Formatting worksheets, Securing & Protecting spread sheets
  • Use the Function Wizard, Common functions (AVERAGE, MIN, MAX, COUNT, COUNTA, ROUND, INT)
  • Nested functions, Name cells /ranges /constants
  • Relative, Absolute, Mixed cell references >, <, = operators
  • Logical functions using IF, AND, OR, NOT
  • The LOOKUP function, Date and time functions, Annotating formulas
  • Sorting
  • To perform a Simple Sort
  • To Sort by Multiple Columns
  • Data Forms
  • Adding Data Using the Data Form
  • Finding Records Using Criteria
  • Managing Windows
  • Multiple Windows
  • Splitting Windows
  • Freezing Panes
  • Analysis tool pack
  • Sub Total Reports, Auto Filter
  • Password Protecting Worksheets
  • Linking Multiple Sheets
  • Sheet Referencing
  • Linking Between Word/Excel/PPT
  • NESTED IF
  • Reporting
  • Character Functions
  • Date Functions
  • Age Calculations
  • Consolidation of Data
  • Data Validation
  • Enter the Pivot Table Data
  • Create the Pivot Table
  • Adding Data to the Pivot Table
  • Filtering the Pivot Table Data
  • Change the Pivot Table Data
  • Analyze Data Columns in Pivot Tables
  • Adjust Data to Analyze
  • Plan a worksheet, Row and Column labels
  • Split worksheet /box /bar, Copy data and formulas
  • Display /move toolbars, Enhance worksheet Appearance
  • Use multiple windows: Copy/ paste between Worksheets
  • Link worksheets, Consolidate worksheets
  • Import and link from other Applications
  • Use AutoFormat: Create, use and modify styles and templates
  • Print features: Create /edit an outline
  • Create charts, enhance charts, Drawing toolbar features
  • Definition and use, Record a macro
  • Assign a macro, Run a macro
  • Store a macro, Introduction to VBA Prog
  • Note: All concepts will be explain from basics in deep knowledge.
  • Contact us to know reference scheme and get attractive discount on admission of 2+ Students.

Frequently Asked Questions

Note : If your questions is still not answered in above FAQs, don't hesitate to contact us. We are available to answer your queries anytime.

What People say

See All Reviews