Menu
Excel For Data Analysis
by
This Excel For Data Analysis course on LearnVern is completely free. It will provide a comprehensive understanding of the topic and its practical applications.
Free Course
#1
See all ranking
Excel For Data Analysis
by
Learnvern
This Excel For Data Analysis course on LearnVern is completely free. It will provide a comprehensive understanding of the topic and its practical applications.
Free Course
#1
See all ranking
2 Modules
with Certifications
2+ Hours
of Recorded Content
3.8 Rated
by 10000 Learners
Hindi
Language
2 Modules
with Certifications
2 + Hours
of Recorded Content
3.8 Rated
by 10000Learners
Read all Reviews
Hindi
Language
Key Features:
This course is completely Free
100% online and Self-paced learning
Available in Multiple languages
Access on Mobile and TV
Full lifetime access to all content
Downloadable Resources
-
Introduction
- Introduction to Data Analysis With Excel
- How to use LearnVern
- What is data analysis and where to use it
-
Excel with Formulas
- 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
-
Conditional Statements and Logical Operators
- 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 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 and Logical Operators Quiz
-
Common Excel Spread Sheet Statistical Functions
- 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
-
Lookup Reference Text Date and Time Functions
- 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 and Averageifs Function Using Excel Spread Sheet
- How To Use Find IfError, Countifs and 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 and Time Functions Quiz
-
Formula Based Conditional Formatting
- 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
-
Data Visualization and Financial Formulas
- 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
-
Excel Chart Formatting and Customization
- 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
-
Mastering Advance Excel Charts and Graphs
- 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
-
Formatting Data with Pivot Tables
- 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
-
Sorting Filtering and Grouping 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
-
Enriching Data with Pivot Table Calculated Values and Fields
- 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
-
Visualizing Data with Excel Spread Sheet Pivot Charts
- 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
-
Linear and Logistic Regression
- How To Implement Linear Regression Analysis In Excel Spread Sheet
- How To Implement Logistic Regression Analysis In Excel Spread Sheet
- Linear and Logistic Regression Quiz
Course Offerings
Certificate you will get
NSDC Certificate of Partnership with LearnVern.
Help build strong resume.
Great add-on to get Internship.
Upgrade your Job with this certificate proof.
Pre Requsites
Basic proficiency in reading and writing.
Familiarity with using technology for research and assignments.
A curious mind and willingness to participate actively.
Course is for
Freshers
Professionals
Students
FAQ's
Similar Courses
Made with 💝 in India