Advanced Excel Training for Corporates in Chennai
Excel Prodigy is one of the Leading Excel Training Company in India. We provide Advanced Excel Training in Chennai for Corporate and Working professionals.
Our training courses will show you how to use Excel better, faster and more efficiently.
You will learn how to save time, access new features and work with confidence. We provide a dynamic learning environment with lots of practical hands on exercise with real world examples.
Our instructors are knowledgeable, experienced and patient computer training professionals with both Industry Expert and Microsoft Certified.
Our training courses will show you how to use Excel better, faster and more efficiently.
You will learn how to save time, access new features and work with confidence. We provide a dynamic learning environment with lots of practical hands on exercise with real world examples.
Our instructors are knowledgeable, experienced and patient computer training professionals with both Industry Expert and Microsoft Certified.
Enquiry Now
Our Corporate Clients:
“Every trained individual from Excel Prodigy is an expertise in MS Excel and can proudly exhibit their Excel skills for their career growth.”
Apart from Advanced Excel Training, we also conduction Corporate In-house Training on Power BI, Tableau, VBA Macro & PowerPoint.
Advanced Excel Training Course Outline:
- Intro Excel 2019
- Auto Fill, Custom List & Fill Series
- AutoComplete Option
- Different methods of selecting Range
- Useful Shortcuts
- Special Formats – Numbers & Dates
- Different File Format (XLS, XLSX, XLSM)
- Insert, Delete & Rename Sheets
- Copy and Move Sheets
- Worksheet Groups
- Using the Clipboard Group
- Using Paste Special
- Problems using Relative References
- Using Absolute References
- Using Mixed Reference
- Basic IF statement
- Nested IF statements
- Combining IF with AND, OR, NOT
- IFERROR & ISNA Function
- UPPER(), LOWER(), PROPER()
- LEFT(), RIGHT(), MID(); LEN()
- TRIM(), SUBSTITUTE()
- Join Cells using & (ampersand), CONCATENATE()
- Create & modify charts
- Different Chart Types
- Adding data to existing chart
- Combo Chart – Columns & Line
- Secondary Axis Chart
- Highlight & Remove Duplicate
- Compare Reports
- Converting Text to Number/Date
- Find & Replace
- Go To (Special) Options
- Slicer
- Spark Lines
- VLOOKUP – Exact Match
- VLOOKUP – Approximate Match
- HLOOKUP
- Nested VLOOKUP
- VLookup & Match
- Index & Match
- VLookup & Indirect
- COUNT(), COUNTA(), COUNTBLANK()
- COUNTIF(), SUMIF(), AVERAGEIF()
- COUNTIFS(), SUMIFS(), AVERAGEIFS()
- PivotTable layout
- Rearranging data
- Filtering a report
- Adding fields
- Field settings
- Refreshing data
- Formatting a PivotTable
- Showing detail
- Create a calculated field
- Advanced data field settings
- Creating a PivotChart
- Creating PivotChart Reports from scratch
- Adding fields to a PivotChart