Waheed Arshad Microsoft Excel Expert
No reviews yet

I am a Microsoft Excel and Microsoft Word expert with more than 20 years of teaching experience in different Computer Training Institutions. As an Excel expert, I'm also offering services on freelancing platforms like Fiverr, Upwork etc., and completed many projects successfully. I provide solutions for any problem in Microsoft Excel work like

1. Automation of Recurring Excel Tasks by Formulas, Macros, Pivot Tables.
2. Excel Data Scrubbing / Cleaning (Formatting, Sorting, Filtering, Merging, Splitting, Organizing, Duplicate Records Removal, etc.)
3. Data Analysis
4. Data Processing to extract useful information
5. Creation and Fixing of Any Excel Formula / Macro
6. Excel Pivot Table Reports and Graphs / Charts
7. Developing Microsoft Excel KPI Dashboards
8. Customized Forms for Fast Data Entry

I will teach you online via Whatsapp, Skype, Zoom, etc. You will find here:

Honesty
The Best Learning
No Ratta System
Practical Examples
Help in Assignments
Answers to your questions
Guaranteed Success in Exams
Practical Training of Computer Subjects
Advanced Level Projects of Computer Subjects

I have full command on my subjects. I teach students at their own mental level and in an easy way with practical examples. I teach computer subjects to students in a practical way and I can guide them to earn online if they are interested.

I am a highly enthusiastic and hard-working individual who believes in practical teaching.

I'm sure you will not regret it.

Thanks,

Waheed

Subjects

Word (Microsoft) Beginner-Expert
Excel Advanced Beginner-Intermediate

Experience

Computer Teacher (Jan, 2017–Present) at Hamza Computer Academy, Faisalabad

Teaching Microsoft Office (Microsoft Word, Microsoft Excel, Microsoft PowerPoint)
Computer Teacher (Mar, 2003–Dec, 2016) at Punjab Computer College

Teaching Microsoft Word and Microsoft Excel

Education

Master in Computer Sciences (Mar, 2001–Mar, 2003) from National Institute of Computer Sciences
Certificate in Computer Hardware (CIH) (Jan, 2000–Jun, 2000) from Sensum Computer College Faisalabad
Diploma in Computer Sciences (DCS) (Jan, 1996–Jan, 1997) from Punjab Board of Technical Education, Lahore, Pakistan

Fee details

Rs1,000–2,000/hour (US$3.60–7.21/hour)

Courses offered

Microsoft Excel Advanced Learning
- US$100
- Duration: 15 days (One Hour Daily)
- Delivery mode: Online
- Group size: 6 - 10
- Instruction language: English, Urdu
- Certificate provided: No
This course includes the learning of Microsoft Excel from Basic to Advance Level. It covers all the necessary topics as detailed below:

I. Introduction to Microsoft Excel

Overview of Excel interface and terminology
Entering data and basic navigation
Saving and opening workbooks

II. Basic Functions and Formulas

Understanding functions and formulas
Using arithmetic and basic functions (SUM, AVERAGE, MAX, MIN)
Creating and editing basic formulas
Using absolute and relative cell references

III. Formatting and Editing Worksheets

Formatting cells and ranges
Using conditional formatting
Editing and manipulating data in worksheets
Using data validation

IV. Working with Charts and Graphs

Creating and formatting charts and graphs
Selecting the right chart type
Modifying and customizing charts
Using sparklines and conditional formatting with charts

V. Data Analysis and Visualization

Sorting and filtering data
Using pivot tables and pivot charts
Working with advanced data analysis tools (e.g. goal seek, scenario manager)
Using Excel's data visualization tools (e.g. slicers, timelines)

VI. Macros and Automation

Understanding macros and VBA (Visual Basic for Applications)
Recording and running macros
Editing and debugging macros
Using automation techniques to streamline tasks

VII. Advanced Functions and Formulas

Using advanced functions (e.g. INDEX, MATCH, VLOOKUP, HLOOKUP)
Creating complex formulas (e.g. nested IF statements)
Using array formulas and functions

VIII. Collaboration and Sharing

Sharing and protecting workbooks
Using Excel with other Office applications (e.g. Word, PowerPoint)
Collaborating with others in real-time (e.g. co-authoring, sharing links)

IX. Advanced Data Analysis and Modeling

Using advanced data analysis tools (e.g. regression analysis, correlation analysis)
Creating custom data models with Power Pivot
Using Excel with external data sources (e.g. SQL databases, web data)