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.
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
Why Advance MS Excel?
Candidate should be familiar with the basic operations in Microsoft Excel, such as simple calculations, formatting and printing.
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
To perform a Simple Sort
To Sort by Multiple Columns
Adding Data Using the Data Form
Finding Records Using Criteria
Analysis tool pack
Sub Total Reports, Auto Filter
Password Protecting Worksheets
Linking Multiple Sheets
Linking Between Word/Excel/PPT
Consolidation of Data
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.
Syllabus is only for your reference. You will be learning a lot more than syllabus. Our approach is to train you according to the Company necessity (As per Industry Requirement).