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
  • Core Excel
  • Conditional Formatting
  • Core Excel Formulas and Functions
  • Core Pivot
  • Excel Tables
  • Excel Shortcuts

Weak Excel muscles can impair your performance, sap your energy, and even hinder your career. In a world flooded with data, you need strong Excel skills to survive and thrive. In just one course, Microsoft Excel- Complete Master Program in MS Excel [2021] will teach you how to use a spreadsheet with ease and confidence, and transform your flabby Excel skills into a sturdy Expert you can build on.

What you'll learn

An accelerated, step-by-step program to give you a strong foundation to Expert Level Skills

Core Excel

Weak Excel muscles can impair your performance, sap your energy, and even hinder your career. In a world flooded with data, you need strong Excel skills to survive and thrive. In just one course, Core Excel will teach you how to use a spreadsheet with ease and confidence, and transform your flabby Excel skills into a sturdy foundation you can build on.

Core Excel Formulas and Functions

Formulas are the key to getting work done in Excel. In this accelerated video course, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn powerful skills to troubleshoot, trace errors, and fix problems. This is the formula training you should have had to begin with. End your frustration with Excel formulas and Functions today.

  • No prior experience required: beginners and experts will learn a lot from the course
  • Microsoft Excel installed, preferably version 2016 or higher
  • Financial, business, data analysts who are looking to drastically improve their workflow and master MS Excel
View More...
  • Section 1 : Microsoft Excel- Basics 14 Lectures 00:23:28

    • Lecture 1 :
    • Lecture 2 :
    • Open and Close Excel Appilication
    • Lecture 3 :
    • Window Controls To Minimize, Maximize and Restore Excel Window
    • Lecture 4 :
    • Resize and Move Excel Window
    • Lecture 5 :
    • Components of Excel Workbook Interface
    • Lecture 6 :
    • Customize Excel Ribbon
    • Lecture 7 :
    • Quick Access Tool Bar
    • Lecture 8 :
    • Configure password for Excel File
    • Lecture 9 :
    • Row, Column and Cell in Excel
    • Lecture 10 :
    • Change Row Height in Excel
    • Lecture 11 :
    • Change Column width in Excel
    • Lecture 12 :
    • Insert Rows, Columns in Excel
    • Lecture 13 :
    • Hide and Unhide Rows, Columns in Excel
    • Lecture 14 :
    • Delete Rows and Columns in Excel
  • Section 2 : Microsoft Excel- Worksheets 3 Lectures 00:04:01

    • Lecture 1 :
    • Insert, Rename and Delete Worksheets
    • Lecture 2 :
    • Hide and Unhide Worksheets in Excel
    • Lecture 3 :
    • Freeze Panes at Rows, Columns in Worksheets
  • Section 3 : Microsoft Excel- Entering Data 8 Lectures 00:08:46

    • Lecture 1 :
    • Enter Data in Excel
    • Lecture 2 :
    • Edit Data in Excel
    • Lecture 3 :
    • Enter Data with Fill handler
    • Lecture 4 :
    • Enter Data with Custom Patterns
    • Lecture 5 :
    • Move Data in Excel
    • Lecture 6 :
    • Duplicate Data in Excel
    • Lecture 7 :
    • Delete Data in Excel
    • Lecture 8 :
    • Use Drag and Drop in Excel
  • Section 4 : Microsoft Excel- Find and Replace 5 Lectures 00:03:26

    • Lecture 1 :
    • Find a Value in Excel
    • Lecture 2 :
    • Find a Formatted Value in Excel
    • Lecture 3 :
    • Find All Matches at Once
    • Lecture 4 :
    • Find and Replace a Value
    • Lecture 5 :
    • Find and Replace a Formatted Value
  • Section 5 : Microsoft Excel- Cell References 6 Lectures 00:13:43

    • Lecture 1 :
    • What is Cell Reference
    • Lecture 2 :
    • Relative Reference in Excel
    • Lecture 3 :
    • Relative Reference Examples
    • Lecture 4 :
    • Absolute Reference
    • Lecture 5 :
    • Absolute Reference Example
    • Lecture 6 :
    • Mixed Reference in Excel
  • Section 6 : Microsoft Excel- Font Formatting 7 Lectures 00:15:59

    • Lecture 1 :
    • Format Font and Font Size
    • Lecture 2 :
    • Bold ,Italic and Underlining Styles
    • Lecture 3 :
    • Change Font Colour
    • Lecture 4 :
    • Different Underlining Options
    • Lecture 5 :
    • Apply superscript, subscript and Strikethrough
    • Lecture 6 :
    • Insert Symbols and Special Characters
    • Lecture 7 :
    • Format Individual Characters
  • Section 7 : Microsoft Excel- Borders and Fills 4 Lectures 00:10:21

    • Lecture 1 :
    • Apply Border to a cell
    • Lecture 2 :
    • Draw Border and Border Grids
    • Lecture 3 :
    • Apply Border using Border Presists
    • Lecture 4 :
    • Remove Existing Borders
  • Section 8 : Microsoft Excel- Name Range 4 Lectures

    • Lecture 1 :
    • Create Name Range
    • Lecture 2 :
    • Name Range Constant
    • Lecture 3 :
    • Dynamic Name Range
    • Lecture 4 :
    • Dynamic Name Range with Table
  • Section 9 : Microsoft Excel- Formulas and Functions 3 Lectures 00:18:21

    • Lecture 1 :
    • What is Formula and Function in Excel
    • Lecture 2 :
    • Arithmetic Operations in Excel
    • Lecture 3 :
    • Order of Operations in Excel
  • Section 10 : Date and Time Functions 6 Lectures 00:13:26

    • Lecture 1 :
    • Create Full Date using DATE() Function
    • Lecture 2 :
    • Extract Year, Day, Month values using YEAR, MONTH, DAY functions
    • Lecture 3 :
    • Generate Time Using HOUR,MINUTE,SECOND and TIME Functions
    • Lecture 4 :
    • get time between dates in years, months, or days using DATEDIF and YEARFRAC
    • Lecture 5 :
    • Generate past, future and end dates using EDATE() and EOMONTH() Function
    • Lecture 6 :
    • Generate weekday and week number using WEEKDAY() and WEEKNUM() functions
  • Section 11 : Information Function 1 Lectures 00:03:51

    • Lecture 1 :
    • Information Functions -ISNUMBER, ISTEXT, ISBLANK, ISERROR
  • Section 12 : Microsoft Excel- Logical Functions 4 Lectures 00:10:52

    • Lecture 1 :
    • Logical Functions - AND () Function
    • Lecture 2 :
    • Logical Functions - OR () Function
    • Lecture 3 :
    • Logical Functions - NOT() Function
    • Lecture 4 :
    • Logical Functions - IF and IFS functions
  • Section 13 : Microsoft Excel- Statistical Functions 6 Lectures 00:11:22

    • Lecture 1 :
    • Count Items using COUNT () Function
    • Lecture 2 :
    • Count items based on criteria using COUNTIF() Function
    • Lecture 3 :
    • Find Total using SUM () Function
    • Lecture 4 :
    • Find Total based on conditions using SUMIF () Function
    • Lecture 5 :
    • Find Minimum and Maximum values using MIN () and MAX () Function
    • Lecture 6 :
    • Generate averages using AVERAGE () Function
  • Section 14 : Microsoft Excel- Text Functions 4 Lectures 00:06:54

    • Lecture 1 :
    • TEXT Functions---> LEFT, RIGHT, MID () Functions
    • Lecture 2 :
    • TEXT Functions -----> LEN () Function
    • Lecture 3 :
    • TEXT FUNCTIONS -----> TRIM, CLEAN() Functions
    • Lecture 4 :
    • TEXT Functions ------> UPPER, LOWER, PROPER() Functions
  • 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?

122661 Course Views

3 Courses

Hello Everyone, I'm having 8+yrs experience in IT industry especially in software development and Quality Engineering.Worked with various Top CMM Level organizations. Experience in various domains like Banking, insurance, telecom,CRM,data security. Expertise in Agile and scrum process environments.
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.