Course Content

Introduction to Data Analysis With Excel

How to use LearnVern

What is data analysis and where to use it

How to use Percentage Variance and Round functions in Excel

How to use count and different types of count functions?

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

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

How to perform calculations using Date and Time functions

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

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

How To Perform Conditions Using Date And Time Functions

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

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

Excel With Formulas Quiz

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

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

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

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

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

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

Assignment On Conditional Statements and Logical Operators Assignment

Conditional Statement & Logical Operators Quiz

What Is Statistics And Statistical Function

What Is Intermediate Statistical Functions

What Is Difference Between Absolute And Relative Cell Reference

What And How To Use Index Function

What And How To Use Match Function

How To Use MMM Formula In Excel Spread Sheet

How To Use Percentiles In Excel Spread Sheet With Example

How To Use Quartile Using Match Function

What Is Outliers And Statistical Outliers

How To Use Leveraged Interquartile Range IQR

How To De Seasonalize Data Before Forecasting Using Excel Spread Sheet

Common Excel Spread Sheet Statistical Functions Quiz

What Is Lookup And Types Of Lookup Function

Different Types Of Examples Using Lookup Function

How To Perform Case Sensitive Lookup Using Index And Exact Function

How To Perform Aggregations On Data Using Lookup Function

What Is Reference And Types Of Reference Functions

What Is Reference Offset Function

How To Use Rows And Columns Reference Function

What And Where To Use Text Function

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

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

How To Use Date And Time Functions In Excel Spread Sheet

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

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

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

Assignment On Date and Time

Assignment On LookUp

Assignment On Reference

Lookup Reference ,Text Date & Time Functions Quiz

What And How To Use Conditional Formatting

Examples Using Conditional Formatting

Examples That Highlight Dates And Statistical Outliers Using Conditional Formatting

Assignment On Formula Based Conditional Formatting

Formula based Conditional Formatting Quiz

What Is Data Visualization And How To Use

What Is The Importance Of Data Visualization

What Are The Common Data Types While Analysing Data

How To Use Different Charts For Data Analysis Presentation And Reporting

When To Use Histogram And Bullet Chart

When To Use Actual vs Target And Funnel Chart

How To Calculate Gross Profit Margin And Gross Profit Margin Percent

How To Calculate COGS EBIT And EBITDA

How To Calculate Customer Churn Return On Equity And Avg. Customer Lifetime Value In Excel Spread Sheet

How To Calculate Employee Turnover And Interest Rates

How To Calculate Effective Rate With FV

How To Create Loan Payment Calculator In Excel Spread Sheet

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

How To Calculate Depreciation Accelerated Depreciation And Present Value

How To Calculate Present Value Of Future Payments And Net Present Value

How To Calculate IRR Positive And Negative And Non-Periodic Cash Flows

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

How To Use Data Visualizations Examples On Extraction Of Data

Assignment On Data Visualization

Data Visualization And Financial Formulas Quiz

How To Format And Customize Chart In Excel Spread Sheet

How To Customize Axes In Excel Spread Sheet Charts

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

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

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

Assignment On Excel Chart Formatting and Customization

What Is Mastering Advance Excel Spread Sheet Chart And Graph

How To Create a DOT PLOT Chart In Excel Spread Sheet

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

Assignment On Mastering Advance Excel Charts and Graphs

What When And How To Use Pivot Table

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

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

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

Assignment On Formatting Data with Pivot Tables

Formatting Data With Pivot Tables Quiz

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

Assignment On Sorting, Filtering and Grouping with Pivot Tables

What Is Calculated Field And How To Use Them

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

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

How To Delete Or Hide Calculated Fields

Assignment On Enriching Data With Pivot Table

How To Visualize Data With Pivot Charts

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

How To Implement Linear Regression

What Is Logistic Regression And Difference Between Linear And Logistic Regression

Visualizing Data with Excel Spread Sheet Pivot Charts Quiz

How To Implement Linear Regression Analysis In Excel Spread Sheet

How To Implement Logistic Regression Analysis In Excel Spread Sheet

Linear & Logistic Regression Quiz

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

Excel For Data Analysis Excel with Formulas

Enroll Now For Free

Discussion

View Resources

View Resources

Formulas With Solution(3)

Course Content

Introduction to Data Analysis With Excel

How to use LearnVern

What is data analysis and where to use it

How to use Percentage Variance and Round functions in Excel

How to use count and different types of count functions?

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

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

How to perform calculations using Date and Time functions

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

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

How To Perform Conditions Using Date And Time Functions

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

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

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

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

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

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

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

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

Assignment On Conditional Statements and Logical Operators Assignment

What Is Statistics And Statistical Function

What Is Intermediate Statistical Functions

What Is Difference Between Absolute And Relative Cell Reference

What And How To Use Index Function

What And How To Use Match Function

How To Use MMM Formula In Excel Spread Sheet

How To Use Percentiles In Excel Spread Sheet With Example

How To Use Quartile Using Match Function

What Is Outliers And Statistical Outliers

How To Use Leveraged Interquartile Range IQR

How To De Seasonalize Data Before Forecasting Using Excel Spread Sheet

What Is Lookup And Types Of Lookup Function

Different Types Of Examples Using Lookup Function

How To Perform Case Sensitive Lookup Using Index And Exact Function

How To Perform Aggregations On Data Using Lookup Function

What Is Reference And Types Of Reference Functions

What Is Reference Offset Function

How To Use Rows And Columns Reference Function

What And Where To Use Text Function

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

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

How To Use Date And Time Functions In Excel Spread Sheet

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

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

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

Assignment On Date and Time

Assignment On LookUp

Assignment On Reference

What And How To Use Conditional Formatting

Examples Using Conditional Formatting

Examples That Highlight Dates And Statistical Outliers Using Conditional Formatting

Assignment On Formula Based Conditional Formatting

What Is Data Visualization And How To Use

What Is The Importance Of Data Visualization

What Are The Common Data Types While Analysing Data

How To Use Different Charts For Data Analysis Presentation And Reporting

When To Use Histogram And Bullet Chart

When To Use Actual vs Target And Funnel Chart

How To Calculate Gross Profit Margin And Gross Profit Margin Percent

How To Calculate COGS EBIT And EBITDA

How To Calculate Customer Churn Return On Equity And Avg. Customer Lifetime Value In Excel Spread Sheet

How To Calculate Employee Turnover And Interest Rates

How To Calculate Effective Rate With FV

How To Create Loan Payment Calculator In Excel Spread Sheet

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

How To Calculate Depreciation Accelerated Depreciation And Present Value

How To Calculate Present Value Of Future Payments And Net Present Value

How To Calculate IRR Positive And Negative And Non-Periodic Cash Flows

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

How To Use Data Visualizations Examples On Extraction Of Data

Assignment On Data Visualization

How To Format And Customize Chart In Excel Spread Sheet

How To Customize Axes In Excel Spread Sheet Charts

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

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

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

Assignment On Excel Chart Formatting and Customization

What Is Mastering Advance Excel Spread Sheet Chart And Graph

How To Create a DOT PLOT Chart In Excel Spread Sheet

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

Assignment On Mastering Advance Excel Charts and Graphs

What When And How To Use Pivot Table

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

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

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

Assignment On Formatting Data with Pivot Tables

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

Assignment On Sorting, Filtering and Grouping with Pivot Tables

What Is Calculated Field And How To Use Them

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

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

How To Delete Or Hide Calculated Fields

Assignment On Enriching Data With Pivot Table

How To Visualize Data With Pivot Charts

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

How To Implement Linear Regression

What Is Logistic Regression And Difference Between Linear And Logistic Regression

How To Implement Linear Regression Analysis In Excel Spread Sheet

How To Implement Logistic Regression Analysis In Excel Spread Sheet

FAQs

For the result, enter the birth date in cell A1 and paste the formula into cell B1. We'll choose the birth date of 11/04/1983 as a starting point: 35 years old. It's the same as when you use the DATEDIF function on a single cell. =int(YEARFRAC(A1,today()))

The Most Important Takeaways "=LEN(TRIM(cell))-LEN(SUBSTITUTE(cell," ",""))+1" is the formula for counting words in a specific range. To handle arrays, the word count formula is used with the SUM or SUMPRODUCT function. The SUBSTITUTE function replaces all of the cell's spaces with the empty string (").

You may also use the YEARFRAC function in Excel to compute the age (in years) of a date range. The YEARFRAC function returns the number of years between two dates, whereas the INT function only returns the integer portion of the result.

You may also acquire the word count easily using Google Docs. To acquire the word and character count, just copy and paste the text into any blank Google Docs document and hit Control + Shift + C (all at once).

Recommended Courses

Data Science Course

Students Enrolled : 28340

4.4

(438)

हिन्दी

This Data Science Course is a comprehensive course that...

Enroll For Free

R Programming Course

Students Enrolled : 8239

4.3

(103)

English

The R programming course assumes no prior knowledge of...

Enroll For Free

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

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