وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Excel Zero to Advance w/ Data Analysis Masterclass & ChatGPT

سرفصل های دوره

Starting from Zero, Master Excel, Data Analysis in Excel, leveraging advanced tools like Power Pivot, DAX, & ChatGPT


1 - Level 1 Getting to know Excel
  • 1 - Getting started with Excel
  • 2 - Understanding and working with Cell
  • 3 - Understanding and working with Column
  • 4 - Understanding and working with Row
  • 5 - Mastering Copy Paste
  • 6 - Mastering Autofill
  • 7 - Intelligent navigation with Excel data
  • 8 - Basic Mathematical functions
  • 9 - Unlocking Keyboard Shortcuts with Masterkey
  • 10 - Homework Entering 10 records in Excel
  • 11 - Best Practices Entering data in Excel

  • 2 - Level 2 Cleaning data
  • 12 - Product-Lookup-removing-duplicates.xlsx
  • 12 - Remove duplicates
  • 13 - Product-Lookup-removing-spaces.xlsx
  • 13 - Removing spaces
  • 14 - Product-Lookup-spell-check.xlsx
  • 14 - Spell check
  • 15 - Find Find Replace
  • 15 - Product-Lookup-find-find-and-replace.xlsx
  • 16 - Product-Lookup-blanks.xlsx
  • 16 - Replacing blank cells
  • 17 - Product-Lookup-Proper-case.xlsx
  • 17 - Using proper fonts
  • 18 - Extracting Substring or part of data
  • 18 - Substring.xlsx
  • 18 - Substring-unsolved.xlsx

  • 3 - Level 3 Transforming Data
  • 19 - Merging data in cells
  • 19 - Product-Lookup-merging-data-in-columns.xlsx
  • 20 - Product-Lookup-unmerge-or-delimate.xlsx
  • 20 - Text to Columns
  • 21 - Data Sorting
  • 21 - Product-Lookup-sorting.xlsx
  • 22 - Transpose.xlsx
  • 22 - Transpose Data
  • 23 - Flash Fill
  • 23 - Flash-fill.xlsx

  • 4 - Level 4 Compiling data
  • 24 - Vlookup
  • 24 - Vlookup-practice-file.xlsx
  • 25 - Hlookup
  • 25 - Hlookup.xlsx
  • 26 - IndexMatch.xlsx
  • 26 - Index and match
  • 27 - Consolidate
  • 27 - Consolidate.xlsx
  • 28 - Append data with Power Query
  • 28 - MonthlySalesFiles.zip

  • 5 - Level 5 Getting ready for Data Analysis
  • 29 - Getting-ready-for-data-analysis-lectures.xlsx
  • 29 - Manipulating dates Date Month Year
  • 30 - Manipulate dates Name of the Day Name of the Month
  • 31 - Manipulating dates Day of the week Week of the year
  • 32 - Day of the Year
  • 33 - Quarter of the Year
  • 34 - Dynamic TODAY Tomorrow Yesterday
  • 35 - Calculating Age
  • 36 - Adding conditional columns based on IF
  • 37 - NESTED IF
  • 38 - IF OR
  • 39 - IF OR Multiple Column
  • 40 - IF OR OR OR Practice
  • 41 - IF AND
  • 42 - IF AND AND AND Practice

  • 6 - Writing formulas to Clean transform Compile Analyze Data with AI ChatGPT
  • 43 - Note for upcoming lectures.html
  • 44 - Getting started writing basic formulas with AI
  • 45 - Writing complex IF formulas with AI

  • 7 - Level 6 Basic Data Analysis Ad hoc Data Analysis
  • 46 - Analysis-sheet.xlsx
  • 46 - Freeze Panes
  • 47 - Filters and advance filters
  • 48 - Conditional Formatting
  • 49 - Subtotals
  • 50 - COUNTIF
  • 51 - COUNTIFS
  • 52 - SUMIF
  • 53 - SUMIFS

  • 8 - Level 7 Data Analysis
  • 54 - Analysis-lectures.xlsx
  • 54 - Introduction to Data Analaysis and Data
  • 55 - Summay by a parameter
  • 56 - Adding parameters with drill down and drill up
  • 57 - Breaking down information by Column
  • 58 - Filtering the data in reports
  • 59 - Understanding Value Field Settings
  • 60 - Working with Dates in rows
  • 61 - Grouping example
  • 62 - Compiling data on one sheet
  • 63 - Slicers
  • 64 - Timeline
  • 65 - Adding Calculated Fields
  • 66 - Calculated Fields Why this approach is better

  • 9 - Level 8 Preparing Dashboard
  • 67 - Dashboard-data.xlsx
  • 67 - Introduction and first chart
  • 68 - Exploring the chart options further
  • 69 - Compiling data on one sheet
  • 70 - Adding timeline time slicer on dashboard
  • 71 - Adding and adjusting slicers
  • 72 - Adding trendline charts

  • 10 - Advanced Data Analysis Introduction and set up
  • 73 - Beyond Pivot Tables
  • 74 - A Quick Glimpse into Power Pivot
  • 75 - Installing Power Pivot in Excel
  • 76 - Business-Data-course-file.xlsx
  • 76 - Download section data file.html
  • 77 - Understanding Relational Data
  • 78 - Uploading data to Data Model
  • 79 - Connecting Tables Data Modeling
  • 80 - Deploying Power Pivot and Exploring it
  • 81 - Distinct Count The Amazing New Field Summarization
  • 82 - Lecture-file-Section-10.xlsx
  • 82 - Section file.html
  • 83 - Next step

  • 11 - Unlocking Advanced Calculations and Analytics
  • 84 - Introduction to DAX
  • 85 - Day Month Year
  • 86 - Month Name WeekDay Name WeekDay
  • 87 - IF IF OR IF AND IF OR AND
  • 88 - Homework IF.html
  • 89 - Multiple conditions with IN
  • 90 - Variables Simplifying formulas
  • 91 - Lecture file.html
  • 91 - Lecture-file-Section-12-File1.xlsx
  • 92 - Nested IF in DAX
  • 93 - SWITCH SWITCH TRUE
  • 94 - SWITCH Continued
  • 95 - Next steps

  • 12 - Putting ChatGPT to write DAX
  • 96 - Firing up the ChatGPT
  • 97 - Intro Prompt.html
  • 98 - Writing Basic DAX functions with ChatGPT
  • 99 - Just received a ChatGPT update
  • 100 - Making ChatGPT write Conditional Columns
  • 101 - Biggest use of ChatGPT with DAX.html

  • 13 - DAX Part 2
  • 102 - Simple Mathematical Calculation Column
  • 103 - Simple Mathematical Column 2 Calculating Sales
  • 104 - RELATED the vlookup xlookup of DAX
  • 105 - RELATED within Calculations
  • 106 - Deleting the unwanted columns

  • 14 - DAX Measures The Real Deal
  • 107 - Our first DAX Measure SUM
  • 108 - Other Basic functions.html
  • 109 - SUMX
  • 110 - SUMX with RELATED
  • 111 - Download the new and old section files here.html
  • 111 - Section-14-File.xlsx
  • 111 - Section-14-File-2.xlsx
  • 112 - Let CHATGPT write measures for you
  • 113 - CALCULATE Calculate values matching a Specific Criteria
  • 114 - A complex calculation with our CALCULATED Value
  • 115 - Section file.html
  • 115 - Section-14-File-2.xlsx

  • 15 - Time Intelligence with DAX
  • 116 - Understanding standard time intelligence and its problems
  • 117 - MIN and MAX
  • 118 - ALL Bypassing Filters MIN Date Across Data
  • 119 - Homework MAX Date Across.html
  • 120 - YTD Year to Date Values
  • 121 - QTD Quarter to Date and MTD Month to Date
  • 122 - TTD Total to Date
  • 123 - FTP For the period Values
  • 124 - Rolling Sum and Moving Average
  • 125 - Rolling Sum and Moving Average excluding the first two months
  • 126 - Excel file for download.html
  • 126 - Section-15-file.xlsx

  • 16 - Time Intelligence with DAX Part 2 Comparison over periods
  • 127 - Calculating Previous Month Value
  • 128 - Calculating Previous Period Value dynamically
  • 129 - Presenting growth in percentage
  • 130 - Calculating Previous Corresponding Period value
  • 131 - Homework PCP Growth.html
  • 132 - PCP Growth
  • 133 - 5.PCP-Growth
  • 133 - Section file.html

  • 17 - Clean Transform with Power Query
  • 134 - Introduction
  • 135 - Navigating to Power Query
  • 136 - Combining Sales from three tables to one
  • 137 - Adding a Unique row identifier for each row Index Column
  • 138 - Adding new columns
  • 139 - Merging tables
  • 140 - Other key features and Uploading data
  • 141 - Book2.xlsx
  • 141 - Section data file.html

  • 18 - Bonus Section
  • 142 - Bonus lecture.html
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    شناسه: 41092
    حجم: 6542 مگابایت
    مدت زمان: 713 دقیقه
    تاریخ انتشار: 2 آبان 1403
    دسته بندی محصول
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید