Enhance your Excel skills and become proficient in advanced data analysis techniques.
Streamline your workflow and increase productivity through automation and macros.
Improve your data visualization skills and create impactful charts and graphs.
Gain a competitive edge in the job market with a recognized certification in Advanced Excel.
Streamline your workflow and increase productivity through automation and macros.
Chinmay is working as an associate at a big4 firm in the valuation, modelling and economics practice. He is a commerce graduate from Mumbai University and has close to 4+ years of work experience across Investment Banking, Financial Due Diligence and Asset Management.
He is a content creator on LinkedIn with 35K+ followers. He has trained 6K+ participants including international students and has been a guest speaker on Analytics & Corporate Finance using MS Excel at top-tier institutes like EY, IIM-A, IIM-B, IIM-L, IIM-T, IIM-K, ISB Hyderabad, IIT – Guhawati, National Forensic Sciences university, various colleges at Mumbai University and Delhi University etc.
Develop Advanced Excel Skills
Gain a comprehensive understanding of advanced Excel functions, formulas, and features, enabling you to efficiently manage and analyze data.
Increase Productivity
Learn time-saving techniques, shortcuts, and automation methods to boost your productivity when working with large datasets.
Creative Interactive Dashboards
Acquire the skills to build dynamic and interactive dashboards that present data visually and facilitate effective decision-making.
Perform Complex Data Analysis
Learn how to leverage advanced data analysis tools, such as PivotTables, Power Query, and Power Pivot, to gain valuable insights from your data.
Automate Tasks with Macros
Discover how to automate repetitive tasks using Excel’s macro recording and VBA programming, streamlining your workflow and reducing errors.
1. Text to Columns and Textsplit (Theory).
2. =AVERAGE(), =COUNTIF(), =MIN(), =MAX(), =SMALL(), =LARGE() functions & Microsoft support Page Trick.
3. Wildcards in Excel (Asterisks *).
4. 100+ Keyboard shortcuts to improve speed & efficiency on Excel.
5. Data Cleaning using =SUBSTITUTE, =CHAR, =UNICODE, =RIGHT functions.
6. Data Visualisation & Auto – update chart using Excel Tables (Dual Axes Charts).
7. Custom Formats & Conditional Formatting in Excel.
1. Concept of Date in Excel and calculating last working day of notice period for Mr. Robot using Date functions (EOMONTH, EDATE, ISNUMBER).
2. Understanding relative & absolute cell referencing in Excel and the new way to spill formulas using Dynamic Arrays based on matrix multiplication & CSE Formulas.
3. VLOOKUP with Wildcards & how to be a better analyst by adding notes & comments by know knitty – gritty of Excel.
4. EMI Computation in Excel for your new iPhone & target repayment with Goal Seek (Introduction to Solver – Theory)
5. Find & Replace Hacks.
6. Paste Special Dialogue Box (CTRL + ALT + V or ALT + E + S).
7. Go To Special Dialogue Box from Financial Modelling perspective.
1. SUMIFS, COUNTIFS, LEN with Ampersand Functions.
2. Using Pivot Tables (2D) to Analyse the workforce (organisational structure) with Slicers.
3. Dynamic Arrays with the new concept of Spill & #.
4. Perform Multi-Lookups using new FILTER & TEXTJOIN function.
5. Data types & Data Validation in Excel (Text, Numbers, Geography, Stocks etc.)
6. Approximate lookups using the New XLOOKUP functions.
7. Perform 3D Lookups using the SUMPRODUCT functions and Binary Logic.
1. Web Scraping Data using Power Query.
2. Exploring Power Query Editor for transformation of data which is not possible in traditional excel.
3. Theory on Financial Modelling with case study on Income Tax Modelling & most exhaustive resource compilation to learn modelling.
4. Named Ranges & Formula Auditing Tools (Trace Precedents & Evaluate Formula).
5. Data Tables & Sensitivity Analysis.
6. Know your hometown’s mayor & recent stock price of your portfolio stocks using new datatypes & stockhistory function in excel.
7. Leveraging the Machine Learning Algorithm in Excel (Flash Fill).
1. Making custom Keyboard Shortcuts using Macros.
2. Activating Developer Tab and exploring custom add-ins in Excel.
3. Understanding the concept of VBA, Macro & automating tasks leveraging ChatGPT or open forums like GitHub.
4. Exploring circular references & iterative calculation in Excel.
5. Basics of OneDrive/SharePoint and leverage free tool – office.com from Microsoft.
6. Google Sheets (Introduction) & History of MS Excel since 1980.
7. Similarities between Python & Excel (LAMBDA – MAP : Theory).
• Find the busiest route for a courier company.
• Dynamically rank NIFTY 50 stocks based on sector & any 1 additional metrics/KPI + Dashboarding.
• Compute Payback Period.
• Capex Modelling – Hospital Beds.
• Create Custom Keyboard Shortcut for Centre Across Selection using VBA/Macros.
You will receive an email with the login details and instructions for accessing the course materials and sessions. You will also receive a link to join the live sessions via Zoom.
You can contact KAGR by email at info@kagr.com or by phone at +91- 9137979582. KAGR’s customer support team will be available 24/7 to assist you.
How does the course accommodate different time zones for international students?
We believe in the value our course offers, but we also understand the importance of satisfaction. We do have a refund policy in place. However, terms and conditions apply. We recommend reaching out to our support team for detailed information.
Yes, upon successfully completing the Advanced Course, you will receive a certificate that can be a valuable addition to your professional portfolio, showcasing your expertise in integrating AI with finance.
Absolutely! The Advanced Course is designed to be interactive, offering opportunities for students to engage with instructors during live sessions. Additionally, enrolling in the course allows you to network with like-minded peers, enhancing the learning experience.
This course covers the Advanced level of Excel. So it is required that you have a basic knowledge of Excel in terms of functions and their applications.
Rs. 2,999 inclusive of GST.
Yes, it will be recorded and those who are not able to attend it, will get a 2-time view only recording of the same for the next 5 days only.
In case any participant wants to claim GST credit, kindly email us a copy of your GST Certificate on info@kagr.club and we shall send the GST invoice to you.