Get Trained from Microsoft Certified Trainers
Excel Prodigy is one of the Leading Excel Training Company in India. We provide Advanced Excel Training in Pune 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.
“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.
About Excel Training
Why Advanced Excel Training in Pune:
Excel Prodigy has been associated with many corporates in Pune for the Advanced Excel & Power BI Training.
Excel is a helpful and powerful program for data analysis. It is a spreadsheet program which contains number of columns and rows where each intersection of a column and row is a “cell”. There are number of spreadsheet program but from all of them, Excel is most widely used. People Have been using it for last 30 years and throughout these years, it has been upgraded with more and more features.
Excel prodigy provide advanced excel training for corporate in Pune which will meet the needs of many finance professionals We are extremely client focused company and we believe that the most effective way to learn advanced excel on our training courses is to address the topics like Vlookup, Pivot Table & If Conditions which are relevant to the Participants daily use.
The information produced in excel prodigy can be used to make decision in both professional and personal contexts. Our trainers will initially understand the participants knowledge & their requirements to customize all the corporate trainings conducted. we make the participants to understand the Logic behind all the topics in Excel which make them to remember it when they see the data’s in future.
Our training method will explore the excel activities that go beyond the basic. After Successful completion of the session, Participants can expect to have the skill required to work efficiently in an existing worksheet.
How can we help you?
Drop Email For Corporate Training Across India & International or Call
Why Us
- Microsoft Certified Trainer
- Industry Expert Trainer
- Advanced Excel Training course
- Real World Examples
- Microsoft Certification
- Post Training Support
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
- Custom & Multiple Sort
- Subtotals
- Advanced Filtering
- Create automatic Subtotals
- Text to Columns
- Use the Group and Outline feature
- Cell Rules
- Top-Bottom Rules
- Data bars, Gradient fills, Icon sets
- Managing multiple conditional formata
- Limiting the range of values
- Drop down lists
- Error alerts
- Goal Seek
- Data Table
- Scenario Manager
- Tracing precedent & dependants
- Display/Hide formulas
- Error Checking
- Evaluate Formulas
- Fixing Formulas Errors
- Protecting cells/Range
- Hide Formulas
- Protecting Worksheet
- Protecting Workbook
Few of our Corporate Clients:
Our Achievements
0
+
Average Feedback
0
+
Corporate Clients
0
+
Corporate Trainings
0
+
Professionals Trained
Testimonial
