This tutor is banned because of:
Duplicate Profile.

Fawad Sarim Microsoft Excel Teaching
No reviews yet

INTRODUCTION:
My name is Muhammad Fawad Ul Hassan Sarim and I am here to provide you all a substantial and enormous opportunity to assimilate Essentials of Microsoft Excel. We all do know that It plays a curtail character not only in professional fields but also in our daily lives. Now I am here to construct your strong foundation of this spreadsheet software. This software has remained the most ubiquitous piece of software used in workplaces all over the world. After learning this you will be capable to confidently work with large amounts of data and create various graphs, patterns, and trends to leverage your decisions. I will help you to acknowledge Excel language by performing Calculations through various formulae and functions. You will learn Excel tools to work with tangled data and Creating Elegant spreadsheets. We will end up learning printing tools and techniques.

PREREQUISITES:
To complete this course successfully, you do not need to have any prior knowledge of Excel. The best way to learn Excel is to use Excel. In order to work alongside me and to complete the assessments in this course, you will need to have access to a computer and to the software Excel (at least version 2007 but preferably 2013 or 2016).

COURSE DETAILS:

1) Course duration = 12 Weeks
2) Average Study Hours per week = 2 hours
3) Weekly Trouble Shooting Sessions = 2 (Skype or Zoom etc)
4) Weekly Practice Challenges = 1
5) Weekly Final Exam = 1

COURSE STUDY METHOD:

>> Recorded Lectures/Practice Videos will be provided to you every week
>> Troubleshooting sessions on Skype or Zoom etc
>> In online sessions side by side practice
>> After every week you will have weekly practice challenge
>> Week will end with a Final Exam
>> Weekly Exam's Passing Marks = 70%

COURSE SYLLABUS:
We will be covering the essential level of Microsoft Excel. I am giving you an overview of the topics we will be covering in the course.

1) Taking Charge of Excel
2) Performing Calculations
3) Formatting Spreadsheets
4) Working with Data
5) Printing Spreadsheets
6) Creating Charts and Graphs
7) Working with Multiple Worksheets and Workbooks
8) Text and Date Functions
9) Name Ranges
10) Summarising Data
11) Tables
12) Pivot Tables, Charts, and Slicers
13) Data Validation
14) Conditional Logics
15) Automating Lookups
16) Formula Auditing and Protection
17) Data Modelling
18) Recording Macros
19) Spreadsheet Design and documentation
20) Advanced Formula Techniques
21) Data Cleaning and Preparation
22) Important Financial Functions
23) Working with dates
24) Excel Database functions
25) Important Statistical Functions
26) Advanced Lookup Functions
Always remember that “ when you are optimistic; there is always an opportunity”.

Thank you

Regards:
Fawad Sarim

Subjects

  • Microsoft Excel Beginner-Expert

  • Calculus 1, 2 Beginner-Expert

  • Excel Advanced Intermediate-Expert

  • Mathematics (Cambridge syllabus) Beginner-Expert

Experience

No experience mentioned.

Education

  • Excel Skills for Business (Aug, 2019–Jun, 2020) from Maquarie University
  • BS Electrical Engineering (Jul, 2019–now) from COMSATS Institute of Information Technology, Islamabad Campus.

Fee details

    Rs5,000–8,000/hour (US$17.99–28.78/hour)

    If you really need skills and are unable to pay fee dues, you can ask me for fee concession. I will surely reduce it. But you must have to show me your dedication and enthusiasm for learning. I will be teaching you just like your friends.

Reviews

No reviews yet. Be the first one to review this tutor.