Course Content

Introduction to Data Analysis With Excel

20m 17s

How to use LearnVern

3m 20s

What is data analysis and where to use it

16m 29s

How to use Percentage Variance and Round functions in Excel

32m 25s

How to use count and different types of count functions?

18m 10s

How to perform calculations on string data using excel spread sheet functions?

24m 30s

How to calculate age and words count using excel spread sheet functions?

22m 13s

How to perform calculations using Date and Time functions

20m 48s

How To Perform Calculations On Time and Completion of Year Percentage Using Excel Spread Sheet Formulas

17m 55s

How To Find The Last Day And Nth Weekday Of The Month Using Date Functions

30m 43s

How To Perform Conditions Using Date And Time Functions

19m 46s

How To Perform Calculations Using Logical Operators On Given Data With Excel Spread Sheet Functions

21m 10s

How To Perform Calculations On Data Using Excel Spread Sheet Functions And Conditions

30m 28s

Excel With Formulas Quiz

5m

What Is Conditional Statements And How To Perform Calculations Using Logical Operators

13m 37s

How To Perform Calculations On Different Data Types With Multiple Conditions Using Logical And Operator

35m 26s

How To Use Multiple AND & OR Logical Operator With Conditions In Excel Spread Sheet

16m 30s

How To Perform Calculations Using One Logical OR and Multiple AND Operators with Ifelce Conditions

17m 39s

How To Perform Calculations And Check Output In Different Way Using Logical OR and NOT Operator

26m 13s

How And Where To Perform Calculations Using Logical XOR Operators With IFELSE conditions

24m 12s

Assignment On Conditional Statements and Logical Operators Assignment

12m 10s

Conditional Statement & Logical Operators Quiz

4m

What Is Statistics And Statistical Function

27m

What Is Intermediate Statistical Functions

17m 13s

What Is Difference Between Absolute And Relative Cell Reference

28m 59s

What And How To Use Index Function

17m 51s

What And How To Use Match Function

21m 50s

How To Use MMM Formula In Excel Spread Sheet

27m 23s

How To Use Percentiles In Excel Spread Sheet With Example

12m 56s

How To Use Quartile Using Match Function

12m 56s

What Is Outliers And Statistical Outliers

21m 25s

How To Use Leveraged Interquartile Range IQR

29m 35s

How To De Seasonalize Data Before Forecasting Using Excel Spread Sheet

40m 24s

Common Excel Spread Sheet Statistical Functions Quiz

5m

What Is Lookup And Types Of Lookup Function

23m 41s

Different Types Of Examples Using Lookup Function

35m 10s

How To Perform Case Sensitive Lookup Using Index And Exact Function

27m

How To Perform Aggregations On Data Using Lookup Function

16m 7s

What Is Reference And Types Of Reference Functions

26m 27s

What Is Reference Offset Function

19m 2s

How To Use Rows And Columns Reference Function

15m 24s

What And Where To Use Text Function

32m 30s

How To Use Vlookup, Len, Concatenate & Averageifs Function Using Excel Spread Sheet

31m 6s

How To Use Find IfError, Countifs & Sum Product Function Using Excel Spread Sheet

25m 38s

How To Use Date And Time Functions In Excel Spread Sheet

11m 22s

How To Use Day Days360 Edate And Date Value Function In Excel Spread Sheet

19m 26s

How To Use Eo Month ISOWeekNum Network Days Intl And Month Function In Excel Spread Sheet

20m 59s

How To Use Weekday WeekNum Workday.Intl And Year Frac Function Using Excel Spread Sheet

26m 45s

Assignment On Date and Time

1m 57s

Assignment On LookUp

1m 16s

Assignment On Reference

2m 14s

Lookup Reference ,Text Date & Time Functions Quiz

5m

What And How To Use Conditional Formatting

20m 13s

Examples Using Conditional Formatting

22m 59s

Examples That Highlight Dates And Statistical Outliers Using Conditional Formatting

34m 19s

Assignment On Formula Based Conditional Formatting

8m 8s

Formula based Conditional Formatting Quiz

5m

How To Format And Customize Chart In Excel Spread Sheet

27m 49s

How To Customize Axes In Excel Spread Sheet Charts

18m 16s

How To Add Labels Hiding And Editing Data In Excel Spread Sheet Charts

26m 58s

When To Use Each Chart Or Graph Type In Excel Spread Sheet

21m 43s

How To Use Scatter Area Stock Radar And Waterfall Chart In Excel Spread Sheet

24m 13s

Assignment On Excel Chart Formatting and Customization

3m 12s

What Is Mastering Advance Excel Spread Sheet Chart And Graph

35m 13s

How To Create a DOT PLOT Chart In Excel Spread Sheet

28m 1s

How To Create a DUMBELL And PANEL Chart In Excel Spread Sheet

39m 16s

Assignment On Mastering Advance Excel Charts and Graphs

2m 35s

What When And How To Use Pivot Table

22m 55s

How To Group Pivot Table Items And Get Data In Right Format With Pivot Tables

34m 52s

How To Use Frequency Distribution And Slicers To Filter Pivot Tables Data

26m 40s

How To Update Pivot Table And Perform Calculations In Excel Spread Sheet

29m 9s

Assignment On Formatting Data with Pivot Tables

4m 44s

Formatting Data With Pivot Tables Quiz

4m

How To Perform Sorting Filtering And Grouping Data With Pivot Tables Using Excel Spread Sheet

31m 57s

Assignment On Sorting, Filtering and Grouping with Pivot Tables

1m 2s

What Is Calculated Field And How To Use Them

19m 46s

Steps To Add Calculated Field In Pivot Table With Excel Spread Sheet

13m 13s

How To See Or List All Calculated Fields In Excel Spread Sheet

21m 22s

How To Delete Or Hide Calculated Fields

30m 40s

Assignment On Enriching Data With Pivot Table

2m 30s

How To Visualize Data With Pivot Charts

23m 45s

Why And How To Use Forecasting Linear Regression In Excel Spread Sheet

25m 42s

How To Implement Linear Regression

7m 57s

What Is Logistic Regression And Difference Between Linear And Logistic Regression

37m 50s

Visualizing Data with Excel Spread Sheet Pivot Charts Quiz

2m

How To Implement Linear Regression Analysis In Excel Spread Sheet

43m 25s

How To Implement Logistic Regression Analysis In Excel Spread Sheet

18m 13s

Linear & Logistic Regression Quiz

5m

How To Create Mortgage Amortization Schedule And Dates Instead Of Payment Numbers

Excel For Data Analysis Data Visualization and Financial Formulas

Enroll Now For Free
Previous Next
Discussion
Previous Discussion Next
Previous
Next
  • Formulas

Course Content

Introduction to Data Analysis With Excel

20m 17s

How to use LearnVern

3m 20s

What is data analysis and where to use it

16m 29s

How to use Percentage Variance and Round functions in Excel

32m 25s

How to use count and different types of count functions?

18m 10s

How to perform calculations on string data using excel spread sheet functions?

24m 30s

How to calculate age and words count using excel spread sheet functions?

22m 13s

How to perform calculations using Date and Time functions

20m 48s

How To Perform Calculations On Time and Completion of Year Percentage Using Excel Spread Sheet Formulas

17m 55s

How To Find The Last Day And Nth Weekday Of The Month Using Date Functions

30m 43s

How To Perform Conditions Using Date And Time Functions

19m 46s

How To Perform Calculations Using Logical Operators On Given Data With Excel Spread Sheet Functions

21m 10s

How To Perform Calculations On Data Using Excel Spread Sheet Functions And Conditions

30m 28s

What Is Conditional Statements And How To Perform Calculations Using Logical Operators

13m 37s

How To Perform Calculations On Different Data Types With Multiple Conditions Using Logical And Operator

35m 26s

How To Use Multiple AND & OR Logical Operator With Conditions In Excel Spread Sheet

16m 30s

How To Perform Calculations Using One Logical OR and Multiple AND Operators with Ifelce Conditions

17m 39s

How To Perform Calculations And Check Output In Different Way Using Logical OR and NOT Operator

26m 13s

How And Where To Perform Calculations Using Logical XOR Operators With IFELSE conditions

24m 12s

Assignment On Conditional Statements and Logical Operators Assignment

12m 10s

What Is Statistics And Statistical Function

27m

What Is Intermediate Statistical Functions

17m 13s

What Is Difference Between Absolute And Relative Cell Reference

28m 59s

What And How To Use Index Function

17m 51s

What And How To Use Match Function

21m 50s

How To Use MMM Formula In Excel Spread Sheet

27m 23s

How To Use Percentiles In Excel Spread Sheet With Example

12m 56s

How To Use Quartile Using Match Function

12m 56s

What Is Outliers And Statistical Outliers

21m 25s

How To Use Leveraged Interquartile Range IQR

29m 35s

How To De Seasonalize Data Before Forecasting Using Excel Spread Sheet

40m 24s

What Is Lookup And Types Of Lookup Function

23m 41s

Different Types Of Examples Using Lookup Function

35m 10s

How To Perform Case Sensitive Lookup Using Index And Exact Function

27m

How To Perform Aggregations On Data Using Lookup Function

16m 7s

What Is Reference And Types Of Reference Functions

26m 27s

What Is Reference Offset Function

19m 2s

How To Use Rows And Columns Reference Function

15m 24s

What And Where To Use Text Function

32m 30s

How To Use Vlookup, Len, Concatenate & Averageifs Function Using Excel Spread Sheet

31m 6s

How To Use Find IfError, Countifs & Sum Product Function Using Excel Spread Sheet

25m 38s

How To Use Date And Time Functions In Excel Spread Sheet

11m 22s

How To Use Day Days360 Edate And Date Value Function In Excel Spread Sheet

19m 26s

How To Use Eo Month ISOWeekNum Network Days Intl And Month Function In Excel Spread Sheet

20m 59s

How To Use Weekday WeekNum Workday.Intl And Year Frac Function Using Excel Spread Sheet

26m 45s

Assignment On Date and Time

1m 57s

Assignment On LookUp

1m 16s

Assignment On Reference

2m 14s

What And How To Use Conditional Formatting

20m 13s

Examples Using Conditional Formatting

22m 59s

Examples That Highlight Dates And Statistical Outliers Using Conditional Formatting

34m 19s

Assignment On Formula Based Conditional Formatting

8m 8s

How To Format And Customize Chart In Excel Spread Sheet

27m 49s

How To Customize Axes In Excel Spread Sheet Charts

18m 16s

How To Add Labels Hiding And Editing Data In Excel Spread Sheet Charts

26m 58s

When To Use Each Chart Or Graph Type In Excel Spread Sheet

21m 43s

How To Use Scatter Area Stock Radar And Waterfall Chart In Excel Spread Sheet

24m 13s

Assignment On Excel Chart Formatting and Customization

3m 12s

What Is Mastering Advance Excel Spread Sheet Chart And Graph

35m 13s

How To Create a DOT PLOT Chart In Excel Spread Sheet

28m 1s

How To Create a DUMBELL And PANEL Chart In Excel Spread Sheet

39m 16s

Assignment On Mastering Advance Excel Charts and Graphs

2m 35s

What When And How To Use Pivot Table

22m 55s

How To Group Pivot Table Items And Get Data In Right Format With Pivot Tables

34m 52s

How To Use Frequency Distribution And Slicers To Filter Pivot Tables Data

26m 40s

How To Update Pivot Table And Perform Calculations In Excel Spread Sheet

29m 9s

Assignment On Formatting Data with Pivot Tables

4m 44s

How To Perform Sorting Filtering And Grouping Data With Pivot Tables Using Excel Spread Sheet

31m 57s

Assignment On Sorting, Filtering and Grouping with Pivot Tables

1m 2s

What Is Calculated Field And How To Use Them

19m 46s

Steps To Add Calculated Field In Pivot Table With Excel Spread Sheet

13m 13s

How To See Or List All Calculated Fields In Excel Spread Sheet

21m 22s

How To Delete Or Hide Calculated Fields

30m 40s

Assignment On Enriching Data With Pivot Table

2m 30s

How To Visualize Data With Pivot Charts

23m 45s

Why And How To Use Forecasting Linear Regression In Excel Spread Sheet

25m 42s

How To Implement Linear Regression

7m 57s

What Is Logistic Regression And Difference Between Linear And Logistic Regression

37m 50s

How To Implement Linear Regression Analysis In Excel Spread Sheet

43m 25s

How To Implement Logistic Regression Analysis In Excel Spread Sheet

18m 13s

FAQs

It's pretty simple to create a loan amortisation schedule if you know the loan's monthly payment. Beginning with the first month, multiply the entire loan amount by the loan's interest rate. Divide the result by 12 to find your monthly interest on a loan with monthly instalments.

There are some significant distinctions. The level of information is the fundamental distinction between the two types of schedules. The amortisation plan divides a payment into the amount paid in interest and the amount paid in principal, whereas the payment schedule does not.

Excel keeps track of dates as serial numbers that can be utilised in calculations. Because it is 39,447 days after January 1, 1900, serial number 1 is assigned by default, and serial number 39448 is assigned by default. The majority of routines convert date values to serial numbers automatically.

The day is represented by the integer portion of the date serial number, while the time is represented by the decimal portion. The date serial number 1 begins on January 1, 1900, i.e. 1/1/1900 has a date serial number of 1. Caution! After February 28, 1900, Excel dates are one day out.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere