Excel Skills

Offered by Escholars Grooming Education Academy.. Faculty: Grooming Education Academy. Language: hinglish. Type: course.

About this course

Excel Skill:  This Excel Skills Course by Grooming Education Academy makes mastering Excel simple and accessible for everyone especially for Accounts & Finance professionals and students.

Learn how to create, format, and analyze data using Excel's powerful tools and features, designed to help you work smarter. This course will guide you step-by-step through essential Excel functions, formulas, data visualization techniques, with unlimited view access of course and download lectures facility in the Application “Escholars AI” and more.
 

This course includes:

  • Introduction to Excel
  • Creating and Formatting Spreadsheets
  • Understanding and Using Formulas
  • Working with Data and Tables
  • Analyzing Data with Charts and Graphs
  • Advanced Excel Features and Tips

Pricing plans

  • 1 Month (with softcopy certificate) — ₹999 (MRP ₹2,430). 30 days access. 5

What this course includes

  • India's first AI based Learning experience
  • Introduction to Excel
  • Creating and Formatting Spreadsheets
  • Understanding and Using Formulas
  • Working with Data and Tables
  • Analyzing Data with Charts and Graphs
  • Download lectures in App and watch offline
  • Watch lectures in both Mobile & Laptop

Why choose this course

  • How to buy the Course?: <div data-video-wrapper="true" data-align="center" style="display: block; width: 100%; max-width: 100%; margin: 12px auto;"><iframe src="https://www.youtube.com/embed/ByTBJG0ibdo?" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen="" data-editor-id="ed-1784388860748-g3k93" data-yt-opts="{&quot;url&quot;:&quot;https://youtu.be/ByTBJG0ibdo?si=49uxvrVJlpAqu3cu&quot;,&quot;width&quot;:&quot;100%&quot;,&quot;aspectRatio&quot;:&quot;16/9&quot;,&quot;autoplay&quot;:false,&quot;muted&quot;:false,&quot;loop&quot;:false,&quot;controls&quot;:true,&quot;startAt&quot;:0}" style="width: 100%; aspect-ratio: 16 / 9; border: 0px; border-radius: 8px; display: block; cursor: pointer;"></iframe></div><p><br></p>
  • How to Download and Use Escholars AI App?: <div data-video-wrapper="true" data-align="center" style="display: block; width: 100%; max-width: 100%; margin: 12px auto;"><iframe src="https://www.youtube.com/embed/r0QZqBP94pA?" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen="" data-editor-id="ed-1784388882747-ubdih" data-yt-opts="{&quot;url&quot;:&quot;https://youtu.be/r0QZqBP94pA?si=xEGYJ24mNwFL7sSm&quot;,&quot;width&quot;:&quot;100%&quot;,&quot;aspectRatio&quot;:&quot;16/9&quot;,&quot;autoplay&quot;:false,&quot;muted&quot;:false,&quot;loop&quot;:false,&quot;controls&quot;:true,&quot;startAt&quot;:0}" style="width: 100%; aspect-ratio: 16 / 9; border: 0px; border-radius: 8px; display: block; cursor: pointer;"></iframe></div><p><br></p>

Course curriculum

  • #0 Introduction
  • #1 What is row and columns in excel (Home tab part 1)
  • #2 How to apply alignment and number formatting in excel (Home tab part 2)
  • #3 What is conditional formatting in excel (Home tab part 3)
  • #4 How to apply formatting on table (Home tab part 4)
  • #5 How to insert & delete cell in excel (Home tab part 5)
  • #6 How to format Cell in excel (Home tab part 6)
  • #7 How to use sort & filter option in excel (home tab part 7)
  • #8 How yo use mathematical functions in excel
  • #9 How to use statistical functions
  • #10 How to use pivot table basic to advance in excel
  • #11 Insert tab
  • #12 Page layout Tab
  • #13 How to use text function in excel
  • #14 How to apply if function in excel
  • #15 How to apply nasted if function in excel
  • #16 Uses of if function with and and or function
  • #17 How to work on formula tab in excel
  • #18 Data tab
  • #19 How to work on review tab in excel
  • #20 How to work on view tab in excel
  • #21 How to use sumif count if average if function in excel
  • #22 How to use advance function in excel (sumifs ifs,count ifs average ifs)
  • #23 How to use date function in excel
  • #24 How to calculate interest by using financial function in excel
  • #25 Paste special tool in excel
  • #26 VLOOKUP, HLOOKUP, match with data list clear
  • #27 How to use templetes
  • #28 Tricks and shortcuts
  • #29 Assignment 1
  • #30 Assignment 2

Frequently asked questions

Frequently Asked Questions

How to Signup and How to Buy the Course?

  1. Kindly visit our Website www.escholars.in and Signup your ID there

Signup option is available in the Login Tab

  1. After Signup select the Course, you want to purchase.
  2. Press Buy Now, and then click on Place Order, Fill in your complete address after that click on deliver to this address, then again click on Place Order, then Proceed to Payment.
  3. Make a payment from available options (UPI, Debit Card, Credit card, Net banking, Google Pay etc.)
  4. After your successful payment, the Course will be added in your "My Courses."

How to access the Course after buying it?

  1. There are two methods to access our Course:-

     (a)  Open our Website www.escholars.in, Through any Internet Browser (Like Google Chrome etc.) on any   Desktop, Laptop, Tab or Mobile Phone Browser.

     (b) Through Our Mobile App "Escholars AI" (Available in Google Play Store) On the Mobile Phone or Tab

     2. After log in to the Website, go to My Course & Click on Start Course.

How to start studies after buying the course?

  1. Follow the sequence in which video lectures have been provided.
Technical Features

a) Offline Mode: Download the Entire Course in APP

1.    The most valuable feature of our Course is that you can Download the Entire Content of Course (Video Lectures & PDF Files) on your Mobile Phone using Our App "Escholars AI."

2.    After Downloading the Course, you can learn Offline. So there is no need for the Internet.

b) Video quality adjustment: Automatic as per internet speed or Manual (same as YouTube)

If you are facing an Internet-related Issue in your phone, then you can adjust the video quality of the Lectures at three levels like Low Med & High

c) Speed adjustment (x 1, x1.5 etc.…)

You can change the Speed of the Video Lectures at Six Levels ranging Low to High Like  0.25  to  2 x

f) Number of devices

1.   According to Academy Policy, you can View your Course through Two Devices Only.

2.   At a time you can run the Course through one device Only.

Downloads Related

Can we download the Course Data (PDF Files and Video Lectures) on Our External Memory Card / Pen Drive / Laptop?

1.    You can download the Course Data (PDF Files and Video Lectures) through Escholars App, and it will reside in your Phones Internal Memory Only

2.    It can not be saved in Your Mobile Phones External Memory Card or anywhere else,

Is there any restriction on the number of downloads of videos?

  1. Yes, you can download the Videos through our App Only for Once.
  2. Video Download facility is not available on Website.

Enrol in Excel Skills at Escholars Grooming Education Academy..