All in One Offer! | Access Unlimited Courses in any category starting at just $29. Offer Ends in:

Browse Library

  • Business Solutions
  • Become an Instructor
  • 0
    Shopping Cart

    Your Cart is empty. Keep shopping to find a course!

    Browse Courses
Get Unlimited Learning Access
$29
7 days left at this price!
30-Day Money-Back Guarantee

This plan includes

  • Instant access to 11,000+ online courses
  • Play & Pause Course Videos
  • HD Video Recorded Lectures
  • Learn on Mobile/PC/Tablet
  • Quizzes and Real Projects
  • Lifetime Course Certificate
  • Instructor Chat Support
  • Cancel Plan Anytime
Subscribe to Learnfly’s top courses
Get this course, plus 11,000+ of our top-rated courses for one year with Go Annually Plan.
$348 $244 a year Save 30%
7 days left at this price!
30-Day Money-Back Guarantee

This plan includes

  • Instant access to 11,000+ online courses
  • Play & Pause Course Videos
  • HD Video Recorded Lectures
  • Learn on Mobile/PC/Tablet
  • Quizzes and Real Projects
  • Lifetime Course Certificate
  • Instructor Chat Support
  • Cancel Plan Anytime
$29
$244
  • 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.
View More...
  • Section 1 : INDEX 3 Lectures

    • Lecture 1 :
    • 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?

910 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.
View More...
  • Unmatched Variety and Value!
    Learnfly's monthly subscription offers unlimited access to a vast range of courses. Affordable pricing, compared to competitors, makes it the ultimate choice for continuous learning.
    Jessica M.

    4.7

    JM
  • Top-Notch Quality, Affordable Rates!
    High-quality courses with certified instructors make Learnfly stand out. The affordable pricing is a game-changer for those seeking premium education.
    Alex P.

    4.5

    AP
  • Certified Excellence Every Time!
    Learnfly's courses, taught by certified instructors, ensure top-notch learning experiences. The course completion certificates add significant value to one's skill set.
    Sarah R.

    4.3

    SR
  • Round-the-Clock Support!
    Learnfly goes the extra mile with 24/7 course support. Their dedication to helping students succeed is commendable.
    Ryan K.

    4.1

    RK
  • Learn Anywhere, Anytime!
    Whether on mobile, PC, or tablet, Learnfly's platform offers flexibility. Learning on the go has never been easier.
    Emily S.

    4.7

    ES
  • Job-Ready Skills!
    Learnfly's job-oriented courses equip learners with practical skills for the workplace. An investment in career growth!
    Jake M.

    4.2

    JM
  • Budget-Friendly Brilliance!
    Learnfly's pricing is a steal for the quality and variety of courses offered. Quality education without breaking the bank.
    Olivia T.

    4.5

    OT
  • Instructor Excellence Unleashed!
    Learn from the best with Learnfly's certified instructors. The platform ensures that knowledge is imparted by industry experts.
    Daniel L.

    4.0

    DL
  • Achievement Unlocked!
    Learnfly not only offers courses but also recognizes your efforts with course completion certificates. A sense of accomplishment with every course finished.
    Maya H.

    4.6

    MH
  • Learning Revolution!
    Learnfly's platform is a revolution in education. Access to unlimited courses at affordable rates is a game-changer.
    Ethan W.

    4.7

    EW
  • principles-of-data-cleaning

    Principles of Data Cleaning

    By : Phikolomzi Gugwana

    Lectures 25 Beginner 0:34:10
  • microsoft-power-bi-a-complete-hands-on-training

    Microsoft Power BI-A Complete Hands...

    By : Deepesh Vashistha

    Lectures 41 Beginner 3:35:28

Students learning on Learnfly works with Fortune 500 companies around the globe.

Sign Up & Start Learning
By signing up, you agree to our Terms of Use and Privacy Policy
Reset Password
Enter your email address and we'll send you a link to reset your password.