1st lesson belanja
Samuel's profile, qualifications and contact details have been verified by our experts
Samuel
- Rate RM43
- Response 1h
-
Students1
Number of students accompanied by Samuel since their arrival at Superprof
Number of students accompanied by Samuel since their arrival at Superprof
RM43/h
Contact
1st lesson belanja
- Microsoft Excel
Graduate of Computer Science. IBM Certified Data Analyst with advanced knowledge of Microsoft Excel, Python and SQL.
- Microsoft Excel
Lesson location
About Samuel
I am an jovial and interesting young tutor with passion for teaching. I love sharing knowledge using the most fun-filled methods, , thereby mixing knowledge with fun.From experience, my students love interacting with me and such a comfortable environment makes learning effective.
I look forward to sharing my best knowledge to you andmaking you an expert in using Microsoft Excel for needed tasks.
See more
About the lesson
- Primary
- Secondary
- SPM
- +11
levels :
Primary
Secondary
SPM
Form 6
Adult education
Bachelor
Masters
Diploma
Doctorate
Beginner
Intermediate
Advanced
Professional
Kids
- English
All languages in which the lesson is available :
English
My teaching is project based.
I take each lesson, by leading my students on little projects,demonstrating the tools for that lesson. At the end ofAl the lessons, multiple projectswould have been completed.
Age range is 8 -45 years old.
SYLLABUS:
Section 1:
1. Launching Excel
2. Microsoft Excel Startup Screen
3. Introduction to the Excel Interface
4. Customizing the Excel Quick Access Toolbar
5. More on the Excel Interface
6. Understanding the Structure of an Excel Workbook
7. Saving an Excel Document
8. Opening an Existing Excel Document
9. Common Excel Shortcut Keys
10. Excel Fundamentals
Section 2
1. Entering Text to Create Spreadsheet Titles
2. Working with Numeric Data in Excel
4. Entering Date Values in Excel
5. Working with Cell References
6. Creating Basic Formulas in Excel
7. Relative Versus Absolute Cell References in Formulas
8. Understanding the Order of Operation
9. Entering and Editing Text and Formulas
10. Quiz
Section 3: Functions
1. Working with the SUM() Function
2. Working with the MIN() and MAX() Functions
3. Working with the AVERAGE() Function
4. Working with the COUNT() Function
5. Adjacent Cells Error in Excel Calculations
6. Using the AutoSum Command
7. Excel's AutoSum Shortcut Key
8. Using the AutoFill Command to Copy Formulas
9. Basic Excel Functions Quiz
Section 4:
1. Moving and Copying Data in an Excel Worksheet
2. Inserting and Deleting Rows and Columns
3. Changing the Width and Height of Cells
4. Hiding and Unhiding Excel Rows and Columns
5. Renaming an Excel Worksheet
6. Deleting an Excel Worksheet
7. Moving and Copying an Excel Worksheet
8. Modifying Worksheets Quiz
Section 5:
1. Moving and Copying Data in an Excel Worksheet
2. Inserting and Deleting Rows and Columns
3. Changing the Width and Height of Cells
4. Hiding and Unhiding Excel Rows and Columns
5. Renaming an Excel Worksheet
6. Deleting an Excel Worksheet
7. Moving and Copying an Excel Worksheet
8. Modifying Worksheets Quiz
Section 6
1. Creating an Excel Column Chart
2. Working with the Excel Chart Ribbon
3. Adding and Modifying Data on an Excel Chart
4. Formatting an Excel Chart
5. Moving a Chart to another Worksheet
6. Working with Excel Pie Charts
7. Working with Excel Charts Quiz
Section 7: Data Analytics
1. Formulas
2. XLookup
3. Data Cleaning for Analysis
3. Creating a Dashboard
See more
Rates
Rate
- RM43
Pack rates
- 5h: RM215
- 10h: RM430
online
- RM43/h
free lessons
This first lesson is free to allow you to get to know your teacher so that they can best meet your needs.
- 1hr
Similar Microsoft Excel tutors in Newcastle
Asil
Petaling Jaya & online
- RM80/h
Carlos
Petaling Jaya & online
- RM80/h
- 1st lesson belanja
Tan
Puchong & online
- RM80/h
- 1st lesson belanja
Fakir Tajul
Seri Kembangan & online
- RM60/h
Wani
Bayan Lepas & online
- RM40/h
- 1st lesson belanja
Ziad
Subang Jaya & online
- RM49/h
- 1st lesson belanja
Mohd
George Town & online
- RM45/h
- 1st lesson belanja
Akmal
Johor Bahru & online
- RM80/h
- 1st lesson belanja
Mohd
Shah Alam & online
- RM150/h
Hareth
Ampang
- RM70/h
- 1st lesson belanja
Arfan
Kuala Lumpur & online
- RM75/h
- 1st lesson belanja
Tan
Bayan Lepas & online
- RM70/h
- 1st lesson belanja
Nian Hee
Sibu & online
- RM85/h
- 1st lesson belanja
Rebecca
Ipoh & online
- RM50/h
- 1st lesson belanja
Yanice
Kuala Lumpur & online
- RM40/h
- 1st lesson belanja
Afzal
Kota Samarahan & online
- RM80/h
- 1st lesson belanja
Abhimanyu
Petaling Jaya & online
- RM40/h
- 1st lesson belanja
Suzy Louise
Jenjarom & online
- RM35/h
- 1st lesson belanja
Jason
Subang Jaya & online
- RM90/h
- 1st lesson belanja
Lyon
Subang Jaya & online
- RM100/h
- 1st lesson belanja
-
See Microsoft Excel tutors
