Learn MS Excel From Scratch | An Ultimate Course in English

Focused View

Ghulam Rasool

3:01:45

92 View

1. Introductions and basic Functions in MS Excel

1. Introduction and overview of course.mp4

07:41

2. Getting Started with MS Excel and Basic Operators.mp4

09:59

3.1 Excel Shortcut List.pdf

3. Basic Functions and Operators in Excel.mp4

14:27

4.1 Excel Training Book.pdf

4.2 marksheet1.xlsx

4. Using Functions into assignment or Task.mp4

07:50

2. More about Excel function and formattings

1. Important Functions for Excel sheets.mp4

11:31

2. PMT and NPER Functions in Excel.mp4

05:01

3. Creating a Students Marks Sheet AND Other sheets.mp4

06:54

4. Basic Formattings in MS Excel.mp4

03:45

3. Advanced Functions of Excel

1. Sumif Function in Excel.mp4

06:02

2. Sumifs and Averageifs Functions in Excel.mp4

11:49

3. if and ifs Functions in MS Excel.mp4

12:41

4. Count, Countif and Countifs Functions in Excel.mp4

04:05

5.1 attendance sheet.xlsx

5. Creating an Attendance Sheet in Excel.mp4

05:03

4. Important and effective Options in MS Excel

1. Page setup and Print Preview in MS Excel.mp4

06:31

2. Conditional Formatting and other Formatting.mp4

02:55

3. Filter and sorting Data in MS Excel.mp4

03:45

4. Working with Drawings, Pictures or chart in Excel.mp4

05:24

5. Working with Advanced Functions of MS Excel

1.1 and or.xlsx

1. Use of and Or Functions in Excel.mp4

03:31

2. Use of if(and if(or in MS Excel.mp4

06:06

3. Use of Lookup Function and payment sheet in Excel.mp4

08:13

6. Super Advanced Functions of MS Excel

1. Protect sheet, workbook and password.mp4

03:20

2.1 DASHBOARD.xlsx

2. Pivot Table in MS Excel.mp4

18:18

3. Creating Data Entry Form in MS Excel.mp4

09:05

4. Calculations through Sheets and Final Words.mp4

07:49

Description

An Ultimate Course of MS Excel - Learn Everything About MS Excel From Basic to Advanced Level in English

What You'll Learn?

Overview & Introduction & Basics of MS Excel
Use of Basic Arithmetic Operators in MS Excel office sheets
Creating Pivot Table with all Optoins in MS Excel
Working with Conditional Formatting and General Formatting in Excel
Working with Drawing tools & pictures in Excel
Working with Sorting and Filtering in MS Excel
Use of Important Functions in MS Excel
Use of decision making Functions in MS Excel
Finalizing Excel Sheets and Page setup with Print Preview Options in MS Excel
Use of If(and / If(Or Options in MS Excel
Working with Countif /Countifs / Sumif /Sumifs /Average & Averageif Functions in Excel
Creating Data Entry Forms in MS Excel
Working for Protections and Password Options in MS Excel
Working with Excel Tables and Other formatting Options

Who is this for?

students who want to learn MS excel from basic to advanced level

Existing users of excel who want to enhance their MS excel knowledge

Accounting and finance students who want to use MS Excel for their educational task.

anybody who is handling accounting or finance at their office or business.

executives or entrepreneurs who want learn excel for their office working

anybody who are working in banks or financial institutions

More details

Description
About This Course:-
This is a special MS Excel Course in English which will cover all about excel from basic to super advanced level. The most important Feature of this course is that it is to the point Explanation mean you will get all which you can expect from an MSÂ Excel Course. Above all this is a step by step explained course which will take you from zero knowledge to advanced level regarding MS Excel Expertise. This is very special course for those who want to learn basic to advanced use of MS Excel.

Special Offer:-
Students will get a Special Training book regarding MS Excel in which you will get everything Chapter wise step by step, you will also get assignments and Projects in that book. This is a special book designs for our MS Excel Studetns.

You will get Following Couse Content:-

Overview and Introduction of MS Excel
Basics of MS Excel
Use of Arithmetic Operator in MS Excel
Use important Functions of MS Excel
Working with Sumif and Sumifs
Working with Count and Countifs
Working with average, averageif & averageifs
Working with PMT and NPER Functions in MS Excel
Working with Decision Making IF and IFS Functions
Working with Lookup Functions
Working with Pivot table and all its options
Working with Data Entry Forms in MS Excel
Using Conditional Formatting and General Formatting in MS Excel
Working with Drawing & Picture Tools in MS Excel
Protection and Password Options in Excel
Working with Sort and Filters in MS Excel
Working with borders and Formatting
Finalizing sheets for office
Page setup and Print Preview
Creating Working sheets in Excel
Working between sheets to sheets in excel
About Your Course Instructor:

Hello Students I am Prof. G. Rasool and I have been teaching these subjects for 20 years now, I have taught thousands of students around the world and local in my countries, We know how to handle these subjects.Â In this course I also take care of distance factor, so did our best to create this professional course in such a way that it will always be a sail through for a student who will be willing to learn it.Â

Who this course is for:
students who want to learn MS excel from basic to advanced level
Existing users of excel who want to enhance their MS excel knowledge
Accounting and finance students who want to use MS Excel for their educational task.
anybody who is handling accounting or finance at their office or business.
executives or entrepreneurs who want learn excel for their office working
anybody who are working in banks or financial institutions

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Ghulam Rasool

Instructor's Courses

Prof. Ghulam RasoolETFD, BCS, MCS, M.A. (Econ.)MPhil Computer ScienceAreas of Expertise:· Embroidery Digitizing· Embroidery Designing· Graphics Designing· Autodesk Suite· Multimedia Suite· Web Designing· Software Development· Affiliate Marketing· Web Development· Ethical Hacking· MS Office SuiteOver 15 years of experience in teaching; currently working with Allied College of Information Technology, IT-Hub College of Advanced Technologies Lahore.Have served in leading Institution across Pakistan, Where taught market oriented courses with zeal.Proficient in planning and developing appropriate teaching programs to optimize learning process effectively addressing student needs.Skilled in integrating relevant technology to support classroom instruction and learning activities.Hands-on experience in developing curriculum to accommodate different learning styles and maximizing students’ comprehension.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.