Hurry Up! Early bird offer ending in

8
Days
5
Hours
43
Min
51
Sec

 Recorded Sessions

Learn whenever you can

3+ Hours of learning

Bonus Study Guide & Workbook

 

About the Course

    Learn how to use Microsoft Excel from basics to advanced level with this course specifically designed for CA/CS/CMA students and professionals. This course will cover all the important aspects of Excel that are required in the accounting and finance industry.

    So in this course we will learn about following things:
    • Introduction to Excel and Spreadsheet basics
    • Managing large datasets, including sorting and filtering
    • Data validation and conditional formatting
    • Advanced functions like IF, VLOOKUP, and HLOOKUP, Sum If etc.
    • Pivot tables and charts
    • Excel shortcuts and tips for efficiency
    • Data Analysis & Cleaning : Text to Column, Flash Fill, Concetanate etc.
    • Macros and automation in Excel 
    • Financial Formulas : NPV, XNPV, IRR, XIRR, PMT
    • Many other things (Sum If, CountIf, Conditional Formulas, Text to Column, Flash Fill,           Trim, Mod, Proper, Locking Specific Portion of Sheet, Date& Time Formulas) etc etc etc 

Meet your mentor

CA Hemant | AIR 46

Hey! This is CA Hemant Somani, CA By Profession & Mentor by Passion. I secured All India Rank 46 (AIR-46) in CA Final examination along with exemption in 7 Papers despite being infected with Covid 19 just 15 days before exams.

I'm Faculty of Audit & GST at CA Final & Inter level. In terms of professional experience, I worked at PwC in the Domain of Audit, MNCs in India & Currently working Abroad in the field of Finance

Benefits & Bonuses Included in the Course

Basics of Excel: Introduction to Excel, Spreadsheet basics, managing worksheets and workbooks.

Data Management: Working with large datasets, sorting and filtering data, data validation and conditional formatting.

ExcelFunctions: Using basic and advanced functions like IF, VLOOKUP, HLOOKUP, SUM, AVERAGE, COUNT, and more.

Excel Shortcuts and Tips:Learn time-saving keyboard shortcuts and tips for improving efficiency in Excel.

Macros & Automation Basics

Self Practice & Automated Sheets: Prepaid Expense, Debtor's Ageing & Bucket, IFRS & AS Financials, Taxation Replies, notices, Drafts etc.


Course Curriculum : Here's what you will learn

Prerequisites for this course

Laptop with Internet

No Prior Experience Required

Hunger for Growth

Ready for the grind

Our winning results

1 / 2

This program is best suited for

Professionals

Specifically for domains such as  (Chartered Accountants (CA), Company Secretary (CS), Cost and Management Accountant (CMA), CFA, ACCA, However Equally useful for other Professionals also

Students

looking to land a career in domains such as (Chartered Accountants, Company Secretary (CS), Cost and Management Accountant (CMA), CFA, ACCA, However equally useful for other professionals Also

Program Highlights

3+ hours of content 

1 Month access to session recordings

Friendly & Peer based learning environment

Bonus Excel Files for Work Automations (Excel Financials etc)

Certificate after Completion

Personalised Feedback

Launch your GraphyLaunch your Graphy
100K+ creators trust Graphy to teach online
The Professional Monk 2024 Privacy policy Terms of use Contact us Refund policy