Aderajew
- Rate RM58
- Response 1h
RM58/h
See Microsoft Excel tutors
This tutor is currently unavailable
- Microsoft Excel
- Microsoft Word
- Microsoft PowerPoint
- Prezi
All contemporary decisions in life are data-driven. Microsoft Excel is one of the tools to deal with data. being conversant with Excel is not a luxury but a necessity.
- Microsoft Excel
- Microsoft Word
- Microsoft PowerPoint
- Prezi
Lesson location
About Aderajew
I will ensure that participants will add value to their skills and that their investment ( time, money, or both) pays off.
I am committed to ensuring that participants derive substantial value from the program, enhancing their skills significantly. I aim to guarantee that their investment, whether in terms of time, money, or both, yields a meaningful and rewarding return.
See more
About the lesson
- Primary
- Secondary
- SPM
- +7
levels :
Primary
Secondary
SPM
Adult education
Masters
Beginner
Intermediate
Advanced
Professional
Kids
- English
All languages in which the lesson is available :
English
I have a passion for managing data, particularly with Microsoft Excel. I have been practicing it for over 10 years.
The teaching m can be either in-person, virtual, or hybrid.
The course would cover:
1. Introduction
1.1 Overview of Microsoft Excel
1.2 Importance of Excel in Business and Personal Use
1.3 Getting Started with Excel
2. Excel Basics
2.1 Excel Interface Overview
2.2 Navigating Worksheets and Workbooks
2.3 Understanding Cells, Rows, and Columns
2.4 Data Entry and Editing Basics
3. Formatting in Excel
3.1 Cell Formatting (Font, Color, Borders)
3.2 Number and Date Formatting
3.3 Conditional Formatting
3.4 AutoFill and Flash Fill
4. Basic Formulas and Functions
4.1 Introduction to Formulas
4.2 Common Mathematical Operators
4.3 Sum, Average, Min, and Max Functions
4.4 Using AutoSum
4.5 Absolute and Relative Cell References
5. Managing Worksheets and Workbooks
5.1 Creating and Saving Workbooks
5.2 Renaming, Moving, and Copying Worksheets
5.3 Grouping and Ungrouping Worksheets
5.4 Linking Data Between Worksheets
6. Data Sorting and Filtering
6.1 Sorting Data
6.2 Filtering Data
6.3 Advanced Filtering Techniques
7. Charts and Graphs
7.1 Creating Basic Charts (Bar, Line, Pie)
7.2 Customizing Charts
7.3 Adding Data Labels and Legends
7.4 Using Sparklines
8. Data Validation and Protection
8.1 Setting Data Validation Rules
8.2 Protecting Worksheets and Workbooks
8.3 Password Protection
8.4 Tracking Changes
9. Introduction to PivotTables
9.1 Creating PivotTables
9.2 Modifying and Updating PivotTables
9.3 Using Slicers with PivotTables
10. Advanced Tips and Tricks
10.1 Keyboard Shortcuts
10.2 Using Templates
10.3 Excel Tips for Efficiency
10.4 Troubleshooting Common Issues
11. Conclusion
11.1 Recap of Key Concepts
11.2 Next Steps in Excel Mastery
See more
Rates
Rate
- RM58
Pack rates
- 5h: RM290
- 10h: RM580
online
- RM58/h
Similar Microsoft Excel tutors in Toronto
Asil
Petaling Jaya & online
- RM80/h
Fakir Tajul
Seri Kembangan & online
- RM60/h
- 1st lesson belanja
Carlos
Petaling Jaya & online
- RM80/h
- 1st lesson belanja
Tan
Puchong & online
- RM80/h
- 1st lesson belanja
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
