- Home
- Microsoft 365 Excel
Microsoft 365 Excel
-
Getting Started
- About NAL Academy Limited (formerly known as NSE Academy Limited)
- Get started for NCFM
- NSE Academy Certification Modules
- NCFM PRO Modules
- Foundation Modules
-
Intermediate Modules
- Overview
- Capital Market (Dealers) Module (CMDM)
- Derivatives Market (Dealers) Module (DMDM)
- Investment Analysis and Portfolio Management
- Fundamental Analysis Module
- Options Trading Strategies Module
- Operations Risk Management Module
- Treasury Management Module
- Insurance Module
- Macroeconomics for Financial Markets Module
- Technical Analysis Module
- Mergers and Acquisitions Module
- Back Office Operations Module
- Banking Sector Module
- Wealth Management Module
- Project Finance Module
- Venture Capital and Private Equity Module
- Advanced Modules
- How to take a Test
- Updates & Announcements
- Partner with Us
-
Certifications/Programs
-
Online Interactive Courses
- Overview
- Professional Certificate in Algo Trading using Python
- Professional Certificate in Advanced Derivatives
- Professional Certificate in Financial Markets (PCFM)
- Technical Analysis
- Advance Technical Analysis Program Level-2
- Concept Of Trading Strategies in Capital Market
- Fundamental Analysis
- Certification in Financial Modeling and Valuation
- Equity Research And Valuation
- Application of Python in trading & investing
- Investment Analysis and portfolio Management
- Advanced Strategies: Japanese Candlestick Charting Techniques
- Elliot wave and Fibonacci Retracement
-
Online / Self-Paced Courses
- Overview
- Portfolio Investment Strategies And Wealth Advisory
- Financial Analytics
- CORPORATE FINANCE, BOND MARKETS, BANKING, INVESTMENT & WEALTH MANAGEMENT
- Technical Analysis and Chart Patterns for Capital Markets
- Global Markets, Investments ,Instruments And Portfolio Management
- Financial Technology & Data Analytics
- Financial Products Marketing & Customer Experience
- Financial Planning, Banking & Investment Management
- Foundation of Capital Market Investing
- Finance for Non-Finance Managers
-
Class Room Courses
- Overview
- Technical & Fundamental Analysis in Capital Market (Mumbai)
- Technical & Fundamental Analysis in Capital Market (Delhi)
- Financial Modelling and Equity Valuation
- Trading & Investing In Capital Market (Stock Market) - Delhi
- Technical Indicators & Concepts of Derivatives (Options)- Offline Mumbai
- Advanced Level Program on Concepts of Derivatives (Future / Options / Swaps / Hedging) - Offline Mumbai
-
Enterprise Training
- Overview
- LEAP - Workshop for First Time Managers
- 5 Star Customer Experience: Winning Strategies
- Unmask the Magic of Finance for Non-Finance Professionals
- AI Fusion: Transforming Finance and Sales with GenAI
- EDGE-BFSI : Enabling Digital Growth Experience for BFSI Professionals
- CyberFusion 2024: Revolutionizing BFSI Security Paradigms
- Compliance Chronicles: Regulatory Insights & Best Practices
- Navigating the Future: Strategic Leadership in BFSI
- Beyond the Glass Ceiling: Strategic Transformation Program for High Potential Women Bankers
- Personal Tax Planning - "Aaykar ko Apna Banaakar"
- PG Full Time Programs
- PG Weekend/Executive Batches
-
Partner Programs
- Overview
- Options Trading Strategies In Python: Intermediate
- Options Trading Strategies In Python: Advanced
- Executive Programme In Algorithmic Trading - EPAT
- Forex and Commodities - Training Program
- Technical Analysis Masterclass
- Future and Option Trading Strategies
- Finance 101
- Currency Market Trading Strategies
- Index Trading Strategies Course
- Advance Technical Analysis
- Advance Future and Options
- Fundamental Analysis and Technical Analysis
- Advance Equity Research And Valuation Course
- Concept and Application of Trading Strategies
- Equity Research And Valuation Course
- Financial Modelling and Valuation
- E-NCCMP
- Basics Future and Options Training
- Technical Analysis (Weekdays Batch)
- Technical Analysis (Weekend Batch)
- Equity Research and Valuation Online / Self-Paced
- Futures and Options Trading Strategies Online / Self-Paced
- Technical Analysis-Weeked Online / Self-Paced
- Financial Modelling and Valuation Online / Self-Paced
- Advanced Technical Analysis Online / Self-Paced
- Advance Futures and Options Online / Self-Paced
- Advanced Equity Research and Valuation Online / Self-Paced
- Technical Analysis Masterclass Online / Self-Paced
- Investment Analysis and Portfolio Management Self-Paced
- Futures and Options Trading Strategies in Hindi Self-Paced
- Technical Analysis in Hindi Self-Paced
- Financial Statement Analysis Self-Paced
- Team Trading – Derivatives Trading Mastery Program
- Futures & Options Simplified Program
- Derpo – Derivatives Portfolio Program
- Greeks Mastery Program
- Visual Trading - Technical Analysis Program
- Stock Market Foundation Program
-
International Certificate Program
- Overview
- Themed Track on ESG (Environmental, Social & Governance)
- Financial Modelling & Valuation
- International Financial Reporting Standards (IFRS)
- Goods and Services Tax (GST)
- MS Excel Essentials
- Business Intelligence using Power BI and Tableau
- Data Analytics using R
- Microsoft 365 Excel
- Data Analytics using Python
- Cyber Security Fundamentals
- Blockchain Technologies
- Finance for Non-Finance Professionals
- Financial Modelling & Valuation THEMED TRACK
- Data Analysis & Visualization THEMED TRACK
- Python for Data Analytics & Reporting THEMED TRACK
-
Online Interactive Courses
-
Student Requirement
-
For Under graduates
- Overview
- B Com in Financial Analytics_Christ Deemed to be University
- B. Com offered by Birla Institute of Technology, Mesra, Ranchi in collaboration with NAL Academy Limited
- BBA in Capital Market Joint Programme by NAL Academy Limited and TransStadia University
- BBA in FM by NAL Academy Limited & GITAM, Telangana
- BBA in FM by NAL Academy Limited & GITAM, Visakhapatnam
- BBA in FM by NAL Academy Limited & GITAM, Bangaluru
- BBA in FM by NAL Academy Limited & St Joseph's College
- B.Com (Hons) Capital Markets
- Fintech Analytics Professional (FAP) Program
- For Dealers
- For Post Graduates
-
For Working Professionals
- Overview
- Anna University - Online PG Certification Programme in Financial Analytics
- Exec KPMG Digital Courses
- Exec FMI Global Financial Modeling Program
- IIM Sirmaur (PGDM) - Post Graduate Diploma in Management (Data Science and AI)
- IIM Sirmaur (PGDM) - Post Graduate Diploma in Management (Tech.)
- IIM Kashipur - Executive Program in Fintech & Applied Financial Analytics
- Executive Program in Financial Analytics - XLRI
- Bootcamp on ESG Environmental , Social and Governance
- IMT Hyderabad-PG Certificate Program in Financial Technologies
- IIM Jammu Executive Program in Financial Analytics
- New York Institute of Finance- Micro Certificate
- Global Risk Management Professional Program
- New York Institute of Finance (NYIF) Certified-Global Investment Strategy Essentials (GISE)
- Certificate Program in Finance for Non-Finance Professionals
- PG Certificate Program in Financial Technologies Cohort-3
- IIM Jammu Executive Program in Financial Analytics
- MBA - FinTech The Future of Finance
- IIM Sambalpur MBA for Working Professionals at Delhi Campus
- IIM Sambalpur MBA for FinTech Management
-
For Under graduates
| TOTAL DURATION | CERTIFICATION VALIDITY | COURSE TYPE |
|---|---|---|
| 45 Hours | No Expiry | Online Self-Paced |
For more Information
Counsellor: +91 7758832162 / +91 9137662466
Email ID: gen_pdp@nse.co.in
With businesses evolving constantly and increasing in complexity, MS Excel has become a popular tool for data analysis in organizations across the globe. It is used in every function, be it strategy, finance, accounting, HR or sales. Many organizations rely on Excel to create financial reports, budgets, forecasts and plans that are necessary for making informed business decisions.
MS Excel’s ability to automate calculations and manipulate large data sets saves time and increases productivity. It is a powerful tool for data analysis because it allows users to sort, filter and analyze data to identify trends, patterns and insights.
- Data management and formatting, Referencing in Excel, Data split, Data validation, Adding hyperlinks, Logical functions
- Lookup functions, Conditional functions, SUMPRODUCT function, Large and small values, Data concatenation, Working with dates and time
- Financial functions, Text-oriented functions, Aggregate function, OFFSET function, INDIRECT function, Formula auditing
- Statistical functions, Using Range Names, Excel Table, What If Analysis, Protecting Worksheet and Workbook, Dashboards and Data Summarization
- MS-365 Excel overview, Create dynamic sequence, Unique, sort and filter, New age lookup, Text-oriented functions
- New data types, Create customized functions in Excel, Other functions, Assessment and study material
- 1-Year of Access Get LMS access for one year
- In-course exercises files to help apply knowledge in real-world situations
- Certificate will be awarded by NAL Academy upon completion.
- Learn practical concepts of Microsoft 365 Excel
- Online Self-Paced Learn at your convenience.
- Online Query Support Through LMS, by SME within 48-Hrs
Updated on: 01/04/2026
GIGW Compliant