What You Will Learn

  • Use Excel as a data analytical tool

  • Use Excel for data analysis

  • Prepare for Associate Level Certification exam

  • Showcase your projects to apply for data analytics related jobs

How you will benefit

  • Get hands-on, practical experience

  • Jump-start your career in the data analytics

  • Receive a certificate of completion

How the course is taught

  • Instructor led online training

  • Two module per week

  • 5 Week Course

  • 3 Months to complete the course

Topics

  1. 1

    • Learning Objectives

    • Key Takeaways
  2. 2

    • Learning Objectives

    • Key Takeaway

    • Objective

    • Sorting Data

    • Lab 1: Using Simple Sort

    • Lab 2: Using Advance Sort

    • Using Filter

    • 3. Freezing and Splitting a Window

    • Lab 3: Enrollment Data: Using Filter

    • Lab 4: Advertisement Expenses: Using Filter
  3. 3

    • Conditional Statement

    • Lesson 1: SUMIF() & SUMIFS() Function

    • Lesson 2: COUNTIF() and COUNTIFS() Functions

    • Lab 1. Calculate Commission with Conditional Statement

    • Lab 2: Commission Calculation for Training Class

    • Lab 3. Calculating Overdue Payment

    • Lab 4: Using SumIf, SumIfs, CountIf and CountIfs

    • Lab 5: Quarterly Expense Report

    • Lab 6: Calculating Student Grades

    • Key Takeaways
  4. 4

    • Learning Objectives

    • VLOOKUP() Function

    • HLookUp() Function

    • MATCH Function

    • Exercise: Using the VLookup Function

    • Exercise 2: Using HLookup for Daily Call Record

    • Quiz: Lookup Functions

    • Financial Functions

    • Time Function

    • Text Function

    • Key Takeaways
  5. 5

    • Learning Objectives

    • Key Takeaways
  6. 6

    • Learning Objectives

    • Conditional Formatting

    • Lab 1: Using Conditional Format on Enrollment data

    • Lab 2: Pizza Store - Applying conditional format

    • Key Takeaways
  7. 7

    • Objective

    • Introduction to Pivot Table

    • Exercise 1: Using Pivot Table & Pivot Chart

    • Exercise 2: PivotTable - Contoso Centers
  8. 8

    • Learning Objectives

    • Data Validation

    • Exercise 1: Data Validation

    • Key Takeaways
  9. 9

    • Learning Objectives

    • Key Takeaways
  10. 10

    • Coding Styles - Best Practices

Frequently Asked Questions

  • What are the benefits of learning Excel for data analysis?

    According to indeed, the average salary of a Data Analysis is $110,026 per year. Python is an easy-to-learn programming language. Its syntax reads more English language compared to other programming languages. Python is used in many industries including Finance, Scientific, web development, system automation, Computer graphics, game development. security, mapping, and more...

  • How do I become Data Analyst?

    Python language is a relatively easy to learn programming language. It has a simple syntax and English-like commands. To become a Python programmer, you need to become familiar with using Python in a variety of applications. The best way to develop your skills with the Python programming language is to work on hands-on projects such as developing games, building a website, creating a website, and working with data using Python. This course includes lectures, quizzes to test the understanding of the concept, and hands-on projects.

  • Who should attend this course?

    This course is ideal for professionals interested in data analytics or data science and how it can be used to improve business decision-making. The analytical skills built in this course can be applied to a range of industries including healthcare, marketing, finance, and more.

Instructor

Vazi Okhandiar

Vazi has over 20 years of experience in Project Management and IT Training experience. She is Project Management Professional (PMP) certified by the Project Management Institute, Microsoft Project Certified by Microsoft, Project+ certified by CompTIA, Microsoft Certified Trainer (MCT), and CompTIA Certified Technical Trainer (CTT+). She has an MBA from the University of California and a Master’s in Computer Science from the Illinois Institute of Technology. She has worked for General Motors, Toyota, EDS/HP, and Mitsubishi. Her expertise includes project management, architecture, design, and software development projects for various industries, including manufacturing, financial, healthcare, and automotive. Vazi has been awarded “Excellence in Development” for an Electronic Billing System by Mitsubishi’s telecommunication division and Product Data Management System at Electronic Data Systems (EDS).