Cynthia's profile, qualifications and contact details have been verified by our experts
Cynthia
- Rate RM98
- Response 2h
-
Students15
Number of students accompanied by Cynthia since their arrival at Superprof
Number of students accompanied by Cynthia since their arrival at Superprof
RM98/h
See Microsoft Excel tutors
This tutor is currently unavailable
- Microsoft Excel
EXCEL TUTOR COACH - 20+ years teaching Excel - expertise in Functions, PivotTables and Reports, Financial Analysis tools
- Microsoft Excel
Lesson location
About Cynthia
I am a Senior Financial Analyst and have used MS Office for 24 years. I taught Microsoft Excel and done numerous contract trainings and consultations on special projects utilizing Excel for business. I provide detailed lessons and guidance in Beginning Excel, Formulas and Functions, PivotTables and Data Analysis.
In sessions with me, you can learn the basics, special features, tips and tricks and the advanced features of Excel. I provide skill practice and skill demonstration exercises at the end of each lesson level.
My teaching is tailored to your level, speed and what you want and need to know so that you can be successful using these applications for your specific needs.
I have tutored and taught from 16 to 80 years-old online and in person, one-on-one, and in group settings.
I have taught Microsoft Excel for the past 20 years.
MY FOCUS:
--YOU! You will be empowered and succeed with each lesson.
-- I will help you feel successful and empowered to master new tools and concepts you may find challenging.
-- With caring, humor and attention, help you achieve your goals, regardless of your experience level
MY EXPERTISE:
-- I'm patient, articulate, and able to effectively explain complex subjects to a wide variety of user levels.
-- I create effective learning materials to accompany my trainings, breaking complicated concepts into simple, easy-to-follow steps
-- I consistently receive high ratings for my teaching as well as for the learning materials created for my students.
MY EXPERIENCE:
-- I have extensive experience in teaching, training, coaching (both individuals and groups) in both educational and business settings. I have professional experience in business settings in computer instruction, training needs assessment, training consulting, and training materials development.
-- Since 1999, I've tutored individuals and taught small businesses, and corporate employees in Microsoft Excel.
See more
About the lesson
- Primary
- Secondary
- SPM
- +10
levels :
Primary
Secondary
SPM
Form 6
STPM
Adult education
Masters
Doctorate
Beginner
Intermediate
Advanced
Professional
Kids
- English
All languages in which the lesson is available :
English
Prepare workbooks for collaboration
• restrict editing
• protect worksheets and cell ranges
• protect workbook structure
• configure formula calculation options
• manage comments
Use and configure language options
• configure editing and display languages
• use language-specific features
Manage and format data
Fill cells based on existing data
• fill cells by using Flash Fill
• fill cells by using advanced Fill Series options
Format and validate data
• create custom number formats
• configure data validation
• group and ungroup data
• calculate data by inserting subtotals and totals
• remove duplicate records
Apply advanced conditional formatting and filtering
• create custom conditional formatting rules
• create conditional formatting rules that use formulas
• manage conditional formatting rules
Create advanced formulas
Perform logical operations in formulas
• perform logical operations by using nested functions including the IF(), IFS(), SWITCH(), SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(),
MINIFS(), AND(), OR(), and NOT() functions
Look up data by using functions
• look up data by using the VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() functions
Use advanced date and time functions
• reference date and time by using the NOW() and TODAY() functions
• calculate dates by using the WEEKDAY() and WORKDAY() functions
Perform data analysis
• summarize data from multiple ranges by using the Consolidate feature
• perform what-if analysis by using Goal Seek and Scenario Manager
• forecast data by using the AND(), IF(), and NPER() functions
• calculate financial data by using the PMT() function
Troubleshoot formulas
• trace precedence and dependence
• monitor cells and formulas by using the Watch Window
• validate formulas by using error checking rules
• evaluate formulas
Create and modify simple macros
• record simple macros
• name simple macros
• edit simple macros
Create and modify PivotTables
• create PivotTables
• modify field selections and options
• create slicers
• group PivotTable data
• add calculated fields
• format data
See more
Rates
Rate
- RM98
Pack rates
- 5h: RM490
- 10h: RM980
online
- RM98/h
Similar Microsoft Excel tutors in Los Angeles
Asil
Petaling Jaya & online
- RM80/h
Carlos
Petaling Jaya & online
- RM60/h
- 1st lesson belanja
Tan
Puchong & online
- RM80/h
- 1st lesson belanja
Fakir Tajul
Seri Kembangan & online
- RM60/h
Ziad
Subang Jaya & online
- RM49/h
- 1st lesson belanja
Mohd
George Town & online
- RM45/h
- 1st lesson belanja
Wani
Bayan Lepas & online
- RM40/h
- 1st lesson belanja
Akmal
Johor Bahru & online
- RM80/h
- 1st lesson belanja
Mohd
Shah Alam & online
- RM150/h
Suzy Louise
Jenjarom & online
- RM35/h
- 1st lesson belanja
Tan
Bayan Lepas & online
- RM70/h
- 1st lesson belanja
Arfan
Kuala Lumpur & online
- RM120/h
- 1st lesson belanja
Rebecca
Ipoh & online
- RM50/h
- 1st lesson belanja
Yanice
Kuala Lumpur & online
- RM40/h
- 1st lesson belanja
Abhimanyu
Petaling Jaya & online
- RM40/h
- 1st lesson belanja
Zul
Puncak Alam & online
- RM35/h
- 1st lesson belanja
Jason
Subang Jaya & online
- RM90/h
- 1st lesson belanja
Lyon
Subang Jaya & online
- RM100/h
- 1st lesson belanja
Iqra
Klang & online
- RM80/h
- 1st lesson belanja
SHARMILA
Simpang Ampat & online
- RM80/h
- 1st lesson belanja
-
See Microsoft Excel tutors
