Learn Ms Excel From Scratch | An Ultimate Course In English

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

Requirements

You need a computer with internet connections at your end

You need to have MS Office installed on your PC or Laptop any version preferably MS Office 2019 or latest.

No prior knowledge of MS Excel is needed even an absolute beginner can learn it

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 ExcelBasics of MS ExcelUse of Arithmetic Operator in MS ExcelUse important Functions of MS ExcelWorking with Sumif and SumifsWorking with Count and CountifsWorking with average, averageif & averageifsWorking with PMT and NPER Functions in MS ExcelWorking with Decision Making IF and IFS FunctionsWorking with Lookup Functions Working with Pivot table and all its options Working with Data Entry Forms in MS ExcelUsing Conditional Formatting and General Formatting in MS ExcelWorking with Drawing & Picture Tools in MS ExcelProtection and Password Options in ExcelWorking with Sort and Filters in MS ExcelWorking with borders and Formatting Finalizing sheets for office Page setup and Print Preview Creating Working sheets in ExcelWorking between sheets to sheets in excelAbout 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. 

Overview

Section 1: Introductions and basic Functions in MS Excel

Lecture 1 Introduction and overview of course

Lecture 2 Getting Started with MS Excel and Basic Operators

Lecture 3 Basic Functions and Operators in Excel

Lecture 4 Using Functions into assignment or Task

Section 2: More about Excel function and formattings

Lecture 5 Important Functions for Excel sheets

Lecture 6 PMT and NPER Functions in Excel

Lecture 7 Creating a Students Marks Sheet AND Other sheets

Lecture 8 Basic Formattings in MS Excel

Section 3: Advanced Functions of Excel

Lecture 9 Sumif Function in Excel

Lecture 10 Sumifs and Averageifs Functions in Excel

Lecture 11 if and ifs Functions in MS Excel

Lecture 12 Count, Countif and Countifs Functions in Excel

Lecture 13 Creating an Attendance Sheet in Excel

Section 4: Important and effective Options in MS Excel

Lecture 14 Page setup and Print Preview in MS Excel

Lecture 15 Conditional Formatting and other Formatting

Lecture 16 Filter and sorting Data in MS Excel

Lecture 17 Working with Drawings, Pictures or chart in Excel

Section 5: Working with Advanced Functions of MS Excel

Lecture 18 Use of and Or Functions in Excel

Lecture 19 Use of if(and if(or in MS Excel

Lecture 20 Use of Lookup Function and payment sheet in Excel

Section 6: Super Advanced Functions of MS Excel

Lecture 21 Protect sheet, workbook and password

Lecture 22 Pivot Table in MS Excel

Lecture 23 Creating Data Entry Form in MS Excel

Lecture 24 Calculations through Sheets and Final Words

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