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
3 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%
3 days left at this price!
Buy Now
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
Buy Now
$244

What you'll learn?

  • Master Microsoft Excel starting from the Basics to Advanced
  • Perform data lookups in Microsoft Excel using various lookup functions such as VLOOKUP, HLOOKUP, INDEX, MATCH, OFFSET, etc.
  • Use Microsoft Excel logic functions such as IF, AND, OR to apply decision making rules
  • Perform basic mathematical to advanced statistical operations such as regression and correlation in Microsoft Excel
  • See how Microsoft Excel Solver can be used to solve complex problems such as optimization
  • Use Microsoft Excel Macros to automate tasks in Excel
  • Use PivotTable to easily manipulate and display data
  • Build Microsoft Excel real world applications - personal expense tracker, mortgage calculator, revenue dashboard, perform trend and correlation analysis

Course Overview

Unlock the Full Potential of Microsoft Excel

Are you looking to gain a competitive edge in today's data-driven world? Our comprehensive Microsoft Excel course is designed to equip beginners with a solid foundation and take them on an immersive journey through the intricate workings of this powerful tool. From the basics to advanced concepts, this course covers all the essentials you need to know to become a proficient Excel user and leverage its capabilities to drive real-world results.

Course Highlights

  1. Excel Fundamentals: Begin your Excel adventure by exploring the basic anatomy of Excel, and learning how to navigate the interface with ease and efficiency.

  2. Data Formatting and Visualization: Discover how to format data for better presentation and create charts that convey information with clarity.

  3. Mathematical Operations and Functions: Dive into the world of mathematical operations and functions within Excel. From simple calculations to complex equations, you'll explore a wide range of functions that empower you to perform calculations swiftly and accurately.

  4. Logical and Conditional Functions: Unleash the power of logic within Excel by mastering both logic and conditional functions. Learn how to make data-driven decisions using formulas that dynamically evaluate conditions and produce desired outcomes.

  5. Lookup Functions: Harness the full potential of Excel's lookup functions, enabling you to efficiently search for and retrieve specific information from huge datasets, saving you time and effort.

  6. Advanced Math and Statistical Functions: Take your analytical skills to the next level with advanced math and statistical functions. Uncover insights and patterns in data by applying statistical formulas and techniques.

  7. Advanced Tools and Techniques: Discover advanced Excel tools like Solver, Pivot Tables, and Macros, empowering you to solve complex problems, manipulate datasets, and automate repetitive tasks.

  8. Real-World Applications: Explore practical applications of Excel by building a revenue dashboard, creating a personal expense tracker, and developing a mortgage calculator. Experience firsthand how Excel can be utilized to tackle real-world challenges and enhance productivity.

  9. Data Analysis: Gain a deeper understanding of data analysis by leveraging Excel's capabilities to perform correlation and trend analysis. Uncover valuable insights from your data and make informed business decisions.

Join us on this transformative journey as we demystify Microsoft Excel and provide you with the tools and knowledge to harness its full potential. Whether you're a student, professional, or business owner, this course will empower you to navigate the world of data with confidence and proficiency. Enroll now and unlock the power of Excel for success in today's data-driven landscape!

See More

Pre-requisites

  • 1. No prior knowledge in Microsoft Excel is required. You will learn what you need in this course.
  • 2. Recommended: Microsoft 2013 or later

Target Audience

  • Anyone from beginner to advanced who is keen to learn more about how to use Microsoft Excel
View More...

Curriculum 35 Lectures 06:00:44

  • Section 1 : Introduction 2 Lectures 00:00:35

    • Lecture 1 :
      • A brief look at what is in the course
    • Lecture 2 :
    • Getting The Best Out Of This Course
      • A short note on how to get the best out of this course.

  • Section 2 : The Basics of Microsoft Excel 3 Lectures 00:42:15

    • Lecture 1 :
    • Basic Anatomy of Microsoft Excel
      • 1. Familiarize yourself with the Microsoft Excel GUI 2. Learn what are a workbook and worksheet 3. Learn what is a cell and what are ranges 4. Learn about the different types of Microsoft Excel files
    • Lecture 2 :
    • Navigating Inside Microsoft Excel
      • 1. Moving around, selecting cells and ranges in Microsoft Excel 2. Copy and pasting 3. Replicating formulas 4. Inserting/deleting/hiding rows and columns 5. Filtering and sorting data
    • Lecture 3 :
    • Formatting Data in Microsoft Excel
      • 1. Formatting cell content 2. Formatting cell attributed 3. Conditional formatting

  • Section 3 : Creating Charts with Microsoft Excel 4 Lectures 00:37:57

    • Lecture 1 :
    • Basic Charts in Microsoft Excel
      • See how to generate simple line, bar, and pie charts in Microsoft Excel.
    • Lecture 2 :
    • Advanced Chart - Scatterplot
      • See how to create a scatterplot and plot a trendline that shows you the relationship between 2 variables in Microsoft Excel.
    • Lecture 3 :
    • Advanced Chart - Histogram
      • See how to create a histogram that shows the distribution of data in Microsoft Excel.
    • Lecture 4 :
    • Advanced Chart - Combo
      • See how to create a combo chart that displays 2 sets of data running on 2 different vertical or y-axis. in Microsoft Excel.

  • Section 4 : Basic Operations and Functions in Microsoft Excel 10 Lectures 01:23:26

    • Lecture 1 :
    • Basic Math Operations in Microsoft Excel
      • Do simple mathematical operations in Microsoft Excel - addition, subtraction, multiplication, division, power.
    • Lecture 2 :
    • Basic Math and Statistical Functions In Microsoft Excel
      • Learn how to use basic math and statistical functions such as AVERAGE, MEDIAN, MODE, SUM, PRODUCT, SUMPRODUCT, MAX, MIN, COUNT, ROUNDUP, ROUNDDOWN, RANK.
    • Lecture 3 :
    • Working With Dates in Microsoft Excel
      • Learn functions that deal with date formatting in Microsoft Excel - MONTH, YEAR, DATE, TODAY, NOW, WEEKDAY.
    • Lecture 4 :
    • Excel Lookup Functions - VLOOKUP
      • Learn how to perform vertical lookup in Microsoft Excel.
    • Lecture 5 :
    • Excel Lookup Functions - HLOOKUP
      • Learn how to perform horizontal lookup in Microsoft Excel.
    • Lecture 6 :
    • Excel Lookup Functions - MATCH
      • Learn how to look up data that matches what you want in Microsoft Excel.
    • Lecture 7 :
    • Excel Lookup Functions - INDEX
      • Learn how to use INDEX and MATCH functions jointly to perform a more powerful and versatile way of lookup up data in Microsoft Excel.
    • Lecture 8 :
    • Excel Lookup Functions - OFFSET
      • Learn how to use OFFSET to do a relative lookup from a reference cell in Microsoft Excel.
    • Lecture 9 :
    • Excel String Manipulation Function - LEFT & RIGHT
      • Learn how to extract characters from text using the LEFT and RIGHT functions in Microsoft Excel.
    • Lecture 10 :
    • A Faster Implementation
      • Look at a faster way of implementing the earlier exercises on the various LOOKUP functions.

  • Section 5 : Logic and Conditional Functions in Microsoft Excel 3 Lectures 00:47:02

    • Lecture 1 :
    • Excel Logic Function - IF AND OR
      • Learn how to perform logic decision rules using IF AND OR in Excel.
    • Lecture 2 :
    • Excel Logic Function - IFNA IFERROR
      • Learn how to perform logic decision rules when errors are encountered using IFNA and IFERROR in Excel.
    • Lecture 3 :
    • Excel Conditional Functions
      • Learn how to perform use conditional mathematical functions in MS Excel such as SUMIF AVERAGEIF COUNTIF MAXIFS MINIFS LARGE SMALL.

  • Section 6 : Advanced Math and Statistical Functions in Microsoft Excel 5 Lectures 00:44:58

    • Lecture 1 :
    • Excel Statistical Function - STDEV SKEW KURT
      • Learn how to use Excel statistical functions STDEV SKEW KURT to calculate the standard deviation, skew, and kurtosis that describe the distribution of a set of data.
    • Lecture 2 :
    • Excel Statistical Function - CORREL
      • Learn how to use Excel statistical functions CORREL to calculate correlation between 2 variables to determine their strength of linear fit.
    • Lecture 3 :
    • Excel Statistical Function - SLOPE INTERCEPT
      • Learn how to use Excel statistical functions SLOPE and INTERCEPT to calculate the gradient (slope) and intercept of a straight line on a 2 dimensional chart or space.
    • Lecture 4 :
    • Excel Statistical Function - LINEST
      • Learn how to use Excel statistical functions LINEST to perform linear regression on 2 variables and how to extend this to a multi-variable linear regression (more than 2 variables).
    • Lecture 5 :
    • Linear Regression using Data Analysis Toolpak In Excel
      • Learn how to perform linear regression using the Data Analysis Toolpak in Microsoft Excel.

  • Section 7 : Advanced Microsoft Excel Tools 3 Lectures 00:30:30

    • Lecture 1 :
    • Excel Solver
      • See how we can use Solver to solve complex problems such as portfolio optimization.
    • Lecture 2 :
    • Excel Pivot Table
      • See how we can use Pivot Tables to manipulate and display data in MS Excel.
    • Lecture 3 :
    • Excel Macros
      • See how we can use Macro to automate tasks in Excel.

  • Section 8 : Applying Microsoft Excel In The Real World 5 Lectures 01:14:01

    • Lecture 1 :
    • Building a Revenue Dashboard in Microsoft Excel
      • Building a Revenue Dashboard in Microsoft Excel
    • Lecture 2 :
    • Performing Correlation Analysis In Microsoft Excel
      • Performing Correlation Analysis In Microsoft Excel
    • Lecture 3 :
    • Performing Trend Analysis In Microsoft Excel
      • Performing Trend Analysis In Microsoft Excel
    • Lecture 4 :
    • Building a Personal Expense Tracker using Microsoft Excel
      • Building a Personal Expense Tracker using Microsoft Excel
    • Lecture 5 :
    • Building a Mortgage Calculator using Microsoft Excel
      • Building a Mortgage Calculator using Microsoft Excel

Our learners work at

Frequently Asked Questions

  • 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?

Instructor

AllQuant .,

217 Course Views

1 Courses

AllQuant is a financial education company founded by investment professionals, Eng Guan (E.G.) Lim and Patrick Ling. They have a total of more than 30 years of experience in the financial markets working their way through asset management firms, investment banks, proprietary trading, and hedge funds. In their last role, they were both portfolio managers in a quantitative multi-strategy hedge fund. In the course of their investment career, they also acquired extensive quantitative modeling skills and experience using MS Excel and other programming languages. As part of their efforts to demystify the quantitative approach to investing, AllQuant is dedicated to providing top-notch education in financial markets, investing, and modeling through MS Excel, aiming to break down the barriers between professional and retail investing. They look to deliver value-adding courses developed through real experiences that are not just pedagogical but practical as well. The ultimate objective is to empower individuals to take charge of their own lives. The founders believe that education is one of the best investments and the solution to a better and fairer world.
View More...

Student Reviews 4.6

  • 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

Students also bought

  • 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.