Best Excel and Advanced Excel training in Pune
Best Excel and Advanced Excel Training in Pune Get enrolled for the most demanding skill in the world. Excel and Advanced Excel training will make your career a new height. We at Besant technologies provide you an excellent platform to learn and explore the subject from industry experts. We help students to dream high and achieve it.
Why choose Besant technologies?
Besant Technologies must be your one-stop solution to get basic and advanced excel training. It is an institute formed by the IIT and IIM experts. It delivers an in-depth Excel and Advanced Excel training to attain the skills and get into a lucrative job position in an MNC.
What is Excel training?
Excel is a critical tool used to manage and analyse various types of data. The excel application performs basic calculations, uses graphical tools to represent information, creates pivot tables and macros. It is used in schools, and many business corporate firms too. The course content for excel training includes:
- Getting acquainted with Excel
- Create basic books in Excel
- Using ranges
- \Creating and using formulas
- Columns and rows
- Worksheet tools
- Setting worksheet layout
- Printing worksheets
- Auditing worksheets
- Consolidating worksheets
- Editing and formatting charts on excel
- Pivot tables
Answer 3 Simple Questions
Get upto 30%* Discount in all courses. Limited Offer. T&c Apply.Register now
Syllabus of Excel and Advanced Excel training in Pune
Module 1: Basic Excel (Duration: 10Hrs )
- Text to Columns
- The Concatenate Function
- The Right Function with Concatenation
- Absolute Cell References
- Data Validation
- Time and Date Calculations
- Conditional Formatting
- Exploring Styles and Clearing Formatting
- Using Conditional Formatting to Hide Cells
- Using the IF Function
- Changing the “Value if false” Condition to Text
- Pivot Tables
- Creating a Pivot Table
- Specifying PivotTable Data
- Changing a PivotTables Calculation
- Filtering and Sorting a PivotTable
- Creating a PivotChart
- Grouping Items
- Updating a PivotTable
- Formatting a PivotTable
- Using Slicers
- Creating a Simple Chart
- Charting Non-Adjacent Cells
- Creating a Chart Using the Chart Wizard
- Modifying Charts
- Moving an Embedded Chart
- Sizing an Embedded Chart
- Changing the Chart Type
- Chart Types
- Changing the Way Data is Displayed
- Moving the Legend
- Formatting Charts
- Adding Chart Items
- Formatting All Text
- Formatting and Aligning Numbers
- Formatting the Plot Area
- Formatting Data Markers
- Pie Charts
- Creating a Pie Chart
- Moving the Pie Chart to its Own Sheet
- Adding Data Labels
- Exploding a Slice of a Pie Chart
- Data Analysis − Overview
- Types of Data Analysis
- Data Analysis Process
- Working with Range Names
- Copying Name using Formula Autocomplete
- Range Name Syntax Rules
- Creating Range Names
- Creating Names for Constants
- Managing Names
- Scope of a Name
- Editing Names
- Applying Names
- Using Names in a Formula
- Viewing Names in a Workbook
- Copying Formulas with Names
- Difference between Tables and Ranges
- Create Table
- Table Name
- Managing Names in a Table
- Table Headers replacing Column Letters
- Propagation of a Formula in a Table
- Resize Table
- Remove Duplicates
- Convert to Range
- Table Style Options
- Table Styles
- Cleaning Data with Text Functions
- Removing Unwanted Characters from Text
- Extracting Data Values from Text
- Formatting Data with Text Functions
Advance Excel (Duration: 15Hrs)
Module 2: Date Formats (Duration: 2Hrs)
- Converting Dates in Serial Format to Month-Day-Year Format
- Converting Dates in Month-Day-Year Format to Serial Format
- Obtaining Today’s Date
- Finding a Workday after Specified Days
- Customizing the Definition of a Weekend
- Number of Workdays between two given dates
- Extracting Year, Month, Day from Date
- Extracting Day of the Week from Date
- Obtaining Date from Year, Month and Day
- Calculating Years, Months and Days between two dates
Module 3: Conditional Formatting (Duration: 2Hrs)
- Highlight Cells Rules
- Top / Bottom Rules
- Data Bars
- Color Scales
- Icon Sets
- New Rule
- Clear Rules
- Manage Rules
Module 4: Sorting (Duration: 2Hrs)
- Sort by Text
- Sort by Numbers
- Sort by Dates or Times
- Sort by Cell Color
- Sort by Font Color
- Sort by Cell Icon
- Sort by a Custom List
- Sort by Rows
- Sort by more than one Column or Row
Module 5: Filtering (Duration: 2Hrs)
- Filter by Selected Values
- Filter by Text
- Filter by Date
- Data Analysis with Excel
- Filter by Numbers
- Filter by Cell Color
- Filter by Font Color
- Filter by Cell Icon
- Clear Filter
- Advanced Filtering
- Filter Using Slicers
Module 6: Other Topics (Duration: 2Hrs)
- Subtotals with Ranges
- Nested Subtotals
- Quick Analysis
- Quick Analysis with TOTALS
- Running Total
- Sum of Columns
Module 7: Lookup Functions (Duration: 3Hrs)
- Using VLOOKUP Function
- Using VLOOKUP Function with range lookup TRUE
- Using VLOOKUP Function with range lookup FALSE
- Using HLOOKUP Function
- Using HLOOKUP Function with range lookup FALSE
- Using HLOOKUP Function with range lookup TRUE
- Using INDEX Function
- Using MATCH Function
Module 8: Pivoting (Duration: 2Hrs)
- Creating PivotTable
- Recommended PivotTables
- PivotTable Fields
- PivotTable Areas
- Nesting in the PivotTable
- Summarizing Values by other Calculations
- PivotTable Tools
- Using Pictures in Column Charts
- Band Chart
- Thermometer Chart
- Gantt Chart
- Waterfall Chart
- Pivot Charts
- PivotChart from PivotTable
- PivotChart without a PivotTable
- Working with Multiple Sheets
- Multiple Worksheets with same Structure
- Creating a Formula across Multiple Worksheets
- Summarizing Data in Multiple Worksheets
- What-If Analysis
Looking for Master your Skills? Enroll Now on Triple Course Offer & Start Learning at 24,999!Explore Now
Upcoming Batch Schedule for Excel and Advanced Excel training in Pune
Besant Technologies provides flexible timings to all our students. Here are the Excel and Advanced Excel Training in Pune Schedule in our branches. If this schedule doesn’t match please let us know. We will try to arrange appropriate timings based on your flexible timings.
- 13-02-2023 Mon (Mon - Fri)Weekdays Batch 08:00 AM (IST)(Class 1Hr - 1:30Hrs) / Per Session Get Fees
- 09-02-2023 Thu (Mon - Fri)Weekdays Batch 08:00 AM (IST)(Class 1Hr - 1:30Hrs) / Per Session Get Fees
- 11-02-2023 Sat (Sat - Sun)Weekend Batch 11:00 AM (IST) (Class 3Hrs) / Per Session Get Fees
Can’t find a batch you were looking for?
Trainer Profile of Excel and Advanced Excel training in Pune
The faculty at Besant Technologies are experts from the world of IT. They possess great years of experience in the line, and they also have amazing personality and communication skills. You would find the best of trainers for quality teaching only at Besant Technologies in Pune.
The teachers at Besant Technologies focus majorly on practical lessons to impart skills of functioning the Excel program well. They mentor the students to work on real-time projects too. The faculty is well-versed of the needs of the industry in the current times, and they frame the curriculum according to it.
Excel and Advanced Excel Exams & Certification in Pune
Besant Technologies Certification is Accredited by all major Global Companies around the world. We provide after completion of the theoretical and practical sessions to fresher’s as well as corporate trainees.
Our certification at Besant Technologies is accredited worldwide. It increases the value of your resume and you can attain leading job posts with the help of this certification in leading MNC’s of the world. The certification is only provided after successful completion of our training and practical based projects.
The certifications provided after the successful completion of the Excel programme at Besant Technologies will hold a high value for your professional career. The certificates will help you secure a quick job in the MNC. All leading firms around the world globally accredit the certificates given by us. Have you mastered the art of Excel programme? It is time to implement those learned skills into practice. Besant Technologies placement assistance services will help you get the desired job.
Get ready to put on the wings to fly as a successful Excel expert. Directly enrol into Besant Technologies and get the required training to climb the ladder of success. Our excel programme helps you to pick the necessary skills which will give you an opportunity to advance in your career.
Key Features of Excel and Advanced Excel training in Pune
30+ Hours Course Duration
100% Job Oriented Training
Industry Expert Faculties
Free Demo Class Available
Completed 800+ Batches
Training Courses Reviews
I would like to highlight a few points about my association with Besant Technologies. The faculty members out here are super supportive. They make you understand a concept till they are convinced you have gotten a good grip over it. The second upside is definitely the amount of friendliness in their approach. I and my fellow mates always felt welcome whenever we had doubts. Thirdly, Besant offers extra support to students with a weaker understanding of the field of IT.
When I joined Besant Technologies, I didn’t really expect a lot from it, to be extremely honest. But as time went by, I realised I got from Besant Technologies exactly what I wanted- a healthy environment for learning. Cordial teachers and their valuable lectures make understanding things so much easy. I thank Besant for having been so supportive throughout the course.
Frequently Asked Questions
Besant Technologies offers 250+ IT training courses in more than 20+ branches all over India with 10+ years of Experienced Expert level Trainers.
- Fully hands-on training
- 30+ hours course duration
- Industry expert faculties
- Completed 1500+ batches
- 100% job oriented training
- Certification guidance
- Own course materials
- Resume editing
- Interview preparation
- Affordable fees structure
Besant Technologies is the Legend in offering placement to the students. Please visit our Placed Students List on our website.
- More than 2000+ students placed in last year.
- We have a dedicated placement portal which caters to the needs of the students during placements.
- Besant Technologies conducts development sessions including mock interviews, presentation skills to prepare students to face a challenging interview situation with ease.
- 92% percent placement record
- 1000+ interviews organized
- Our trainers are more than 10+ years of experience in course relavent technologies.
- Trainers are expert level and fully up-to-date in the subjects they teach because they continue to spend time working on real-world industry applications.
- Trainers have experienced on multiple real-time projects in their industries.
- Are working professionals working in multinational companies such as CTS, TCS, HCL Technologies, ZOHO, Birlasoft, IBM, Microsoft, HP, Scope, Philips Technologies, etc…
- Trained more than 2000+ students in a year.
- Strong theoretical & practical knowledge.
- Are certified professionals with high grade.
- Are well connected with hiring HRs in multinational companies.
No worries. Besant technologies assure that no one misses single lectures topics. We will reschedule the classes as per your convenience within the stipulated course duration with all such possibilities. If required you can even attend that topic with any other batches.
Besant Technologies provides many suitable modes of training to the students like
- Classroom training
- One to One training
- Fast track training
- Live Instructor LED Online training
- Customized training
You will receive Besant Technologies globally recognized course completion certification.
Yes, Besant Technologies provides group discounts for its training programs. To get more details, visit our website and contact our support team via Call, Email, Live Chat option or drop a Quick Enquiry. Depending on the group size, we offer discounts as per the terms and conditions.
We accept all major kinds of payment options. Cash, Card (Master, Visa, and Maestro, etc), Net Banking and etc.