0

Loading ...

Instructor Name

Super admin

Category

Tech Development

Reviews

0 (0 Rating)

Course Requirements

Graduates and Working Prpfessionals

Course Description

MS Excel is a powerful tool that can be used for data analysis, especially for smaller datasets. The WBL  course  which combines data analytics with MS Excel will provide you with a solid foundation in data analysis techniques and practical skills.

Course Curriculum

The WBL  data analytics course with MS Excel covers the following topics:

  • Introduction to Data Analytics:
    • Defining data analytics
    • Types of data
    • Data cleaning and preparation
  • MS Excel Basics:
    • Essential Excel functions (SUM, AVERAGE, COUNT, IF, VLOOKUP, etc.)
    • Data validation
    • Conditional formatting
  • Data Analysis Tools in Excel:
    • Pivot tables
    • Pivot charts
    • Goal seek
    • Solve
  • Data Visualization:
    • Creating effective charts and graphs
    • Choosing the right chart type

    Data Analytics tools for Excel. 

    This course is suitable for individuals who:

    • Work with data in their professional roles.
    • Want to enhance their data analysis skills.
    • Are interested in using Excel for more than basic spreadsheet tasks.
    • Are looking for a practical introduction to data analytics.


      Course Outcomes

      By completing a data analytics course with MS Excel, you can expect to:

      • Gain a solid understanding of data analytics concepts.
      • Master essential MS Excel functions and tools for data analysis.
      • Develop skills in data cleaning, preparation, and visualization.
      • Learn statistical analysis techniques.
      • Be able to apply data analytics to solve real-world problems.

      Course Curriculum

      1 Understanding Databases
      N/A


      1 Introduction to Data Analytics
      24 Min


      1 MS Excel as a Data Analytics Tool
      1 Hour18 Min


      1 Type and Volume of Data
      7 Min


      1 Values and Data Types
      12 Min


      1 Data Set Format and Structure
      3 Min


      1 Excel Dashboards
      6 Min


      1 Data Analytics Toolkit in Excel
      8 Min


      Instructor

      Administrator

      Super admin

      Administrator

      Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.

      0 Rating
      0 Reviews
      5 Students
      10 Courses

      Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

      Student Feedback

      Data Analytics with MS Excel

      0

      Course Rating
      0.00%
      0.00%
      0.00%
      0.00%
      0.00%

      No Review found

      Sign In or Sign Up as student to post a review

      Reviews