Parag Parikh Flexi Cap Fund increases stake in ITC and 11 other stocks in July
, the largest active fund and flexi cap fund, increased its stake in
ITC
and 11 other stocks in the month of July. The fund added around 47.50 lakh shares of ITC taking the total number of shares to 12.21 crore in July against 11.74 crore in June.
The other stocks added in the portfolio included
Axis Bank
,
Bharti Airtel
,
Cipla
,
Dr. Reddy's Laboratories
,
EID Parry India
,
HCL Technologies
,
HDFC Bank
,
ICICI Bank
,
Kotak Mahindra Bank
,
Power Grid Corporation of India
,
Zydus Lifesciences
.
Productivity Tool
Zero to Hero in Microsoft Excel: Complete Excel guide
By Metla Sudha Sekhar
View Program
Finance
Introduction to Technical Analysis & Candlestick Theory
By Dinesh Nagpal
View Program
Finance
Financial Literacy i e Lets Crack the Billionaire Code
By CA Rahul Gupta
View Program
Digital Marketing
Digital Marketing Masterclass by Neil Patel
By Neil Patel
View Program
Finance
Technical Analysis Demystified- A Complete Guide to Trading
By Kunal Patel
View Program
Productivity Tool
Excel Essentials to Expert: Your Complete Guide
By Study at home
View Program
Artificial Intelligence
AI For Business Professionals Batch 2
By Ansh Mehra
View Program
Also Read |
Raksha Bandhan: Could a mutual fund SIP gift today secure your sibling's future?
Best MF to invest
Looking for the best mutual funds to invest? Here are our recommendations.
View
Details
»
by Taboola
by Taboola
Sponsored Links
Sponsored Links
Promoted Links
Promoted Links
You May Like
When the Camera Clicked at the Worst Possible Time
Lintmit.com
Read More
Undo
It added around 65.70 lakh shares of Power Grid Corporation of India, followed by 31.16 lakh shares of ICICI Bank.
The flexi cap fund reduced its stake from IPCA Laboratories and sold 7.45 lakh shares of this stock from the portfolio.
Live Events
Only one new stock was added in the portfolio in the said period.
Motilal Oswal Financial Services
was the new entrant in the portfolio and around 5.91 lakh shares were added to the portfolio. The fund did not make a complete exit from any stock in the mentioned time period.
Exposure in nearly 15 stocks remained unchanged in July which includes Bajaj Holdings & Investment, Balkrishna Industries,
CDSL
, Coal India, Indian Energy Exchange, Infosys, Mahindra & Mahindra,
MCX
, Swaraj Engines, and Zydus Wellness.
Parag Parikh Flexi Cap Fund is an open-ended dynamic Equity scheme investing across large cap, mid cap, small cap stocks.
The investment objective of the fund is to seek to generate long-term capital growth from an actively managed portfolio primarily of Equity and Equity Related Securities. The scheme shall invest in Indian equities, foreign equities and related instruments and debt securities.
Launched on May 24, 2013, the fund had an AUM of Rs 1.13 lakh crore as on July 31, 2025.
The flexi cap fund is benchmarked against NIFTY 500 (TRI) and is managed by Rajeev Thakkar, Raunak Onkar, Raj Mehta, Rukun Tarachandani, and Mansi Kariya.
Also Read |
Over 50 mutual fund SIPs give negative returns in 1 year. Should you pause, redeem, or continue?
According to the monthly release by the fund house, the core portfolio consists of equity investments made with a long term outlook and the factors considered while investing are quality of management, quality of the sector and the business (return on capital, entry barriers, capital intensity, use of debt, growth prospects etc) and the valuation of the companies. The endeavor of the fund management team is to identify opportunities for long term investments.
'We continue to look at individual investments on their own merits and will not hesitate to invest if an opportunity looks attractive. As usual, our investment stance does not depend much on the macro-economic situation but is focussed on individual companies. We have about 23.29% in cash holdings, debt & money market instruments and arbitrage positions which can be deployed in long term investments at appropriate levels,' the fund house said.
Hashtags
Try Our AI Features
Explore what Daily8 AI can do for you:
Comments
No comments yet...
Related Articles
Time of India
2 hours ago
- Time of India
Rs 50k to Rs 15k: ICICI bank rolls back min account balance rule
MUMBAI: ICICI Bank has rolled back its rule requiring new savings accounts opened after Aug 1 to maintain a monthly average balance (MAB) of Rs 50,000 and has revised the threshold to Rs 15,000. Tired of too many ads? go ad free now The move follows a social media backlash against the higher balance requirement, which was criticised for making banking exclusive. The bank said it has revised its schedule of charges and MAB requirements following customer feedback. The changes do not apply to salary accounts, senior citizens above 60 years, basic accounts/PM Jan Dhan Yojana accounts, or those opened before July 31, 2025. Meanwhile, HDFC Bank denied reports that it has hiked MAB requirement to Rs 25,000. The bank said that the Rs 25,000 limit is for its 'savings max' account and the average monthly balance for the regular savings account continues to be Rs 10,000. For resident Indians below 60 years, ICICI Bank's MAB is Rs 15,000 in metro and urban areas, Rs 7,500 in semi-urban locations, and Rs 2,500 in rural areas. Pensioners below 60 and students from 1,200 listed institutes are exempt from MAB. Non-maintenance will attract a charge of 6% of the shortfall or Rs 500, whichever is lower. The bank will offer three premium programmes - Select Banking, Wealth Management and Private Banking - with higher deposit and investment thresholds, which waive MAB penalties if met. Key charges include Rs 23 per ATM withdrawal beyond five free transactions at ICICI Bank machines, and varying free limits at non-ICICI ATMs depending on location. Cash deposits and withdrawals at branches are free for up to three transactions.
Economic Times
3 hours ago
- Economic Times
Best Online Microsoft Excel Certification Courses for Professionals in 2025
Synopsis In today's data-driven world, Microsoft Excel remains one of the most essential tools for professionals across industries. This curated list of the best online Microsoft Excel certification courses features top-rated programs designed to enhance your skills, from basic spreadsheet operations to advanced data analysis, automation, and financial modeling. Whether you are a beginner aiming to build a solid foundation or an experienced user looking to master complex functions like Power Query, PivotTables, or VBA, these courses offer practical, real-world applications. Team ProductLine In 2025, Microsoft Excel remains one of the most powerful and widely used tools in the professional world. From finance and marketing to data analysis and operations, Excel's versatility makes it essential for professionals looking to boost productivity, streamline processes, and make data-driven decisions. As the demand for advanced Excel skills grows across industries, enrolling in a certified Excel course is a smart investment in your career. This guide to the best online Microsoft Excel certification courses highlights the top training programs that cater to all skill levels, from beginners to advanced users. Whether you are aiming to master formulas, automate workflows with macros, or analyze complex datasets using PivotTables and Power Query, these courses offer flexible learning, and certifications that enhance your credibility and job prospects in today's competitive market. Microsoft Excel is one of the most essential tools in today's digital workplace. Its importance lies in its powerful ability to organize, analyze, and visualize data efficiently. Whether you are a student, professional, entrepreneur, or researcher, Excel helps streamline workflows, reduce manual tasks, and support data-driven how Excel can help you: Data Organization: Easily manage large datasets using tables, filters, and sorting options. Easily manage large datasets using tables, filters, and sorting options. Accurate Calculations: Use formulas and functions to perform complex mathematical and statistical operations quickly and accurately. Use formulas and functions to perform complex mathematical and statistical operations quickly and accurately. Data Analysis: Identify trends, make forecasts, and gain insights using tools like PivotTables, charts, and conditional formatting. Identify trends, make forecasts, and gain insights using tools like PivotTables, charts, and conditional formatting. Automation: Save time by automating repetitive tasks with Macros and VBA scripts. Save time by automating repetitive tasks with Macros and VBA scripts. Reporting: Create dynamic dashboards and professional reports to communicate findings clearly. Create dynamic dashboards and professional reports to communicate findings clearly. Collaboration: Share and edit spreadsheets with team members in real-time via Excel 365 integration. Course Expert: NA Course Description:Take your Excel skills from beginner to expert with this course. Designed for learners of all backgrounds, this comprehensive training begins with the fundamentals: navigating spreadsheets, data entry, formatting, and basic calculations and steadily progresses to advanced topics such as VLOOKUP, PivotTables, Financial Functions, Macros, and VBA programming. You'll learn how to automate repetitive tasks, create impactful visual reports, analyze complex datasets, and perform financial modelling using hands-on workbooks. The course covers everything from conditional formatting, logical formulas, and lookup functions to advanced tools like Goal Seek, Scenario Manager, Data Validation, and What-If Analysis. Course Details: Cost of course: Rs. 899 (one time) Rs. 899 (one time) Course format: Online, self-paced Online, self-paced Duration: NA NA Course includes: Certification What you'll learn Master Excel basics: Data entry, cell formatting, and foundational calculations. Data entry, cell formatting, and foundational calculations. Use formulas & functions: IF, AND, OR, AutoSum, VLOOKUP, HLOOKUP, COUNT, RANK, SUMIF, COUNTIF, AVERAGEIF, and more. IF, AND, OR, AutoSum, VLOOKUP, HLOOKUP, COUNT, RANK, SUMIF, COUNTIF, AVERAGEIF, and more. Understand referencing: Create formulas with relative and absolute references. Create formulas with relative and absolute references. Work with data: Conditional formatting, linking sheets, paste special, and data validation. Conditional formatting, linking sheets, paste special, and data validation. Master charts and visualizations: Create and format impactful Excel charts. Create and format impactful Excel charts. Perform financial analysis: Use NPV, IRR, PMT, and depreciation functions for real-world scenarios. Use NPV, IRR, PMT, and depreciation functions for real-world scenarios. Automate tasks: Learn Macros and VBA basics to streamline repetitive processes. Learn Macros and VBA basics to streamline repetitive processes. Analyze data like a pro: Use PivotTables, Goal Seek, Scenario Manager, and other advanced tools. Use PivotTables, Goal Seek, Scenario Manager, and other advanced tools. Boost productivity: Learn keyboard shortcuts, auditing tools, and how to create print-ready sheets. Learn keyboard shortcuts, auditing tools, and how to create print-ready sheets. Hands-on learning: Includes workbooks and an eBook for practice and revision. Who should enrol Anyone interested in learning Excel, from the ground up to an expert level. Students and freshers aiming to enhance their resume and skillset. Professionals looking to upskill for better roles or promotions. Trainers and facilitators who want to teach or support Excel learning. Graduates and working professionals who want to build data handling and reporting proficiency. Business owners and entrepreneurs looking to streamline and automate business processes. Click here to explore the course Course Expert: Metla Sudha Sekhar Course Description:Master Microsoft Excel from the ground up with this one-stop learning path to becoming an Excel expert. This comprehensive course takes you from the fundamentals of Excel, like worksheet basics, formulas, and formatting to advanced data tools, business analysis, and automation using Macros and VBA. You'll explore Excel's full potential through practical lessons on PivotTables, data validation, charting, and lookup functions like VLOOKUP, HLOOKUP, INDEX-MATCH, and XLOOKUP (including Excel 365 features). Learn to clean and import data from TXT, CSV, PDF, and web sources, create dynamic dashboards and business reports, and solve real-world problems using powerful Excel tools like Solver, Scenario Manager, and What-If acquire knowledge about business scenarios like sales forecasting, and tax calculation. This course also includes coverage of Geo-charts, 3D Maps, and even a glimpse into how Generative AI can assist in Excel-based predictions and automation. Course Details: Cost of course: Rs. 2,500 (one time) Rs. 2,500 (one time) Course format: Online, self-paced Online, self-paced Duration: 9.4 hours 9.4 hours Course includes: Lifetime access, Certificate of completion What you'll learn Master foundational Excel operations: Including formulas, data entry, ranges, formatting, and navigation. Including formulas, data entry, ranges, formatting, and navigation. Build confidence with essential formulas: Like SUM, AVERAGE, IF, COUNTIF, ROUND, and logical functions. Like SUM, AVERAGE, IF, COUNTIF, ROUND, and logical functions. Use advanced lookup techniques: Including VLOOKUP, HLOOKUP, MATCH, INDEX, and XLOOKUP (Excel 365+). Including VLOOKUP, HLOOKUP, MATCH, INDEX, and XLOOKUP (Excel 365+). Clean and import data: From multiple sources like TXT, CSV, PDF, and online databases. From multiple sources like TXT, CSV, PDF, and online databases. Create visually impactful charts : Including bar, pie, scatter, bubble, waterfall, radar, sunburst, and more. : Including bar, pie, scatter, bubble, waterfall, radar, sunburst, and more. Summarize and analyze data: Using PivotTables and PivotCharts for business intelligence. Using PivotTables and PivotCharts for business intelligence. Apply automation techniques: Using Macros and VBA to save time and reduce errors. Using Macros and VBA to save time and reduce errors. Visualize data trends with Geo-maps, 3D maps, sparklines, heatmaps, and dynamic dashboards. with Geo-maps, 3D maps, sparklines, heatmaps, and dynamic dashboards. Utilize data tools: Such as Flash Fill, Remove Duplicates, Data Validation, Solver, Scenario Manager, and What-If Analysis. Such as Flash Fill, Remove Duplicates, Data Validation, Solver, Scenario Manager, and What-If Analysis. Fix common Excel errors: E.g., #N/A, #VALUE!, #REF! and learn how to avoid them. E.g., #N/A, #VALUE!, #REF! and learn how to avoid them. Understand and apply named ranges and INDIRECT functions : For cleaner, dynamic formulas. : For cleaner, dynamic formulas. Leverage AI-powered insights: To automate repetitive Excel tasks and predict trends. To automate repetitive Excel tasks and predict trends. Practice through real-life projects: Such as sales forecasting and tax invoice generation to reinforce your learning. Who should enrol Students pursuing fields like data analysis, business studies, finance, or accounting. Working professionals seeking to sharpen Excel skills and boost productivity. Business owners and entrepreneurs wanting to harness Excel for better planning, tracking, and reporting. Analysts, managers, and consultants who rely on Excel for day-to-day data handling and decisions. Beginners or self-taught users who want to master Excel from the basics to expert-level tools. Anyone aiming to improve career opportunities with data-driven skills. Click here to explore the course Course Expert: Metla Sudha Sekhar Course Description:Unlock the full potential of Microsoft Office with this comprehensive course designed to equip you with the essential skills to thrive in a digital-first work environment. While this course covers all major Office tools, special emphasis is placed on Microsoft Excel 2021, the industry's leading spreadsheet application. Start your journey with the basics of Excel: use basic formulas, and work with ranges. As you progress, dive into advanced Excel functions like VLOOKUP, HLOOKUP, XLOOKUP (for Office 365). Explore formatting techniques, build and style tables, and visualize data through compelling charts, graphs, and PivotTables. Course Details: Cost of course: Rs. 549 (one time) Rs. 549 (one time) Course format: Online, self-paced Online, self-paced Duration: NA NA Course includes: Certification What you'll learn Excel Mastery: Create and manage spreadsheets , enter and format data with ease. , enter and format data with ease. Apply essential formulas and functions such as SUM, AVERAGE, IF, COUNT, and DATE. such as SUM, AVERAGE, IF, COUNT, and DATE. Work with advanced lookup tools like VLOOKUP, HLOOKUP, and XLOOKUP (Office 365). like VLOOKUP, HLOOKUP, and XLOOKUP (Office 365). Format cells, numbers, and tables to create clean and readable sheets. to create clean and readable sheets. Use tools like Flash Fill, Data Validation, and Remove Duplicates for efficient data handling. for efficient data handling. Visualize data using PivotTables, PivotCharts, column charts, line graphs, and more. using PivotTables, PivotCharts, column charts, line graphs, and more. Import data from text, CSV, and other formats for analysis. from text, CSV, and other formats for analysis. Set up print-ready pages with Fit-to-Page and advanced print options. with Fit-to-Page and advanced print options. Sort, filter, and manage large datasets with ease. PowerPoint and Word Essentials: Create polished presentations with images, charts, multimedia, animations, and transitions. Design and format Word documents using styles, tables, images, and templates. Use SmartArt, charts, and multimedia in PowerPoint to enhance audience engagement. Office 365 Integration: Understand how to collaborate in real-time using cloud-based tools. Learn the advantages of Office 365 for team communication and productivity. Explore cross-device accessibility and file sharing features. Bonus: Discover AI-powered tools to speed up tasks like content creation and Excel formula generation. Who should enrol Business professionals looking to work smarter with spreadsheets, documents, and presentations. Students and researchers who need to analyze data, write reports, or build slide decks. Job seekers wanting to boost their resumes with Microsoft Office expertise. Freelancers and entrepreneurs who need to manage their own documentation and data. Project managers and analysts who rely on Excel for tracking, forecasting, and data visualization. Anyone looking to gain hands-on, practical knowledge of Microsoft Excel and other Office tools for personal or professional use. Click here to explore the course Course Expert: Metla Sudha Sekhar Course Description:Unlock the full potential of Google Sheets with this comprehensive Google Sheets Masterclass. Designed for learners of all levels, from beginners to advanced users, this course equips you with the skills to streamline your workflow, master spreadsheet functions, and analyze data like a pro. You'll start with the fundamentals such as formatting, formulas, and file sharing, and progressively dive into advanced features like QUERY, IMPORTXML, pivot tables, and dynamic charts. Learn to automate repetitive tasks, collaborate in real time, secure your data, and build interactive dashboards using real-world datasets. With integrated tools like ARRAYFORMULA, IMPORTRANGE, and Google Workspace, this course empowers you to transform raw data into meaningful insights. Course Details: Cost of course: Rs. 799 (one time) Rs. 799 (one time) Course format: Online, self-paced Online, self-paced Duration: 7.32 hours 7.32 hours Course includes: Lifetime access, Certificate of completion What you'll learn Master basic spreadsheet features: Like cells, formulas, and data formatting. Like cells, formulas, and data formatting. Use essential functions: Such as SUM, COUNT, IFS, and more. Such as SUM, COUNT, IFS, and more. Analyze and visualize data: With pivot tables and dynamic charts. With pivot tables and dynamic charts. Implement advanced functions: Like QUERY, ARRAYFORMULA, and INDEX MATCH. Like QUERY, ARRAYFORMULA, and INDEX MATCH. Import and clean data: From CSVs, text files, and web sources. From CSVs, text files, and web sources. Collaborate in real-time : Manage team-based projects within Google Sheets. : Manage team-based projects within Google Sheets. Automate tasks; Using scripts and smart formulas. Using scripts and smart formulas. Secure spreadsheets: With permissions and data protection. With permissions and data protection. Use generative AI: To boost productivity and enhance spreadsheet performance. To boost productivity and enhance spreadsheet performance. QR code and images: Generate QR codes, embed images , and build interactive dashboards. Who should enrol Working professionals aiming to enhance their data analysis and reporting capabilities. Entrepreneurs and business owners looking to manage operations, finances, and reporting more effectively. Students and academic researchers managing and analyzing data for research or coursework. Data analysts and Excel users wanting to expand into Google Sheets and cloud-based collaboration. Anyone interested in mastering Google Sheets for personal productivity, professional use, or career advancement. Click here to explore the course Course Expert: Ricardo R. Trujeque Course Description:Excel for Everyone is a three-part comprehensive learning path developed by UBCx on edX, designed to take learners from complete beginners to confident users of advanced Excel functionalities. In the Core Foundations course, you'll begin with Excel essentials such as data entry, formatting, and performing basic calculations. The Data Management module advances your knowledge into managing larger datasets, using PivotTables, What-If analysis, and integrating logical/statistical functions. Finally, the Data Analysis Fundamentals course teaches you how to automate tasks, use advanced formulas, build dashboards, and make data-driven decisions. Course Details: Cost of course: $510.30 $510.30 Course format: Online, self-paced Online, self-paced Duration: 18 weeks 18 weeks Course includes: Certification What you'll learn Build strong Excel foundations : Learn essential Excel operations such as data entry, formatting, and basic formulas. : Learn essential Excel operations such as data entry, formatting, and basic formulas. Develop a data-centric mindset : Understand how to solve problems using data models and structured thinking. : Understand how to solve problems using data models and structured thinking. Manipulate raw data efficiently : Clean, filter, and transform data using functions like VLOOKUP, PivotTables, and What-If Analysis.. : Clean, filter, and transform data using functions like VLOOKUP, PivotTables, and What-If Analysis.. Visualize data effectively : Create and customize charts, dashboards, and tables for clear and compelling presentations. : Create and customize charts, dashboards, and tables for clear and compelling presentations. Perform advanced data analysis : Apply conditional logic, and automate repetitive tasks. : Apply conditional logic, and automate repetitive tasks. Use real-world Excel tools : Explore Date, Financial, and Statistical functions to support personal and organizational decision-making. : Explore Date, Financial, and Statistical functions to support personal and organizational decision-making. Automate tasks with confidence : Create macros, use Visual Basic (VBA), and audit formulas for error-free workbooks. Who should enrol Beginners with little to no Excel experience who want to start from scratch. Students looking to boost their academic and career potential with Excel proficiency. Professionals who use Excel at a basic level and want to unlock its full potential. Business analysts, operations managers, and data-driven professionals seeking advanced analysis and automation skills. Anyone interested in Excel for personal productivity, career development, or organizational impact. Click here to explore the course Course Expert: Duncan McKeen Course Description:Excel Fundamentals- Formulas for Finance by the Corporate Finance Institute (CFI) is designed to equip finance professionals and Excel users with the essential skills required to perform accurate and efficient financial analysis using Excel 365. In just over two hours, this hands-on course cuts through Excel's vast functionality to focus on the tools most relevant to finance, such as aggregation functions, date calculations, lookup tools, and return formulas. Whether you are managing pricing data, modeling cash flows, or simply cleaning up large data sets, this course introduces exercises that help you apply what you learn immediately. You'll also gain an understanding of how to compare functions like NPV/IRR vs. XNPV/XIRR, work with financial dates, and apply custom formatting to reports and models. Course Details: Cost of course: $ 347.90 (for unlimited access to courses) $ 347.90 (for unlimited access to courses) Course format: Online, self-paced Online, self-paced Duration: 2 hours 14 minutes 2 hours 14 minutes Course includes: Certification What you'll learn Use essential Excel functions: To perform financial and statistical analysis on datasets. To perform financial and statistical analysis on datasets. Aggregate and summarize financial data: Using core Excel functions such as COUNTIF, SUMIF, etc. Using core Excel functions such as COUNTIF, SUMIF, etc. Compare and apply lookup functions: Such as VLOOKUP, HLOOKUP, and XLOOKUP for data retrieval. Such as VLOOKUP, HLOOKUP, and XLOOKUP for data retrieval. Utilize Excel's date functions: To build annual, quarterly, and monthly financial models. To build annual, quarterly, and monthly financial models. Understand time-value concepts: Using NPV, IRR, XNPV, and XIRR functions. Using NPV, IRR, XNPV, and XIRR functions. Apply professional formatting: For numbers and dates to enhance clarity and consistency in reports. For numbers and dates to enhance clarity and consistency in reports. Practice keyboard shortcuts and tools: To boost speed and accuracy in financial modeling. Who should enrol Beginners seeking foundational Excel skills for finance. Intermediate Excel users looking to expand their toolkit for real-world financial tasks. Advanced users wanting a fast-paced refresher focused on finance-specific formulas. Finance professionals, analysts, accountants, or students preparing for roles that require financial data analysis in Excel. Anyone expanding their data skills in financial modeling. Click here to explore the course Course Expert: Ken Puls Course Description:Microsoft Excel 365- Basic & Advanced by GoSkills is a comprehensive, CPD-accredited online course designed to take learners from Excel beginners to confident, productive users ready to tackle advanced data analysis, reporting, and automation. Taught by award-winning instructor Ken Puls, this self-paced course breaks down complex Excel skills into engaging bite-sized lessons that make learning intuitive and achievable, whether you are starting fresh or brushing up your existing knowledge. You'll gain expertise in formulas, functions, PivotTables, data validation, dynamic arrays, macros, charting, and more. You'll also explore newer Excel 365 features like XLOOKUP and LET functions. Course Details: Cost of course: Rs. 1,400 per month platform fee Course format: Online, self-paced Duration: 2 hours 14 minutes Course includes: Certification What you'll learn Navigate and customize the Excel 365 interface for efficient use. the Excel 365 interface for efficient use. Master core formulas and functions for math, statistics, logic, and text manipulation. for math, statistics, logic, and text manipulation. Organize and filter data using tables, named ranges, and data validation techniques. using tables, named ranges, and data validation techniques. Summarize large datasets with PivotTables and perform What-If analysis. with PivotTables and perform What-If analysis. Visualize insights through compelling charts, and graphs. through compelling charts, and graphs. Automate repetitive tasks by recording macros and using Power Query. by recording macros and using Power Query. Explore new Excel 365 features like Dynamic Arrays, FILTER, XLOOKUP, and LET. like Dynamic Arrays, FILTER, XLOOKUP, and LET. Format and prepare workbooks for professional reporting and printing. Who should enrol Beginners looking to build a strong foundation in Excel from scratch. Intermediate users aiming to unlock Excel's full capabilities and streamline their workflow. Professionals in any industry who handle data and want to become more efficient with reporting, analysis, or project tracking. Students or job seekers wanting to enhance their resume with Excel certification. Entrepreneurs and small business owners who want better control over their business data and decision-making. Click here to explore the course Course Expert: NA Course Description: The Advanced Excel Certification Course by the Indian Institute of Skill Development Training is a career-boosting program tailored for individuals seeking to master Microsoft Excel for real-world applications in finance, business, data analysis, and project management. This comprehensive course covers everything from foundational Excel concepts to highly advanced functions and techniques, equipping learners with the skills to perform data-driven tasks with accuracy, speed, and confidence. The course includes lifetime-valid certification, job-ready training aligned with industry standards, and free job assistance based on your career interests. Course Details: Cost of course: Rs. 4,000 Course format: Online examination, self-paced Duration: 2 months Course includes: Certification What you'll learn Master Excel fundamentals: Including workbook management, formatting, formulas, and shortcuts. Including workbook management, formatting, formulas, and shortcuts. Use advanced formulas and functions: Such as VLOOKUP, XLOOKUP, IF, SUMIF, TEXTJOIN, and more. Such as VLOOKUP, XLOOKUP, IF, SUMIF, TEXTJOIN, and more. Clean and manage data: Using tools like Flash Fill, TRIM, CLEAN, Go To Special, and Data Validation. Using tools like Flash Fill, TRIM, CLEAN, Go To Special, and Data Validation. Analyze and summarize data: With PivotTables, calculated fields, slicers, and pivot charts. With PivotTables, calculated fields, slicers, and pivot charts. Create professional-level charts: Including dynamic dashboards, Gantt charts, and sparklines. Including dynamic dashboards, Gantt charts, and sparklines. Perform advanced data analysis: Using Goal Seek, Solver, Scenario Manager, trendlines, and statistical tools. Using Goal Seek, Solver, Scenario Manager, trendlines, and statistical tools. Model and forecast data: Using histograms, frequency distributions, and regression analysis. Using histograms, frequency distributions, and regression analysis. Audit and troubleshoot formulas: With tools like IFERROR, INDIRECT, and Formula Auditing. Who should enrol Finance, accounting and data professionals who need to create reports, dashboards, or perform financial modeling. Business managers and entrepreneurs who want to improve decision-making with powerful data insights. Students and graduates, especially those in commerce, economics, data science, or business analytics programs. Anyone looking to boost their resume and improve employability in data-driven roles. Click here to explore the course Course Expert: NA Course Description: Advanced Excel Course with Certificate by Upskillist is a self-paced, certification course designed to elevate your Excel skills, from basics to advanced mastery. Over 19 weeks, you'll engage with video lectures, quizzes, assignments, and assessments that walk you through practical, real-world Excel applications. The curriculum is structured across four progressive modules– 'Diploma in Excel,' 'Intermediate in Excel,' 'Advanced in Excel,' and 'Proficient in Excel', ensuring a deep understanding of essential and advanced features. This in-depth program prepares you to handle complex data, automate workflows with VBA and macros, and collaborate effectively in professional environments. Course Details: Cost of course: Monthly subscription Course format: Online, self-paced Duration: 19 weeks Course includes: Certification What you'll learn Fundamentals of Microsoft Excel , including key terminologies, basic operations, and interface navigation. , including key terminologies, basic operations, and interface navigation. Techniques for effective data analysis using advanced tools like PivotTables, slicers, and built-in functions. using advanced tools like PivotTables, slicers, and built-in functions. How to maintain data integrity through structured input methods, validation techniques, and error-checking strategies. through structured input methods, validation techniques, and error-checking strategies. Creation and use of input sheets with enhanced data accuracy and auditing capabilities. with enhanced data accuracy and auditing capabilities. Methods for presenting and formatting data using spreadsheets, charts, and graphs for clear and professional reporting. using spreadsheets, charts, and graphs for clear and professional reporting. Navigating multiple sheets and workbooks , including workbook management, printing options, and efficient navigation techniques. , including workbook management, printing options, and efficient navigation techniques. Development of custom templates and lists , empowering students to streamline repetitive tasks. , empowering students to streamline repetitive tasks. Automation of tasks using Macros and VBA , allowing for improved efficiency and customization in workflow execution. Who should enrol Beginners who want a foundational yet advanced Excel skillset. Intermediate users aiming to gain mastery over advanced tools and automation. Professionals in finance, analytics, operations, research, or project management seeking efficiency through Excel. Students and early career professionals looking to enhance employability with practical Excel credentials. Entrepreneurs and freelancers managing business data or reports who want streamlined workflows. Click here to explore the course Ans. Anyone who works with data or spreadsheets can benefit, including: Professionals in finance, HR, marketing, and operations Business analysts and data analysts Students and recent graduates Entrepreneurs and freelancers Anyone looking to improve job prospects or productivity Ans. It's recommended to learn Excel 365, the most current version, as it includes the latest features such as Dynamic Arrays, XLOOKUP, and LET functions. However, many courses still cater to Excel 2016, 2019, and earlier Excel certifications are typically offered at three levels: Beginner/Core – Basic formatting, formulas, and data entry Intermediate – Charts, PivotTables, and data tools Advanced/ Expert – Macros, VBA, automation, and data modeling The above content is an initiative by Times Internet content team to explain product features and simplify jargons for its users. It should not be construed as an endorsement to buy. Times Internet may make a very small commission from its sale if one chooses to buy the product from any of the links in this article.
Mint
5 hours ago
- Mint
How much time does it take to double your money? Rule of 72 explains…
For most investors, amassing wealth to meet their goals is important, be it increasing your net worth, creating a good retirement fund, funding your or your children's education, building a wedding fund, and more. However, most may not know where to begin, or how. To guide in this, we bring you a simple do-it-yourself (DIY) rule of thumb known as the 'Rule of 72'. The 'Rule of 72' provides investors a basic calculated estimate of how many years it would take to double your money in any particular investment tool. The maths is simple: Divide the rate of returns by 72, the answer is the number of years it would take you to to double your investment in that particular instrument. According to Investopedia, The Rule of 72 is 'handy' for a quick mental guage of the approximate value of an investment. Key highlights: A simplified formula, it calculates how long it'll take for an investment to double in value, based on its rate of return. It applies to compounded interest rates and is 'reasonably accurate' for interest rates that fall in the range of 6-10 per cent. Besides investment, it can be applied all exponential increases such as inflation and GDP. Fixed deposits (FDs): Most bank FDs range from 7 days to 10 years, with varying interest rates. For banks such as State Bank of India and ICICI Bank, you can get anything between 3-7 per cent on FDs. Thus, if you intend to invest ₹ 1 lakh in a bank FD with an interest rate of 7 per cent per annum, let's calculate how long it would take to double your money using Rule of 72: 72/7 = 10.28 years. Most bank FDs range from 7 days to 10 years, with varying interest rates. For banks such as State Bank of India and ICICI Bank, you can get anything between 3-7 per cent on FDs. Thus, if you intend to invest 1 lakh in a bank FD with an interest rate of 7 per cent per annum, let's calculate how long it would take to double your money using Rule of 72: 72/7 = 10.28 years. Public Public Provident Fund (PPF): For the current financial year, the interest on PPF is 7.1 per cent, which using the Rule of 72, will also take you around 10 years to double investment: 72/7.1 = 10.14 years. For the current financial year, the interest on PPF is 7.1 per cent, which using the Rule of 72, will also take you around 10 years to double investment: 72/7.1 = 10.14 years. What about equities? If we consider Nifty50, it has given a 13.5 per cent return in 2024, and 80 per cent in five years. So, an investment of ₹ 1 lakh in equities will double ( ₹ 2 lakh) in five years assuming a 5.33 per cent interest rate. The formula is applied as below: 72/13.5 = 5.33 years. If we consider Nifty50, it has given a 13.5 per cent return in 2024, and 80 per cent in five years. So, an investment of 1 lakh in equities will double ( 2 lakh) in five years assuming a 5.33 per cent interest rate. The formula is applied as below: 72/13.5 = 5.33 years. Mutual funds: Disciplined investment in mutual funds are expected to give around 12-15 per cent means that an investment of ₹ 1 lakh in MFs will double ( ₹ 2 lakh) in six years assuming a 12 per cent interest rate: 72/12 = 6 years Disclaimer: We advise investors to check with certified experts before making any investment decisions.
