Microsoft Excel Basics to Advance Course (Specifically for CA/CS/CMA/CFA) by CA Hemant Somani
Demo Video
Write a review
.png)
Microsoft Excel Basics to Advance Course (Specifically for CA/CS/CMA/CFA) by CA Hemant Somani
"Need One time Free Mentorship from CA & CA Ranker About Faculty & Strategy for Subject ? CAZilla.in Provides free one time mentorship By CA (including CA Rankers), and also get the Best Guaranteed Price, In case you find this product anywhere cheaper, Just share us proof, we will provide you the Best….."
Make your Own Combo and Get Discount +917877973155 (WhatsApp)
For Hemant Somani Sir Products, Contact +919079350107 (Whatsapp)
✅ Duration: 3+ hours of Recorded Session
✅ Access: 1 months (Recordings & other resource material Available)
✅ Even if you have Small Size/ Mid Size or Dummy Experience
✅ Language: English
✅ Way to get into Big-4 & Big MNC's
✅ Microsoft Excel Course Specifically Designed for CA / CS & CMA Students and Professionals
✅ Certificate after Completion
HOW TO WATCH COURSE
- After Purchasing it, Login to https://cahemantsomani.graphy.com/
(then, Login to Website, there you can watch the course, ACCESS WILL BE PROVIDED IMMEDIATELY AFTER PURCHASE)
Any Query related to Purchase: camentorzilla@gmail.com
So in this course we will learn about following things:
| 1 | Basics, Crazy Shortcuts, Special paste, Auto fill etc. |
| 2 | Conditional Formatting & Filteration |
| 3 | PIVOT Table |
| 4 | V-LookUp, H-LookUp & X LookUp |
| 5 | Conditional Formulas : "If" Formula for Conditions, "IF" & "and" Combo |
| 6 | Data Analysis & Cleaning : Text to Column, Flash Fill, Concetanate etc. |
| 7 | SumIf, Sumifs, Countif, Countif's |
| 8 | Some important Financial Formulas : NPV, XNPV, IRR, XIRR, PMT |
| 9 | Some important Date & Time Formulas |
| 10 | Other Important Formulas, Eg. : Trim, Mod, Proper etc |
| 11 | How to Lock Specific Portion of Sheet for editing, Lock full sheet etc |
| 12 | How to Print Excel sheet Correctly |
| 13 | Basics of MACROS with example |
| 14 | Basics of Charts |
| 15 | Advance Slicer Filter |
| 16 | Advance What if Analysis (Calculate different-Different Scenerio calculation in Just a Few Seconds) |
| 17 | Exercise : Practical Implications of All above formulas on real data |
| 18 | And Many other things ;-p |
About Faculty
CA Hemant Somani
Buy the CA Hemant Somani- CA Final Audit, CA Inter Audit, CA Final GST, Online course, pendrive classes, Google Drive & video lectures, Books available from India's Best CA faculties at the CAZilla website.
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 & SM-FM 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.
In just a short duration of Time only, We have produced Many Rankers ;-p, Including Many Single Digits AIR's & Uncontable Exemptions.
Master the intricacies of CA Final and Inter Audit, along with GST, through CAZilla's comprehensive online courses and pendrive classes. Access top-notch video lectures and study materials curated by India's finest CA faculties. Elevate your preparation with our Audit All in One Book. Dive deep into the world of auditing and taxation with CAZilla today
You can Purchase CA Final Audit Classes, CA Inter Audit Classes, CA Final Audit Book, CA Inter Audit Book, CA Final GST & other Classess of CA Hemant Somani from CAzilla website at Lowest cost.
