Over 50 mutual fund SIPs give negative returns in 1 year. Should you pause, redeem, or continue?
mutual funds
were there in the mentioned time period.
Samco Flexi Cap Fund lost the most on SIP investments in the last one year of around 9.91%, followed by two funds from Quant Mutual Fund. Quant Multi Cap Fund and
Quant Mid Cap Fund
gave a negative XIRR of 8.70% and 7.28% respectively on SIP investments.
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
Best MF to invest
Looking for the best mutual funds to invest? Here are our recommendations.
View
Details
»
Also Read |
Multi asset mutual funds beat other hybrid funds in 1 & 3 years. Should they be in your portfolio?
Shriram Flexi Cap Fund delivered a negative XIRR of 6.82% on SIP investments in the last one year. Quant Large & Mid Cap Fund delivered a negative XIRR of 6.02% on SIP investments in the last one year, followed by Old Bridge Focused Fund which gave a negative XIRR of 5.96% on SIP investments in the said time period.
Three flexi cap funds -
Quant Flexi Cap Fund
, NJ Flexi Cap Fund, and JM Flexicap Fund, offered a negative XIRR of 5.79%, 5.39%, and 5.20% respectively on SIP investments in the mentioned time period.
Live Events
Two value oriented funds - LIC MF Value Fund and Aditya Birla SL Value Fund - lost 5.10% and 4.85% respectively on SIP investments in the last one year. Another value fund - Quant Value Fund - lost 3.87% on SIP investments in the same time horizon.
SBI Midcap Fund
gave a negative XIRR of 3.81% on SIP investments in the mentioned time period. Quant Focused Fund offered a negative XIRR of 3.36% in the last one year, followed by two funds from JM Mutual Fund.
JM Focused Fund
and JM Large Cap Fund delivered a negative XIRR of 3.31% and 3.20% respectively in the last one year on SIP investments made. Quant ELSS Tax Saver Fund offered a negative XIRR of 1.75% in the similar time frame, followed by
Kotak Small Cap Fund
which lost 1.63% on SIP investments.
Two small cap funds - Franklin India Small Cap Fund and
Quant Small Cap Fund
- offered a negative XIRR 1.51% and 1.44% on SIP investments in the last one year.
SBI Small Cap Fund
, a prominent small cap fund, delivered a negative XIRR of 0.90% in the said time period.
SBI Contra Fund, the oldest and largest contra fund, delivered a negative XIRR of 0.13% on SIP investments in the last one year, followed by Quant Large Cap Fund which lost 0.07% on SIP investments in the said time period.
Also Read |
These 11 mutual funds gave over 30% CAGR in 3 years. Do you hold any?
With around 51 funds offering negative return on SIP investments one year ago, investors are worried about their SIP investments and are wondering whether they should one pause, redeem, or continue SIPs in funds showing negative 1-year returns, an expert replies that it is too early for an investor to be concerned about their investments and one should continue with their SIPs.
'We believe it is too early for investors to be concerned about negative returns in SIPs as equity investments through SIPs are designed for holding periods of 7-10 years at the least,' Vishal Dhawan, CEO of Plan Ahead Wealth Advisors, a wealth management firm in Mumbai, shared with ETMutualFunds.
'They should continue SIPs as the benefit of lower prices help with rupee cost averaging allowing more units to be purchased with the same rupee value. They do need to track the performance of their schemes over a 3 year period against peers to ensure that the schemes that they are investing in, are doing well vis a vis their peers and category,' he added.
In the last one year, Nifty 50 and BSE Sensex, have gained 2.42% and 2.48% respectively. Nifty Midcap 150 - TRI went up by 2.93% whereas Nifty Smallcap 250 TRI went down by 0.01% and Nifty Smallcap 100 - TRI went down by 0.48% in the mentioned period.
One should always invest based on their risk appetite, investment horizon, and goals.
(
Disclaimer
: Recommendations, suggestions, views and opinions given by the experts are their own. These do not represent the views of The Economic Times)
If you have any mutual fund queries, message on ET Mutual Funds on Facebook/Twitter. We will get it answered by our panel of experts. Do share your questions on
ETMFqueries@timesinternet.in
alongwith your age, risk profile, and Twitter handle.
Hashtags
Try Our AI Features
Explore what Daily8 AI can do for you:
Comments
No comments yet...
Related Articles
Economic Times
an hour ago
- Economic Times
AMFI leads economic transformation with 3 decades of building an investor-first India
Synopsis AMFI's 30-year journey reflects India's economic transformation, from UTI's monopoly era to a ₹75 trillion AUM industry today, driven by SIPs, regulation, awareness, and growing retail participation, supporting PM Modi's Viksit Bharat 2047 vision. AMFI celebrates 30 years of fostering trust, awareness, and inclusion, with mutual fund AUM tripling to ₹75 trillion, supporting India's vision of becoming a developed nation by 2047. A few years ago, our Hon'ble Prime Minister, Shri Narendra Modi, articulated a bold and compelling vision - to see India emerge as a Viksit Bharat (Developed Nation) by 2047. At Association of Mutual Funds in India (AMFI), this vision is deeply personal. For us, nation building is not only about infrastructure, industry or GDP numbers. It is equally about mobilising savings, fostering an investment mindset, and ensuring every citizen – from the largest city to the smallest village – has the tools and knowledge to achieve financial independence. When I look back at AMFI's 30-year journey, I see it running parallel to India's own transformation - from a closed, cautious economy in the early 1990s to a confident, investment-aware nation today. And at the heart of this change lies one simple, yet powerful idea: an informed investor is an empowered citizen. Starting from 1963 and well into the 1980s, the mutual fund industry was a single player domain- dominated by the state-owned UTI - catering to a limited number of investors. Market maturity was low, retail participation was negligible, and large institutions often influenced market movements. The early 1990s were a turning point. The early 1990s were a turning point. Economic liberalisation opened India's economy, and the creation of SEBI as an independent regulator brought much-needed structure, credibility, and investor protection to our capital markets. It was in this backdrop that AMFI was born in 1995, with a mission far greater than industry representation — to instill trust, transparency, and investor-centricity in the DNA of mutual funds, and to take investment awareness to every corner of India. Over the years, AMFI worked alongside SEBI to strengthen regulation and set benchmarks for self-regulation. The shift to NAV-based pricing was a watershed moment — for the first time, investors could see the daily value of their holdings, making wealth creation transparent and the late 1990s, we introduced Systematic Investment Plans (SIPs) — a quiet revolution that democratised investing. No longer was wealth creation the privilege of the affluent. Even the smallest saver could participate in India's growth story with as little as ₹500 a such as the Riskometer, Scheme Categorisation Norms, and Uniform Disclosure Standards simplified mutual funds for millions. KYC norms, and later e-KYC, streamlined onboarding, while technology opened new frontiers for distribution and industry faced its share of challenges — the 2008 Global Financial Crisis, the 2012 Taper Tantrum, and volatile market cycles. Each time, we emerged stronger, not just in numbers but in investor the mid-2010s, mutual funds had crossed ₹10 trillion in assets under management (AUM). Between 2014 and 2017, AUM doubled to ₹20 trillion, and by November 2020, crossed ₹30 last five years have been the most remarkable yet. From June 2020 to July 2025, AUM has tripled to ₹75 trillion. Investor folios now exceed 240 million, with nearly 2.5 million new folios being added every month — a clear testament to growing trust and surge is no longer limited to metros. Today, a first-time earner in a Tier-3 town is just as likely to start their financial journey with a mutual fund as someone in Mumbai or turning point was 2017, when AMFI launched the 'Mutual Fund Sahi Hai' campaign — breaking the myth that mutual funds were only for the wealthy, and speaking to every Indian in their own language. It took investment awareness to the smallest towns, rural markets, and digital screens across the has been a game changer — with smartphones and UPI, investing in a mutual fund has become as simple as sending a text message. Improve financial literacy in schools, colleges, workplaces, and communities. Create financial independence by empowering citizens with the knowledge to save, invest, and plan for their future. Reach the unreached — the hundreds of millions of Indians who have yet to take their first step into formal investing. We envision a future where every Indian household has an investment plan, where women and youth lead the way in disciplined savings, and where financial security becomes a way of life, not a journey has always been about more than products or performance. It has been about trust built patiently over decades, discipline nurtured through awareness, and empowerment delivered through AMFI, we remain steadfast in keeping the investor-first approach at the heart of everything we do. Because when investors grow, India grows. And when India grows, the dream of Viksit Bharat will not just be a vision — it will be a reality. 'Karmanye vadhikaraste, Ma phaleshou kada chana' You have the right to perform your actions, but not to the fruits thereof. This timeless wisdom captures the spirit that guides us — to act with integrity, dedication, and unwavering purpose. At AMFI, our commitment remains clear: to empower every Indian with the knowledge and tools to invest wisely and build a secure future. Because when we focus on the right actions, the outcomes — for the investor, the industry, and the nation — will follow. (The author Venkat N Chalasani is Chief Executive – Association of Mutual Funds in India (AMFI). Views are own) (Disclaimer: Recommendations, suggestions, views, and opinions given by experts are their own. These do not represent the views of the Economic Times) (Disclaimer: The opinions expressed in this column are that of the writer. The facts and opinions expressed here do not reflect the views of
Time of India
a day ago
- Time of India
Best Online Microsoft Excel Certification Courses for Professionals in 2025
Why Microsoft Excel is Important and How It 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. Live Events List of the best Microsoft Excel certification courses online 1. Excel Essentials to Expert: Your Complete Guide Cost of course: Rs. 899 (one time) Course format: Online, self-paced Duration: NA Course includes: Certification Master Excel basics: Data entry, cell formatting, and foundational calculations. Use formulas & functions: IF, AND, OR, AutoSum, VLOOKUP, HLOOKUP, COUNT, RANK, SUMIF, COUNTIF, AVERAGEIF, and more. Understand referencing: Create formulas with relative and absolute references. Work with data: Conditional formatting, linking sheets, paste special, and data validation. Master charts and visualizations: Create and format impactful Excel charts. Perform financial analysis: Use NPV, IRR, PMT, and depreciation functions for real-world scenarios. Automate tasks: Learn Macros and VBA basics to streamline repetitive processes. Analyze data like a pro: Use PivotTables, Goal Seek, Scenario Manager, and other advanced tools. Boost productivity: Learn keyboard shortcuts, auditing tools, and how to create print-ready sheets. Hands-on learning: Includes workbooks and an eBook for practice and revision. 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. 2. Zero to Hero in Microsoft Excel: Complete Excel guide 2024 Cost of course: Rs. 2,500 (one time) Course format: Online, self-paced Duration: 9.4 hours Course includes: Lifetime access, Certificate of completion Master foundational Excel operations: Including formulas, data entry, ranges, formatting, and navigation. Build confidence with essential formulas: Like SUM, AVERAGE, IF, COUNTIF, ROUND, and logical functions. Use advanced lookup techniques: Including VLOOKUP, HLOOKUP, MATCH, INDEX, and XLOOKUP (Excel 365+). Clean and import data: From multiple sources like TXT, CSV, PDF, and online databases. Create visually impactful charts: Including bar, pie, scatter, bubble, waterfall, radar, sunburst, and more. Summarize and analyze data: Using PivotTables and PivotCharts for business intelligence. Apply automation techniques: Using Macros and VBA to save time and reduce errors. Visualize data trends 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. Fix common Excel errors: E.g., #N/A, #VALUE!, #REF! and learn how to avoid them. Understand and apply named ranges and INDIRECT functions: For cleaner, dynamic formulas. Leverage AI-powered insights: 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. 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. 3. Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Cost of course: Rs. 549 (one time) Course format: Online, self-paced Duration: NA Course includes: Certification Create and manage spreadsheets, enter and format data with ease. Apply essential formulas and functions such as SUM, AVERAGE, IF, COUNT, and DATE. Work with advanced lookup tools like VLOOKUP, HLOOKUP, and XLOOKUP (Office 365). Format cells, numbers, and tables to create clean and readable sheets. Use tools like Flash Fill, Data Validation, and Remove Duplicates for efficient data handling. Visualize data using PivotTables, PivotCharts, column charts, line graphs, and more. Import data from text, CSV, and other formats for analysis. Set up print-ready pages with Fit-to-Page and advanced print options. Sort, filter, and manage large datasets with ease. 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. 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. Discover AI-powered tools to speed up tasks like content creation and Excel formula generation. 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. 4. Mastering Google Sheets: Unleash the Power of Excel and Advance Analysis Cost of course: Rs. 799 (one time) Course format: Online, self-paced Duration: 7.32 hours Course includes: Lifetime access, Certificate of completion Master basic spreadsheet features: Like cells, formulas, and data formatting. Use essential functions: Such as SUM, COUNT, IFS, and more. Analyze and visualize data: With pivot tables and dynamic charts. Implement advanced functions: Like QUERY, ARRAYFORMULA, and INDEX MATCH. Import and clean data: From CSVs, text files, and web sources. Collaborate in real-time: Manage team-based projects within Google Sheets. Automate tasks; Using scripts and smart formulas. Secure spreadsheets: With permissions and data protection. Use generative AI: To boost productivity and enhance spreadsheet performance. QR code and images: Generate QR codes, embed images, and build interactive dashboards. 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. 5. Excel for Everyone By Edx Cost of course: $510.30 Course format: Online, self-paced Duration: 18 weeks Course includes: Certification Build strong Excel foundations: 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. Manipulate raw data efficiently: 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. Perform advanced data analysis: 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. Automate tasks with confidence: Create macros, use Visual Basic (VBA), and audit formulas for error-free workbooks. 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. 6. Excel Fundamentals – Formulas for Finance By Corporate Finance Institute Cost of course: $ 347.90 (for unlimited access to courses) Course format: Online, self-paced Duration: 2 hours 14 minutes Course includes: Certification Use essential Excel functions: To perform financial and statistical analysis on datasets. Aggregate and summarize financial data: Using core Excel functions such as COUNTIF, SUMIF, etc. Compare and apply lookup functions: Such as VLOOKUP, HLOOKUP, and XLOOKUP for data retrieval. Utilize Excel's date functions: To build annual, quarterly, and monthly financial models. Understand time-value concepts: Using NPV, IRR, XNPV, and XIRR functions. Apply professional formatting: For numbers and dates to enhance clarity and consistency in reports. Practice keyboard shortcuts and tools: To boost speed and accuracy in financial modeling. 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. 7. Microsoft Excel 365 - Basic & Advanced By Goskills Cost of course: Rs. 1,400 per month platform fee Course format: Online, self-paced Duration: 2 hours 14 minutes Course includes: Certification Navigate and customize the Excel 365 interface for efficient use. Master core formulas and functions for math, statistics, logic, and text manipulation. Organize and filter data using tables, named ranges, and data validation techniques. Summarize large datasets with PivotTables and perform What-If analysis. Visualize insights through compelling charts, and graphs. Automate repetitive tasks by recording macros and using Power Query. Explore new Excel 365 features like Dynamic Arrays, FILTER, XLOOKUP, and LET. Format and prepare workbooks for professional reporting and printing. 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. 8. Advanced Excel certification course by Indian institute of Skill Development Training Cost of course: Rs. 4,000 Course format: Online examination, self-paced Duration: 2 months Course includes: Certification Master Excel fundamentals: Including workbook management, formatting, formulas, and shortcuts. Use advanced formulas and functions: 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. Analyze and summarize data: With PivotTables, calculated fields, slicers, and pivot charts. Create professional-level charts: Including dynamic dashboards, Gantt charts, and sparklines. Perform advanced data analysis: Using Goal Seek, Solver, Scenario Manager, trendlines, and statistical tools. Model and forecast data: Using histograms, frequency distributions, and regression analysis. Audit and troubleshoot formulas: With tools like IFERROR, INDIRECT, and Formula Auditing. 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. 9. Advanced excel course online with certificate By Upskillist Cost of course: Monthly subscription Course format: Online, self-paced Duration: 19 weeks Course includes: Certification Fundamentals of Microsoft Excel, including key terminologies, basic operations, and interface navigation. Techniques for effective data analysis 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. Creation and use of input sheets with enhanced data accuracy and auditing capabilities. Methods for presenting and formatting data using spreadsheets, charts, and graphs for clear and professional reporting. Navigating multiple sheets and workbooks, including workbook management, printing options, and efficient navigation techniques. Development of custom templates and lists, empowering students to streamline repetitive tasks. Automation of tasks using Macros and VBA, allowing for improved efficiency and customization in workflow execution. 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. FAQs: Microsoft Excel Courses Q1. Who should get certified in Microsoft Excel? 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 Q2. What version of Excel should I learn or use? Q3. What levels of certification are available? Beginner/Core – Basic formatting, formulas, and data entry Intermediate – Charts, PivotTables, and data tools Advanced/ Expert – Macros, VBA, automation, and data modeling 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 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 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:NATake 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 Sudha SekharMaster 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 Sudha SekharUnlock 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 Sudha SekharUnlock 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 R. TrujequeExcel 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 McKeenExcel 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 PulsMicrosoft 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 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 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 Anyone who works with data or spreadsheets can benefit, including: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:
Time of India
2 days ago
- Time of India
8 equity mutual funds offer over 15% return in 6 months. Are there any included in your portfolio?
Eight equity mutual funds offered over 15% return in the last six months, an analysis by ETMutualFunds showed. There were around 281 equity mutual funds in the said period. Independence Day 2025 Before Trump, British used tariffs to kill Indian textile Bank of Azad Hind: When Netaji gave India its own currency Swadeshi 2.0: India is no longer just a market, it's a maker The two toppers were from Invesco India Mutual Fund . Invesco India Midcap Fund and Invesco India Large & Mid Cap Fund offered 20.63% and 18.97% returns respectively in the last six months. 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 Undo Canara Robeco Mid Cap Fund offered a return of 17.39% in the mentioned time period, followed by Helios Large & Mid Cap Fund- which delivered a return of 16.57% in the same period. Also Read | HDFC Defence Fund increases stake in Bharat Dynamics and 3 others, trims exposure in 5 stocks in July HSBC Midcap Fund posted a return of 16.33% in the last six months, followed by two funds from Mirae Asset Mutual Fund. Mirae Asset Midcap Fund and Mirae Asset Small Cap Fund delivered a return of 15.82% and 15.65% respectively in the mentioned period. Live Events Kotak Midcap Fund , a mid cap fund, delivered a return of 15.45% in the last six months. A further deep dive in the data showed that all funds which were there in the said time period delivered positive returns ranging between 2.71% to 14.88%. ICICI Pru Midcap Fund posted a return of 14.88% in the last six months. Three mid cap funds - Union Midcap Fund, WOC Mid Cap Fund, and Bandhan Midcap Fund delivered a return of 14.10%, 13.85%, and 13.50% respectively. Two small cap funds - DSP Small Cap Fund and Aditya Birla SL Small Cap Fund - delivered a return of 12.21% each in the said period. The largest small cap fund based on assets managed, Nippon India Small Cap Fund, offered a return of 10.90% in the last six months. Quant Small Cap Fund delivered a return of 10.06% in the said period. Bank of India Large Cap Fund and Bandhan Large Cap Fund delivered 10.04% return each in the last six months. ITI ELSS Tax Saver Fund was the last one to deliver a double digit return in the said period. The fund gave a 10% return. HDFC Flexi Cap Fund and UTI Small Cap Fund delivered 9.66% returns each in the said time period. SBI ELSS Tax Saver Fund, the oldest ELSS fund, delivered a return of 7.22% in the said time period. Parag Parikh Flexi Cap Fund, the largest active fund and flexi cap fund based on assets managed, delivered a return of 6.40% in the last six months. Also Read | Motilal Oswal Mutual Fund joins ONDC, appoints Cybrilla as service provide SBI Contra Fund, the largest and oldest contra fund, delivered a return of 5.71% in the said time period. Quant Mid Cap Fund posted a return of 4.01% in the said time period. Two funds from LIC Mutual Fund - LIC MF Value Fund and LIC MF Small Cap Fund - posted a return of 3.09% and 2.85% respectively in the same period. JM Flexicap Fund was the last one in the list and gave 2.71% return in the last six months. We considered all equity mutual funds excluding sectoral and thematic funds. We considered regular and growth options. We calculated the returns for the last six months. Note, the above exercise is not a recommendation. The exercise was done to find which equity mutual funds have offered over 15% return in the last six months. One should not make investment or redemption decisions based on the above exercise. One should always consider their risk appetite, investment horizon, and goals before making any investment decisions .
