1st lesson free
The email address and phone number of Sanjana have been verified.
Sanjana
- Rate UGX 86,746
- Response 1h
-
Students8
Number of students Sanjana has accompanied since arriving at Superprof
Number of students Sanjana has accompanied since arriving at Superprof
UGX 86,746/hr
Contact
1st lesson free
- Microsoft Excel
Data Science Master's Student | Advanced Excel & Dashboard Automation Expert with 4+ Years of Professional Experience in 3 Multi-National Companies
- Microsoft Excel
Lesson location
About Sanjana
Hello! My name is Sanjana Krishnamurthy, and I’m currently pursuing my Master’s in Data Science. I have over four years of professional experience in data analysis, I've developed a deep understanding of Excel, especially in advanced functions like data visualization and automation. My background has not only equipped me with technical expertise but also with the skill to teach complex concepts in a way that’s easy to understand.
Throughout my career, I’ve trained new joiners in both job-specific tasks and Excel skills, and I've seen how a clear, simplified approach helps them quickly pick up essential skills. I enjoy breaking down concepts into manageable steps, making the learning process approachable and effective.
Teaching Excel isn’t just about sharing knowledge for me; it’s a way to reinforce my own learning as well. As a data science student, teaching allows me to stay refreshed on the fundamentals while building confidence and expertise in my students. I'm committed to creating an engaging, supportive learning environment where you feel confident and empowered to master Excel. Let’s dive in and make learning Excel both useful and enjoyable!
See more
About the lesson
- Primary
- Secondary
- Tertiary
- +10
levels :
Primary
Secondary
Tertiary
Adult Education
Masters
Diploma
PhD (Doctor of Philosophy)
MBA
Beginner
Intermediate
Advanced
Professional/Expert
Children
- English
All languages in which the lesson is available :
English
Here's a structured 2 month training program for Microsoft Excel, covering topics from beginner to advanced levels. This program can be adapted based on students' progress and comfort level with each topic:
Microsoft Excel Training Program Outline:
Beginner Level (Weeks 1-2)
1. **Introduction to Excel Basics**
- Navigating the Excel interface
- Understanding the ribbon, toolbar, and cells
- Basic data entry, formatting, and saving files
2. **Working with Basic Formulas and Functions**
- Using basic arithmetic formulas (SUM, AVERAGE, COUNT, MIN, MAX)
- Introduction to cell references (absolute vs. relative)
- Basic error handling in formulas
3. **Data Management and Formatting**
- Sorting, filtering, and basic data validation
- Formatting cells, rows, and columns
- Creating and using tables for organized data
4. **Introduction to Charts and Visualizations**
- Basic chart types (bar, line, pie charts)
- Formatting and customizing charts for readability
- Best practices for visual data representation
Intermediate Level (Weeks 3-4)
5. **Intermediate Functions and Formula Auditing**
- Logical functions (IF, AND, OR)
- Lookup functions (VLOOKUP, HLOOKUP, and XLOOKUP)
- Text functions (LEFT, RIGHT, MID, CONCATENATE, TRIM)
- Introduction to conditional formatting
6. **Data Analysis with PivotTables and PivotCharts**
- Creating and customizing PivotTables
- Grouping, filtering, and drilling down in PivotTables
- Using PivotCharts to visualize PivotTable data
7. **Data Cleaning Techniques**
- Removing duplicates and cleaning datasets
- Using Text-to-Columns and Flash Fill
- Working with date and time data
8. **Enhanced Charting and Visualization Techniques**
- Using combo charts and sparklines
- Customizing chart elements for dynamic visuals
- Introduction to dynamic charts with form controls
Advanced Level (Weeks 5-8)
9. **Advanced Formulas and Array Functions**
- Nested formulas for complex logic
- Advanced lookup functions (INDEX and MATCH)
- Introduction to dynamic arrays and functions (UNIQUE, SORT, FILTER)
10. **Advanced Data Analysis with Power Query**
- Introduction to Power Query and data import
- Data transformation and cleaning in Power Query
- Merging and appending data from different sources
11. **Dashboard Design and Automation**
- Dashboard layout and design principles
- Using form controls (drop-downs, sliders) for interactivity
- Creating automated, dynamic dashboards with PivotTables, charts, and slicers
12. **Introduction to Macros and VBA for Excel Automation**
- Recording and running macros
- Editing macro code for basic automation
- Introduction to VBA editor and basic VBA commands
Additional Training Details
- **Typical Lesson Length**: 1-2 hours per session, with time for hands-on practice and Q&A.
- **Methodology**: Each lesson combines theory with real-life examples and practice exercises. Sessions are interactive, allowing students to apply concepts immediately and receive feedback.
- **Who This Course is For**: Designed for students, professionals, and individuals (age 16+) looking to gain practical Excel skills, from beginners to those aiming to master advanced data analysis and automation in Excel.
This training plan provides a well-rounded progression through essential Excel skills, preparing students to handle real-world data management, reporting, and automation tasks.
See more
Review
All of our reviews are collected by us and are 100% reliable. They correspond to a real experience lived by the students of Sanjana.
1 review
Perfect! Very professional, amicable and knowledgeable.
A pleasure to work with.View more reviews
See more
Rates
Rate
- UGX 86,746
Pack prices
- 5h: UGX 433,730
- 10h: UGX 867,460
Travel
- + UGX 20
free lessons
The first free lesson with Sanjana will allow you to get to know each other and clearly specify your needs for your next lessons.
- 1hr
online
- UGX 71,438/hr
Similar Microsoft Excel teachers in Woking
Mourad
Paris 12e, France & Online
- UGX 166,257/hr
- 1st lesson free
Billy
Bullhead City, United States & Online
- UGX 188,738/hr
- 1st lesson free
Erica
Fairfield, Australia & Online
- UGX 161,842/hr
Ireneusz
Gdańsk, Poland & Online
- UGX 80,765/hr
- 1st lesson free
Zammad
New York, United States & Online
- UGX 188,738/hr
- 1st lesson free
Arbaz
New York, United States & Online
- UGX 150,990/hr
- 1st lesson free
Matthieu
Tigery, France & Online
- UGX 131,255/hr
- 1st lesson free
Adi
Toronto, Canada & Online
- UGX 135,817/hr
- 1st lesson free
Moreno
Monza, Italy & Online
- UGX 218,759/hr
- 1st lesson free
Ben
Bristol, United Kingdom & Online
- UGX 229,544/hr
- 1st lesson free
Ilian
Paris 8e, France & Online
- UGX 109,379/hr
- 1st lesson free
Patricia
Madrid, Spain & Online
- UGX 109,379/hr
Marc
New York, United States & Online
- UGX 471,844/hr
Inès
Paris 1er, France & Online
- UGX 196,883/hr
Doğukan
Küçükçekmece, Turkey & Online
- UGX 78,170/hr
Matthew
London, United Kingdom & Online
- UGX 198,938/hr
- 1st lesson free
Cassandre
Lehigh Acres, United States & Online
- UGX 222,710/hr
Massimiliano
Ancona, Italy & Online
- UGX 131,255/hr
- 1st lesson free
Gabriel
São Paulo, Brazil & Online
- UGX 85,688/hr
- 1st lesson free
Leonardo
Itaim Bibi, Brazil & Online
- UGX 65,914/hr
- 1st lesson free
-
See Microsoft Excel tutors
