Microsoft Excel: Learn Complete Basics, Functions & Formulas

Learn all Basics of MS Excel. Expertise your MS Excel Functions & Formulas that Boosts Your Confidence.

Created by : Rated :4.3 575 views

Last Updated: 2023-03-20 05:03:57 English Course Type: Self Learning

Building a strong understanding on the Basics of Microsoft Excel.
Learn ADD, FILL, SPLIT, TRANSPOSE, SORT & FILTER, TABLES, DROP-DOWNS, ANALYZE, CHARTS and PIVOTE TABLES.
Learn multiple methods of basic arithmetic functions like addition, subtractions, multiplications, divisions ect.
Introduction to Functions, Average, Min & Max, Date and Time and Joining Text & Numbers.
Learn IF Statements, VLOOKUP, Conditional Function, Function Wizard and Formula Errors.
Learn Power Query, Pie Charts and Organization Chart from the Data.

Microsoft Excel: Learn Complete Basics, Functions & Formulas...

Learn all Basics of MS Excel. Expertise your MS Excel Functions & Formulas that Boosts Your Confidence.

Microsoft Office Excel provides powerful tools and features that you can use to analyze, share, and manage your data with ease. The user interface makes it easy for you to work in Microsoft Office Excel. Commands and features that were often buried in complex menus and toolbars are now easier to find on task-oriented tabs that contain logical groups of commands and features. Many dialog boxes are replaced with drop-down galleries that display the available options, and descriptive tooltips or sample previews are provided to help you choose the right option. No matter what activity you are performing in the new user interface—whether it's formatting or analyzing data—Excel presents the tools that are most useful to successfully complete that task.

To enable you to explore massive amounts of data in worksheets, Office Excel supports up to 1 million rows and 16 thousand columns per worksheet. Specifically, the Office Excel grid is 1,048,576 rows by 16,384 columns, which provides you with 1,500% more rows and 6,300% more columns. For those of you who are curious, columns now end at XFD instead of IV. Instead of 4 thousand types of formatting, you can now use an unlimited number in the same workbook, and the number of cell references per cell are increased from 8 thousand to limited by available memory. To improve the performance of Excel, memory management has been increased from 1 GB of memory to 2 GB in Office Excel.

You will also experience faster calculations in large, formula-intensive worksheets because Office Excel supports dual-processors and multithreaded chipsets. Office Excel also supports up to 16 million colors. You can use conditional formatting to visually annotate your data for both analytical and presentation purposes. To easily find exceptions and to spot important trends in your data, you can implement and manage multiple conditional formatting rules that apply rich visual formatting in the form of gradient colors, data bars, and icon sets to data that meets those rules. Conditional formats are also easy to apply—in just a few clicks, you can see relationships in your data that you can use for your analysis purposes.

No prior knowledge of an excel is required, but must know bit about computer typing.
MS Office of any version is installed in your system or PC.

For Beginners or Intermediates in any stream of the education are eligible to learn.
This course is mainly helps to those who are working in Banking or Banking sectors.
School students, College students and all professionals can learn this course and make work life easy.

Section 1 : INDEX 3 Lectures 00:00:00
Lecture 1 :
The Excel Course Promo Preview
Lecture 2 :
How to Get MS Office Application...?
Lecture 3 :
Things We Learn From Now...
Section 2 : INTRODUCTION 19 Lectures 00:04:08
Lecture 1 :
An Introduction to MS Excel Professional Plus 2021
Lecture 2 :
Knowing Excel Cells, Rows, Columns
Lecture 3 :
What are Clipboard?
Lecture 4 :
Work On Fonts Part 1
Lecture 5 :
Work On Fonts Part 2
Lecture 6 :
Work On Fonts Part 3
Lecture 7 :
Lets See Alignment Part 1
Lecture 8 :
Lets See Alignment Part 2
Lecture 9 :
Lets See Alignment Part 3
Lecture 10 :
Shall We Discuss on Numbers? Part 1
Lecture 11 :
Shall We Discuss on Numbers? Part 2
Lecture 12 :
Shall We Discuss on Numbers? Part 3
Lecture 13 :
Look at the Excel Styles...
Lecture 14 :
Lets Talk About Cells Part 1
Lecture 15 :
Lets Talk About Cells Part 2
Lecture 16 :
Lets Talk About Cells Part 3
Lecture 17 :
Will Do Some Editing Part 1
Lecture 18 :
Will Do Some Editing Part 2
Lecture 19 :
Will Do Some Editing Part 3
Section 3 : WELCOME TO EXCELL 6 Lectures 00:21:03
Lecture 1 :
Basic Arithmetic Operations
Lecture 2 :
Working with ADD
Lecture 3 :
Working with FILL
Lecture 4 :
Working with SPLIT
Lecture 5 :
Working with TRANSPOSE
Lecture 6 :
Discussion on SORT and FILTERS

How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
Is there any free trial?
Currently, we do not offer any free trial.
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

Pradeep Raj,

3831 Course Views

4 Courses

I hold degrees in Electronics and Communication Engineering. I am an Electronics and Communication Engineer that specializes in circuit design, hardware design, PCB layout design and PCB Manufacturing. I have written many blogs and articles on the aforementioned subjects and taught Electronics Engineering courses at Swarna Institute of Technology (recognized by Micro Small and Medium Enterprise (MSME), Government of India) as well as online for many years. I also train on many professional skills like Microsoft office (Microsoft Word, Microsoft presentation and Microsoft Excel etc.), Fusion 360 (3D design and Development), Website Design and Development, Digital Marketing and 2D and 3D Animation. I am currently working as 'Training Head' at Swarna Institute of Technology, Bangalore, Karnataka, India.