Advanced Excel
Microsoft Excel is a spreadsheet program part of Microsoft Office suite of applications. In Excel spreadsheets, values are arranged in rows and columns which can be changed mathematically by using both basic and complex arithmetic operations. Microsoft Excel was first released for Macintosh systems in the year 1985, followed by the first Windows version in 1987.
Course Objective
Participants will learn how to use advanced functions of Excel to improve productivity, enhance spreadsheets with templates, charts, graphics, and excel formulas and streamline their operational work.
They will apply visual elements and advanced formulas to a worksheet to display data in various formats. The topics covered will help them to leverage on Excel advanced functionality to simplify and streamline their day-to-day work.
Course Title: Course on Advanced Excel
Training on Advanced Excel
|
- Enter data & formatting
- Formulas & functions: SUM, AVERAGE, MAX, MIN, AND, OR, CONCATENATE
- Develop different types of charts
- Conditional logic, Data forms, Drop down lists, Creating hyperlinks
- Grouping & Outlining and Subtotals
- Formulas & functions – PART 2 : SUMIF, COUNTIF, MAXIF, MINIF, LEFT, RIGHT
- MID, LEN, nested if, UPPER, LOWER
- Import Export: Importing text file by opening it in Excel
- What-If Analysis
- Consolidation
- PivotTables
- Array Functions
- HLOOKUP and VLOOKUP Functions
|
Course deliverables for participants
E-book access of learning material
Batch Type
Who can enrol & Eligibility?
This course is designed for working professionals & students who are interested in learning the Advanced Excel techniques to increase productivity and improve efficiency by streamlining the workflow.
Corporate Training
Our training methodology is very well appreciated in the corporate world. Improved productivity of the trained professionals is evident. Customized training programs based on specific requirements are also offered. Visit to office premises for a demo/discussion of the software is available.
Contact us to know more about this. You could also drop in a mail to the email id corporate@cadpmtraining.com or fill in the
corporate training requirement form.