*#1 Most Popular Online Course in Computer Science* You can enroll today & get certified from EasyShiksha &
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.
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
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.
Anyone can choose a preferred course and start immediately without any delay.
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.
If you have completed the course, you would be able to have lifetime access to it for future reference too.
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.
All the software/tools that you need for the course would be shared with you during the training as and when you need them.
No, only a soft copy of the certificate will be awarded, which can be downloaded and printed, if required.
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
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.
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.
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.
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.
Please contact us at: info@easyshiksha.com
Discover thousands of colleges and courses, enhance skills with online courses and internships, explore career alternatives, and stay updated with the latest educational news..
Gain high-quality, filtered student leads, prominent homepage ads, top search ranking, and a separate website. Let us actively enhance your brand awareness.
Download EasyShiksha Mobile Apps from Android Play Store, Apple App Store, Amazon App Store, and Jio STB.
1 million+ learned on the EasyShiksha App
