MS Excel Beginners to Advanced Level Complete Course (Hindi)

*#1 Most Popular Online Course in Computer Science* You can enroll today & get certified from EasyShiksha & HawksCode

MS Excel Beginners to Advanced Level Complete Course (Hindi) Description

Our MS Excel course is designed under the expert knowledge of CA Santosh Apraj, with the use of the latest Office 365 and updated MS Excel software program on windows. In this course you will acquire the complete knowledge about Excel Fundamentals and all the necessary formulae and functions. We have included many tricks and shortcuts that will help you to easily use Excel and save your time while dealing with huge data and bring efficiency in your day-to-day tasks.

हमने विशेष रूप से काम करने वाले पेशेवरों, Job aspirants और छात्रों को ध्यान में रखते हुए हमारे Course को डिज़ाइन किया है, ताकि यह Course प्रत्येक और हर एक के लिए beneficial हो सके।

Our course is specially designed with ease of explanation and putting down difficult formulae with easy explanation and how helpful it will be in your daily life. We have also included some questions & answers after each section so that you can test your knowledge and skills.

This course will teach you thoroughly on how to use and apply the important tools & shortcuts in Excel and how to apply various functions that can help save your time.

So what are you waiting for?

Enroll now and enjoy this complete course on Excel.

What you will learn from this Course? (आप इस कोर्स से क्या सीखेंगे?)

At the end of the course you will be able to deal with a large amount of data and also will be able to apply text, number, math, lookup function, statistical functions & reference functions very easily without any hesitation. You will find it easy to manage organizing tools in Excel like charts, pivot table, etc.

Who should Enroll? (कोर्स में किसे दाखिला लेना चाहिए?)

This course is designed for Individuals seeking jobs, college students, working professionals, data analysts and anyone who is willing to gain knowledge about Excel applications.

For whom is this Course designed: (यह Course किसके लिए बनाया गया है?)

· Job Aspirants

· Working Professionals

· Marketing, Finance, Sales department Professionals

· Any Graduates who want to learn Excel.

· Students who want to aspire their Career into the field of Data Science, Data mining & Data MIS.

Who this course is for:

  • Anyone who wants to learn how to use MS Excel from the scratch
  • Professionals who want to brush up their previous knowledge in using Excel
  • Job aspirants who want to learn Excel that can be Helpful for their Interview
  • Marketing, Finance, Sales department Professionals
  • Students who want to aspire their Career into the field of Data Science, Data mining & Data MIS.
  • Any Student or fresh Graduate who want to learn MS Excel.
  • Students who want to learn Advanced Excel Functions like Macros, VBA, Logic, Looping Statement, etc.

Course Content

Launching Excel: Startup Screen and User Interface, Different versions of Excel Microsoft Excel Startup Screen Introduction to Excel Interface, basic shortcuts, etc Customizing the quick access toolbar More information of the Excel interface Understanding the Structure of Excel workbook Saving an excel document Opening an Existing Excel file Common Shortcut keys to use in Excel Navigating Excel worksheet with Ctrl Shortcuts How to save time with Function Shortcuts? Accessing Tools with Alt Keys Entering Text to Create Spreadsheet Titles Working with Numeric Data in Excel Creating Drop-Down Menus with Data Validation Entering Date Value in Excel Working with Cell Reference Creating Basic Formulas in Excel Relative vs Absolute Cell References in Formulas Understanding the Order of Operations Writing Efficient formula with Fixed or Relative References Moving and Copying Data in an Excel Worksheet Inserting and Deleting Rows and Columns Changing the Width and Height of Cells Hiding and Unhiding Excel Rows and Columns Renaming and Deleting an Excel Worksheet Moving and Copying an Excel Worksheet Verifying your Document in Print Preview Changing the Margins, Scaling and Orientation Working with Page Layout View Adding Header and Footer Content Printing a Specific Range of Cells How to enter text and edit formulas Common Types of Errors in Excel formulas Absolute Reference Relative Reference Mixed Reference Use of Functions Inserting Images Inserting Excel Shapes Formatting Excel Shapes Working with Excel Smart Act Visually representing Data Creating Excel Column Chart Working with Excel Chart Ribbon Formatting Charts Scatter Charts Combo Charts Pivot Charts Pie Charts: How to use and Application Adding and Modifying a Data on Excel Chart Structure of Excel Function Working with SUM() Working with MIN() MAX() Functions Working with AVG() Working with COUNT() Cell Errors in Excel Calculations How to use Autosum Command & Shortcut key Using Autofill Command to copy Formulas Introduction to Advance Functions in Excels Payment Functions & Loans Future Value Function & Pensions VLOOKUP Function & GradeBooks IF, Concatenate, & Evaluation Conditional Formatting IFERROR Function & Dynamic Amortization Tables Calculating A Grade Example How to Collect Data by Google Forms? Basic Excel Statistical Functions: COUNT, MEDIAN, MODE, PERCENTILE, STDEV, VAR, Extracting Values with SMALL/LARGE & RANK/PERCENTRANK Randomization with RAND() & RANDBETWEEN Row-Level Calculation with SUMPRODUCT How to Calculate Shipping Cost with SUMPRODUCT? Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS Building a Basic Dashboard with COUNTIFS & SUMIFS Counting Duplicates with COUNTIF & SUMPRODUCT Data Profiling with COUNT & SUMPRODUCT Introduction to Macros Basics: VBA Editor Advanced: VBA Editor Basics: Creating / Editing Code Advanced: Creating / Editing Code Beginners: Invoking Macros Advanced: Invoking Macros Basic: Compiling Code Advanced: Compiling Code Understanding Variables Advanced: Variables Basic: Working with Object Model Advanced: Working with Object Model Basic: Creating and naming objects Advanced: Creating and naming objects Beginners: Navigation / Selection Techniques Advanced: Navigation / Selection Techniques What is Logical Statement? Logic Statement: Nested IF Functions - User Defined Basic: Looping Statement Looping Statements Basic: Interactive Code Advanced: Interactive Code Basic: Error Handles Error Handlings

What You Need For This Course?

  • Access to Smart Phone / Computer
  • Good Internet Speed (Wifi/3G/4G)
  • Good Quality Earphones / Speakers
  • Basic Understanding of English
  • Dedication & Confidence to clear any exam

Internship Students Testimonials

Relevant Courses

Frequently Asked Questions

Q.Is the course 100% online? Does it require any offline classes too?

The following course is fully online, and hence there is no need for any physical classroom session. The lectures and assignments can be accessed anytime and anywhere through a smart web or mobile device.

Q.When can I start the course?

Anyone can choose a preferred course and start immediately without any delay.

Q.What are the course and session timings?

As this is a purely online course program, you can choose to learn at any time of the day and for as much time as you want. Though we follow a well-established structure and schedule, we recommend a routine for you as well. But it finally depends on you, as you have to learn.

Q.What will happen when my course is over?

If you have completed the course, you would be able to have lifetime access to it for future reference too.

Q.Can I download the notes and study material?

Yes, you can access and download the content of the course for the duration. And even have lifetime access to it for any further reference.

Q. What software/tools would be needed for the course and how can I get them?

All the software/tools that you need for the course would be shared with you during the training as and when you need them.

Q. Do I get the certificate in a hard copy?

No, only a soft copy of the certificate will be awarded, which can be downloaded and printed, if required.

Q. I’m unable to make a payment. What to do now?

You can try to make the payment through a different card or account (maybe a friend or family). If the problem persists, email us at info@easyshiksha.com

Q. The payment got deducted, but the updated transaction status is showing “failed”. What to do now?

Due to some technical faults, this can happen. In such a case the amount deducted will be transferred to the bank account in the next 7-10 working days. Normally the bank takes this much time to credit the amount back into your account.

Q. The payment was successful but it still shows ‘Buy Now’ or not showing any videos on my dashboard? What should I do?

At times, there may be a slight delay in your payment reflecting on your EasyShiksha dashboard. However, if the problem is taking longer than 30 minutes, please let us know by writing to us at info@easyshiksha.com from your registered email id, and attach the screenshot of the payment receipt or transaction history. Soon after verification from the backend, we will update the payment status.

Q. What is the refund policy?

If you have enrolled, and are facing any technical problem then you can request a refund. But once the certificate has been generated, we shall not refund that.

Q.Can I just enrol in a single course?

Yes! You surely can. To begin this, just click the course of your interest and fill in the details to enrol. You are ready to learn, once the payment is made. For the same, you earn a certificate too.

My questions are not listed above. I need further help.

Please contact us at: info@easyshiksha.com

WE FEATURED IN

NOW
WE'RE ON MOBILE TOO

10X FASTER EXPERIENCE

Want to learn more about college option and to secure an admission now!

EasyShiksha's expert counsellors can help you with all your doubts

by proceeding ahead you expressly agree to the EasyShiksha terms of use and privacy policy.