1st lesson free
The email address and phone number of CA Rajat have been verified.
CA Rajat
- Rate UGX 40,848
- Response 5h
-
Students1
Number of students CA Rajat has accompanied since arriving at Superprof
Number of students CA Rajat has accompanied since arriving at Superprof
UGX 40,848/hr
Contact
1st lesson free
- Microsoft Excel
- Microsoft Word
- Microsoft PowerPoint
Learn the tricks of microsoft excel from a chartered accountant and start saving your hours of work daily
- Microsoft Excel
- Microsoft Word
- Microsoft PowerPoint
Lesson location
About CA Rajat
EDUCATIONAL PROFILE
Chartered Accountant. (CA)
Bachelor of Commerce (BCOM)
Diploma in Information Systems Audit (DISA)
Certification on Forensic Accounting & Fraud Detection (FAFD)
Certification on Concurrent Audit of Bank (CAB)
PROFESSIONAL PROFILE
Practicing CA in Chhattisgarh in the field of Audit, Income Tax & GST.
Faculty of Information Systems Audit- DISA ( Mentored Thousands of CA Members through video lectures )
Expert in Data Analytics with experience on IDEA Software, Excel- Power Query & Power BI.
Handled various automation projects and development MIS Dashboard.
Expert in Google Ads with experience on optimizing ad budgets for startups.
Expert in web development & SEO with experience on many WordPress projects.
Trainer and panelist for Various programs of ICAI.
CA Rajat is a passionate speaker and Business Consultant, with the mission to empower Chartered Accountants to achieve Financial Freedom through technological Advancement.
See more
About the lesson
- Primary
- Secondary
- Tertiary
- +14
levels :
Primary
Secondary
Tertiary
University
Adult Education
Masters
Diploma
PhD (Doctor of Philosophy)
Post-Graduate Diploma in Legal Practice
MBA
Early childhood education
Beginner
Intermediate
Advanced
Professional/Expert
Other
Children
- English
All languages in which the lesson is available :
English
EXCEL BASICS (for Beginners)
Getting Started with Excel
Data Entry, Data Editing, and Number Formatting
Data Formatting
Working with Cells and Ranges in Excel
Managing Worksheets
EXCEL ESSENTIALS
Introduction to Excel Tables
Auto-fill, Custom Lists, and Flash Fill
Number Formatting in Excel
EXCEL FORMULAS
Excel Formula Basics
Logical Formulas in Excel
Math Formulas in Excel
Lookup and Reference Formulas in Excel
Stats Formulas in Excel
Text Formulas in Excel
Date and Time Formulas in Excel
Formulas Mix and Match
DATA ANALYSIS
Named Ranges in Excel
Data Validation in Excel
Data Sorting and Filtering in Excel
Using Conditional Formatting in Excel
INTRODUCTION TO EXCEL CHARTING
Introduction to Excel Charting
10 Advanced Excel Charting Examples
Dynamic Charts in Excel
PIVOT TABLE
Overview of Excel Pivot Table
EXCEL EXTRAS FEATURES
Protection in Excel
Introduction to Macros and VB Editor
Advanced Formula in Excel:
1. VLOOKUP
2. Sum Function
3. MAX MIN function
4. IF Function
5. SUMIF Function
6. COUNTIF Function
7. AND Function
8. OR function
9. LEFT Function
10. RIGHT Function
11. CONCATENATION Function
12. ROUND Function
13. PROPER Function
14. NOW Function
15. Change the case
16. TRIM advanced excel formula
17. Customized MAX MIN
18. Choose()
19. REPT()
20. TYPE()
21. RANDBETWEEN()
22. Unit conversion by CONVERT()
23. PV function
24. Time functions
25. Mathematical functions
See more
Rates
Rate
- UGX 40,848
Pack prices
- 5h: UGX 163,515
- 10h: UGX 286,182
free lessons
The first free lesson with CA Rajat will allow you to get to know each other and clearly specify your needs for your next lessons.
- 30mins
online
- UGX 40,848/hr
CA Rajat's Video
Similar Microsoft Excel teachers in Rajnandgaon
Mourad
Paris 12e, France & Online
- UGX 170,100/hr
- 1st lesson free
Billy
Bullhead City, United States & Online
- UGX 195,900/hr
- 1st lesson free
Erica
Fairfield, Australia & Online
- UGX 165,849/hr
Ireneusz
Gdańsk, Poland & Online
- UGX 122,460/hr
- 1st lesson free
Zammad
New York, United States & Online
- UGX 195,900/hr
- 1st lesson free
Arbaz
New York, United States & Online
- UGX 176,310/hr
- 1st lesson free
Matthieu
Tigery, France & Online
- UGX 134,290/hr
- 1st lesson free
Adi
Toronto, Canada & Online
- UGX 138,489/hr
- 1st lesson free
Ben
Bristol, United Kingdom & Online
- UGX 233,620/hr
- 1st lesson free
Ilian
Paris 8e, France & Online
- UGX 111,908/hr
- 1st lesson free
Patricia
Madrid, Spain & Online
- UGX 111,908/hr
Inès
Paris 1er, France & Online
- UGX 201,434/hr
Moreno
Monza, Italy & Online
- UGX 223,816/hr
- 1st lesson free
Doğukan
Küçükçekmece, Turkey & Online
- UGX 80,053/hr
Matthew
London, United Kingdom & Online
- UGX 202,470/hr
- 1st lesson free
Cassandre
Lehigh Acres, United States & Online
- UGX 231,162/hr
Massimiliano
Ancona, Italy & Online
- UGX 134,290/hr
- 1st lesson free
Gabriel
São Paulo, Brazil & Online
- UGX 88,466/hr
- 1st lesson free
Leonardo
Itaim Bibi, Brazil & Online
- UGX 68,051/hr
- 1st lesson free
Ghada Maged Ali
, Canada & Online
- UGX 152,338/hr
-
See Microsoft Excel tutors
