1st lesson free
Ranit Kr profile and its contact details have been verified by our team.
Ranit Kr
- Rate 1€
- Response 1h
1€/h
Contact
1st lesson free
- Microsoft Excel
- Microsoft Word
- Microsoft PowerPoint
- Microsoft Outlook
I have over 10 years of experience in MS Excel, MS PowerPoint, MS Word, and MS Outlook. For the past 10 years, I have been teaching these tools, along with Google Slides, Google Docs, and Google Sheet
- Microsoft Excel
- Microsoft Word
- Microsoft PowerPoint
- Microsoft Outlook
Lesson location
About Ranit Kr
"I have over 10 years of experience in MS Excel, MS PowerPoint, MS Word, and MS Outlook. For the past decade, I have been teaching these tools, along with Google Slides, Google Docs, and Google Sheets, both online and offline, at my computer center. I conduct classes in Bengali, Hindi, and English, helping students master these essential software tools for productivity and data management."
See more
About the lesson
- Primary School
- Secondary School
- Post-Secondary Education
- +20
levels :
Primary School
Secondary School
Post-Secondary Education
1st year of Sixth Form
2nd year of Sixth Form
BTS
Supérieur
Bachelor
Masters
Diplomgrad
Doctorate
Other
GDL
Bar Professional Training Course
Qualified Lawyer Transfer Scheme
MBA
Kindergarten
Beginner
Intermediate
Advanced
Professionnel
Autres
Kids
- English
All languages in which the lesson is available :
English
II MICROSOFT EXCEL IN BENGALI , HINDI , ENGLISH & GOOGLE SHEET II
Q. What learners will learn in Basic to Advanced MS Excel & GOOGLE SHEET:
A.Basic Level:
1.Introduction to Excel (Workbooks, Worksheets, Rows, and Columns)
2.Data Entry & Basic Formatting
3.Basic Functions
4.Cell Referencing
5.Basic Data Sorting & Filtering
6.Basic Charts & Graphs
B.Intermediate Level:
1.Intermediate Functions(VLOOKUP&HLOOKUP)
2.Conditional Formatting
3.Data Validation
4.Working with Dates and Time
C. Advanced Level:
1.Advanced Functions
2.Pivot Tables & Pivot Charts
3.Power Query
4.Power Pivot
5.Dynamic Arrays & New Excel Functions
6.Macros and VBA (Visual Basic for Applications)
7.Advanced Charting Techniques
8.Advanced Data Analysis Tools
9.Collaboration Features
D. Project Work (Practical Application):
1.Creating a Business Dashboard:
Combining Pivot Tables, charts, and data analysis to create a comprehensive business performance dashboard.Using dynamic charts and slicers for interactive data analysis.
2.Budgeting & Financial Modelling:
Designing a financial model to forecast revenue, expenses, and profits over time.Using advanced Excel functions and charts to represent business financial health.
3.Inventory Management System :
Building an inventory system with Excel to track product stock, sales, and reordering needs.Using Excel’s database functions to manage and analyze inventory data.
4.Sales and Marketing Analysis :
Creating a sales report system with dynamic charts and pivot tables.Using conditional formatting to highlight top-performing sales representatives.
5. Other Project :
GST calculator
Personal Finance Tracker
Sales Report Dashboard
Employee Attendance Tracker
Project Management Timeline
Inventory Management System
Student Gradebook
Customer Database
Budget Planner
Expense Reimbursement Tracker
Data Cleaning and Analysis Project
Task and To-Do List Tracker
Survey Data Analysis
Employee Payroll System and more....
***************************************************************
II MICROSOFT POWERPOINT IN BENGALI , HINDI , ENGLISH & GOOGLE SLIDE II
Q. What learners will learn in Basic to Advanced MS PowerPoint & Google Slide :
A.Basic Level:
1.Introduction to PowerPoint (interface: Ribbon, Slide Pane, and Notes section)
2.Creating and Formatting Slides(slide layouts,text formatting)
3.Inserting and Formatting Objects
4.Using SmartArt and Icons
5.Working with Slide Transitions
6.Basic Animation Effects
7.Working with Backgrounds
8.Inserting Links and Multimedia
B .Intermediate Level:
1.Working with Themes and Templates
2.Inserting Charts and Graphs
3.Using Tables for Data Presentation
4.Advanced Text Formatting
5.Slide Master and Layouts
6.Using Comments and Notes
7.Using and Managing Multiple Slides
8.Inserting Diagrams and Flowcharts
C. Advanced Level:
1.Advanced Animations and Transitions
2.Interactive Presentations
3.Working with Audio and Video
4.Collaboration and Sharing
5.Using PowerPoint's Recording Tools
6.Customizing the Ribbon and Quick Access Toolbar
7.Creating a Professional Portfolio or Presentation
8. Advanced Data Visualization
9. Final Touches and Publishing
D .Project Work (Practical Application):
1.Creating a Business Presentation:
Building a corporate pitch or business strategy presentation using various PowerPoint features.
Utilizing charts, SmartArt, and custom designs to represent business ideas effectively.
2.Educational Presentation
Designing educational content with step-by-step instructions, visuals, and multimedia elements.
Creating interactive lessons and quizzes.
3.Marketing Campaign Presentation:
Creating a marketing plan presentation with visual graphics, timelines, and charts to present marketing data.
Building a product or service launch presentation with compelling visuals.
4.Project or Research Presentation:
Preparing a research or project report using advanced features like embedded videos, links, and data charts.
***************************************************************
II MICROSOFT WORD IN BENGALI , HINDI , ENGLISH & GOOGLE SLIDE II
Q.What learners will learn in Basic to Advanced MS Word & Google Docs:
A.Basic Level:
1.Introduction to MS Word(ribbon, toolbar, document area)
2.Basic Document Formatting
3.Working with Text Styles
4.Page Setup and Layout
5.Inserting Objects
6.Spell Check and Grammar
7.Saving and Sharing Documents
B.Intermediate Level:
1.Advanced Text Formatting
2.Working with Tables
3.Using SmartArt and Graphics
4.Document Navigation and Organization
5.Using Styles and Themes
6.Columns and Layout
7.Track Changes and Comments
C.Advanced Level:
1.Advanced Document Formatting
2.Mail Merge
3.Tables of Contents, Index, and Footnotes
4.Document Protection and Security
5.Macros and Automation
6.Working with References and Citations
7.Advanced Graphics and Image Editing
8.Using Templates and Custom Styles
9.Document Finalization and Print Layout
10.Collaboration and Cloud Integration
D.Project Work (Practical Application):
1.Creating a Professional Report or Thesis :
Organizing research and creating a detailed report with a Table of Contents, references, and proper formatting.Using styles, footnotes, citations, and a bibliography to create a comprehensive report.
2.Designing a Newsletter :
Creating a visually appealing and well-organized newsletter with multiple columns, images, and text formatting.Using Word’s built-in templates and customizing them for your own needs.
3.Resume or CV Creation :
Using Word to design a professional and eye-catching resume or curriculum vitae.Customizing sections like Work Experience, Education, and Skills, and adding formatting for impact.
4.Business Letter and Proposal :
Writing professional business letters using the Mail Merge feature to personalize each letter for different recipients.
Creating a business proposal with professional formatting, tables, and charts.
***************************************************
II MICROSOFT OUTLOOK IN BENGALI , HINDI , ENGLISH II
Q. What learners will learn in Basic to Advanced MS Outlook:
A . Basic Level:
1. Introduction to MS Outlook ( Ribbon, Folders, Navigation Pane, Reading Pane)
2.Managing Emails
3.Basic Email Formatting
4.Email Organization and Management
5.Working with Contacts
6.Calendar Basics
7.Managing Junk Email
B. Intermediate Level:
1.Advanced Email Features
2.Managing Multiple Email Accounts
3.Using the Calendar Efficiently
4.Task Management
5.Collaboration Tools in Outlook
6.Setting Up and Using Notes
7.Advanced Search and Filters
C. Advanced Level:
1.Customizing Outlook
2.Email Encryption and Security
3.Integrating Outlook with Other Microsoft Apps
4.Managing Folders and Archiving
5.Delegating Access to Others
6.Using Outlook with Mobile Devices
7.Managing Email Delays and Scheduling
8.Automating Tasks with Quick Steps
9.Working with Public Folders and Shared Mailboxes
10.Business and Corporate Features
D.Project Work (Practical Application):
1.Creating a Team Calendar:
Setting up a shared team calendar for managing projects and deadlines.Scheduling team meetings and managing availability.
2.Managing Email Communication for a Business :
Setting up and organizing multiple email accounts for a company.Automating email sorting and filtering for better communication management.
3.Collaborating on Documents and Tasks :
Collaborating with colleagues on shared tasks, calendars, and documents.Using Outlook to manage a project, send updates, and track progress.
4.Configuring and Securing Outlook for a Business :
Setting up secure email communication with encryption and digital signatures.Managing privacy and security settings for corporate use.
***************************************************
II MICROSOFT ACCESS IN BENGALI , HINDI , ENGLISH II
Q. What learners will learn in Basic to Advanced MS ACCESS:
A. Basic Level:
1.Introduction to MS Access (Ribbon, Navigation Pane, Tables, Queries, Forms, and Reports)
2.Creating and Designing Tables
3.Understanding and Using Data Types
4.Creating Relationships between Tables
5.Entering and Editing Data
6.Sorting and Filtering Data
7.Using Simple Queries
8.Creating Forms for Data Entry
9.Creating Reports
B. Intermediate Level:
1.Advanced Table Design
2.Advanced Query Techniques
3.Using Forms for Enhanced Data Entry
4.Using Macros for Automation
5.Working with Multiple Tables
6.Creating and Using Calculated Fields
7.Creating Data Validation Rules
C. Advanced Level:
1.SQL in MS Access
2.Advanced Report Design
3.Database Normalization
4.Database Security and User Permissions
5.Creating Complex Forms
6.Working with External Data
7.Database Optimization and Performance
8.Advanced Macros and VBA
D.Project Work (Practical Application):
1.Building a Comprehensive Database :
Designing a fully functional database for a business or personal project.Creating multiple related tables, forms, queries, and reports.
Using VBA for complex logic and automation.
Securing the database and managing user permissions.
2. Inventory Management System :
Creating a complete inventory management system using Access.
Designing tables to track products, suppliers, sales, and stock levels.
Generating reports for inventory status, sales trends, and reorder alerts.
3.Sales and Customer Relationship Management (CRM) System :
Designing a database for managing customer data, sales records, and invoices. Creating queries and reports to track sales performance and customer interactions .Automating tasks like sending order confirmations or reminders.
***************************************************************
See more
Rates
Rate
- 1€
Pack rates
- 5 h: 5€
- 10 h: 10€
online
- 1€/h
free lessons
This first lesson offered with Ranit Kr will allow you to get to know each other and clearly specify your needs for your next lessons.
- 1hr
Other tutors in Microsoft Excel
Mourad
Paris 12e, France & online
- 37€/h
- 1st lesson free
Billy
Bullhead City, United States & online
- 43€/h
- 1st lesson free
Erica
Fairfield, Australia & online
- 34€/h
Ireneusz
Gdańsk, Poland & online
- 18€/h
- 1st lesson free
Lindsay
Boston, United States & online
- 85€/h
- 1st lesson free
Adi
Toronto, Canada & online
- 31€/h
- 1st lesson free
Arbaz
New York, United States & online
- 38€/h
- 1st lesson free
Ben
Southampton, United Kingdom & online
- 52€/h
- 1st lesson free
Ilian
Paris 8e, France & online
- 25€/h
- 1st lesson free
Marc
New York, United States & online
- 107€/h
David
London, United Kingdom & online
- 32€/h
- 1st lesson free
Inès
Paris 1er, France & online
- 45€/h
Ghada Maged Ali
Toronto, Canada & online
- 28€/h
Patricia
Madrid, Spain & online
- 20€/h
Cassandre
Lehigh Acres, United States & online
- 50€/h
Gabriel
, Brazil & online
- 18€/h
- 1st lesson free
Leonardo
Lapa de Baixo, Brazil & online
- 16€/h
- 1st lesson free
Doğukan
Küçükçekmece, Turkey & online
- 12€/h
Moreno
Monza, Italy & online
- 50€/h
- 1st lesson free
Nathalie
Paris 16e, France & online
- 40€/h
-
More Microsoft Excel tutors
