About Course
Data analytics skills can help you understand customer data and make smart business decisions. Excel is sophisticated spreadsheet software that can not only explore but also has different ways of presenting your data. Microsoft Excel Spreadsheets and Data Analysis Advanced Course will help Excel users gain knowledge of PivotTables, data.
You can also earn a renowned certificate from Skillindia/ NSDC for the acknowledgment of the skills you earn to add value to your CV
The Industry Experts of LearnVern offers a ‘Beginner to Advance Excel for Data Science’ online course in Hindi to give you a deep knowledge of this course in your mother language. This course will enable you to start your career in the field of Data Analytics.As each company has started storing data of its Customers, Preferences, User and a lot more this store data needs to be analyzed and monitored. This Data Analytics course will help you learn how to manage and report on this data. This course is a step by step approach of how to use excel and its advance features to build a successful career in Data Analytics.
What Will You Learn?
- ou will learn data analysis fundamentals, data cleaning, visualization, Excel, SQL, and basic Python tools for data analysis.
Course Content
Introduction
-
Introduction to Data Analysis With Excel
-
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
Conditional Statements & 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 & 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
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
Lookup Reference Text Date & 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 & 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
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
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
Excel Chart Formatting & 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
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
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
Sorting Filtering & Grouping Data with Pivot Tables
-
How To Perform Sorting Filtering And Grouping Data With Pivot Tables Using Excel Spread Sheet
Enriching Data with Pivot Table Calculated Values & 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
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
Linear & Logistic Regression
-
How To Implement Linear Regression Analysis In Excel Spread Sheet
-
How To Implement Logistic Regression Analysis In Excel Spread Sheet
Student Ratings & Reviews
No Review Yet
