Home Search Profile

Master Excel Formulas & Functions: Data Analysis Pro 2024

Focused View

2:14:56

  • 1 -Getting Started with Excel Formulas and Functions.mp4
    12:17
  • 1 -Text Functions.mp4
    15:31
  • 2 -Logical Function.xlsx
  • 2 -Logical Functions.mp4
    17:05
  • 3 -Lookup and Reference Functions.mp4
    11:29
  • 1 -Basic Mathematical Functions.mp4
    11:50
  • 2 -Statistical Analysis in Excel.mp4
    11:42
  • 3 -Exercise 1.mp4
    02:11
  • 3 -Exercise 1.xlsx
  • 3 -Solutions.xlsx
  • 1 -Working with Dates and Times.mp4
    07:00
  • 2 -Date and Time Manipulation.mp4
    18:14
  • 1 -Conditional Functions.xlsx
  • 1 -Conditional and Array Functions.mp4
    14:44
  • 2 -Error Handling Functions.mp4
    12:53
  • More details


    Course Overview

    Transform from beginner to advanced Excel user by mastering essential formulas and functions for powerful data analysis and workplace productivity.

    What You'll Learn

    • Master 50+ essential Excel functions for data analysis
    • Apply statistical methods and advanced lookup formulas
    • Handle complex date/time calculations and error checking

    Who This Is For

    • Aspiring data analysts building Excel skills
    • Office professionals wanting to boost productivity
    • Anyone needing to analyze data in Excel

    Key Benefits

    • No prior Excel experience required
    • Hands-on exercises with real-world applications
    • Immediately applicable workplace skills

    Curriculum Highlights

    1. Core functions for text, logic and lookups
    2. Statistical analysis and math functions
    3. Advanced conditional and array formulas
    Focused display
    • language english
    • Training sessions 11
    • duration 2:14:56
    • Release Date 2025/04/26