Get Trained from Microsoft Certified Trainers
Excel Prodigy is one of the Leading Excel Training Company in India. We provide Advanced Excel Training in Bangalore 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 Bangalore:
Excel is one of the most ought courses in cities like Bangalore. Since Bangalore is one of the largest IT Hub, many IT firms take this Advanced Excel Course for their employees to increase their work productivity. So, Excel Prodigy teaches how to preform calculations, Manipulate, Present and Combine data in Various Ways. Also, MS Excel is one of the key tool in IT Workplace in Bangalore and an Essential skills for many job roles.
Excel Prodigy has been associated with many corporates in Bangalore for the Advanced Excel & PowerPoint Training like Hitachi, HCL, Credit Suisse, Godrej, VMWare & NetApp.
Our training methods for IT Companies like Bangalore are so customized and we give them the real time IT scenarios examples for all the Topics. Training conducted as In-House Programs and workshop in Bangalore, 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. This is one of our practice we follow in all our trainings.
Our Excel Trainings will make participants to master all their data management and reporting needs in corporate world. Also there are many small business owners and entrepreneurs in Bangalore where they maintain all their data’s in Excel, which is easier for them to maintain their marketing data’s and for accounting purpose. These companies will uses most of the Charts, Tables & Graphs options to pictorially depict their data to their clients. So, we Excel Prodigy provide them the Basic Excel & Advanced Excel training in very feasible cost to this clients.
Advanced Excel Training Course Outline:
- Quick Access Tool Bar, The Ribbon, Status Bar
- Simple Calculation & Basic Functions
- Using AutoFill Option
- Quick Formatting & Keyboard Shortcuts
- Using Paste Special
- Relative Reference
- Absolute Reference
- Mixed Reference
- Dynamic Reference
- Understanding different Error Types
- Fixing Formula Error
- Table
- Slicers
- Sparklines
- FlashFill
- Quick Analysis
- Recommended Chart & Pivot
- VLOOKUP, HLOOKUP
- NESTED LOOKUP
- VLOOKUP, MATCH
- INDEX, MATCH
- IF, AND, OR
- NESTED IF
- IFERROR & IFNA
- COUNTIF & COUNTIFS
- SUMIF & SUMIFS
- AVERAGEIF & AVERAGEIFS
- Create & Modify a Chart
- Different types of charts
- Chart Layouts & Styles
- Combo Chart - Column & Line
- Creating Two Axes Chart
- Creating a Pivot Table
- Adding Fields & Rearranging Data
- Multiple Fields & Report Filter
- Pivot Table Style & Classical Layout
- Creating Monthly, Quarterly & Yearly Reports
- Working with Slicers
- Highlight cell rules, Top/Bottom Rules
- Data Bar, Icon Set
- Using Formulas
- Custom Sorting
- Advance Filtering
- Subtotals
- Removing Duplicates
- Limiting the range of values
- Drop down lists
- Error alerts
- SUBSTITUTE, SEARCH
- LEFT, RIGHT, MID
- CONCATENATE, & TRIM
- DAY, MONTH, YEAR
- DATEDIF, EDATE, EOMONTH
- NETWORKDAYS, WORKDAY
- Introduction to Template
- Creating and Using Template
- Editing existing template
- Trace Precedent/Dependents
- Evaluate Formula
- Error Checks
- Highlight Duplicate
- Goto Special
- Fill In Blanks
- Find & Replace
- File Sharing & Track Changes
- Protecting file, workbooks, sheets
- Protecting Specific Cells & Range
- XLOOKUP, XMATCH
- CONCAT, TEXT JOIN
- IFS, SWITCH, XOR
- FILTER, SORT, SORTBY
- Introduction & Loading to Power Query
- Remove Rows & Columns
- Fill Data, Split Data, Detect Data Types
- Transpose Data, Merge Columns
- Replace Values & Errors
- Converting unstructured data to structured format
- Exacting Data, Add Columns
- Loading Data to Data Module
- Overview of built-in AI features in Excel
- Key examples of AI utilization in Excel
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
Few of our Corporate Clients:
Our Achievements
0
+
Average Feedback
0
+
Corporate Clients
0
+
Corporate Trainings
0
+
Professionals Trained
Testimonial
